I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the command shutdown immediate;
. I get the
Database closed.
Database dismounted.
ORACLE instance shut down
reponses. I exit out of sqlplus, and try to log back in (ORACLE_SID is set correctly) so I can issue the startup mount;
command, but I get the
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
error. All of the Windows services involving my database dantest3 are started. Doing research, I found the oradim command, but while that starts my database and allowing me to login, that is the full startup, and I want to only be in "mount" mode.
I am logging in with the following command -
sqlplus sys/[passwordforacct]@dantest3 as sysdba
If I try the simple sqlplus / as sydba
, I get a
ORA-12560: TNS:protocol adapter error
oradim command -
oradim -start -sid dantest3
Requested variables -
TNS_ADMIN = C:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
ORACLE_SID = dantest3
ORACLE_HOME_11gR2 = C:\Oracle\product\11.2.0\dbhome_1