Troubleshooting

Troubleshooting

 STEP 1: Try to Start the DB without ENV File:

[oracle@dev140 10.2.0]$ export ORACLE_SID=PROD

[oracle@dev140 10.2.0]$ export ORACLE_HOME=/oracle/PROD/db/tech_st/10.2.0/

[oracle@dev140 10.2.0]$ export PATH=$PATH:$ORACLE_HOME/bin

[oracle@dev140 10.2.0]$ echo $PATH

/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin:/ oracle/PROD/db/tech_st/10.2.0//bin

[oracle@dev140 10.2.0]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Dec 20 14:57:22 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size 1271540 bytes

Variable Size 427821324 bytes

Database Buffers 633339904 bytes

Redo Buffers 11309056 bytes

Database mounted.

Database opened.

SQL>

Step 2: Creating LISTENER / NET SERVICE NAME

Creating Listner using NETCA.

[oracle@dev140 bin]$ pwd

/oracle/PROD/db/tech_st/10.2.0/bin

[oracle@dev140 bin]$

[oracle@dev140 bin]$ ./netca

Step:3 creating context file and Inst_top

oracle@dev140 bin]$ pwd

/oracle/PROD/apps/apps_st/comn/clone/bin

[oracle@dev140 bin]$

set the CLASSPATH using Following Command.

[oracle@dev140 bin]$ ls

adaddnode.pl adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl

[oracle@dev140 bin]$ export CLASSPATH=/oracle/PROD/apps/apps_st/comn/java/classes

[oracle@dev140 bin]$ ./adclonectx.pl

CREATING CONTEXT FILE IN APPS TIER USING FOLLOWING COMMAND

[oracle@dev140 bin]$ ./adclonectx.pl retrieve

Copyright (c) 2002 Oracle Corporation

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adclonectx Version 120.23.12010000.1

Running:

/oracle/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/RetrieveContext_12201730.log

Database Host [dev140]:

Database Host Domain [chainsys.com]:

Database Port [1521]:

Database SID:PROD

APPS Schema Name [APPS]:

APPS Schema Password:apps

The following context files are available:

[1] PROD_dev140 (APPL_TOP Context)

[2] PROD_dev140 (Database Context)

Select the context to retrieve [1]:1

Destination file path [/oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml]:/oracle/PROD_dev140.xml---------------------------------->inew context file created and stored in this path.

Retrieved context file to /oracle/PROD_dev140.xml

Log file location: /oracle/PROD/apps/apps_st/comn/clone/bin/RetrieveContext_12201730.log

[oracle@dev140 bin]$

CREATING INST_TOP

[oracle@dev140 bin]$ ./adclonectx.pl contextfile=/oracle/PROD_dev140.xml

Copyright (c) 2002 Oracle Corporation

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adclonectx Version 120.23.12010000.1

Running:

/oracle/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/oracle/PROD/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /oracle/PROD_dev140.xml

Enter the APPS password : apps

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1220173221.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [dev140] :

It is recommended that your inputs are validated by the program.

However you might choose not to validate them under following circumstances:

-If cloning a context on source system for a remote system.

-If cloning a context on a machine where the ports are taken and

you do not want to shutdown the services at this point.

-If cloning a context but the database it needs to connect is not available.

Do you want the inputs to be validated (y/n) [n] ? : y----> IF WE GIVE YES INST_TOP WILL BE CREATED

Target System Database SID : PROD

Target System Database Server Node [dev140] :

Target System Base Directory : /oracle/PROD

Target System Tools ORACLE_HOME Directory [/oracle/PROD/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/oracle/PROD/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/oracle/PROD/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/oracle/PROD/apps/apps_st/comn] :

Target System Instance Home Directory [/oracle/PROD/inst] :

Username for the Applications File System Owner [oracle] :

Group for the Applications File System Owner [dba] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [dev140:0.0] (y/n) ? : n

Target System Display [dev140:0.0] :

Target System Port Pool [0-99] : 0

Checking the port pool 0

done: Port Pool 0 is free

Report file located at /oracle/PROD/inst/apps/PROD_dev140/admin/out/portpool.lst

Complete port information available at /oracle/PROD/inst/apps/PROD_dev140/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /usr/tmp

3. /oracle/PROD/db/tech_st/10.2.0/appsutil/outbound/PROD_dev140

4. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from :

/oracle/PROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :

/oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1220173221.log

contextfile=/oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml

Check Clone Context logfile /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1220173221.log for details.

[oracle@dev140 bin]$ pwd

/oracle/PROD/apps/apps_st/comn/clone/bin

[oracle@dev140 bin]$

RUN ADCONFIG TO CREATING .ENV FILE.

[oracle@dev140 bin]$ pwd

/oracle/PROD/apps/apps_st/appl/ad/12.0.0/bin

[oracle@dev140 bin]$

[oracle@dev140 bin]$ ./adconfig.pl contextfile=/oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml

Enter the APPS user password:

The log file for this session is located at: /oracle/PROD/inst/apps/PROD_dev140/admin/log/12201824/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location : /oracle/PROD/inst/apps/PROD_dev140

Classpath : /oracle/PROD/apps/apps_st/comn/java/lib/appsborg2.zip:/oracle/PROD/apps/apps_st/comn/java/classes

Using Context file : /oracle/PROD/inst/apps/PROD_dev140/appl/admin/PROD_dev140.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

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

Configuring templates from all of the product tops...

Configuring AD_TOP........COMPLETED

Configuring FND_TOP.......COMPLETED

Configuring ICX_TOP.......COMPLETED

Configuring MSC_TOP.......COMPLETED

Configuring IEO_TOP.......COMPLETED

Configuring BIS_TOP.......COMPLETED

Configuring AMS_TOP.......COMPLETED

Configuring CCT_TOP.......COMPLETED

Configuring WSH_TOP.......COMPLETED

Configuring CLN_TOP.......COMPLETED

Configuring OKE_TOP.......COMPLETED

Configuring OKL_TOP.......COMPLETED

Configuring OKS_TOP.......COMPLETED

Configuring CSF_TOP.......COMPLETED

Configuring IGS_TOP.......COMPLETED

Configuring IBY_TOP.......COMPLETED

Configuring JTF_TOP.......COMPLETED

Configuring MWA_TOP.......COMPLETED

Configuring CN_TOP........COMPLETED

Configuring CSI_TOP.......COMPLETED

Configuring WIP_TOP.......COMPLETED

Configuring CSE_TOP.......COMPLETED

Configuring EAM_TOP.......COMPLETED

Configuring FTE_TOP.......COMPLETED

Configuring ONT_TOP.......COMPLETED

Configuring AR_TOP........COMPLETED

Configuring AHL_TOP.......COMPLETED

Configuring OZF_TOP.......COMPLETED

Configuring IES_TOP.......COMPLETED

Configuring CSD_TOP.......COMPLETED

Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

[oracle@dev140 bin]$

Step 3: Creating Appsutil using admkappsutil.

Source the new APPS .ENV file

[oracle@dev140 bin]$ pwd

/oracle/PROD/apps/apps_st/appl/ad/12.0.0/bin

[oracle@dev140 bin]$

[oracle@dev140 bin]$ ./admkappsutil.pl

OUTPUT OF THIS SCRIPT

Starting the generation of appsutil.zip

Log file located at /oracle/PROD/inst/apps/PROD_dev140/admin/log/MakeAppsUtil_12201842.log

output located at /oracle/PROD/inst/apps/PROD_dev140/admin/out/appsutil.zip

MakeAppsUtil completed successfully.

[oracle@dev140 bin]$

MOVE THE APPSUTIL ZIP FILE TO RDBMS HOME LOCATION USING FOLLOWING COMMAND

[oracle@dev140 bin]$cp -pr /oracle/PROD/inst/apps/PROD_dev140/admin/out/appsutil.zip /oracle/PROD/db/tech_st/10.2.0/

UNZIP THIS FILE IN RDBMS HOME LOCATION

[oracle@dev140 10.2.0]$ unzip -o appsutil.zip

STEP :4 NO JRE FILE IN APPSUTIL RDBMS HOME.SO COPYING FROM THE COMMONTOP JRE DIR .USING THE FOLLOWING STEP.

[oracle@dev140 clone]$ pwd

/oracle/PROD/apps/apps_st/comn/clone

[oracle@dev140 clone]$ cp -pr jre /oracle/PROD/db/tech_st/10.2.0/appsutil

OR THIS COMMAND

[oracle@dev140 clone]$ cp -vR jre /oracle/PROD/db/tech_st/10.2.0/appsutil

STEP:5

CREATING CONTEXT FILE IN DBTIER USING FOLLOWING STEPS

SET YOUR OWN PROFILE

[oracle@dev140 10.2.0]$ . profile

[oracle@dev140 10.2.0]$ pwd

/oracle/PROD/db/tech_st/10.2.0

[oracle@dev140 10.2.0]$ cd appsutil/bin/

[oracle@dev140 bin]$ ./adbldxml.pl

OUTPUT:

Starting context file generation for db tier..

Using JVM from /oracle/PROD/db/tech_st/10.2.0/appsutil/jre/bin/java to execute java programs..

APPS Password: apps

The log file for this adbldxml session is located at:

/oracle/PROD/db/tech_st/10.2.0/appsutil/log/adbldxml_12201900.log

AC-00013: Error: File: /oracle/PROD/db/tech_st/10.2.0/network/admin/listener.ora is not a valid file as database SID could not be found for connect string: PROD

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

Enter Hostname of Database server: dev140

Enter Port of Database server: 1521

Enter SID of Database server: PROD

The context file has been created at:

/oracle/PROD/db/tech_st/10.2.0/appsutil/PROD_dev140.xml

[oracle@dev140 bin]$

CREATING .ENV FILE BY USING ADCONFIG.PL

[oracle@dev140 bin]$ pwd

/oracle/PROD/db/tech_st/10.2.0/bin

[oracle@dev140 bin]$

[oracle@dev140 bin]$ ./adconfig.pl contextfile=/oracle/PROD/db/tech_st/10.2.0/appsutil/PROD_dev140.xml

OUTPUT:

Enter the APPS user password:

The log file for this session is located at: /oracle/PROD/db/tech_st/10.2.0/appsutil/log/PROD_dev140/12201906/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /oracle/PROD/db/tech_st/10.2.0

Classpath : :/oracle/PROD/db/tech_st/10.2.0/jdbc/lib/ojdbc14.jar:/oracle/PROD/db/tech_st/10.2.0/appsutil/java/xmlparserv2.jar:/oracle/PROD/db/tech_st/10.2.0/appsutil/java:/oracle/PROD/db/tech_st/10.2.0/jlib/netcfg.jar:/oracle/PROD/db/tech_st/10.2.0/jlib/ldapjclnt10.jar

Using Context file : /oracle/PROD/db/tech_st/10.2.0/appsutil/PROD_dev140.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 db102

Updating rdbms type in Context file to 32 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

[oracle@dev140 bin]$ pwd

/oracle/PROD/db/tech_st/10.2.0/appsutil/bin

[oracle@dev140 bin]$

SET THE APPS ENV FILE AND START THE APPLICATION