Installing Oracle 20c Binary on OEL 7.5

In this post, we are installing Oracle 20c binaries on OEL 7.5. First, we need to download the software then unzip it on oracle home and start runInstaller from the software location. Initally, you can use Oracle 20c on OCI.

Select a “Set Up Software Only” and click next. Select on “Single instance database […]

Read More

Background Media Recovery terminated with ORA-1274 after adding a Datafile

Today lt’s have a tour towards the steps which we are going to solve the issue regards “Background Media Recovery terminated with ORA-1274 after adding a Datafile“ Symptoms in alert.log file:

Trace file:

Cause: This Error occurs if we add a Datafile OR Tablespace in PRIMARY Database and that could not be translated […]

Read More

crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104

Today we are going to work on the error of oracle “crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104” .  Let’s have a look on the steps .

Cause: Hostname was changed, in this case it was changed to localhost Solution: Option 1:

Option 2:

Oracle Support Doc ID 1551791.1 Thank […]

Read More

ORA-19511: Error received from media manager layer

Today we are going to have a look on the steps which we use to resolve the issue “ORA-19511: Error received from media manager layer, error text: ANS1017E (RC-50) Session rejected: TCP/IP connection failure”

Solution: In this case TSM(Tivoli Storage Manager) died due to paging space. After started it again by Server responsible people […]

Read More

ORA-16014: log X sequence# XXX not archived in Standby

Today we are going to have a look on the steps which are used by DBA’s to resolve issue “ORA-16014: log X sequence# XXX not archived, no available destinations (In Standby Database)”. Problem: In the alert log file

Cause : In this case the problem was log_archive_dest_2 was set incorrectly.

Solution :

Please check […]

Read More

ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN

We are going to follow some steps to solve the “ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN”.

Solution: In my case when I checked the permission of $ORACLE_HOME and $GRID_HOME and the permission was incorrect which caused the problem. After fixing the permission it works fine.

The […]

Read More

EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033

Today we are going to have a look on the steps which we use to resolve the issue “EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033” ERROR : Error Description: IMPDP fails or terminate with following errors.

Solution : Remove the parallel clause from datapump expdp/impdp and retry the job. If that does not […]

Read More

New Features in Oracle Database 20c

Force Upgraded Password File to be Case Sensitive Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive.  SYSLOG Destination for Common Unified Audit Policies Certain predefined columns of unified audit records from common unified audit policies can be written […]

Read More

OCR create keys failed for root with OCR error 27

Let’s have look on the steps which we use to solve the issue “OCR create keys failed for root with OCR error 27”

Cause: An asmadmin group is missing in grid user

Solution:

Rerun the roothas.pl

Today’s thought “Never complain, never explain. Resist the temptation to defend yourself or make excuses”. […]

Read More