Author Archives: shanojkumar

About shanojkumar

* Has 12 years of experience in Planning, Implementing, Managing and Monitoring the Oracle Databases as an (Oracle 10g & 11g OCP) Certified Oracle Database Administrator.

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

OGG-00446 No valid log files for current redo sequence:

ERROR: OGG-00446 No valid log files for current redo sequence 33, thread 1, error retrieving redo file name for sequence 33, archived = 0, use_alternate = 0Not able to establish initial position for begin time 2018-03-18 17:44:15.000000. Cause: As the … Continue reading

Posted in GoldenGate | Tagged , | Leave a comment

Step-by-step guide for Install, Configure and Maintain Oracle Database 12C in AWS Cloud

Creating an Account with AWS Creating a VPC Creating a Security Group & SSH Key Pair Building an EC2 instance in AWS Cloud Connecting to an EC2 Instance Downloading Oracle Database 12c Software Preparing EC2 instance for Oracle Database 12c … Continue reading

Posted in Cloud | Tagged , , | 3 Comments

Installing and Using Swingbench 2.5

Swingbench is a free easy-to-use stress testing utility on Oracle databases.download Click the link above to download the full document.  

Posted in Oracle RAC | Tagged , | Leave a comment