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

[StryderKC]

On my test server I was installing a custom application which uses the Oracle Database as Backend. However My installation failed and I have contacted their support team. However my issue is that now even when I am trying to connect with plain SQL Plus into the Oracle Database I am getting this:

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

Now I did the basic troubleshooting and restarted Oracle service to make sure it is mounted correctly. But this is refusing to go away. It is interesting because there seems to be no issue with starting and shutting down oracle.

Any ideas?

[simply_dba]

Log in administrator. Open cmd prompt. type sqlplus. Login / as sysdba (assuming u r using 9i or above). type startup. Post the results here.

[StryderKC]

Hmmm things just got wierder...

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 30 18:26:57 2009
Copyright (c) 1982, 2005, 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>

Seems like i might need to raise an SR

[simply_dba]

Can you post the relevant contents of the alert log here ? Also first few paragraph of the trace file generated.

Edit:

Typically this error occurs when allocating an extent in the PGA, if the minimum size requested is greater than what is allowed for this port. try lowering the following parameters and restart.
sort_area_size,hash_area_size.

Also, it may be that you have hit a bug (i found some relating to this). Better raise a SR with Oracle.

[Shekhar81]

The most common cause of the ORA-01034 ORA-27101 Problem is when the ORACLE_SID or ORACLE_HOME is not properly set. When you tried to start the database did you do so after configuring the SID like this

$ export ORACLE_SID=[your oracle SID]
or
$ setenv ORACLE_SID=[your oracle SID]

Remember that ORACLE_SID is case sensitive on unix like systems

[StryderKC]

Hi guys thanks for helping, really appreciate it. actually it seems the server was running out of resources because we rebooted the server and also disabled certain other services which were running. Now I can connect to the test server and the error is coming no more.

Thanks again.