Re: unable to mount database

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 10 Aug 2005 04:45:35 -0700
Message-ID: <1123674335.211236.223230@g47g2000cwa.googlegroups.com>

As Sybrand said, you may need to recreate your password file, or your error message seem to indicate that your ORACLE_SID or INSTANCE environment variable is not properly set. The system is looking for something called PWDSID.ora, and you have something called PWDprd.ora. What comes after the PWD is the instance identifier. If you are in DOS/CMD mode, what does SET show for value of ORACLE_SID, or try the following in a new DOS/CMD window...

set ORACLE_SID=prd
sqlplus /nolog
connect / as sysdba
startup ....

HTH Received on Wed Aug 10 2005 - 06:45:35 CDT