Oracle Cloud Infrastructure
Coming soon ...
Apps R12.2
  • R12.2 Architecture
  • Cloning Error (RC-50208)
  • Apps R12.1
  • Major changes from 11i
  • R12:HTTP Debug Logging
  • Compile Apps Schema invalid objects in R12
  • Apps 11i
  • Apps Components and Architecture
  • Concurrent managers
  • Patching
  • Using AD Patch
  • Using AD Control
  • FNDCPASS utility
  • Single-node Installation
  • Multi-node Installation
  • Find Apps Version
  • Cloning
  • Upgrade 11.5.9 to 11.5.10.2
  • Upgrade from 11.5.10.2 to R12
  • Upgrading 9i to 10g with 11i
  • 11i/R12 General Topics
  • AppsDBA System Management Utilities Guide
  • Identifying Long Idle Sessions
  • Identifying High Active Sessions
  • Change hostname for EBS
  • Oracle 12c Database
  • Oracle12c PSU Apply
  • Oracle12c Datafile moved Online
  • Oracle 11g Database
  • Upgrade 10g to 11g R1
  • Upgrade 11.2.0.2 to 11.2.0.3
  • Database 9i-10g
  • Top 99 Responsibilities of a DBA
  • General Info
  • Database Patching
  • 10g:ASM
  • 10g:Data Pump
  • 10g:Data Guard Installing
  • 10g:Rollback Monitoring
  • 10g:Flashback Table
  • Tablespace Management
  • Materialized Views
  • 10g:Enterprise Manager
  • 10g:Upgrade
  • Error:Ora-01631
  • DBA Scripts
  • Disk I/O,Events,Waits
  • Tablespace Information
  • Session Statistics
  • Hit/Miss Ratios
  • User Information
  • Rollback Segments
  • Full Table Scans
  • Contention/Locking
  • Redo Log Buffer
  • Data Dictionary Info
  • Oracle10g Application Server
  • Oracle10g Application Installation
  • (Re)Securing OAS Control
  • Oracle AS10g null protocol issue
  • Oracle Backup & Recovery
  • RMAN
  • RMAN Setup
  • Backup Recovery
  • Flash Recovery Area
  • Oracle10g Discoverer with Apps
    Coming soon ..............
    Troubleshooting
  • Discoverer Troubleshooting
  • Access EBS in mozile
  • Linux and Unix Platforms
  • How To configure NFS
  • Unix/Linux Command
  • Change hostname in Linux
  • SENDMAIL configuration
  • This Oracle Application DBA Portal is the biggest knowledge gateway for the people in the world of Oracle...
    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:

    posted by Srinivasan .R @ 1:13 AM  
    21 Comments:
    Post a Comment
    << Home
     
    About Me

    Name: Srinivasan .R
    Home: Chennai, India

    About Me:
    I am working as an Oracle Applications DBA specializing in EBS 11i/R12 with Over 14+ years of experience, mainly in different versions of Oracle Database & Application administration on various platforms like HP-UX, SOLARIS, AIX, Red hat Linux & Windows
    See my complete profile
    High Availability
  • Oracle10g RAC Installation
  • A Quick Reference for Oracle Database 10g RAC on Linux and Unix Platforms
  • Implementing Oracle 10g RAC with ASM on AIX
  • Locked objects for whole RAC
  • Monitor Memory RAC
  • Sessions RAC
  • Install Oracle 11g RAC On Linux
  • Migrating Oracle10g DB to ASM
  • Helpful Links
  • Good Metalink Notes
  • Discoverer:Metalink Notes
  • Logs Scripts:Metalink Notes
  • Support:Metalink Notes
  • Previous Post
  • Discoverer Troubleshooting
  • Error:ORA-01631
  • Multi-Node Installation
  • UNIX / LINUX COMMAND
  • Upgrade 11.5.9 to 11.5.10.2
  • Single-node Installation
  • Upgrade to Oracle Database 10g
  • Flash Recovery Area
  • Database Patching
  • AD Control
  • Archives
    Download Software
  • Oracle 11g
  • Oracle 10g
  • 10g Express Edition
  • Oracle 9i
  • Oracle Apps
  • Oracle Linux
  • Oracle VM
  • App Server
  • Solaris
  • Fedora
  • Fedora
  • OpenSUSE
  • Ubuntu
  • Advertisement Links
    INTUIT Technology

    MACHS DATA

    Add Ons
    Locations of visitors to this page

    Add to Google Reader or Homepage

    Template by
    Sreene



    Oracle Application DBA Portal