|
| Friday, April 17, 2009 |
| Change hostname for E-Business Suite |
Run AutoConfig to change hostname for E-Business Suite
Oracle E-Business Suite is dependent on hostname. User can easily change the IP of the machine, but user cannot anyhow change the hostname of the machine. To change the hostname, we need to run AutoConfig on E-Business Suite.
First, startup dbTier. AppTier is not required at all in the whole process.
FOR DATABASE TIER:
Note:338003.1 How to change the hostname and/or port of the Database Tier using AutoConfig
1. Login as oracle user.
2. De-register the current database server.
perl $ORACLE_HOME/appsutil/bin/adgentns.pl appspass=apps contextfile=$CONTEXT_FILE -removeserver
3. Update AutoConfig Context file with new host information. Edit $CONTEXT_FILE directly.
* Copy $CONTEXT_FILE to a new context file.
cp /opt/oracle/product/10.1.0/db/appsutil/PROD_.xml
/opt/oracle/product/10.1.0/db/appsutil/PROD_.xml
* Edit /opt/oracle/product/10.1.0/db/appsutil/PROD_.xml directly.
- Replace all to
- Replace all to < newdomain.com>
4. Change hostname.
- Execute " system-config-network" to change the new hostname for the machine.
- Edit /etc/hosts with " newhost.newdomain.com ip newhost".
(After changing hostname, you'll not be able to startup any graphical application such as xclock due to "Xlib: connection to :0.0 refused by server". You can press "ctrl + alt + backspace" to kill x server.)
5. Execute AutoConfig for dbTier.
cd $ORACLE_HOME/appsutil/bin/
./adconfig.sh contextfile=$ORACLE_HOME/appsutil/PROD_.xml
FOR APPS TIER:
Note:341322.1 How to change the hostname of an Applications Tier using AutoConfig
1. Login as applmgr user.
2. De-register the current apps server.
perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$CONTEXT_FILE -removeserver
3. Update AutoConfig Context file with new host information. It is easier to edit $CONTEXT_FILE directly.
* Copy $CONTEXT_FILE to a new context file.
cp /opt/oracle/apps/prodappl/admin/PROD_.xml
/opt/oracle/apps/prodappl/admin/PROD_.xml
* Edit /opt/oracle/apps/prodappl/admin/PROD_.xml directly.
- Replace all to
- Replace all < olddomain.com> to < newdomain.com>
4. Execute AutoConfig for appTier.
cd $AD_TOP/bin
./adconfig.sh contextfile=/opt/oracle/apps/prodappl/admin/PROD_.xml appspass=apps
FINISHING TASK:
AutoConfig doesn't convert E-Business Suite completely. Some settings may remain unchanged or reset to default. So, it is required to go check the configuration as described in Cloning Guide.
Identified steps are:
1. As applmgr, vi /opt/oracle/apps/prodappl/admin/adgetlnxver.sh to ensure ctxfile is pointing to correct PROD_.xml file.
ctxfile="/opt/oracle/apps/prodappl/admin/PROD_htb.xml"
2. As applmgr user, vi $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.properties to ensure:
wrapper.bin.parameters=-Djava.awt.headless=true
wrapper.bin.parameters=-DAdaptorCatalog=/opt/oracle/apps/prodappl/au/11.5.0/java/catalog.xml
wrapper.bin.parameters=-DClientMode=local
3. As oracle user, do the following:
$ sqlplus apps/apps
sql> update icx_parameters set session_cookie_domain=' newdomain.com';
sql> conn applsys/apps
sql> select profile_option_value from fnd_profile_option_values where profile_option_value like '%oldhost%';
sql> update fnd_profile_option_values set profile_option_value='/opt/oracle/db/proddb/9.2.0/appsutil/outbound/PROD_newhost' where profile_option_value like '%oldhost%';
3 rows will be updated.
sql> exit;
Done. You can startup AppTier now and access E-Business Suite login page at http://newhost.newdomain.com:8000.Labels: Change hostname for E-Business Suite |
posted by Srinivasan .R @ 1:13 AM  |
|
| 21 Comments: |
-
Hostname change at Linux with Oracle DB
1. If you have to change a host name then following steps should have done for Oracle DB and OEM to work properly.
2. Change the host name properly:
/etc/hosts
/etc/sysconfig/network
3. Change the hostname in tnsnames.ora and listener.ora:
$ORACLE_HOME/network/admin/tnsnames.ora
$ORACLE_HOME/network/admin/listener.ora
4. Change the hostname in emd.properties:
$ORACLE_HOME/sysman/config/emd.properties
5. Reboot
Restart the listener manually:
lsnrctl stop
lsnrctl start
lsnrctl status
6. Recreate EM repository:
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
-
-
Really Awe! Great And Valuable Information Provided by the blog.Very Useful and helpful.Coming to our self,we are the leading providers for Restaurant Equipment Parts In Us.Great Job.Really Thanks For Posting.
-
Thank You Srinivasan for sharing such a wonderful post.Awesome! Superbly Written by the blogger just loved his way of posting in the blog and also happy for sharing this about our service called Urgent care
in chicago.happy for sharing the information.I just Want to share the blog to my friends and family members.
-
This Blog is very helpful and useful, came to know that I should be strong in my basics and this blog helps me to improve it, US Medical Residency in Chicago Services Provided by Us. Thanks For Posting. I Am refereed by my friend to this blog and I also want to refer my other friends to this blog.
-
The Best article, Bala Guntipalli This concept is a good way to enhance the knowledge.
-
Really its a informative post. Nice article. You did a great Job. Thanks so much for sharing this info.
-
You are Providing the Best and Great Information On Oracle.Really Thanks For Posting.
Vizag Real Estate
-
This Blog is very helpful and useful, came to know that I should be strong in my basics and this blog helps me to improve it... Web Development Services
-
Thank for the great information....
JNTU 99
-
-
-
-
-
-
-
-
-
-
-
|
| |
| << Home |
| |
|
|
|
|
Hostname change at Linux with Oracle DB
1. If you have to change a host name then following steps should have done for Oracle DB and OEM to work properly.
2. Change the host name properly:
/etc/hosts
/etc/sysconfig/network
3. Change the hostname in tnsnames.ora and listener.ora:
$ORACLE_HOME/network/admin/tnsnames.ora
$ORACLE_HOME/network/admin/listener.ora
4. Change the hostname in emd.properties:
$ORACLE_HOME/sysman/config/emd.properties
5. Reboot
Restart the listener manually:
lsnrctl stop
lsnrctl start
lsnrctl status
6. Recreate EM repository:
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create