OraFAQ Forum: Server Administration » ORA-01034, ORA-27101, ORA-00600

Home » RDBMS Server » Server Administration » ORA-01034, ORA-27101, ORA-00600

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01034, ORA-27101, ORA-00600 [message #139380]

Tue, 27 September 2005 14:55

mitra fatolahi
Messages: 38
Registered: October 2002

Member

Hello,
I can not connect to my current database using Oracle9i or the sqlplus.
It was working fine until I decided to delete several old databases using Database Configuration Appplication.

Oracle 9i Enterprise Manager prompts me with the message that Oracle instance is not available.

I tried to connect to the database using sqlplus and I got these error messages:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

==============================================================
I also tried to startup in nomount using sqlplus I got the following error:

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Sep 27 13:06:57 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password:

Connected to an idle instance.
SQL> startup nomount
ORA-00600: internal error code, arguments: [733], [538969648], [pga heap], [], [
], [], [], []
SQL>
=============================================================

Please note both TNSListner and OracleServicedb_name are shown as started in Services window (Windows 2000 OS).

Please advise,
Thank you so much,
Mitra

Report message to a moderator

Re: ORA-01034, ORA-27101, ORA-00600 [message #139444 is a reply to message #139380]

Wed, 28 September 2005 01:06

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Time to contact Oracle support.
Raise a tar on metalink.

ORA-00600 error is dealt by oracle itself.

See this

regards,
tarun

[Updated on: Wed, 28 September 2005 01:06]

Report message to a moderator

Re: ORA-01034, ORA-27101, ORA-00600 [message #139471 is a reply to message #139444]

Wed, 28 September 2005 03:38

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

Pls check your Tnsnames.ora file ... and find out which database your are trying to connect as u had written that you removed few database through configuration Assistance so i think that you r trying to connect to the database which u had removed...

Do one thing go at command prompt and set oracle sid for the database you want to connect

D:\>set ORACLE_SID=<database name>

Example:-
=========
suppose your database name is orcl then

D:\>set ORACLE_SID=orcl

now try to connect to the database...

Hope things may work for you .... if it dosen't work then restart your Machine on which database is present..
And still you get problem then .. contact system support of oracle corporation .... for error ORA-00600 Very Happy

Regards
Always Friend Sunilkumar.

Report message to a moderator

Re: ORA-01034, ORA-27101, ORA-00600 [message #139603 is a reply to message #139380]

Wed, 28 September 2005 15:28

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Not sure if this will work .. No harm in trying ..

try to reduce the sort_area_size or hash_area_size ...and try to bring up the db ...

-Sai Jeedigunta

Report message to a moderator

Re: ORA-01034, ORA-27101, ORA-00600 [message #139710 is a reply to message #139603]

Thu, 29 September 2005 04:55

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

This may help:

http://www.lazydba.com/oracle/0__73766.html

Report message to a moderator

Previous Topic:	How to Connect two oracle server with internet
Next Topic:	NLS_LANG settings

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:51:59 CDT 2024