Problem:
When trying to clone Illuminat TEST database, the following error occurred:
sh: adchkutl.sh: command not found
Solution:
perl adcfgclone.pl dbTier
Use:
perl ./adcfgclone.pl dbTier
Situation: After reinstalling Red Hat Enterprise Linux AS 4 on the server and restoring Oracle Applications, the instance is started.
Problem: When accessing page http://ebusiness.support.com:8001/oa_servlets/AppsLogin, the following error is encountered:
Internet Explorer cannot display the webpage Most likely causes: You are not connected to the Internet. The website is encountering problems. There might be a typing error in the address. What you can try: Diagnose Connection Problems More information This problem can be caused by a variety of issues, including: Internet connectivity has been lost. The website is temporarily unavailable. The Domain Name Server (DNS) is not reachable. The Domain Name Server (DNS) does not have a listing for the website's domain. If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section. For offline users You can still view subscribed feeds and some recently viewed webpages. To view subscribed feeds Click the Favorites Center button , click Feeds, and then click the feed you want to view. To view recently visited webpages (might not work on all pages) Click Tools , and then click Work Offline. Click the Favorites Center button , click History, and then click the page you want to view.
Solution: Apply patch 4198954. Create a directory 4198954, copy the patch into this directory and extract the patch (two RPMS and README). Install the RPMS using rpm -ivh … . The RPMS install without issue
Then reran patch 3830807. Relink Application files using adadmin, use all defaults for the relink (takes about ten minutes).
Did not work.
Updated /etc/hosts
Checked Apache logs
/u0/oracle/testora/iAS/Apache/Apache/logs/error_log
/u0/oracle/testora/iAS/Apache/Jserv/logs/mod_jserv.log
See Metalink Doc ID: Note: 231137.1 “Troubleshooting the Self Service Framework with Oracle Applications”
Search for: File does not exist: /oa_servlets/AppsLogin
See Metalink Doc ID: Note: 344379.1 “Subject: File Not Found /oa_servlets/AppsLogin”
http://ebusiness.support.com:8001/pls/TEST/fnd_web.ping
http://ebusiness.support.com:8001/OA_HTML/US/ICXINDEX.htm
ftp /usr/java/j2sdk-1_3_1_11-linux-i586.rpm.bin from 200.65.1.86 into the /usr/java (make this directory if necessary)
chmod a+x j2sdk-1_3_1_11-linux-i586.rpm.bin
Unzips jdk-1.3.1_11.i586.rpm
rpm -ivh jdk-1.3.1_11.i586.rpm
SUCCESS! Page appears.
| Step No. | Patch Number | Type of Patch | Patch Name | Date Applied | Comment | Node Applied |
| Patches Applied to PROD on July 5, 2007 | ||||||
| Refer to Metalink Doc ID: 230672.1 (Cloning Oracle Applications Release 11i with Rapid Clone) | ||||||
| Enable Maintenance Mode | ||||||
| Shut down Oracle application tier services | ||||||
| 1 | 5035661 | Minipack | UPGRADE OUI TO VERSION 2.2 | 5-Jul-07 | Apply to iAS and RDBMS homes | linux-blade |
| 2 | 4712852 | Minipack | MINIPACK 11I.AD.I.4 | 5-Jul-07 | See Metalink Doc ID: 233044.1 | linux-blade |
| 3 | 5759055 | Rollup Patch | TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH P (MAR/APR 2007) | 5-Jul-07 | See Metalink Doc ID: 165195.1 | linux-blade |
| Update RDBMS ORACLE_HOME with AutoConfig files from Application Tier | ||||||
| 4 | 5225940 | Family Pack | POST ADX-F FIXES | 5-Jul-07 | linux-blade | |
| Disable Maintenance Mode before copying files | ||||||
| Continue cloning process | ||||||
| Restart Oracle application tier services | ||||||
| Note: | ||||||
| Patches 3453499 and 4709948 were applied by 5759055; there is no need to apply these patches. | ||||||
| linux-blade: Database tier, concurrent processing server, administration server, reports server, forms server, web server | ||||||
| Source directory: /emca/PROD/ | ||||||
| Target Directory: /u0/oracle | ||||||
Problem: What environment variables must be set before cloning, assuming no prior EBS environment file is present?
Solution:
Here is a sample script to source before running post-clone steps. It sets up the location to the PERL and Java executables. Note the directories must be changed to reflect your environment.
export PERL5LIB=/u01/deltaora/iAS/Apache/perl/lib/5.00503: /u01/deltaora/iAS/Apache/perl/lib/site_perl/5.005:/u01/deltaappl/au/11.5.0/perl export PATH=.:/u01/deltaora/iAS/Apache/perl/bin:/u01/deltacomn/util/jre/1.1.8/bin:$PATH export LD_ASSUME_KERNEL=2.4.19
This document briefly outlines the procedure for cloning an 11i multi node instance to a single node instance.
Assumptions
1. SOURCE Instance is split on 2 NODES:
SOURCE DB NODE – Both APPS and DB services installed on 1st Server
Application tier services are shut down
SOURCE APPS NODE – Both APPS and DB services installed on 2nd Server
Application tier services are started
2. TARGET instance is to be a single node (may be a new machine or one of the above)
Summary
Shut down the apps server
Start all services on db server
Run autoconfig to convert to instance to a single node
Run the preclone perl scripts
Copy files to new location
Convert source to 2 nodes by running autoconfig
Run clone scripts on Target
Cloning SOURCE Instance
1. Refer to the latest version of the cloning documentation on Metalink (Metalink Doc ID: 230672.1) to determine which patches to apply before cloning.
2. Shutdown the application server by running the adstpall.sh script:
cd /oraprod/oracle/prodcomn/admin/scripts/PROD_finsvr/
./adstpall.sh apps/apps
Log off source APPS node
Log on source DB node
Make multi node a single node to begin cloning.
1. cd /oraprod/oracle/prodcomn/admin/scripts/PROD_finsvr
2. Start all application services on database Source DB Node using adstrtal.sh:
cd /oraprod/oracle/prodcomn/admin/scripts/PROD_finsvr
./adstrtal.sh apps/apps
Even though the listener and concurrent manager are the only services started on PROD, you will need to ensure that you start ALL services. Verify that the Concurrent Manager is up.
3. Run autoconfig:
cd /oraprod/oracle/prodcomn/admin/scripts/PROD_finsvr
./adautocfg.sh
Read prompt carefully, choosing default responses where possible.
Migrating to AutoConfig on the Source DB Node (necessary only if a new rapid clone patch is applied).
4. cd /oraprod/oracle/prodappl/ad/11.5.0/bin (that is, $AD_TOP/bin)
Create appsutil.zip file:
perl admkappsutil.pl
appsutil.zip created in $APPL_TOP/admin/out
On the database tier (finmgr), copy or FTP the appsutil.zip file to the RDBMS_ORACLE_HOME.
5. Copy file appsutil.zip to /oraprod/oracle/proddb/9.2.0/*
unzip -o appsutil.zip
Generate and Apply AutoConfig Configuration files
This step performs the conversion to AutoConfig. Once completed, the previous configuration will not be available. The database server and the database listener must remain available during the AutoConfig run. All other database tier services should be shut down.
Warning: Running AutoConfig on the database node will update the RDBMS network listener file. Save the listener file before you run autoconfig.
7. Change directory to RDBMS_ORACLE_HOME/appsutil/bin
cd /oraprod/oracle/proddb/9.2.0/appsutil/bin
adconfig.sh contextfile=PROD_finmgr.xml appspass=apps*
8. Prepare the source system database tier for cloning
cd /oraprod/oracle/proddb/9.2.0/appsutil/scripts/PROD_finmgr (that is, $RBDMS_ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
perl adpreclone.pl db Tier
9. Prepare the source system application tier for cloning
cd /oraprod/oracle/prodcomn/admin/scripts/PROD_finmgr (that is, $COMMON_TOP/admin/scripts/$CONTEXT_NAME)
perl adpreclone appsTier
10. Stop all services (DB and APPS)
cd /oraprod/oracle/prodcomn/admin/scripts/PROD_finmgr/
./adstpall.sh apps/apps
Shutdown database listener (addlnctl.sh stop apps/apps)
Shutdown database (addbctl.sh stop apps/apps)
Or run the stopDB script in /oraprod/scripts (doing so will attempt to shut the services again)
11. Copy files
Create the respective folders on target node:
clondb
clondata
clonora
clonappl
cloncomn
Copy the files from Source DB Node to Target Node. As root user, mount source node on target Node by editing /etc/exports on target node and adding the line where the source files are located (i.e. /oraprod/oracle).
Then restart NFS on the target server by entering the following command at the command prompt (as root user):
service nfs restart
12. On the target node (that is, where the clone is being created), do the following:
a. su – applmgr
b. cd /orapatch (new clone top directory)
c. mkdir prodfiles (where we want the files copied to)
d. su – root
e. Mount SOURCE directory onto TARGET directory
f. Copy the files using the operating system utilities
May need to ensure that the owner name and group of target directories are applmgr and dba respectively and not nfsmount.
To convert from single node to multi node:
Run autoconfig on Source Apps Node to make Source Instance 2 Node.
When a report is run on the target instance we get an error: “File server could not verify its initialization parameters when viewing output”. Patch 4244610 was applied, but this did not resolve the issue.
Removed spaces from listener.ora file in /orapatch/oracle/clonora/8.0.6/network/admin/clon_newtest/listener.ora. Removed all spaces near the APPLFSTT parameter. Removed everything and left reference to database alone. Bounce listener.
To change color and name, go to SysAdmin/ Security/Profile/System, under profile %Site%, change Site Name to new name. To change color, navigate to profile %Color% JavaColorScheme and Service:Visual Attributes for Settings where the colour can also be changed.
Recent Comments