SQL Plus Login Error [message #281764] |
Mon, 19 November 2007 04:55 |
krapvag
Messages: 3 Registered: November 2007
|
Junior Member |
|
|
Hi,
We have a problem where attempting to connect to an Oracle database we get the error message:
ORA-01033: ORACLE initialization or shutdown in progress
I've tried the following solution
1- SQL> shutdown abort
O/P- ORACLE instance shut down.
2- SQL> start database step by step
O/P- SP2-0310: unable to open file "database.sql"
3- SQL> startup nomount
ORACLE instance started.
But everytime I attempt to login to SQLPlus I get the 01033 error message, and no login takes place
Any ideas?????
|
|
|
|
Re: SQL Plus Login Error [message #281771 is a reply to message #281764] |
Mon, 19 November 2007 05:06 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
ARe you on windows or linux?
If on windows,go to task manager and kill the oracle process amd then try to start the instance.
If on linux, type ps -a and kill all tthe oracle processes and then try.
|
|
|
|
Re: SQL Plus Login Error [message #281775 is a reply to message #281764] |
Mon, 19 November 2007 05:12 |
krapvag
Messages: 3 Registered: November 2007
|
Junior Member |
|
|
Yeah, there's a bit missing after the startup nomount command, but what I meant to say is that I cannot get past the login to run that
which service do I stop in the task manager? The problem is I know nothing about Oracle (dba is on holiday!!) so any help is greatfully received
Thanks
|
|
|
|
|
Re: SQL Plus Login Error [message #281780 is a reply to message #281764] |
Mon, 19 November 2007 05:19 |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Click on the process option,search for oracle.exe and kill it.
After that start your instance, from the command prompt type
net start "yourservicename"
and then log in sqlplus
|
|
|
Re: SQL Plus Login Error [message #281812 is a reply to message #281778] |
Mon, 19 November 2007 06:44 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
go to services.msc window and stop oracle services and again start.
start --- > run --- > services.msc <<hit enter>>
then connect with sys user to sqlplus and startup your database.
Regards
Mohammed Taj
|
|
|