Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Oracle error

Occasional Advisor

Oracle error

Hi there,

When I try to access oracle from the application I get the following error on the HP/UX 11.00 ( 64 bit )

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

I have rebooted the box.
Have set the kernel parameters as per the recommendations in the Oracle documentation

Any advise will be helpful.

Michael Tully
Honored Contributor

Re: Oracle error


Have a look at this link. The information provided by Patrick should help.

Anyone for a Mutiny ?
Balaji N
Honored Contributor

Re: Oracle error


Just a thought.

Have this been working now and suddenly stopped working? Or has the database been migrated recently.

We had a similar problem. Everything was working fine but still we were not able to connect to the database and we were getting a similar error. Finaly we discovered that the path to the Oracle Server binaries specified in the listener.ora (ORACLE_HOME) was wrong.

Correcting it fixed the problem.

Its Always Important To Know, What People Think Of You. Then, Of Course, You Surprise Them By Giving More.
T G Manikandan
Honored Contributor

Re: Oracle error

I would do the following steps to Troubleshoot

1.First check the database whether it is up and running also with the listener on the Oracle server.

Try doing a

/@ to check that everything is working properly.

If this is working then the problem should be on the client side.

2.On the client make sure that the ORACLE_SID is set properly.

Also make sure that you have the entry in the tnsnames.ora file to reach the database on the remote machine.

Please revert

Alexander M. Ermes
Honored Contributor

Re: Oracle error

Hi there.
Pls check the install and upgrade guide from
It looks, like you did not set the kernel params correctly. Check the params ( especially the semaphore part ).
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Occasional Advisor

Re: Oracle error

Hi people,

I have already checked for the following :-
1. Kernel paramers - set as per the manual/installation guide.

2. ORACLE_SID and ORACLE_HOME are properly set.

3. I can execute sqlplus once, then I start an application which is on a different box, the application errors out with the errors that I mentioned earlier, after this if I try to do sqlplus, I get those errors everytime.

4. Overnight the box jammed completly, can even open a telnet session.
R. Allan Hicks
Trusted Contributor

Re: Oracle error

The other folks seem right on with their analysis. One thing that intrequed me was the box jamming overnight. When I first installed 9i, my "intelligent" agent had a memory leak and would consume the entire machine in the space of a day. There was a network patch that took care of things. I think the patch is part of release 2.

Try doing a top and watch dbsnmp. If you have the same problem that I had, the program's memory requirements will increase as top runs.

I usually see your original errors when Oracle is not running or like others have already pointed out, the SID is wrong. If you type:


followed by:

ps -ef|grep _pmon

You should see the SID in pmon's processes' name.


>ps -ef|grep _pmon

see metalink doc id

-Good Luck
"Only he who attempts the absurd is capable of achieving the impossible
Occasional Advisor

Re: Oracle error

Hi All,

All your inputs were valuable. I had to do some tunning with valuable inputs from a collegue, I would like to share them with you:

Cusrosrs : 300
Shared pool size : 4500000
Processes : 150

Probably the number of processes were too high ( 300).

Steven E. Protter
Exalted Contributor

Re: Oracle error

Try this oracle support script.

It gives you shared memory kernal and other needed changes in one passs.

It can't check physical memory. If you have more than 256 Meg, you are cool, though I know you want MUCH, MUCH more for performance reasons.

Steven E Protter
Owner of ISN Corporation