Re: ORA-00205,ORA-09782

From this script it appears you didn't explicitly set the environment variable ORACLE_SID to the correct value before you started svrmgrl. This will definitely create havoc. Oracle always need the correct ORACLE_SID and ORACLE_HOME before you can do anything.

Hth,
Sybrand Bakker, Oracle DBA

nguyenqhh_at_hotmail.com wrote:

> Hi everyone,
>
> I've seen the other posts on this topic but none seem to fit my problem
> exactly. We have 3 instances running, one of them doesn't start
> when I try to use the UNIX command "su oracle -c script" to start
> my database, the following messages appear:
> ORA-00205: error in identifying control file '/vol2/data1/cntrl01.dbf'
> ORA-09782: sfifi: another instance has the same database mounted.
>
> But when I manually go into svrmgrl and do a startup as oracle user, it works
> fine!
> Here's the startup command I use in the script 7.3)
> svrmgrl <<EOF
> connect internal
> startup pfile=initSID.ora
> EOF
>
> I've even tried recreating the control files, doing a recover database
> using backup controlfile, etc... same thing. Works when I type it, fails
> in the script. The user who run the script has the right environment
> variable as ORACLE_HOME and ORACLE_SID. Any clues?
>
> Thanks.
>
> Hanh.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Sat Jan 23 1999 - 17:15:31 CST