cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle error

Vivek_9
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 )

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
8 REPLIES
Michael Tully
Honored Contributor

Re: Oracle error

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
Anyone for a Mutiny ?
Balaji N
Honored Contributor

Re: Oracle error

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
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.
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
Alexander M. Ermes
Honored Contributor

Re: Oracle error

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Vivek_9
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.
Ta.
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:

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
"Only he who attempts the absurd is capable of achieving the impossible
Vivek_9
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).
Regards


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
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com