Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: Changed IP Address

    Hi All,

    I have an Oracle 8i (8.0.6) database. The machine that it is on currently has a 207.101.xxx.xx address. I would like to change this to a 192.168.xx.xx address. I know that I will have to edit the tnsnames.ora file on client pc's, but what do I need to do on the server side? In the Listener.ora file I can't find a place to enter the new IP address. Not that much information on the web either. If someone can help I would appreciate it.

    Thanks,
    Jared

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I know that I will have to edit the tnsnames.ora file on client pc's
    WHY?
    Why not just changed the DNS entry to reflect the new IP#?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by jcoe
    Hi All,

    I have an Oracle 8i (8.0.6) database. The machine that it is on currently has a 207.101.xxx.xx address. I would like to change this to a 192.168.xx.xx address. I know that I will have to edit the tnsnames.ora file on client pc's, but what do I need to do on the server side? In the Listener.ora file I can't find a place to enter the new IP address. Not that much information on the web either. If someone can help I would appreciate it.

    Thanks,
    Jared
    The listener already knows the IP address of the machine that it is running on. The only thing that needs to know the address of the server is the client.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jul 2004
    Posts
    34
    In the tnsnames.ora file the IP address to the host machine is there. I thought this needed to be changed.

    If I do change the IP address of the Database server then I can't connect to the database, login to Enterprise manager, etc. If the listener looks at the address of the machine shouldn't I be able to do this?

  5. #5
    Quote Originally Posted by beilstwh
    The listener already knows the IP address of the machine that it is running on. The only thing that needs to know the address of the server is the client.

    yaaaaaa...is true

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    In this case, client software that just happens to be on the same machine as the database needs to know the address of the server. Change the TNSNAMES.ORA file so that the database server can be found.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Jul 2004
    Posts
    34
    Thanks! I will give it a shot and reply back...

Posting Permissions

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