- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2002 02:56 PM
тАО10-27-2002 02:56 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2002 03:23 PM
тАО10-27-2002 03:23 PM
Re: Oracle error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2002 06:16 PM
тАО10-27-2002 06:16 PM
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.
hth
-balaji
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2002 09:25 PM
тАО10-27-2002 09:25 PM
Re: Oracle error
1.First check the database whether it is up and running also with the listener on the Oracle server.
Try doing a
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=
Also make sure that you have the entry in the tnsnames.ora file to reach the database on the remote machine.
Please revert
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-28-2002 04:34 AM
тАО10-28-2002 04:34 AM
Re: Oracle error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-28-2002 02:40 PM
тАО10-28-2002 02:40 PM
Re: Oracle error
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2002 07:59 AM
тАО10-29-2002 07:59 AM
Re: Oracle error
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
see metalink doc id
122183.1
-Good Luck
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2002 01:46 PM
тАО10-29-2002 01:46 PM
Re: Oracle error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-06-2002 10:04 AM
тАО11-06-2002 10:04 AM
Re: Oracle error
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.
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com