Error :Password for 'SYSTEM' Does not work Please reenter

 

Error :Password for 'SYSTEM' Does not work Please reenter

 

 

 

This error due database dll file.

downloaded the proper dll and copy to DIR_CT_RUN folder and restart the system and  restart the SUM from  scratch.

 

998004 - Update the Oracle Instant Client on Windows

Symptom

You have to update the Oracle Instant Client with the newest version that is available on SAP Service Marketplace.

Other Terms

ORACLE Instant Client, OICL, OCI.DLL

Reason and Prerequisites

The currently used Oracle Instant Client is not up-to-date.

Solution

1. Download the latest supported Oracle Instant Client (see also SAP note 819829) from SAP Service Marketplace at:
   http://support.sap.com/software/databases.html > Oracle
1. Select one of the following:
• Oracle 12.1 Software (<your platform>) for the Oracle 12.1 Instant Client
• Oracle 11.2 Software (<your platform>) for the Oracle 11.2 Instant Client
• Oracle 10.2 Software (<your platform>) for the Oracle 10.2 Instant Client.
2. Choose Installation -> Microsoft Windows -> ORACLE database.
3. In the list of the downloadable objects, you can find Oracle Client <your Oracle version> DVD containing the archive named OCL<RELEASE><WORDSIZE>.SAR e.g. OCL112164.SAR, OCL11264.SAR or OCL10264.SAR.

By default, the installation stores the Oracle Instant Client in the $(DIR_CT_RUN) directory. During the startup of an SAP instance, it is copied to the $(DIR_EXECUTABLE) directory.

2. Delete the Oracle Instant Client:
   Since the contents of a newer Oracle Instant Client might differ from the client version you are currently using, you first have to delete the current Oracle Instant Client as follows:
1. Download deldbclient.vbs, which is included in the deldbclient.zip file attached to this SAP note.
2. Get the value of instance profile parameter DIR_EXECUTABLE for every application server instance and DIR_CT_RUN. For more information, see SAP note 997848.
3. Stop all application servers, including the central instance.
4. On the central instance host, open a command prompt as <SAPSID>adm, change the current working directory to DIR_CT_RUN, and run cscript.exe //nologo deldbclient.vbs in this directory.
   If you use an MSCS configuration with SAP kernel release 700 and clustered SCS instances, the DIR_CT_RUN directory is located on the SCS instance host.
5. Repeat the previous step on every application server instance DIR_EXECUTABLE directory. 
   Note: On SAP application servers with a kernel version lower than 700, the DIR_EXECUTABLE directory of the central instance might be the same as DIR_CT_RUN. 
3. Unpack the Oracle Instant Client using SAPCAR -xvf <OCL SAR Archive> as follows:
1. Open a command prompt on the host where DIR_CT_RUN is located.
2. Change the working directory to DIR_CT_RUN.
3. Unpack the Oracle Instance Client to this directory.
4. Start your SAP application servers.

 The Oracle Instant Client is automatically distributed to the instance-specific DIR_EXECUTABLE directories.

sapgui 7.40/ 7.50: How can I migrate saplogon.ini to new SAPUILandscape.xml file?

How can I migrate saplogon.ini to new SAPUILandscape.xml file?

Ans: Rename the existing  SAPUILandscape.xml  and restart the SAPLOGN then it will create new SAPUILandscape.xml  from your saplogon.ini file.

thanks

Yoonus

ORA-38880: Cannot Advance Compatibility From 12.1.0.2.0 To 12.2.0.1.0 Due To Guaranteed Restore Points

PROBLEM:

After successful db upgrade, I tried to update the compatible parameter and restart the database. I got below error.

 

 

 

SQL>  alter system set compatible="12.2.0.1" scope=spfile;

 

System altered.

 

 

 

 

SQL> startup force

ORACLE instance started.

 

Total System Global Area 1.4663E+10 bytes

Fixed Size                 15697000 bytes

Variable Size            8455723928 bytes

Database Buffers         6140461056 bytes

Redo Buffers               51404800 bytes

ORA-38880: Cannot advance compatibility from 12.1.0.2.0 to 12.2.0.1.0 due to guaranteed restore points

 

 

 

 

SOLUTION:

The error is because, I have enabled flashback and created a guaranteed restore point, before the upgrade. So while trying to update the compatible parameter, it is not allowing. Because ,once compatible parameter is changed, we can’t downgrade.

To fix it, we need to drop the restore point. Follow below steps:

 

Set to the old existing compatible.

 

SQL> alter system set compatible="12.1.0.2.0" scope=spfile;

 

System altered.

 

SQL> startup force

ORACLE instance started.

 

Total System Global Area 1.4663E+10 bytes

Fixed Size                 15697000 bytes

Variable Size            8455723928 bytes

Database Buffers         6140461056 bytes

Redo Buffers               51404800 bytes

Database mounted.

Database opened.

 

Check the flashback restore point and drop it:

 

SQL> select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point;

 

GUARANTEE_FLASHBACK_DATABASE     NAME

-------------------------------- -----------------------------

YES                              GRP_1487689238734

 

SQL> select flashback_On from v$database;

 

FLASHBACK_ON

------------------

YES

 

SQL> alter database flashback off;

 

Database altered.

 

SQL> select flashback_On from v$database;

 

FLASHBACK_ON

------------------

RESTORE POINT ONLY

 

SQL> drop restore point GRP_1487689238734;

 

Restore point dropped.

 

SQL>  select flashback_On from v$database;

 

FLASHBACK_ON

------------------

NO

 

 

 Now update the compatible parameter in spfile and restart

 

SQL> show parameter comp

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

cell_offload_compaction              string      ADAPTIVE

compatible                           string      12.1.0.2.0

db_index_compression_inheritance     string      NONE

nls_comp                             string      BINARY

noncdb_compatible                    boolean     FALSE

plsql_v2_compatibility               boolean     FALSE

SQL> alter system set compatible="12.2.0.1" scope=spfile;

 

System altered.

 

SQL> startup force;

ORACLE instance started.

 

Total System Global Area 1.4663E+10 bytes

Fixed Size                 15697000 bytes

Variable Size            8455723928 bytes

Database Buffers         6140461056 bytes

Redo Buffers               51404800 bytes

Database mounted.

Database opened.

SQL> show parameter comp

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

cell_offload_compaction              string      ADAPTIVE

compatible                           string      12.2.0.1

db_index_compression_inheritance     string      NONE

nls_comp                             string      BINARY

noncdb_compatible                    boolean     FALSE

plsql_v2_compatibility               boolean     FALSE