Visit Counter

Monday, August 14, 2017

Cloning of EBS R12.1 running on OEL 6 64 bit using Rapid Clone

Application Tier


----------------------------------------------------------------------------------------------------------
Login as appsmgr
-----------------------------------------------------------------------------------------------------------

/ora/apps121/PROD/apps/apps_st/appl

-bash-4.1$ . PROD_apps12.env

-bash-4.1$ cd $INST_TOP/admin/scripts

-bash-4.1$ pwd
/ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts


-bash-4.1$ ./adstpall.sh apps/apps

You are running adstpall.sh version 120.10

The logfile for this session is located at /ora/apps121/PROD/inst/apps/PROD_apps12/logs/appl/admin/log/adstpall.log
Executing service control script:
/ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts/jtffmctl.sh stop
script returned:
..
..
..
..
..

****************************************************


All enabled services on this node are stopped.

adstpall.sh:Exiting with status 0

adstpall.sh: check the logfile /ora/apps121/PROD/inst/apps/PROD_apps12/logs/appl/admin/log/adstpall.log for more information ...

-bash-4.1$ cd  /ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts

-bash-4.1$ ./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /ora/apps121/PROD/inst/apps/PROD_apps12/admin/log/08101430/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location     : /ora/apps121/PROD/inst/apps/PROD_apps12
Classpath                   : /ora/apps121/PROD/apps/apps_st/comn/java/lib/appsborg2.zip:/ora/apps121/PROD/apps/apps_st/comn/java/classes

Using Context file          : /ora/apps121/PROD/inst/apps/PROD_apps12/appl/admin/PROD_apps12.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.
You have new mail in /var/spool/mail/applmgr
-bash-4.1$

-------------------------------------------------------------------------------------------------
Oracle Database Tier
--------------------------------------------------------------------------------------------------------
Login as oracle


-bash-4.1$



-bash-4.1$ ./adautocfg.sh 
Enter the APPS user password:
The log file for this session is located at: /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/log/PROD_apps12/08101652/adconfig.log

AutoConfig is configuring the Database environment...

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

Using Context file          : /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml

Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11

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.
-bash-4.1$



-bash-4.1$

--------------------------------------------------------------------------------------------------------------------------
APPS Tier
--------------------------------------------------------------------------------------------------------------------------



/ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts



-bash-4.1$ perl adpreclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.2

Running:
perl /ora/apps121/PROD/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl java=/ora/apps121/PROD/apps/tech_st/10.1.3/appsutil/jdk mode=stage stage=/ora/apps121/PROD/apps/apps_st/comn/clone component=appsTier method= appctx=/ora/apps121/PROD/inst/apps/PROD_apps12/appl/admin/PROD_apps12.xml showProgress
APPS Password :
method defaulted to CUSTOM


Beginning application tier Stage - Sun Aug 13 09:10:02 2017

/ora/apps121/PROD/apps/tech_st/10.1.3/appsutil/jdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/oui -classpath /ora/apps121/PROD/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/ora/apps121/PROD/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:/ora/apps121/PROD/apps/apps_st/comn/java/classes:/ora/apps121/PROD/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:/ora/apps121/PROD/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/ora/apps121/PROD/apps/tech_st/10.1.3/oui/jlib/share.jar:/ora/apps121/PROD/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/ora/apps121/PROD/apps/tech_st/10.1.3/jlib/ojmisc.jar  oracle.apps.ad.clone.StageAppsTier -e /ora/apps121/PROD/inst/apps/PROD_apps12/appl/admin/PROD_apps12.xml -stage /ora/apps121/PROD/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM   -showProgress

Log file located at /ora/apps121/PROD/inst/apps/PROD_apps12/admin/log/StageAppsTier_08130910.log

  /     80% completed    

Completed Stage...
Sun Aug 13 09:10:18 2017
-bash-4.1$



------------------------------------------------------------------------------------------------------------------
DB Tier
------------------------------------------------------------------------------------------------------------------


-bash-4.1$ pwd
/ora/apps121/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_apps12
-bash-4.1$
-bash-4.1$ perl adpreclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.2

Enter the APPS User Password:
Running:
perl /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/bin/adclone.pl java=/ora/apps121/PROD/db/tech_st/11.1.0/appsutil/jre mode=stage stage=/ora/apps121/PROD/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/ora/apps121/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml showProgress
APPS Password :

Beginning database tier Stage - Sun Aug 13 09:18:03 2017

/ora/apps121/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/ora/apps121/PROD/db/tech_st/11.1.0/oui -classpath /ora/apps121/PROD/db/tech_st/11.1.0/lib/xmlparserv2.jar:/ora/apps121/PROD/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/ora/apps121/PROD/db/tech_st/11.1.0/appsutil/java:/ora/apps121/PROD/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/ora/apps121/PROD/db/tech_st/11.1.0/oui/jlib/ewt3.jar:/ora/apps121/PROD/db/tech_st/11.1.0/oui/jlib/share.jar:/ora/apps121/PROD/db/tech_st/11.1.0/oui/jlib/srvm.jar:/ora/apps121/PROD/db/tech_st/11.1.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml -stage /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password :
Log file located at /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/log/PROD_apps12/StageDBTier_08130918.log

  /     79% completed    

Completed Stage...
Sun Aug 13 09:18:17 2017



-bash-4.1$ /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_apps12


Shutdown DB


-bash-4.1$ ./addbctl.sh stop

You are running addbctl.sh version 120.1


Shutting down database PROD ...


SQL*Plus: Release 11.1.0.7.0 - Production on Sun Aug 13 09:29:41 2017

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0

-bash-4.1$


-bash-4.1$ pwd
/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin

-bash-4.1$ perl adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.1

Enter the APPS password :

Running:
/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/java:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_2641.lst -stage /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone  2> /tmp/adcfgclone_2641.err; echo $? > /tmp/adcfgclone_2641.res

Log file located at /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0813150147.log

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

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

Target Instance is RAC (y/n) [n] : 

Target System Database SID : PROD  

Target System Base Directory : /ora/appscl

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [1] : 

Target System DATA_TOP Directory 1 [/ora/apps121/PROD/db/apps_st/data] : /ora/appscl/PROD/db/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/ora/appscl/db/tech_st/11.1.0] : /ora/appscl/PROD/db/tech_st/11.1.0

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

Target System Port Pool [0-99] : 7

Checking the port pool 4
done: Port Pool 4 is free
Report file located at /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port information available at /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/temp/portpool.lst

Backing up /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml to /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml.bak

Creating the new Database Context file from :
  /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
  /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml

Log file located at /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0813150147.log
Check Clone Context logfile /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0813150147.log for details.

Running Rapid Clone with command:
perl /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml showProgress contextValidated=true
Running:
perl /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml showProgress contextValidated=true
APPS Password :

Beginning database tier Apply - Sun Aug 13 15:25:05 2017

/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/ora/appscl/PROD/db/tech_st/11.1.0/oui -classpath /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc6.jar:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/java:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/ewt3.jar:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/srvm.jar:/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/PROD_apps12.xml -stage /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/clone   -showProgress
APPS Password : Log file located at /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/log/PROD_apps12/ApplyDBTier_08131525.log
  \     15% completed    

Completed Apply...
Sun Aug 13 15:31:40 2017

Starting database listener for PROD:
Running:
/ora/appscl/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_apps12/addlnctl.sh start PROD

You are running addlnctl.sh version 120.1.12010000.2

Logfile: /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/log/PROD_apps12/addlnctl.txt

Starting listener process PROD ...


Listener PROD has already been started.


addlnctl.sh: exiting with status 0



-------------------------------------------------------------------------------------------------------------
Apps Tier
-------------------------------------------------------------------------------------------------------------

-bash-4.1$ cd $INST_TOP/admin/scripts

-bash-4.1$ pwd

/ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts

-bash-4.1$


Do it this step open new terminal and don't set up env

/ora/appscl/PROD/apps/apps_st/comn/clone/bin

-bash-4.1$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.1

Enter the APPS password :

Running:
/ora/appscl/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /ora/appscl/PROD/apps/apps_st/comn/clone/jlib/java:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /ora/appscl/PROD/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_26593.lst -stage /ora/appscl/PROD/apps/apps_st/comn/clone  2> /tmp/adcfgclone_26593.err; echo $? > /tmp/adcfgclone_26593.res

Log file located at /ora/appscl/PROD/apps/apps_st/comn/clone/bin/CloneContext_0815083444.log

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

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

Target System Database SID : VIS

Target System Database Server Node [apps12] : 

Target System Base Directory : /ora/appscl

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

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

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

Target System COMMON_TOP Directory [/ora/appscl/apps/apps_st/comn] : /ora/appscl/PROD/apps/apps_st/appl/comn
RC-00002: Warning: Directory /ora/appscl/PROD/apps/apps_st/appl/comn not found.

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

Target System Instance Home Directory [/ora/appscl/inst] : /ora/appscl/PROD/inst

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 [apps12:0.0] (y/n) ? : y

Target System Port Pool [0-99] : 7

Checking the port pool 7
done: Port Pool 7 is free
Report file located at /ora/appscl/PROD/inst/apps/VIS_apps12/admin/out/portpool.lst
Complete port information available at /ora/appscl/PROD/inst/apps/VIS_apps12/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /ora/appscl/PROD/db/tech_st/11.1.0/appsutil/outbound/VIS_apps12
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 :
  /ora/appscl/PROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /ora/appscl/PROD/inst/apps/VIS_apps12/appl/admin/VIS_apps12.xml

Log file located at /ora/appscl/PROD/apps/apps_st/comn/clone/bin/CloneContext_0815083444.log
Check Clone Context logfile /ora/appscl/PROD/apps/apps_st/comn/clone/bin/CloneContext_0815083444.log for details.

Running Rapid Clone with command:
perl /ora/appscl/PROD/apps/apps_st/comn/clone/bin/adclone.pl java=/ora/appscl/PROD/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/ora/appscl/PROD/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/ora/appscl/PROD/inst/apps/VIS_apps12/appl/admin/VIS_apps12.xml showProgress contextValidated=true
Running:
perl /ora/appscl/PROD/apps/apps_st/comn/clone/bin/adclone.pl java=/ora/appscl/PROD/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/ora/appscl/PROD/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/ora/appscl/PROD/inst/apps/VIS_apps12/appl/admin/VIS_apps12.xml showProgress contextValidated=true
APPS Password :

Beginning application tier Apply - Tue Aug 15 08:58:31 2017

/ora/appscl/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /ora/appscl/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/java:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/oui/share.jar:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/ora/appscl/PROD/apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /ora/appscl/PROD/inst/apps/VIS_apps12/appl/admin/VIS_apps12.xml -stage /ora/appscl/PROD/apps/apps_st/comn/clone    -showProgress
APPS Password : Log file located at /ora/appscl/PROD/inst/apps/VIS_apps12/admin/log/ApplyAppsTier_08150858.log
  -     71% completed    

Completed Apply...
Tue Aug 15 09:02:23 2017

Starting application Services for VIS:
Running:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adstrtal.sh -nopromptmsg

You are running adstrtal.sh version 120.15

The logfile for this session is located at /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adstrtal.log
Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.6

Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adopmnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_VIS.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adalnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adapcctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.13

Starting OPMN managed OACORE OC4J instance  ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adoacorectl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh  version 120.16

Starting OPMN managed FORMS OC4J instance  ...

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adformsctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.8

Starting OPMN managed OAFM OC4J instance  ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adoafmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.17.12010000.3

Starting concurrent manager for VIS ...
Starting VIS_0815@VIS Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adcmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/ora/appscl/PROD/inst/apps/VIS_apps12/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /ora/appscl/PROD/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for VIS on port 9307 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /ora/appscl/PROD/inst/apps/VIS_apps12/logs/appl/admin/log/adstrtal.log for more information ...

-bash-4.1$



New Port:


http://apps12.ora.com:8007/OA_HTML/RF.jsp?function_id=28716&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=US&params=-cAVMd3G07eI8YQCsc5b0qGjLatsBpcsjWh-Fg0XzYwk4J-kfrI2Tkk9NY0Rtn1I&oas=zo090nBN6oOBSrqsxIDExw..

sysadmin
sysadmin









Rapid Clone Failed While Running "Adcfgclone.pl dbTier": ORA-01194 and RC-00118

Refer: 375389.1


While cloning Oracle EBS 12.1.1...I retry below command after getting this error.

$ perl adcfgclone.pl dbTier

...
...
...
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 581506616 bytes
Fixed Size 452152 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes

Control file created.

alter database open resetlogs




Solution:


Please follow one of the following solutions (In a crash and burn or non business critical instance):

Solution 1
Startup mount;
SQL> recover database using backup controlfile until cancel;
-- type CANCEL

SQL> alter database open resetlogs; 
Retry the clone. If the SQL commands or the reattempt of the clone fails to recover the database, then you must follow solution 2. There are no other solutions for this issue.


Solution 2
1. Shutdown the source database normally.
2. Re-copy the database files from the source to target and retry the clone process.

Wednesday, August 9, 2017

Installing Oracle EBS 12.1.1 on Oracle Linux 6 (64-bit)

Env:

EBS: 12.1.1
O/S:  Oracle Linux 6 (64-bit)
-------------------------------------------

Prerequisites:

  • Edit ‘/etc/hosts’ file and add the hostname in the below shown format

[root@apps12 rapidwiz]# cat /etc/hosts



127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1              localhost localhost.localdomain localhost6 localhost6.localdomain6

192.0.0.28 apps12.ora.com apps12

[root@apps12 rapidwiz]#

---------------------------------------------------------------------------------------------------------

  • Edit the /etc/sysctl.conf file and configure the kernel settings as shown below. After editing the file, use the
  •  “sysctl -p” command or restart the system to invoke the new settings.


[root@apps12 rapidwiz]# cat /etc/sysctl.conf
# Kernel sysctl configuration file for Oracle Linux
#
# For binary values, 0 is disabled, 1 is enabled.  See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Disable netfilter on bridges.
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0

kernel.shmall = 2097152
kernel.shmmax = 5203054592
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 9815744
net.ipv4.ip_local_port_range = 10000 65000
kernel.msgmni = 2878
fs.aio-max-nr = 1048576
kernel.msgmax = 8192
kernel.msgmnb = 65535
net.core.rmem_default = 10485762
net.core.wmem_default = 10485762
net.core.rmem_max = 4194304
net.core.wmem_max = 10485762


[root@apps12 rapidwiz]#  /etc/sysctl.conf/sysctl -p

----------------------------------------------------------------------------------------------------------------


  • Edit the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters as below.

hard nofile 65536
soft nofile 4096
hard nproc 16384
soft nproc 2047
hard stack 16384
soft stack 10240


-------------------------------------------------------------------------------------------------


  • Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause attempted network connections to an Oracle database to fail. Add or update the following entries to these minimum settings in the /etc/resolv.conf file.
options attempts:5
options timeout:15
-------------------------------------------------------------------------------------------------
Create oraInst.loc if not exists and add below entry.

[root@apps12 etc]# ls -l oraInst.loc
-rwxrwxrwx. 1 oracle dba  59 Jul 18 14:02 oraInst.loc


[root@apps12 etc]# cat oraInst.loc

inventory_loc=/ora/oracle/CRP/oraInventory
inst_group=dba

[root@apps12 etc]#


--------------------------------------------------------------------------------------------------
http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/


openmotif21-2.1.30-11.EL6.i686 (32-bit)
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386
libXrender-0.9.5-1.el6.i686
binutils-2.20.51.0.2-5.20.el6.x86_64
compat-libstdc++-296-2.96-144.el6.i686
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.5-6.el6.x86_64
gcc-c++-4.4.5-6.el6.x86_64
glibc-2.12-1.7.el6.i686 (32-bit)
glibc-2.12-1.7.el6.x86_64
glibc-common-2.12-1.7.el6.x86_64
glibc-devel-2.12-1.7.el6.i686 (32-bit)
glibc-devel-2.12-1.7.el6.x86_64
libgcc-4.4.4-13.el6.i686
libgcc-4.4.4-13.el6.x86_64
libstdc++-devel-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6.x86_64
libstdc++-4.4.4-13.el6.i686
libstdc++-4.4.4-13.el6.x86_64
libXi-1.3-3.el6.i686
libXp-1.0.0-15.1.el6.i686
libXp-1.0.0-15.1.el6.x86_64
libXtst-1.0.99.2-3.el6.i686
libaio-0.3.107-10.el6.i686
libaio-0.3.107-10.el6.x86_64
libgomp-4.4.4-13.el6.x86_64
make-3.81-19.el6.x86_64
gdbm-1.8.0-36.el6.i686
gdbm-1.8.0-36.el6.x86_64
redhat-lsb-4.0-3.0.1.el6.x86_64
sysstat-9.0.4-11.el6.x86_64
util-linux-ng-2.17.2-6.el6.x86_64
compat-libcap1-1.10-1.x86_64
compat-libstdc++-33-3.2.3-69.el6.x86_64
elfutils-libelf-devel-0.148.1-el6.x86_64
libaio-devel-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6.x86_64
unixODBC-2.2.14-11.el6.i686
unixODBC-devel-2.2.14-11.el6.i686
xorg-x11-utils-7.4-8.el6.x86_64







---------------------------------------------------------------------------------------------------
  • Create users and assign default groups as shown below. ‘oracle‘ user is the owner of database tier and ‘applmgr‘ is the owner of application tier and these users belong to ‘dba’ group. We follow these notations through out the installation process. Also create required directories and change permissions as shown below.


# groupadd dba
useradd -g dba oracle
useradd -g dba applmgr
mkdir /ora/apps121stage
chmod -R 777 oracle:dba /ora/apps121stage
chown -R oracle:dba /ora/apps121stage
chgrp -R dba /ora/apps121stage





Error: 


AC-00402: Unable to read driver file: /opt/oracrp/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv


Solution:

First of all rename the unzip version 6 because unzip ver 6 does not support staging of EBS 12.1.1 so we need download and install ver 5 for staging EBS 12.1.1

Rename the unzip version 6

# mv /usr/bin/unzip  /usr/bin/unzip6

Download unzip version 5 for staging below the steps

https://oss.oracle.com/el4/unzip/unzip.html

unzip utility
unzip-5.51-10.el5.src.rpm

Installation

  • Download tar archive containing unzip utility
  • Extract the unzip utility from the tar file
  • # tar -xf unzip.tar
  • Copy this utility to /usr/local/bin

  • Provide execute permission to downloaded file using command :
  • # chmod +x /usr/local/bin/unzip
  • Make sure you run unzip as /usr/local/bin/unzip


Creating Staging Area (All Zip files in apps121stage folder)


 # cd /ora/apps121stage

 # unzip \*.zip


[root@apps12 apps121stage]# pwd
/ora/apps121stage

[root@apps12 apps121stage]# ls

oraAppDB oraApps oraAS oraDB startCD 

B53824-01_1of4.zip  V15680-01_1of3.zip  V15684-01_1of3.zip  V15688-01_1of2.zip
B53824-01_2of4.zip  V15680-01_2of3.zip  V15684-01_2of3.zip  V15688-01_2of2.zip
B53824-01_3of4.zip  V15680-01_3of3.zip  V15684-01_3of3.zip  V15689-01.zip
B53824-01_4of4.zip  V15681-01_1of3.zip  V15685-01_1of3.zip  V15690-01_1of3.zip
V15681-01_2of3.zip  V15685-01_2of3.zip  V15690-01_2of3.zip
V15681-01_3of3.zip  V15685-01_3of3.zip  V15690-01_3of3.zip
V15682-01_1of3.zip  V15686-01_1of3.zip  V15691-01_1of3.zip
V15682-01_2of3.zip  V15686-01_2of3.zip  V15691-01_2of3.zip
V15682-01_3of3.zip  V15686-01_3of3.zip  V15691-01_3of3.zip
V15679-01_1of3.zip  V15683-01_1of3.zip  V15687-01_1of3.zip
V15679-01_2of3.zip  V15683-01_2of3.zip  V15687-01_2of3.zip
V15679-01_3of3.zip  V15683-01_3of3.zip  V15687-01_3of3.zip

[root@apps12 apps121stage]#


[root@apps12 rapidwiz]# pwd

/ora/apps121stage/startCD/Disk1/rapidwiz

[root@apps12 rapidwiz]# ls

adautostg.pl   driver  images  oui           RapidWiz.ini         template
bin            etc     jlib    rapidwiz      RapidWizVersion      unzip
ClientWiz.cmd  File    jre     RapidWiz.cmd  RapidWizVersion.cmd


[root@apps12 rapidwiz]# ./rapidwiz





















 http://apps.ora.com:8000















RW-50015: Error: – HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button



RW-50015: Error: – HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button






/ora/apps121/PROD/inst/apps/PROD_apps12/logs


HTTP

-----
   checking URL = http://apps12.ora.com:8000

   RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page

----------
   checking URL = http://apps12.ora.com:8000/OA_HTML/help

   RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory

------------------
   RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP

----
   checking URL = http://apps12.ora.com:8000/OA_HTML/jtfTestCookie.jsp

   RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page

-----------
   RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
[root@apps12 logs]#





Checking Application status :-
=================================================================



At last steps of Installation during validating system configuration it failed on HTTP, loginpage, Help Directory and JSP.
When checked all services were up and running except web server.
checking status of OPMN managed processes…
Processes in Instance: PROD_ebs.ebs.ORACLE.com

———————————+——————–+———+———
ias-component                    | process-type       |     pid | status
———————————+——————–+———+———
OC4JGroup:default_group          | OC4J:oafm          |   13776 | Alive
OC4JGroup:default_group          | OC4J:forms         |   13703 | Alive
OC4JGroup:default_group          | OC4J:oacore       |   13617 | Alive
HTTP_Server                              | HTTP_Server       |   13560 | Down

Http_server is shown as Down.


===============================================================

 Due to missing library.  /usr/lib/libdb.so.2
if you got this type of error then you can take a new terminal and Down the all application services and follow below steps.








Solution:=
================================================================ 
* Shut DB services. (Database User oracle)

$ cd /ora/apps121/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_apps12

$./addlnctl.sh

$./addbctl.sh stop


Shut Application Services (Application user appsmgr)

/ora/apps121/PROD/inst/apps/PROD_apps12/admin/scripts

./adstpall.sh apps/apps


* create the below link for library file 


  root  ]# ln -s   /usr/lib/libgdbm.so.2.0.0  /usr/lib/libdb.so.2


# vi  /etc/selinux/config

change the SELINUX=enforcing


* Startup all application services. And press the Retry button 
 
after  check the oacore status


./addlnctl.sh start PROD

./addbctl.sh start

./adstrtal.sh start




[root@apps12 scripts]#  ./adoacorectl.sh status

You are running adoacorectl.sh version 120.13

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: PROD_apps12.apps12.ora.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |     715 | Alive
OC4JGroup:default_group          | OC4J:forms         |     644 | Alive
OC4JGroup:default_group          | OC4J:oacore        |     559 | Alive
HTTP_Server                              | HTTP_Server        |     502 | Alive


adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /ora/apps121/PROD/inst/apps/PROD_apps12/logs/appl/admin/log/adoacorectl.txt for more information ...

[root@apps12 scripts]#



























Monday, August 7, 2017

RW-50016: RW-00023: RW-50015 Installing Oracle EBS 12.1 Error



While installing Oracle EBS 12.1 on Oracle linux 6 getting below error.

Log file path
---------------

/ora/apps121/VIS/db/tech_st/11.1.0/appsutil/log/VIS_apps12

Environment File

-----------------


   RW-50016: Error: - Database ORACLE_HOME environment file was not created:
      File = /ora/apps121/PROD/db/tech_st/11.1.0/PROD_apps12.env
   RW-50016: Error: - Apps ORACLE_HOME environment file was not created:
      File = /ora/apps121/PROD/inst/apps/PROD_apps12/ora/10.1.3/PROD_apps12.env
   RW-50016: Error: - iAS ORACLE_HOME environment file was not created:
      File = /ora/apps121/PROD/inst/apps/PROD_apps12/ora/10.1.2/PROD_apps12.env
   RW-50016: Error: - APPL_TOP environment file was not created:
      File = /ora/apps121/PROD/apps/apps_st/appl/PROD_apps12.env
   RW-50016: Error: - ADOVARS environment file was not created:
      File = /ora/apps121/PROD/apps/apps_st/appl/admin/adovars.env
   RW-50016: Error: - APPSCONFIG was not created:
      File = /ora/apps121/PROD/apps/apps_st/appl/admin/adconfig.txt
DBC File

---------


   RW-00023: Error: - DBC file was not created:
      File = /ora/apps121/PROD/inst/apps/PROD_apps12/appl/fnd/12.0.0/secure/PROD.dbc
HTTP

-----


   checking URL = http://apps12.ora.com:8000

   RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Help Page

----------


   checking URL = http://apps12.ora.com:8000/OA_HTML/help

   RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Virtual Directory

------------------


   RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
JSP

----


   checking URL = http://apps12.ora.com:8000/OA_HTML/jtfTestCookie.jsp

   RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
Login Page

-----------


   RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.
RW-10001: Rapidinstall wizard has detected that your configuration has errors. You must resolve these issues before continuing.



Solution:
----------

# vi /etv/selinux/config




[root@apps12 VIS_apps12]# cat /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.

SELINUX=disabled


# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted









RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.



While installing Oracle EBS 12.1 getting error.

--------------------------------------------------------


/ora/apps121/VIS/db/tech_st/11.1.0/appsutil/log/VIS_apps12




Unzip Count:153

Processing Disk1....

RC-20200: Fatal: Could not find Unzip. At this time only Native UnZip 5.X is supported.

Please make sure you have UnZip 5.X in your path and try again...

Cannot execute Install for database ORACLE_HOME

    RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Running Database Install Driver for VIS instance


[root@apps12 VIS_apps12]#


Solution:

-----------



[root@apps12 VIS_apps12]# mv /usr/bin/unzip /usr/bin/unzip-ver6






Refer: 1455077.1




Saturday, August 5, 2017