Category Archives: Oracle

Oracle 12CR2: Creating PDB from the Seed

• Create a PDB using SQL*Plus • Delete a PDB using the DBCA • Add the created Pluggable Database net service name in the tnsnames.ora file Advertisements

Posted in Oracle | Tagged , , | Leave a comment

Creating a CDB database on Oracle 12CR2 (Create an empty Container database)

 

Posted in Oracle, Oracle RAC | Tagged , | Leave a comment

DBCA error while creating CDB database.

Attempt to create a database in Oracle Restart environment fails and the following error ORA-01017: invalid username/password; logon denied . For details refer to “(:CLSN00107:)” in “/u01/app/grid/diag/crs/multisrv1/crs/trace/ohasd_oraagent_grid.trc”. CRS-2674: Start of ‘ora.cdb1.db’ on ‘multisrv1’ failed ORA-01017: invalid username/password; logon denied oracle.cluster.impl.crs.cops.CRSNativeResult.createException(CRSNativeResult.java:617) … Continue reading

Posted in Oracle, Oracle RAC | Tagged , | Leave a comment

Upgrade the Oracle RAC Grid Infrastructure from release 12.1.0.2 to release 12.2.0.1.

Upgrade Oracle Grid Infrastructure: Note: Oracle Grid Infrastructure 12.2 has added new features that require plenty of disk space in the CRS disk group. Therefore, you must expand the size of the CRS disk group before you can upgrade Oracle … Continue reading

Posted in Oracle, Oracle RAC | Tagged , , , , , , , , , , , , | Leave a comment

How to Reconfigure Oracle Restart | ASM startup fail with ORA-29701.

How to Reconfigure Oracle Restart : Cause: Today I faced one issue while cloning my VM for making a dataguard server, I done the server name change while crs was up and running and end up in ASM startup failure. … Continue reading

Posted in Oracle, Oracle RAC | Tagged , | Leave a comment

Enterprise Manager Cloud Control 13C Installation (Step by Step with all screen Shoots)

13c_re_work

Posted in Oracle, Oracle RAC | Tagged , | 1 Comment

Steps for RMAN Restore backup of lower version database to a higher version

Source DB Name       :   TESTDB Source DB Version     :   11.2.0.1.0 Source DB Host Name   :   HOSTNAME_1 Target DB Name       :   TESTDB Target DB Version     :   11.2.0.4 Target DB Host Name   :   HOSTNAME_2   Step-1 ===== Installing the Oracle binary version … Continue reading

Posted in Oracle | Leave a comment