Re: How can I change sid name?
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 3 Mar 2003 10:52:23 -0800
Message-ID: <2687bb95.0303031052.22f25322_at_posting.google.com>
Date: 3 Mar 2003 10:52:23 -0800
Message-ID: <2687bb95.0303031052.22f25322_at_posting.google.com>
"Sebastijan Mrkus" <sebastijan.mrkus_at_etk.ericsson.se> wrote in message news:<b3vrur$si0$1_at_newstree.ericsson.se>...
> How can I change sid name on existing instance on unix?
>
> Thanks.
>
> Sebastijan
What version. Prior to 9 or if no spfile in use
create init_newsid.ora file
set Oracle environment
export $ORACLE_SID=newsid [Korn shell version]
unset TWO_TASK [if in use]
connect in svrmgrl or sqlplus /nolog
startup
This is the simple case; you might have to create some files or links depending on your directory naming pattern/rules
HTH -- Mark D Powell -- Received on Mon Mar 03 2003 - 19:52:23 CET