How to change global name to reflect a new host name?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to change global name to reflect a new host name?

  1. #1
    Join Date
    Feb 2001
    Posts
    3

    Question

    Hello,
    I restored hot backup on another NT server.
    Here are changes I made to reflect a new host name:
    db_domain & service_name in init.ora
    SID_NAME and GLOBAL_DBNAME in listener.ora
    HOST and SERVICE_NAME in tnsnames.ora

    Everything works ok. The only place I see an old host
    name is when I
    select * from global_name

    Is there any way to change domain part of global name
    to specify a new host name?

    Thanks
    ninel

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Check out [url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=1018634.102&p_database_id=NOT[/url]
    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