There are several places to look at :
$ORACLE_SID
$ORACLE_HOME/dbs/init<SID>.ora
$ORACLE_HOME/dbs/orapw<SID>
oratab
listener.ora
tnsnames.ora
> ----------
> From: magesh[SMTP:magesh_at_garoo.ne.jp]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, August 23, 2000 09:04
> To: Multiple recipients of list ORACLE-L
> Subject: Renaming Oracle Instance
>
> Hi All
>
> How to rename an Oracle Instance , Currently my Oracle instance is ORCL
> , Now i want to change it as ORA8.
>
> Regards
Received on Wed Aug 23 2000 - 04:14:19 CDT
