Home » RDBMS Server » Server Administration » Database down (10g)
Database down [message #581944] Fri, 12 April 2013 01:38 Go to next message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
Hi All,

Unable to connect to database getting below error,Please help

sqlplus sys/oracle@server_name/orcl

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 12 11:07:15 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12518: TNS:listener could not hand off client connection


Below is alertlog entry

Completed: alter database open
Thu Apr 04 17:06:19 2013
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Thu Apr 04 17:35:11 2013
Incremental checkpoint up to RBA [0x3c9.847.0], current log tail at RBA [0x3c9.fe5.0]
Thu Apr 04 17:45:39 2013
Starting background process EMN0
EMN0 started with pid=20, OS id=1156
Thu Apr 04 17:45:39 2013
Shutting down instance: further logons disabled
Thu Apr 04 17:45:40 2013
Stopping background process CJQ0
Thu Apr 04 17:45:41 2013
Stopping background process QMNC
Thu Apr 04 17:45:42 2013
Stopping background process MMNL
Thu Apr 04 17:45:43 2013
Stopping background process MMON
Thu Apr 04 17:45:45 2013
Shutting down instance (immediate)
License high water mark = 4
Thu Apr 04 17:45:45 2013
Stopping Job queue slave processes
Thu Apr 04 17:45:45 2013
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Thu Apr 04 17:45:52 2013
alter database close normal
Thu Apr 04 17:45:53 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Apr 04 17:45:55 2013
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 969
Successful close of redo thread 1
Thu Apr 04 17:45:57 2013
Completed: alter database close normal
Thu Apr 04 17:45:57 2013
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active


Re: Database down [message #581945 is a reply to message #581944] Fri, 12 April 2013 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The database is down.
Start it... from the database server.

Regards
Michel
Re: Database down [message #581956 is a reply to message #581945] Fri, 12 April 2013 03:11 Go to previous messageGo to next message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
Thanks Michel,

Earlier when i was trying to startup from database server i was getting
ORA-12560: TNS:protocol adapter error


I restarted all the services and it worked
Re: Database down [message #581988 is a reply to message #581956] Fri, 12 April 2013 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You had not set ORACLE_HOME and/or ORACLE_SID and so on.

Regards
Michel

[Updated on: Fri, 12 April 2013 07:44]

Report message to a moderator

Re: Database down [message #585212 is a reply to message #581944] Thu, 23 May 2013 00:49 Go to previous messageGo to next message
deeplydrink
Messages: 14
Registered: May 2013
Location: Beijing
Junior Member
1.the correct way to connect the db from remote server: sqlplus username/password@tns_connect

2.logon on the db server, use "sqlplus / as sysdba" to connect the instance
Re: Database down [message #585216 is a reply to message #585212] Thu, 23 May 2013 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. It is ONE way not the only correct one. OP's one is also correct.
2. Only if OS authentication is enabled.

Regards
Michel
Re: Database down [message #585247 is a reply to message #585216] Thu, 23 May 2013 03:16 Go to previous message
deeplydrink
Messages: 14
Registered: May 2013
Location: Beijing
Junior Member
Michel Cadot wrote on Thu, 23 May 2013 01:19
1. It is ONE way not the only correct one. OP's one is also correct.
2. Only if OS authentication is enabled.

Regards
Michel



^_^
Previous Topic: Max process
Next Topic: ORA-00600: [kql-hash-collision]
Goto Forum:
  


Current Time: Thu Mar 28 12:05:45 CDT 2024