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-2003 01:36 AM
тАО10-27-2003 01:36 AM
sqlplus
I am logged on hp-unix 11:00 box and trying to
log to sqlplus. I have exports in my .profile
for ORACLE_SID ,CLASSPATH LD_LIBRARY_PATH etc
and proper Path etc
but when I type my in sqlplus id I get an error message
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
Any clue what could nbe happeing.
Thanks for help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 01:39 AM
тАО10-27-2003 01:39 AM
Re: sqlplus
To check your database, do a
ps -ef | grep pmon
and see your database listed.
Also check your oracle installation path. there may be multiple directories.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 01:58 AM
тАО10-27-2003 01:58 AM
Re: sqlplus
Oracle not available.
Is the box you are logged into the same box that runs the database?
If so, check your sid (echo $ORACLE_SID), and ask the DBA ti check the database for that SID.
If not, you need to specify a database location to sqlplus (eg sqlplus myid@database)
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 02:11 AM
тАО10-27-2003 02:11 AM
Re: sqlplus
oracle sid is OK. pmon is running. database is up.
is it possible that id is wrong?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 02:28 AM
тАО10-27-2003 02:28 AM
Re: sqlplus
set | grep -i ora
and check the alertfile, whether oracle has any problems since last startup.
Do you just execute sqlplus and then type user/password?
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 02:35 AM
тАО10-27-2003 02:35 AM
Re: sqlplus
Note:122183.1
Subject:
ORA-27101 "Shared Memory Realm Does Not
Exist" Connecting Via Net8
Type:
PROBLEM
Status:
REVIEWED
Content Type:
TEXT/PLAIN
Creation Date:
17-OCT-2000
Last Revision Date:
29-DEC-2000
Language:
USAENG
*************************************************************
This article is being delivered in Draft form and may contain
errors. Please use the MetaLink "Feedback" button to advise
Oracle of any issues related to this article.
*************************************************************
Problem Description
-------------------
You are attempting a client connection to an 8i database via
sqlplus and receive the following errors:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
You have installed 8.1.7 on the same server in a seperate
ORACLE_HOME.
Solution Description
--------------------
1) For local (BEQ) connections:
Verify that ORACLE_SID is set and points to a valid 8.1.7
database which is up and running.
% echo $ORACLE_SID
junk
% ps -ef |grep smon
oracle 24603 1 0 15:22:51 ? 0:02 ora_smon_JUNK
In this scenario, as ORACLE_SID is case-sensitive on the Unix
platform, a database called 'junk' isn't running. The fix would
be to set ORACLE_SID correctly or to the valid instance.
% setenv ORACLE_SID JUNK
2) For remote (TCP/listener) connections:
Review the listener.ora currently used to startup the listener
and verify the ORACLE_HOME is correct for all listed 8i
databases.
If the ORACLE_HOME points to the 8.1.7 software yet the database
was created with 8.1.6 or 8.1.5, then this error can occur.
Explanation
-----------
Previously when the ORACLE_HOME or ORACLE_SID was set incorrectly,
in the 'oracle' or client user's environment, only ora-1034 was reported.
ORA-01034 "ORACLE not available"
With 8.1.7, the ora-27101 is reporting that the shared memory
key generated by the client doesn't match any currently
existing keys. This is to be expected if the ORACLE_HOME used by
the client isn't the same as the one used to startup the database
with or the ORACLE_SID is not correctly referencing the right
instance.
Additional Search Words
-----------------------
listener, tnslsnr, parameter, hashing algorithm, attach, SGA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 02:51 AM
тАО10-27-2003 02:51 AM
Re: sqlplus
The shared memory id is calculated as a hash from ORACLE_HOME and ORACLE_SID. Maybe you listener.ora / tnsnames.ora do not match the environment used to start the DB?
If you can't figure it out from there, then also check that oracle has setuid (+s)
ls -l $ORACLE_HOME/bin/oracle:
-rwsr-sr-x ... oracle
chmod 7755 $ORACLE_HOME/bin/oracle
hth,
Hein.