Friday 4 September 2015

create appsutil directory on db


create new appsutil directory on standalone db:

$AD_TOP/bin/admkappsutil.pl

o/p: $INST_TOP/admin/out/appsutil.zip

copy this zip file to dbtier and unzip

[oraoba@our12-test 11.2.0]$ cd appsutil/bin/

[oraoba@our12-test bin]$ perl  adbldxml.pl appsuser=apps appspass=appsoba template=/data1/OBADB/db/tech_st/11.2.0/appsutil/template/adxdbctx.tmp out=$ORACLE_HOME/appsutil/OBA_our12-test.xml

Starting context file generation for db tier..
Using JVM from /data1/OBADB/db/tech_st/11.2.0/jdk/jre/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/data1/OBADB/db/tech_st/11.2.0/appsutil/log/adbldxml_09050637.log

Enter the value for Display Variable: our12-test:0.0

The context file has been created at:
/data1/OBADB/db/tech_st/11.2.0/appsutil/OBA_our12-test.xml

[oraoba@our12-test bin]$ cd ../

[oraoba@our12-test appsutil]$ ls

bin  html  java  log  media  OBA_our12-test.xml  perl  sql  template

[oraoba@our12-test appsutil]$ vi OBA_our12-test.xml

[oraoba@our12-test appsutil]$ pwd

/data1/OBADB/db/tech_st/11.2.0/appsutil


[oraoba@our12-test appsutil]$ cd bin/
[oraoba@our12-test bin]$ ls
adbldxml.pl   adchkutl.sh    adclone.sh    adconfig.sh       adcvm.cmd    adgentns.pl       adxerr.pl                txkInventory.pl
adchkcfg.cmd  adclonectx.pl  adconfig.cmd  adcustomizer.cmd  adcvm.sh     adtmplreport.cmd  txkGenCtxInfRep.pl       txkrun.pl
adchkcfg.sh   adclone.pl     adconfig.pl   adcustomizer.sh   addlnctl.pl  adtmplreport.sh   txkHealthCheckReport.pl  TXKScript.pl
[oraoba@our12-test bin]$ sh adconfig.sh
Enter the full path to the Context file: /data1/OBADB/db/tech_st/11.2.0/appsutil/OBA_our12-test.xml
Enter the APPS user password:
The log file for this session is located at: /data1/OBADB/db/tech_st/11.2.0/appsutil/log/OBA_our12-test/09050641/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /data1/OBADB/db/tech_st/11.2.0
        Classpath                   : :/data1/OBADB/db/tech_st/11.2.0/jdbc/lib/ojdbc5.jar:/data1/OBADB/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/data1/OBADB/db/tech_st/11.2.0/appsutil/java:/data1/OBADB/db/tech_st/11.2.0/jlib/netcfg.jar:/data1/OBADB/db/tech_st/11.2.0/jlib/ldapjclnt11.jar

        Using Context file          : /data1/OBADB/db/tech_st/11.2.0/appsutil/OBA_our12-test.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
[oraoba@our12-test bin]$ cd ../
[oraoba@our12-test appsutil]$ ls
bin  html  install  java  log  media  OBA_our12-test.xml  out  perl  scripts  sql  temp  template
[oraoba@our12-test appsutil]$ cd scripts/
[oraoba@our12-test scripts]$ ls
OBA_our12-test
[oraoba@our12-test scripts]$ cd OBA_our12-test/
[oraoba@our12-test OBA_our12-test]$ ls
adautocfg.sh  adchknls.pl  addbctl.sh  addlnctl.sh  adexecsql.pl  adlsnodes.sh  adpreclone.pl  adstopdb.sql  adstrtdb.sql
[oraoba@our12-test OBA_our12-test]$