Home » RDBMS Server » Server Administration » Database Instance down (Oracle : 11g : MS windows server 2003)
Database Instance down [message #431178] Mon, 16 November 2009 00:51 Go to next message
rwaqas
Messages: 7
Registered: November 2009
Location: Lahore
Junior Member
Hi,

Last night our oracle server was improperly shutdown due to which now the Database instance is down as well as Agent connection to instance. This is why we are unable to connect to database 'orcl'. We tried using enterprise manager but it requires OS password and on providing it with OS passward it says Invalid user name and password. We have also tried using sqlplus 'STARTUP' (conn sys/pass @orcl as sysdba) using login 'sys' as sysdba but it says:

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Any resolution other than reinstallation of OS or Oracle?

Thanks.
Regards,
Waqas
Re: Database Instance down [message #431181 is a reply to message #431178] Mon, 16 November 2009 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connect on the database server as a OS dba user, set ORACLE_HOME and ORACLE_SID environment variable and execute SQL*Plus connecting as "/ as sysdba", then you will be able to execute STARTUP.

Regards
Michel
Re: Database Instance down [message #431199 is a reply to message #431181] Mon, 16 November 2009 03:16 Go to previous messageGo to next message
rwaqas
Messages: 7
Registered: November 2009
Location: Lahore
Junior Member
I tried that but when I tries to login as sysdba using
conn sys/password @orcl using sysdba
it states:
ERROR:
ORA-12560: TNS:protocol adapter error
Re: Database Instance down [message #431200 is a reply to message #431199] Mon, 16 November 2009 03:20 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
rwaqas wrote on Mon, 16 November 2009 03:16
I tried that but when I tries to login as sysdba using
conn sys/password @orcl using sysdba
it states:
ERROR:
ORA-12560: TNS:protocol adapter error


Observe the Michel`s Answer again you can find the solution.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

Z:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 16 14:57:26 2009

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: conn sys / as sysdba
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon>  ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Z:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 16 14:57:56 2009

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: sys / as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Z:\>set oracle_sid=satya

Z:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 16 14:58:21 2009

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>


sriram

[Updated on: Mon, 16 November 2009 03:28]

Report message to a moderator

Re: Database Instance down [message #431205 is a reply to message #431178] Mon, 16 November 2009 03:43 Go to previous messageGo to next message
rwaqas
Messages: 7
Registered: November 2009
Location: Lahore
Junior Member
Actually I started this service 'OracleserviceORCL' which was set automatic but some how was not started. So after started it my attempt to connect as sysdba was successfull. heres the log including a new error while trying 'STARTUP'

SQL> conn sys/password as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 523108352 bytes
Fixed Size 1334292 bytes
Variable Size 377488364 bytes
Database Buffers 138412032 bytes
Redo Buffers 5873664 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error
Process ID: 292
Session ID: 170 Serial number: 5
Re: Database Instance down [message #431206 is a reply to message #431205] Mon, 16 November 2009 03:46 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Have a look at what is says in the alert log of the instance.

( alert_[SID].log in the background dump directory )
Re: Database Instance down [message #431212 is a reply to message #431178] Mon, 16 November 2009 04:02 Go to previous messageGo to next message
rwaqas
Messages: 7
Registered: November 2009
Location: Lahore
Junior Member
Hi which directory is it. Can you be specific about the path of this dump dir where these alert logs are located.
Re: Database Instance down [message #431214 is a reply to message #431212] Mon, 16 November 2009 04:06 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Not really, since you have to specify it during the database creation, so there is no way anyone other than the person who installed the database really knows.

The directory itself is called "bdump" in maybe 80% of cases, and is either somewhere where the datafiles are or somewhere where the Oracle installation is.
Re: Database Instance down [message #431217 is a reply to message #431178] Mon, 16 November 2009 04:10 Go to previous messageGo to next message
rwaqas
Messages: 7
Registered: November 2009
Location: Lahore
Junior Member
got it..

The last few logs suggests:

Mon Nov 16 04:56:45 2009
Flush retried for xcb 0x2d711704, pmd 0x2d08a4f4
Doing block recovery for file 3 block 3924
Errors in file c:\app\dc.systems\diag\rdbms\orcl\orcl\trace\orcl_pmon_3168.trc:
ORA-00600: internal error code, arguments: [4194], [6], [11], [], [], [], [], []
No block recovery was needed
PMON (ospid: 3168): terminating the instance due to error 472
Mon Nov 16 04:56:55 2009
ORA-1092 : opidrv aborting process W000 ospid (948_600)
Mon Nov 16 04:57:00 2009
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x8] [PC:0x92AC85, _kksMapCursor()+317]
Errors in file c:\app\dc.systems\diag\rdbms\orcl\orcl\trace\orcl_ora_3300.trc (incident=26757):
ORA-07445: exception encountered: core dump [kksMapCursor()+317] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x92AC85] [UNABLE_TO_READ] []
ORA-00472: PMON process terminated with error
Incident details in: c:\app\dc.systems\diag\rdbms\orcl\orcl\incident\incdir_26757\orcl_ora_3300_i26757.trc
Mon Nov 16 04:57:00 2009
Errors in file c:\app\dc.systems\diag\rdbms\orcl\orcl\trace\orcl_q002_4036.trc:
ORA-00472: PMON process terminated with error
ORA-1092 : opidrv aborting process Q002 ospid (948_4036)
Mon Nov 16 04:57:00 2009
ORA-472 : opidrv aborting process S000 ospid (948_1936)
Errors in file c:\app\dc.systems\diag\rdbms\orcl\orcl\incident\incdir_26757\orcl_ora_3300_i26757.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 472
ORA-07445: exception encountered: core dump [kksMapCursor()+317] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x92AC85] [UNABLE_TO_READ] []
ORA-00472: PMON process terminated with error
Errors in file c:\app\dc.systems\diag\rdbms\orcl\orcl\incident\incdir_26757\orcl_ora_3300_i26757.trc:
ORA-00449: background process 'LGWR' unexpectedly terminated with error 472
ORA-07445: exception encountered: core dump [kksMapCursor()+317] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x92AC85] [UNABLE_TO_READ] []
ORA-00472: PMON process terminated with error
Mon Nov 16 04:57:15 2009
Instance terminated by PMON, pid = 3168
Re: Database Instance down [message #431220 is a reply to message #431214] Mon, 16 November 2009 04:13 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Check you parameter value for background_dump_dest like below mentioned...And read Oracle Documents For the concepts.

I.E

SQL> sho parameter background_dump_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      C:\ORACLE\PRODUCT\10.2.0\ADMIN
                                                 \SATYA\BDUMP
SQL>


sriram
Re: Database Instance down [message #431223 is a reply to message #431217] Mon, 16 November 2009 04:16 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
ORA-00600: internal error code, arguments: [4194], [6], [11], [], [], [], [], []


Contact your Oracle support.

Sriram.
Re: Database Instance down [message #431224 is a reply to message #431178] Mon, 16 November 2009 04:17 Go to previous messageGo to next message
rwaqas
Messages: 7
Registered: November 2009
Location: Lahore
Junior Member
okay.

when I give that command it says 'Oracle is not available'


SQL> conn sys/cure2000 @orcl as sysdba
Connected to an idle instance.
SQL> sho parameter background_dump_dest
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

Re: Database Instance down [message #431226 is a reply to message #431224] Mon, 16 November 2009 04:20 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
rwaqas,

My post is a reply for you to find the alert log location...And as you found it and posted some content of the file ..
And it is showing some ORA-00600: internal error code, arguments: [4194], [6], [11], [], [], [], [], []

Which is an internal error for which you need to contact your Oracle support.

Sriram
Re: Database Instance down [message #431230 is a reply to message #431178] Mon, 16 November 2009 04:24 Go to previous message
rwaqas
Messages: 7
Registered: November 2009
Location: Lahore
Junior Member
thanks Sriram.

I google the errors!

regards,
waqas
Previous Topic: connection hang
Next Topic: ora-09925
Goto Forum:
  


Current Time: Mon Dec 05 18:56:09 CST 2016

Total time taken to generate the page: 0.10387 seconds