Re: renaming database

On Sat, 22 Aug 1998 12:47:51 +0700, "B Krisna Y D N" <krisna_at_bes.co.id> wrote:

>I am not a DBA, I am a Developer. Since our DBA is no longer with us, I have
>to take care of some DBA Activities, which is quite new for me. Could anyone
>tell me how to rename a Database name ? We have 2 Database in 2 machines but
>with same Database name.

If you mean the service name, i.e. the name you type in as a connect string when logging on w/SQL*plus, then changing the name involves changing the TNSNAMES.ORA files on your client machines. For example, i have the following entry in my TNSNAMES file for a database named "PINE":

PINE.world=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(COMMUNITY= NMP.world)(PROTOCOL= NMP)(SERVER= PMA0781D00)(PIPE= ORAPIPE))(ADDRESS=(COMMUNITY= TCP.world)(Host = pma0781d00)(PROTOCOL= TCP)(Port= 1521))(ADDRESS=(COMMUNITY= TCP.world)(Host = 127.0.0.1)(PROTOCOL= TCP)(Port= 1521))(ADDRESS=(COMMUNITY= TCP.world)(Host = pma0781d00)(PROTOCOL= TCP)(Port= 1526))(ADDRESS=(COMMUNITY= SPX.world)(PROTOCOL= SPX)(Service=
pma0781d00_lsnr)))(CONNECT_DATA=(SID=PINE)(SERVER=DEDICATED)))

To change the service name to APPLE, all I have to do is edit the TNSNAMES file to read:

APPLE.world=(DESCRIPTION=....

The SID name can remain as PINE, although this can sometimes be confusing to people.

regards,

Jonathan Received on Sat Aug 22 1998 - 17:25:28 CDT