Thursday, December 2, 2021

How To Recreate appsutil directory for RDBMS HOME using $AD_TOP/bin/admkappsutil.pl


Hai, in this blog we learn how to recreate appsutil directory for RDBMS HOME in EBS R12.2

E-Business Suite Applications Manager Steps To Recreate the <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME> directory (Doc ID 377495.1)


Recreate appsutil directory for RDBMS Home:
apploci@ebsprodapp3:~$ perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodapp3/admin/log/MakeAppsUtil_12011830.log
output located at /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodapp3/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
apploci@ebsprodapp3:~$ scp $INST_TOP/admin/out/appsutil.zip oraoci@192.168.4.12:/u01/app/oraoci/product/12.1.0.2/dbhome_1
Password:
appsutil.zip                                                                                                                                                          100% 3986KB  54.9MB/s   00:00
apploci@ebsprodapp3:~$

oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1$ mv appsutil appsutil_old
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1$ unzip -o appsutil.zip
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil_old$ cp jre-7u251-solaris-sparc*.tar.gz /u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil

Create jre folder from previous appsutil directory: 
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil$ tar -xvzf jre-7u251-solaris-sparc.tar.gz
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil$ tar -xvzf jre-7u251-solaris-sparcv9.tar.gz
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil$ mv jre1.7.0_251 jre

Create Contextfile for Database Tier:
oraoci@ebsproddb1:~$ cd $ORACLE_HOME/appsutil/bin
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/bin$ perl adbldxml.pl appsuser=apps appspass=appspswd template=$ORACLE_HOME/appsutil/template/adxdbctx.tmp out=$ORACLE_HOME/appsutil/PRODPDB_ebsproddb1.xml

Starting context file generation for db tier..
Using JVM from /u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/jre/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/log/adbldxml_12011857.log

Enter Database Service Name: PRODPDB

Enter the value for Display Variable: :0.0

The context file has been created at:
/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/PRODPDB_ebsproddb1.xml
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/bin$

Create Scripts directory:
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/bin$ sh adconfig.sh contextfile=$ORACLE_HOME/appsutil/PRODPDB_ebsproddb1.xml
Enter the APPS user password:
The log file for this session is located at: /u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/log/PRODPDB_ebsproddb1/12011901/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/app/oraoci/product/12.1.0.2/dbhome_1

Value of s_dbcset is AR8MSWIN1256

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AR8MSWIN1256

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.
        Classpath                   : :/u01/app/oraoci/product/12.1.0.2/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/java:/u01/app/oraoci/product/12.1.0.2/dbhome_1/jlib/netcfg.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/jlib/ldapjclnt12.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/jlib/orai18n.jar

        Using Context file          : /u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/PRODPDB_ebsproddb1.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 db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/bin$

Run AutoConfig on the <RDBMS ORACLE_HOME>:
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/scripts/PRODPDB_ebsproddb1$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/log/PRODPDB_ebsproddb1/12011902/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/app/oraoci/product/12.1.0.2/dbhome_1

Value of s_dbcset is AR8MSWIN1256

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AR8MSWIN1256

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.
        Classpath                   : :/u01/app/oraoci/product/12.1.0.2/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/java:/u01/app/oraoci/product/12.1.0.2/dbhome_1/jlib/netcfg.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/jlib/ldapjclnt12.jar:/u01/app/oraoci/product/12.1.0.2/dbhome_1/jlib/orai18n.jar

        Using Context file          : /u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/PRODPDB_ebsproddb1.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 db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
oraoci@ebsproddb1:/u01/app/oraoci/product/12.1.0.2/dbhome_1/appsutil/scripts/PRODPDB_ebsproddb1$
#############################################################################






Thanks for Reading


Regards,
Mohammed Areefuddin.

No comments:

Post a Comment