Posts by Venkateshwaran Govindaraj

ORA-19909: datafile 1 belongs to an orphan incarnation

ERROR: ORA-19909: datafile 1 belongs to an orphan incarnation When I tried to Flashback on in standby database then suddenly below message found in alert log and standby database not…

Read More

Scheduled Request Goes Inactive/On Hold Status Automatically by Concurrent Manager User

Problem Scheduled Request Goes Inactive/On Hold Status Automatically by Concurrent Manager User Cause: It is an oracle bug Solution 1.Apply the Patch -22549247 2.It will give you a newer file…

Read More

How to resolve the issue for concurrent program stuck in opp

Follow the below steps to resolve program stuck in OPP issues, 1.You will need to check and fix the Invalid FND Objects : select owner, object_name,object_type,status from dba_objects where status =’INVALID’ and object_name like ‘FND%’; 2.AQ$_FND_CP_GSM_OPP_AQTBL tables has a lot of rows and purge is needed select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_T; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_G; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_H; select count(*) from APPLSYS.AQ$_FND_CP_GSM_OPP_AQTBL_I;…

Read More

How to START and STOP the TOMCAT Services

1.Start the Tomcat a.source the java path $ cat tomcat_java.env export JAVA_HOME=/rupdb01/oracle/tomcat/java71_64 export PATH=/rupdb01/oracle/tomcat/java71_64/jre/bin:$PATH b.Go to the tomcat installed location $ cd apache-tomcat-8.5.37/bin c.execute startup.sh $ sh startup.sh Using CATALINA_BASE:…

Read More

Install TOMCAT in oracle AIX

Below steps for installing tomcat in oracle 1.Pre-req: Install Java 8 For Apache Tomcat 9 to be installed and configured properly, you need to have Java version 8 installed on…

Read More

Export and Import in AWS Cloud

Below is the steps to do export and import in AWS Cloud Environment 1.CONNECT TO PROD AWS CLOUD FROM LOCAL PROD DB sqlplus root/<root_password>@awscld 2.EXPORT DECLARE hdnl NUMBER; BEGIN hdnl := DBMS_DATAPUMP.OPEN( operation => ‘EXPORT’, job_mode => ‘SCHEMA’, job_name=>null); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<DUMP_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_dump_file); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<EXPDUMP_LOG_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_log_file); DBMS_DATAPUMP.METADATA_FILTER(hdnl,’SCHEMA_EXPR’,’IN (”<SCHEMA_NAME>”)’); DBMS_DATAPUMP.START_JOB(hdnl); END; / 3.CHECK THE STATUS OF THE EXPORT BY USING BELOW QUERY SELECT text FROM table(rdsadmin.rds_file_util.read_text_file(‘DATA_PUMP_DIR’,'<DUMP_LOG_NAME>’)); 4.MOVE THE DUMP FILE TO AWS DEV CLOUD  Move the DUMP to AWS DEV CLOUD…

Read More