Change Hostname of database server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Change Hostname of database server

Hybrid View

  1. #1
    Join Date
    Oct 2006
    Posts
    18

    Question Change Hostname of database server

    Is it possible to change hostname of the database server after oracle 10g installation and database running on the server. What files would need to be modified other than thnsnames and listener.ora?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    That should do it. Change the tnsnames.ora and listener.ora on the server and the tnsnames.ora on the clients.
    this space intentionally left blank

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Maybe /etc/hosts as well.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    maybe init.ora depending on how you have local_listener and dispatches configured...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width