topic Re: Oracle error in Operating System - HP-UX

Oracle error

Vivek_9 — Sun, 27 Oct 2002 22:56:33 GMT

Hi there,

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

ERROR:
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.

Regards

Re: Oracle error

Michael Tully — Sun, 27 Oct 2002 23:23:30 GMT

Hi,

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

Regards
Michael

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x50ba854994d9d4118fef0090279cd0f9,00.html

Re: Oracle error

Balaji N — Mon, 28 Oct 2002 02:16:53 GMT

Hi,

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.

hth
-balaji

Re: Oracle error

T G Manikandan — Mon, 28 Oct 2002 05:25:08 GMT

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.
ORACLE_SID=export ORACLE_SID.

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

Please revert

Thanks

Re: Oracle error

Alexander M. Ermes — Mon, 28 Oct 2002 12:34:26 GMT

Hi there.
Pls check the install and upgrade guide from
Oracle.
It looks, like you did not set the kernel params correctly. Check the params ( especially the semaphore part ).
Rgds
Alexander M. Ermes

Re: Oracle error

Vivek_9 — Mon, 28 Oct 2002 22:40:36 GMT

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.
Ta.

Re: Oracle error

R. Allan Hicks — Tue, 29 Oct 2002 15:59:09 GMT

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:

echo $ORACLE_SID

followed by:

ps -ef|grep _pmon

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

ex:

>echo $ORACLE_SID
FOO
>ps -ef|grep _pmon
ora_pmon_FOO

see metalink doc id
122183.1

-Good Luck

Re: Oracle error

Vivek_9 — Tue, 29 Oct 2002 21:46:51 GMT

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).
Regards

Re: Oracle error

Steven E. Protter — Wed, 06 Nov 2002 18:04:51 GMT

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.