Showing posts with label EBS. Show all posts
Showing posts with label EBS. Show all posts

Tuesday, September 22, 2009

How to rejoin new ORACLE_HOME with an installed EBS Instance?

If the database is currently running, do the following :

Remove ORACLE_HOME info from NetServices Toplogy model :

1. Set env from old $ORACLE_HOME
2. Start Listener and database
3. cd $ORACLE_HOME/appsutil/bin
Execute following command :
perl adgentns.pl contextfile=old $ORACLE_HOME/appsutil/_.xml -removesystem

4. Shutdown Database and listener

Update new ORACLE_HOME :
5. Copy OLD $ORACLE_HOME/appsutil directory to new $ORACLE_HOME

6. Copy OLD $TNS_ADMIN directory to new $ORACLE_HOME
7. Edit new $TNS_ADMIN/*.ora files and update ORACLE_HOME path in following files :
tnsnames.ora
sqlnet.ora
listener.ora
8. Copy OLD $ORACLE_HOME/*.env to new $ORACLE_HOME
9. Edit /*.env files and update paths within10. Run /_.env
11. Rename any existing /dbs/initSID.ora or spfile
12. cd $ORACLE_HOME/appsutil/bin


Build a new context file via following command :

./adclonectx.pl contextfile=/appsutil/_.xml validate=no

Enter the values to reflect new ORACLE_HOME

13. Run AutoConfig via following commands :

a) cd $ORACLE_HOME/appsutil/bin

b) ./adconfig.sh contextfile=/appsutil/SID_hostname.xml

NOTE: It will fail because database is down, but we want it to create configuration files

15. Start listener
16. Start Database

Wednesday, April 8, 2009

Oracle EBS on Windows halts every now and then without an issue

The instance can be started and login successful. But it crashes with in few minutes.
The issue has been resolved after done the following steps,


1) Enabled the TCP port to be allowed by the firewall using the exception tab on the firewall or else Concurrent manager will not be started and also will not be able to ping to the server.

2) Added following entry in the http.conf after the install (430386.1)
MaxRequestsPerChild 0

MaxClients 150
ThreadsPerChild 20

3) Increaded the Paging file size to double the size of the RAM

4) For Oracle forms launch with FRM-92101/500 error, recompiled the forms using adadmin (Ref Note # 427714.1)