DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: change name database server

  1. #1
    Join Date
    Nov 2005
    Location
    Brazil
    Posts
    22

    change name database server

    Hi all,

    I need to change name database server? But, I have a database running, can I do this?

    Thanks.

    Leonardo

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    You need to see the impact this would generate. Like if you have used server names in tnsnames file users may not connect to the db, check all the config fiels dependent on the server names.
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    If you refer to the Server name itself: NO, the tnsnames.ora file has the server name (unless you used an alias).

    You would need to shutdown DB and modify tnsnames.ora file(s).


    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Feb 2003
    Posts
    63
    Also you may need to check the listener.ora file as well

  5. #5
    Join Date
    Nov 2005
    Location
    Brazil
    Posts
    22
    Thanks for all.

    But is there any impact in database ?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    shut everything down then do it - why risk it?

  7. #7
    Join Date
    Nov 2005
    Location
    Brazil
    Posts
    22
    ok, thanks for your help.

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