RE: Unix host name change - what happens to db?

Wed, 04 Jun 2003 07:12:28 -0700

Title: Message
If your host name is part of your database global name, then you'll have to change the global name.
 
SQL> alter database rename global_name to 'SID.HOST';
 
Also, if you have db links which have host name as part of their name, then you'll have to recreate the db links.
 
HTH,
Gerardo
-----Original Message-----
From: Carmen Rusu [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Unix host name change - what happens to db?

 
My boss has decided to change the name of the Sun OS 2.8 host of my Oracle 8i databases.
 
Question: how does this name change affect my Oracle software installation and my databases?
 
Has this happened to any of you?
 
Thanks,
 
Carmen Rusu

Reply via email to