Re: Oracle Administration

From: Ewan Parker <ewan_at_chimera.u-net.com>
Date: 25 Jan 2000 21:41:47 +0000
Message-ID: <734.59T2363T13016362ewan@chimera.u-net.com>

On 24-Jan-00 02:17:38, Novice said about Re: Oracle Administration:

> Orcale server comes up normally when system boots. The
> instance sar3 comes up without any hiccup. Only problem is I
> cannot access it thru sqlplus although I am able to access
> sar3 from Sql Worksheet from a client PC.

> SVRMGR> startup open sar3
> ORA-01504: database name 'SAR3' does not match parameter
> db_name 'sar1'

It sounds as if your $ORACLE_SID is set to sar1 instead of sar3, as this would explain why svrmgrl is using the wrong parameter file, and you cannot connect using sqlplus. If it is wrong, reset the sid by running oraenv.

Regards,
Ewan.

--
Email: mailto:ewan_at_chimera.u-net.com Public key: http://www.chimera.u-net.com/ewan.asc Received on Tue Jan 25 2000 - 15:41:47 CST