How to change Oracle hostname

6925 pts.
Tags:
Oracle
Oracle administration
My Oracle database control is pointing at the wrong hostname. Where do I change that? Thank you. Moderator Note: This is a submitted question

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

I believe that you can change that in the INIT.ORA file (or its equivalent (I always have to qualify my Oracle answers because most everyone uses Oracle on a PC-type platform while I worked with it on mainframe using MVS, OS/390, z/OS and ofcourse there is no “init.ora” but we did have the equivalent))
secondly, if you are using TNSPROC (or its PC-type equivalent called SQLNET you may have changes to the listeners as well.

as always, back it up first … just in case.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: