Pular para o conteúdo principal

How to recreate oraInventory in ebs R12

Edit the oraInst.loc file:
vi /etc/oraInst.loc

Change the inventory_loc to a new location:
inventory_loc=/prod/oraInventory_new

Create the new directory:
mkdir /prod/oraInventory_new

Give permissions to the new directory:
chmod -R 777 /prod/oraInventory_new

-- Add the 10.1.3 Oracle Home to the new created oraInventory:
cd $INST_TOP/ora/10.1.3
. ./APP.env

Go to the $ORACLE_HOME:
cd $ORACLE_HOME

Edit the oraInst.loc and point it to the same location ad done in step 1:
inventory_loc=/prod/oraInventory_new

Add the 10.1.3 Oracle Home to the new oraInventory location:
cd $ORACLE_HOME/appsutil/clone
./ouicli.pl

Verify if the 10.1.3 is added to the new oraInventory directory:

cd /prod/oraInventory_new/ContentsXML

cat inventory.xml

If it's not added, check the /prod/oraInventory_new/logs file.

Verify the oraInventory has the information about the 10.1.3 Oracle Home:
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory -detail

-- Add the 10.1.2 Oracle Home to the new created oraInventory:
cd $INST_TOP/ora/10.1.2
. ./APP.env

Go to the $ORACLE_HOME:
cd $ORACLE_HOME

Edit the oraInst.loc and point it to the same location ad done in step 1:
inventory_loc=/prod/oraInventory_new

export TMP=/tmp

Add the 10.1.2 Oracle Home to the new oraInventory location:
cd $ORACLE_HOME/appsutil/clone
./ouicli.pl

Verify if the 10.1.2 is added to the new oraInventory directory:
cd /prod/oraInventory_new/ContentsXML
cat inventory.xml

If it's not added, check the /prod/oraInventory_new/logs file.

Verify the oraInventory has the information about the 10.1.2 Oracle Home:

export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory -detail

--Add the DB Oracle Home to the new created oraInventory:
cd $ORACLE_HOME
. ./BD.env

Go to the $ORACLE_HOME:
cd $ORACLE_HOME

Edit the oraInst.loc and point it to the same location ad done in step 1:
inventory_loc=/prod/oraInventory_new

Add the DB Oracle Home to the new oraInventory location:
cd $ORACLE_HOME/appsutil/clone
./ouicli.pl

Verify if the DB Oracle Home is added to the new oraInventory directory:
cd /prod/oraInventory_new/ContentsXML
cat inventory.xml

If it's not added, check the /prod/oraInventory_new/logs file.
Verify the oraInventory has the information about the DB Oracle Home:

export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory -detail


Note:

Running ouicli.pl can result in error:
"Exception in thread "main" java.lang.NoClassDefFoundError: oracle/apps/ad/clone/util/OracleHomeCloner"

This can be fixed by setting Context variable s_clonestage to \clone

For example:

\oracle\PROD\apps\apps_st\comn\clone

Comentários

Postagens mais visitadas deste blog

Recompile JSP EBS - R12.2

1. Backup $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/ $ mv _pages _pages_old 2. Stop services cd $ADMIN_SCCRIPTS_HOME ./adapcctl.sh stop ./admanagedsrvctl.sh stop oafm_server1 ./admanagedsrvctl.sh stop oacore_server1 3. Compile the jsps manually  cd $FND_TOP/patch/115/bin/ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p             4. Checking $ cd $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages $ ls -ltr  5. Start services cd $ADMIN_SCCRIPTS_HOME ./admanagedsrvctl.sh start oacore_server1 ./admanagedsrvctl.sh start oafm_server1 ./adapcctl.sh start 6. Clear your web browser cache

How to Disable WebLogic Server Diagnostic Framework (WLDF)

[weblogic@yourhost ]$ cd $MW_HOME/oracle_common/common/bin/ [weblogic@yourhost bin]$ ./wlst.sh Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands wls:/offline> connect('weblogic','password','t3://host_ip:port') Connecting to t3://xx.xx.xx.xx:7001 with userid weblogic ... Successfully connected to Admin Server "AdminServer" that belongs to domain "WeblogicDomain". Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. wls:/WeblogiDomain/serverConfig/> edit() Location changed to edit tree. This is a writable tree with DomainMBean as the root. To make changes you will need to start an edit session via startEdit(). For more help, use help('edit'). wls:/WeblogiDomain/edit/> startEdit() Starting an edit session ... Started edit session, be sure...

Oracle Data Modeler and SQL Developer: change user interface (GUI) language

Oracle Data Modeler and Oracle SQL Developer does not allow to change the user interface language in “Options” or somewhere else in the GUI. This applies to the versions: Oracle SQL Developer Data Modeler - Version All and later (18.2.0 in my case) Oracle SQL Developer - Version 3.2 and later However, it’s possible switch to other language, changing datamodeler\ide\bin\ide.conf configuration file. The following lines should be added to the file for support English: AddVMOption -Duser.language=en AddVMOption -Duser.country=US Restart application! SQL Developer and Data Modeler supports the following languages: French(fr), German(de), Italian(it), Spanish(es), Brazilian Portuguese(pt BR), Japanese(ja), Korean(ko), Simplified Chinese(zh CN), Traditional Chinese(zh TW).