Saturday, February 2, 2019

Create scripts directory under appsutil in EBS environment (appsutil/scripts)

Create scripts directory in appsutil in EBS environment (appsutil/scrtips)

When we execute admkappsutil.pl on application server to generate appsutil.zip and unzip on DB node ,we don't find scripts directory under appsutil folder.( $ORACLE_HOME/appsutil)

In order to over come this issue, we need to run perl adbldxml.pl utility ($ORACLE_HOME/appsutil/bin) to  build XML file on database Tier.

This newly created XML file is a central repository for database which intact with application node.

By using newly generated XML file, we need to run adconfig.sh ($ORACLE_HOME/appsutil/bin) on DB node. This will create scripts directory under $ORACLE_HOME/appsutil

Steps

====

1 ) On Application Tier and source the env file.

**Go to $AD_TOP/bin

**perl admkappsutil.pl to create appsutil.zip file

** Log file created at $INST_TOP/admin/out

** Copy appsutil.zip to DB node $ORACLE_HOME

** unzip -o appsutil.zip

** Build new XML for Database using perl  adbldxml.pl ( $ORACLE_HOME/appsutil/bin )

** Run ./adconfig.sh ($ORACLE_HOME/appsutil/bin) using new XML file.

** This will create scripts directory at $ORACLE_HOME/appsutil

[@jajajja~]$ cd $AD_TOP/bin

[***@jajajbin]$ pwd

/u01/app/**/orti/apps/apps_st/appl/ad/12.0.0/bin

[***@jajajajbin]$ perl admkappsutil.pl

Starting the generation of appsutil.zip

Log file located at /u01/app/***/****/inst/apps/orat/admin/log/MakeAppsUtil_02011459.log

output located at /u01/app/***/DAJALA/inst/apps/DAJALA_lkjhga/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

@jajajajbin]$ perl adbldxml.pl

Starting context file generation for db tier..

Using JVM from /u01/app/***/JddadaI/db/tech_st/12.1.0.2/jdk/jre/bin/java to execute java programs..

APPS Password: *****
The log file for this adbldxml session is located at:

/u01/app/*****/DAJALA/db/tech_st/12.1.0.2/appsutil/log/adbldxml_02011519.log

UnsatisfiedLinkError exception loading native library: njni12

java.lang.UnsatisfiedLinkError: no njni12 in java.library.path

Could not Connect to the Database with the above parameters, Please answer the Questions below

Enter Hostname of Database server: jajajajaa

Enter Port of Database server: 1522

Enter SID of Database server: DAJALA

The context file has been created at:

/u01/app/****/DAJALA/db/tech_st/12.1.0.2/appsutil/DAJALA_jaudauasdb01.xml

[@jaudauas bin]$ ./adconfig.sh

Enter the full path to the Context file: /u01/app/****/DAJALA/db/tech_st/12.1.0.2/appsutil/DAJALA_jaudauasxml

Enter the APPS user password:

The log file for this session is located at: /u01/app/****/DAJALA/db/tech_st/12.1.0.2/appsutil/log/DAJALA_jaudauas/02011522/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
l

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.


Thanks.
Sreeharsha

No comments:

Post a Comment