Problem:
While cloning E-Business Suite R12 on Windows 2008 to a new machine, the following error appears:
C:oracleTEST2dbtech_st11.1.0appsutilclonebin>perl adcfgclone.pl dbTier Perl lib version (v5.6.1) doesn't match executable version (v5.8.3) at C:oracle UAT1appstech_st10.1.2perl5.6.1libMSWin32-x86/Config.pm line 21. Compilation failed in require at adcfgclone.pl line 28. BEGIN failed--compilation aborted at adcfgclone.pl line 28.
Solution:
Unset PERl5LIB environment variable.
Problem:
When cloning the database tier of Illuminat HRMS Production, the process fails on 70% with error:
Beginning database tier Apply - Wed May 27 10:12:21 2009 Log file located at /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log RC-50004: Fatal: Error occurred in ApplyDatabase: Control file creation failed ERROR while running Apply... ERROR: Failed to execute adclone.pl Please check logfile. Log file /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/ApplyDBTier_05271012.log showed: --------------------------------------------------------------- ADX Database Utility --------------------------------------------------------------- getConnectionUsingAppsJDBCConnector() --> APPS_JDBC_URL='null' Trying to get connection using SID based connect descriptor getConnection() --> sDbHost : ebusinesstest sDbDomain : illuminatnm.com sDbPort : 1523 sDbSid : TEST2 sDbUser : APPS Trying to connect using SID... getConnectionUsingSID() --> JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2 Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Trying to connect using SID as ServiceName getConnectionUsingServiceName() --> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2))) Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Trying to connect using SID as ServiceName.DomainName getConnectionUsingServiceName() --> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com))) Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4)))) Connection could not be obtained; returning null -------------------ADX Database Utility Finished--------------- adcrdb.sh started at Wed May 27 10:54:18 AST 2009 The environment settings are as follows ... ORACLE_HOME : /u0/oracle/TEST2/test2db/9.2.0 ORACLE_SID : TEST2 TWO_TASK : PATH : /u0/oracle/TEST2/test2db/9.2.0/Apache/perl/bin:/u0/oracle/TEST2/test2db/9.2.0/bin:/usr/bin:/usr/sbin:/u0/oracle/TEST2/test2db/9.2.0/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:../jre/1.3.1/bin:/u0/oracle/testdb/9.2.0/Apache/perl/bin:/usr/kerberos/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:. LD_LIBRARY_PATH : /u0/oracle/TEST2/test2db/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u0/oracle/TEST2/test2db/9.2.0/ctx/lib Executable : /u0/oracle/TEST2/test2db/9.2.0/bin/sqlplus The log information will be written to /u0/oracle/TEST2/test2db/9.2.0/appsutil/log/TEST2_ebusinesstest/adcrdb_TEST2.txt Creating the control file for TEST2_ebusinesstest database ... SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:54:18 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to an idle instance. ORACLE instance shut down. Connected to an idle instance. ORACLE instance started. Total System Global Area 581506100 bytes Fixed Size 451636 bytes Variable Size 402653184 bytes Database Buffers 167772160 bytes Redo Buffers 10629120 bytes Control file created. Database altered. Tablespace altered. Database altered. Database closed. Database dismounted. ORACLE instance shut down. Connected to an idle instance. ORACLE instance started. Total System Global Area 581506100 bytes Fixed Size 451636 bytes Variable Size 402653184 bytes Database Buffers 167772160 bytes Redo Buffers 10629120 bytes Database mounted. BEGIN dbms_backup_restore.zeroDbid(0); END; * ERROR at line 1: ORA-01119: error in creating database file '/u0/oracle/TEST2/test2db/9.2.0/dbs/MISSING00395' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284 ORA-06512: at line 1 ORACLE instance shut down. Connected to an idle instance. ORACLE instance started. Total System Global Area 581506100 bytes Fixed Size 451636 bytes Variable Size 402653184 bytes Database Buffers 167772160 bytes Redo Buffers 10629120 bytes Control file created. Database altered. Tablespace altered. Database altered. old 2: '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.&libext' new 2: '/u0/oracle/TEST2/test2db/9.2.0/ctx/lib/libctxx9.so' Library created. old 2: '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.&libext' new 2: '/u0/oracle/TEST2/test2db/9.2.0/lib/libqsmashr.so' Library created. old 2: '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.&libext' new 2: '/u0/oracle/TEST2/test2db/9.2.0/lib/libordim9.so' Library created. Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production exit_code=0 Checking for errors ... ORA-01119: error in creating database file ORA-27037: unable to obtain file status ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 3284 ORA-06512: at line 1 The database has not been successfully created. Shutting down the instance ... SQL*Plus: Release 9.2.0.3.0 - Production on Wed May 27 10:57:56 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected. ORACLE instance shut down. Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production .end std out. .end err out. --------------------------------------------------------------- ADX Database Utility --------------------------------------------------------------- getConnectionUsingAppsJDBCConnector() --> APPS_JDBC_URL='null' Trying to get connection using SID based connect descriptor getConnection() --> sDbHost : ebusinesstest sDbDomain : illuminatnm.com sDbPort : 1523 sDbSid : TEST2 sDbUser : APPS Trying to connect using SID... getConnectionUsingSID() --> JDBC URL: jdbc:oracle:thin:@ebusinesstest.illuminatnm.com:1523:TEST2 Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Trying to connect using SID as ServiceName getConnectionUsingServiceName() --> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2))) Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory Trying to connect using SID as ServiceName.DomainName getConnectionUsingServiceName() --> JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebusinesstest.illuminatnm.com)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=TEST2.illuminatnm.com))) Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092864)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4)))) Connection could not be obtained; returning null -------------------ADX Database Utility Finished--------------- RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:469) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:314) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:290) at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:131) at java.lang.reflect.Constructor.newInstance(Native Method) at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68) at java.lang.Thread.run(Thread.java:479)
Solution:
The cloning process omits two files that were created since the last adpreclone.pl run. Therefore, run preclone scripts (adpreclone.pl) on the production instance before copying files.
[amazon asin=0070077290&template=iframe image&chan=default] [amazon asin=1453742735&template=iframe image&chan=default] [amazon asin=0615238440&template=iframe image&chan=default]
Here are the steps to clone the PeopleSoft instance:
1. Backup the database (FSDEV) and restore it to another name (FSTST)
2. Clear the GUID field in the PSOPTIONS table in FSTST
3. Set up ODBC connection for FSTST
4. Map PS_HOME network drive and run Configuration Manager to set up shortcuts, PS/nVision path names
5. Create new application server domain for FSTST
6. Create new batch server for FSTST
7. Stop web server and setup new PIA for FSTST
8. Start application server, batch server, web server and log on to FSTST.
[amazon asin=0071664939&template=iframe image&chan=default] [amazon asin=1430237074&template=iframe image&chan=default] [amazon asin=0071787925&template=iframe image&chan=default]
|
# |
Step |
Estimated duration |
| 1. | Prepare the test machine (echo) that shall be used as the new production machine for cloning:Remove any existing E-Business Suite instance on the machine. Ideally, reinstall the operating system, apply any required service packs, install the additional software such as JDK, Visual C++, MKS Toolkit etc. The software should be installed to the same directory paths as those on the production instance.If the test machine will not reinstalled, then remove the Oracle-related keys from the registry. |
1 day |
| 2. | Carry out the pre-clone steps for the production instance (adpreclone.pl). |
½ day |
| 3. | Shutdown the production E-Business Suite instance (application and database tier services) and copy the files from the production machine (delta) to the test machine (echo). |
1 day |
| 4. | Disconnect the production server from the network. Change the name and IP address of the test machine (echo) to that of the production machine (delta). Update the ‘hosts’ file on the new production server, so that it now contains the new IP address and hostname. |
1 hour |
| 5. | Clone the new production server. Run the clone scripts on the new production server (adcfgclone.pl). |
½ day |
| 6. | Perform stress-testing of the new server to ensure that it responds suitably to the load. |
1 day |
| 7. | Backup and test recovery of the instance on another server. |
1 day |
Please note:
1. Ensure that the Database processes are properly shut down before proceeding to copy the files; if files aren’t copied correctly, the cloning process would not be executed correctly.
2. Do not run the Gather Schema Statistics concurrent job on the new PROD instance.
Problem:
When trying to log on to the newly cloned TEST instance as sysadmin user, the following error appears:
You have insufficient privileges for the current operation. Please contact your System Administrator.
Solution:
Used URL:
http://ebusinesstest.support.com:8001/OA_HTML/jsp/fnd/aoljtest.jsp
to compare differences between TEST and PROD. Noticed that JSP Ping not working on both.
In Metalink, searched for error:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
Checked document: Subject: Troubleshooting Login (Doc ID: Note:178437.1), “3. Login: java.lang.StringIndexOutOfBoundsException when log into jtflogin.jsp”
In SQL*Plus, executed the following code:
select SESSION_COOKIE_DOMAIN from icx_parameters;
update icx.icx_parameters set SESSION_COOKIE_DOMAIN = ‘.support.com’;
commit;
select SESSION_COOKIE_DOMAIN from icx_parameters;
Tested logon on ebusinesstest, working now.
Reference:
Subject: Configuring and Troubleshooting the Self Service Framework 5.5.2 with 11i (Doc ID: Note:177095.1)
Problem:
When running AutoConfig, it fails at 50% with the following error:
ERROR
ORA-12224: TNS:no listener
Solution:
Run the following, and then restart AutoConfig.
perl <AD_TOP>/bin/adgentns.pl appspass=<APPSpwd> contextfile=<CONTEXT> -removesystem
perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml –removesystem
Reference:
Subject: TNS Connectivity With Database Breaks After Running Autoconfig
Doc ID: Note:377764.1
1020 unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip
1021 . /u0/oracle/testappl/APPSTEST_ebusinesstest.env
1022 cd /u0/oracle/testora/iAS/appsoui/setup/
1023 perl OUIsetup.pl
1024 perl /u0/oracle/testappl/ad/11.5.0/bin/adgentns.pl appspass=APPS contextfile=/u0/oracle/testappl/admin/TEST_ebusinesstest.xml -removesystem
1025 cd /u0/oracle/testcomn/clone/bin/
1026 perl adcfgclone.pl appsTier
Problem:
When rerunning adcfgclone.pl, the following error occurs:
ERROR: The version of the OUI found in /u0/oracle/testora/iAS/appsoui (2.1.0.17.0) is too low. Please make sure that you have applied the latest OUI patch required by Rapid Clone.
Restart adclone.pl after performing required corrections.
ERROR: Failed to execute adclone.pl
Solution:
Apply patch 5035661:
A. Applying the patch on the iAS $ORACLE_HOME:
———————————————-
1.Unzip the patch into the <iAS ORACLE_HOME> directory:
unzip -od <iAS ORACLE_HOME> p5035661_11i_<PLATFORM>.zip
ie: unzip -od /u01/oracle/prodora/iAS p5035661_11i_LINUX.zip
2.Source the Apps environment file :
On Unix/Linux, execute <APPL_TOP>/APPS<SID>_<hostname>.env
On Windows, execute <APPL_TOP>Envshell.cmd.
If the environment file is not available, please make sure the environment variable ‘APPL_TOP’ is set.
3.Change directory to the <iAS ORACLE_HOME>/appsoui/setup
4.Execute the perl script OUIsetup.pl:
perl OUIsetup.pl
NOTE:
In the case of a Multi-Node instance, the above process should be repeated on the <iAS ORACLE_HOME> of each Node.
unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip
. /u0/oracle/testappl/APPSTEST_ebusinesstest.env
cd /u0/oracle/testora/iAS/appsoui/setup/
perl OUIsetup.pl
Problem:
When running adcfgclone.cfg on the Apps tier, it completes with the following error:
Running Rapid Clone with command:
perl adclone.pl java=../jre/1.3.1 mode=apply stage=/u0/oracle/testcomn/c lone/bin/.. component=appsTier method=CUSTOM appctxtg=/u0/oracle/testappl/admin/ TEST_ebusinesstest.xml showProgress contextValidated=true
Beginning application tier Apply – Thu Sep 18 14:33:30 2008
Log file located at /u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTi er_09180233.log
– 50% completed
AC-50207: Fatal: Failed to execute one or more of the config tools during Contex t Value Management
Deactivating Context Value Management System.
Restored the Context file in :
/u0/oracle/testappl/admin/TEST_ebusinesstest.xml
Aborting the running of Context Value Management
Error occured before Context Value Management could be completed
| 50% completed WARNING: AutoConfig completed with errors. Check log file at /u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTier_09180233. log for details.
/u0/oracle/testappl/admin/TEST_ebusinesstest/log/ApplyAppsTier_09180233.log shows:
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u0/oracle/testcomn/admin/install/TEST_ebusinesstest
adgentopfile.sh INSTE8_SETUP 1
AutoConfig is exiting with status 1
Solution:
Source the apps tier environment and run AutoConfig (/u0/oracle/testcomn/admin/scripts/TEST_ebusinesstest/adautocfg.sh)
Problem:
/etc/oraInst.loc points to an Inventory that does not exist:
mkdir : No such file or directory at ./adclone.pl line 1274
ERROR: Failed to execute ./adclone.pl
Solution:
As root user, ran /tmp/orainstRoot.sh.
Reran clone again, but it failed.
The root directory had completely filled up because the backup was restored to /oracle and not /u0/oracle. Removed /oracle, then reran /tmp/orainstRoot.sh and tried script again.
Recent Comments