Database Blog

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

Installation Of OID 11.1.1.9 On RHEL7 Fails With linking phase (ins_sqlplus.mk)

APPLIES TO: Oracle Internet Directory – Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g] Oracle Fusion Middleware – Version 11.1.1.9.0 to 11.1.1.9.0 [Release Oracle11g] Information in this document applies to RHEL 7/OEL…

Read More

11g FMW Installations Fails with “Error in invoking target ‘install’ of makefile ” For ins_sqlplus.mk

APPLIES TO: Oracle Fusion Middleware – Version 11.1.2.2.0 and later Information in this document applies to any platform. ERROR: FMW 11.1.1.9 OID installation or 11.1.2.2 Forms and reports installation on…

Read More

Errors When Applying the Patches “genclntsh: Failed to link libclntsh.so.11.1” on OHS 11.1.1.7.0 or 11.1.1.9.0

APPLIES TO: Oracle HTTP Server – Version 11.1.1.7.0 to 11.1.1.9.0 [Release Oracle11g] Linux x86-64 ERROR: When applying the patches Patch 22290164 and Patch 26610710 on Red Hat 7 or Oracle Linux 7 x86-64 bit,…

Read More

RCU Fails with ORA-28104, ORA-06512 Errors when 12.2.x Database is Used

APPLIES TO: Oracle Fusion Middleware – Version 12.2.1.0.0 and later Information in this document applies to any platform. ERROR: Running RCU fails with ORA-28104, ORA-06512 Errors when 12.2.x database is used…

Read More

Return error “libc.so.6 version GLIBC_2.14 Not Found” Applying RUP Patches

APPLIES TO: Oracle EBS Applications Translation – Version 12.1.3 to 12.1.3 [Release 12.1] Information in this document applies to any platform. ERROR: While applying RUP patches 27212160 and 22698083,this error…

Read More

Steps to add new hosts in OEM 13c

Logon as sysman in OEM console. 1. Choose: Setup, Add Target, Add Targets Manually. 2. Under “Add Host Targets” Click “Install Agent on Host” 3. Add Host Name: tst01.example.com &…

Read More

OPATCHAUTO-72043: Failed to create bundle patch object

I have recently faced this issue, while applying the PSU patch encountered “OPATCHAUTO-72043: Failed to create bundle patch object”. Issue: OPATCHAUTO-72043: Failed to create bundle patch object opatchauto apply -analyze…

Read More