DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, October 11, 2017

Creating the Autoconfig Script in DBTier

Steps:
      1. Creating the Context file
      2. Creating the autoconfig script folder in DBTier
      3.Executing the autoconfig file.


1) Creating the Context file:

[oracle@myebs bin]$ perl adbldxml.pl appsuser=apps appspasswd=apps jtop=/u01/mydb/db/tech_st/11.1.0/appsutil_bkp/jre

Starting context file generation for db tier..
Using JVM from /u01/mydb/db/tech_st/11.1.0/appsutil_bkp/jre/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/u01/mydb/db/tech_st/11.1.0/appsutil/log/adbldxml_10110135.log

Enter the value for Display Variable:

Invalid input, reenter the value for Display Variable: 2

The context file has been created at:
/u01/mydb/db/tech_st/11.1.0/appsutil/PROD_myebs.xml
[oracle@myebs bin]$ cd /u01/mydb/db/tech_st/11.1.0/appsutil/
[oracle@myebs appsutil]$ ls
bin  html  java  log  media  perl  PROD_myebs.xml  sql  template
[oracle@myebs appsutil]$ cd bin/

2) Creating the Autoconfig Script folder in DBTier:

[oracle@myebs bin]$ sh adconfig.sh contextfile=/u01/mydb/db/tech_st/11.1.0/appsutil/PROD_myebs.xml appspass=apps

The log file for this session is located at: /u01/mydb/db/tech_st/11.1.0/appsutil/log/PROD_myebs/10110138/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/mydb/db/tech_st/11.1.0
        Classpath                   : :/u01/mydb/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/u01/mydb/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/u01/mydb/db/tech_st/11.1.0/appsutil/java:/u01/mydb/db/tech_st/11.1.0/jlib/netcfg.jar:/u01/mydb/db/tech_st/11.1.0/jlib/ldapjclnt11.jar

        Using Context file          : /u01/mydb/db/tech_st/11.1.0/appsutil/PROD_myebs.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 db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

[oracle@myebs PROD_myebs]$ pwd
/u01/mydb/db/tech_st/11.1.0/appsutil/scripts/PROD_myebs
[oracle@myebs PROD_myebs]$ ls -ltr
total 60
-rw------- 1 oracle oinstall  1303 Oct 11 01:40 adstrtdb.sql
-rw------- 1 oracle oinstall   805 Oct 11 01:40 adstopdb.sql
-rwx------ 1 oracle oinstall  7384 Oct 11 01:40 adexecsql.pl
-rwx------ 1 oracle oinstall  5274 Oct 11 01:40 adchknls.pl
-rwx------ 1 oracle oinstall 15247 Oct 11 01:40 adpreclone.pl
-rwx------ 1 oracle oinstall  3450 Oct 11 01:40 adlsnodes.sh
-rwx------ 1 oracle oinstall  6749 Oct 11 01:40 addlnctl.sh
-rwx------ 1 oracle oinstall  2760 Oct 11 01:40 addbctl.sh
-rwx------ 1 oracle oinstall  1518 Oct 11 01:40 adautocfg.sh
[oracle@myebs PROD_myebs]$

3) Executing the Auto Config:

[oracle@myebs PROD_myebs]$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/mydb/db/tech_st/11.1.0/appsutil/log/PROD_myebs/10110140/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/mydb/db/tech_st/11.1.0
        Classpath                   : :/u01/mydb/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/u01/mydb/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/u01/mydb/db/tech_st/11.1.0/appsutil/java:/u01/mydb/db/tech_st/11.1.0/jlib/netcfg.jar:/u01/mydb/db/tech_st/11.1.0/jlib/ldapjclnt11.jar

        Using Context file          : /u01/mydb/db/tech_st/11.1.0/appsutil/PROD_myebs.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 db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

[oracle@myebs PROD_myebs]$

No comments: