Hello, I'm trying to bounce a database (called sadas) but I have come across a strange problem. I can log in to sqlplus using sys/pass@sadas as sysdba. I can then perform 'shutdown immediate' with no problems.
But then when I attempt 'startup' I get told: "you are not logged in". So then I exit out of sqlplus and log in again as sys. I then attempt 'startup' again, and get the message 'database cannot be mounted in exclusive mode'.
I really can't make out what is happening, I am simply trying to bounce the server in the most basic way.
The contractor who created the database has told me to use the following script to do this, but I still can't get past the fact that I should be able to do a basic shutdown as described above!
call c:\APPS\oracle\ora81\bin\oradim.exe -shutdown -sid SADAS -usrpwd ORACLE -shuttype srvc,inst -shutmode i
net stop OracleORAHOME81TNSListener
net start OracleOraHOME81TNSListener
ORADIM -STARTUP -SID SADAS -USRPWD ORACLE -STARTTYPE SRVC -PFILE D:\SADAS\ORACLE\ADMIN\PFILE\SADASINIT.ORA
I shouldn't have to shut the listener down to shut the database as far as I know. I don't do that on all my other oracle dbs.
The above script is shutting down the Oracle Service (instance and service) ... look in the services
to see this ... control panel / administrative / services / OracleServiceSADAS. Look in the registry to see if the
AUTOSTART is set to TRUE (hkey_local_machine\software\oracle\...).
If the database is setup for AUTOSTART = TRUE, then you should be able
to stop and start the service and be ok.
No, sorry, I know that the oradim scripts work fine, and do indeed bring the db up and down as required along with the service etc, but my point is really that I can't see why the db doesn't shutdown and startup manually when I type the command directly into sqlplus. I want to know why I can't just log in as sysdba and do shutdown immediate, followed by startup.