Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am a newbie with Oracle so bear with me.

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

Any advice or suggestions would be greatly appreciated!

share|improve this question
    
What exact sqlplus command are you issuing? –  FreshPhilOfSO Aug 19 '13 at 15:45
    
Have you verified that the service listener is started ? if i remember well it is mandatory on windows platforms, even for local connections. –  Nicolas Durand Aug 20 '13 at 13:58
add comment

1 Answer

Is the environment variable LOCAL set? this will cause sqlplus to connect to a TNS alias instead of directly to the local database instance.

Your other problem with starting it into mount, you are missing a parameter to oradim -STARTTYPE srvc. All of the options can be seen by typing oradim /?

to start just the service so that you can manually start to mount use

oradim -start -sid dantest3 -starttype srvc

At this point the database will not be registered with the listener so you will still need to connect without using the listener.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.