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.

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 , , | 2 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

Oracle 12c RDBMS binary installation on 2 node (RAC)

Posted in 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