Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing IP address

Status
Not open for further replies.
Moose467

Moose467

Technical User
Joined
Aug 6, 2002
Messages
47
Location
GB
Hi,
Does anybody know of any implications that may arise to an oracle database, if the IP address of the server is changed?
I'm using 8.1.7 on AIX 4.3.3
Thanks in advance
 
Sort by date Sort by votes
If you've been using a named host approach in your Net8 setup, I don't believe it will have any effect on your database. The IP on my server changes now and again, but the change is transparent to my database. On the other hand, if you've been hardcoding your IP address into your listener.ora, tnsnames.ora, etc files, then you will have to change all of these values and bounce your listener.
 
Upvote 0 Downvote
Thanks Carp,
That was my general feeling too, all I needed to do was edit the hosts table and stop and start the listener.
Thanks again
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question Question
Hi, I have an address field (1 sin
Replies
12
Views
614
rk68
rk68
sxschech
  • Locked
  • Question Question
If Mailing Address and PermAdr are same show one record else show both
Replies
9
Views
288
sxschech
sxschech
informer30
  • Locked
  • Question Question
Changing a Date Data Type
Replies
1
Views
122
IanWaterman
IanWaterman
THEaix
  • Locked
  • Question Question
CHANGING DBNAME 10G
Replies
2
Views
150
KenCunningham
KenCunningham
ThessDJ
  • Locked
  • Question Question
Changing the default date format in SQLPlus
Replies
1
Views
231
Turkbear
Turkbear

Part and Inventory Search

Sponsor

Back
Top