Change IP address of the Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Change IP address of the Server

  1. #1
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Hi,
    Can we change the IP address after you create the Database.

    Thanks.

  2. #2
    Join Date
    Jul 2000
    Posts
    37
    I think so, yes. I suppose it would have an impact on connectivity if you used ip addresses as opposed to host names in your tnanames.ora and listener.ora files, but apart from that I can't see a problem. Anyone else, please correct me if I'm wrong.

    cheers

    chris.

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Yes we can change the IP address of the machine after u create the database.But u have to make sure that ur tnsnames.ora file on the server and the clients are also updated with the new Ip address.Also u have to see that ur database links are working properly after the change.
    In case of any doubts please be free to write to me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA.OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    Feb 2001
    Posts
    389
    tnsnames.ora,sqlnet.ora and listener.ora should never have an IP address.
    They should have hostname.domain name and DNS or /etc/hosts should take care of the mapping.


  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by gpsingh
    tnsnames.ora,sqlnet.ora and listener.ora should never have an IP address.
    Never say never . As much as I agree with you, there allways are exceptions from the rule. For example, when setting up Oracle Fail Safe in NT cluster environment, Oracle insists in having virtual network addresse to be written as IP andresses and refuses to use aliases.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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