For Discoverer 10g: 1. On the Discoverer 10g Server machine, please set the environment variables by running the following script, . ./$OH/discoverer/discwb.sh (Note : It is dot space dot slash…
Read MoreOne small article on ASMCMD commands which can help you in day to day ASM Command-Line tasks. 1. Let’s check ASMCMD’s version. [oracle@dbnode1 ~]$ asmcmd -V asmcmd version 11.2.0.0.0 Let’s…
Read MoreCategory Location Start/Stop Logfiles $INST_TOP/logs/appl/admin/log Log files for OPMN and OHS processes $IAS_ORACLE_HOME/ instances//diagnostics/logs Weblogic Nodemanager $FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log Apache Logs $IAS_ORACLE_HOME/instances//diagnostics/logs/OHS/EBS_web_/*log OPMN Logs $IAS_ORACLE_HOME/instances//diagnostics/logs/OPMN/opmn/ Weblogic Logs $IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager $EBS_DOMAIN_HOME/servers/oa/logs/ $EBS_DOMAIN_HOME/servers/forms/logs/ $EBS_DOMAIN_HOME/servers/AdminServer/logs/* $EBS_DOMAIN_HOME/sysman/log/*
Read MoreGroup Services Scripts Purposes Root Services Node Manager adnodemgrctl.sh WLS Node Manager controls server instances within a domain providing automatic restart functionality. Web Administration Services WebLogic Admin Server adadminsrvctl.sh WLS…
Read MoreCategory 12.1 12.2 Forms & Reports, Developer Home, Tools Home 10.1.2 – ORACLE_HOME 10.1.2 ORACLE_HOME OC4J/OHS/OPMN 10.1.3 – IAS-ORACLE_HOME OPMN, oacore-oc4j, oafm-oc4j, forms-oc4j, etc Fusion Middleware – OHS/WLS OHS –…
Read Morea. Create a gold image of the 19c Oracle Home. $ cd $ORACLE_HOME/ $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent Successfully Setup Software. Gold Image location: /u03/database19c/db_home_2018-02-26_22-47-54PM.zip…
Read MoreWhen users asks the DBA’s to create a dblink, we would normally get back to the users asking for the dblink’s owner password to create the required db link. The…
Read Morea. Create a temporary dummy table for storing the rowids of the corrupted LOBs. here the dummy table name is “corrupt_lobs”. SQL> create table corrupt_lobs (corrupt_rowid rowid, err_num number); Create…
Read Morea. Create a temporary dummy table for storing the rowids of the corrupted LOBs. here the dummy table name is “corrupt_lobs”. SQL> create table corrupt_lobs (corrupt_rowid rowid, err_num number); Create…
Read MoreIf your table has any logical corruptions the expdp of the table might fail with ORA-155 error. If your table has any logical corruption, first identify the rows/rowids that are…
Read More