Home » Infrastructure » Linux » Database doesn't connect , SQLPlus doesn't start (Oracle10g , Debian)
Database doesn't connect , SQLPlus doesn't start [message #277019] Sun, 28 October 2007 00:54 Go to next message
abkhiz
Messages: 3
Registered: October 2007
Junior Member
Dear friends ,

Please urgently advice me about this problem ...
a few hours ago , our clients reported that they cannot run the application and the message is can not connect to database .
I tried to run sqlplus , but after pressing enter it do nothing , no error message , nothing at all , by ctrl+c again I have the linux prompt .
I thought its maybe an Oracle session overflown and tried to kill some of Ora user proccesses but didnt help .
I tried to DBSHUT but again it did nothing , just I can see a DBSHUT now in proccesses .
I tried to reboot the server , but as long as it cannot shut down the database it wont go for reboot .
I dont wanna use shutdown immediate in case of data loose .
Please write me back if I have to check anything , I'm not such a expert in Oracle .

Thanks and regards
Re: Database doesn't connect , SQLPlus doesn't start [message #277021 is a reply to message #277019] Sun, 28 October 2007 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Archived log or audit file system full?

Regards
Michel
Re: Database doesn't connect , SQLPlus doesn't start [message #277026 is a reply to message #277019] Sun, 28 October 2007 01:32 Go to previous messageGo to next message
abkhiz
Messages: 3
Registered: October 2007
Junior Member
Dear Michel

By DF command it shows me that /log space usage is 58% so this partition is not full , is there anything else to check ??
Advice me with detail please .
Re: Database doesn't connect , SQLPlus doesn't start [message #277029 is a reply to message #277026] Sun, 28 October 2007 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
check alert.log

Regards
Michel
Re: Database doesn't connect , SQLPlus doesn't start [message #277036 is a reply to message #277019] Sun, 28 October 2007 03:10 Go to previous message
abkhiz
Messages: 3
Registered: October 2007
Junior Member
Last data in Alert.log is about midnight backup and everything seems allright .
Previous Topic: oracle 10gR2 skgaio.o missing
Next Topic: oracle instant client installtion on linux
Goto Forum:
  


Current Time: Fri Mar 29 10:49:18 CDT 2024