ORA-00205,ORA-09782

From: <nguyenqhh_at_hotmail.com>
Date: Tue, 19 Jan 1999 15:09:48 GMT
Message-ID: <78277j$1b9$1@nnrp1.dejanews.com>

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 Tue Jan 19 1999 - 09:09:48 CST