Home » RDBMS Server » Networking and Gateways » ORA-27101: shared memory realm does not exist (connect from unix to window db) (9.2.0.7)
ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #307780] Wed, 19 March 2008 19:34 Go to next message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
Hi,
I am trying to connect to a window database from Unix from SQLPlus but keep getting the following error:
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

However, when I attempt connect to the database on this Unix box, I was able to. Just can not connect to database window server.

I export and have the window database in the tnsnames.ora on Unix. I attempt to ping but it could not resolve the name.

Thanks!
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #307781 is a reply to message #307780] Wed, 19 March 2008 19:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you saying you can't ping the server and/or tnsping the database? If you can't ping by name, have you tried the IP address of the Windows box?

What does your tnsnames.ora file look like?
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #307786 is a reply to message #307780] Wed, 19 March 2008 20:42 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
Is Oracle RDBMS running on the Windows system?
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #307900 is a reply to message #307780] Thu, 20 March 2008 05:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Possibly ORACLE_SID settings problem.
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #307978 is a reply to message #307900] Thu, 20 March 2008 11:41 Go to previous messageGo to next message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
In the TNSNAMES file, I tried IP and dns name, but no luck.
Yes, Oracle RDBMS is running on Windows; however, I also have one running on Unix for different database.

I try tnsping and ping the server. When I ping the server, I keep getting the following message:
PING oracle-oms.smfbc.org: 64 byte packets
64 bytes from 10.40.3.38: icmp_seq=0. time=0. ms
64 bytes from 10.40.3.38: icmp_seq=1. time=0. ms
64 bytes from 10.40.3.38: icmp_seq=2. time=0. ms
64 bytes from 10.40.3.38: icmp_seq=3. time=0. ms
.
.
64 bytes from 10.40.3.38: icmp_seq=64. time=0. ms
.
.
I had kill it because it seems to go forever. I will talk to my Unix Admin since it looks like this is where the issue is.

Thanks!

Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308009 is a reply to message #307780] Thu, 20 March 2008 14:59 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
> I am trying to connect to a window database
>I will talk to my Unix Admin since it looks like this is where the issue is.

Since the error occurs when trying to use Oracle on Windoze, how/why are you dragging the poor Unix SA into this cesspool?

The problem resides on the Windows box is my best guess?
Can ANY client talk to the Oracle DB on Windows?

Once AGAIN,
Is Oracle RDBMS actually running on the Windows system?
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308010 is a reply to message #308009] Thu, 20 March 2008 15:13 Go to previous messageGo to next message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
Yes, Oracle RDBMS is running on Windows. I want to connect to the database on Windows from Unix because my RMAN Recovery catalog database is on Windows. Currently all my Oracle databases on Windows use this RMAN database as recovery catalog and I would like to include my Unix database backup to it.

anacedent: Can ANY client talk to the Oracle DB on Windows?
Yes, if I'm connecting from another Windows server/pc.
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308011 is a reply to message #307780] Thu, 20 March 2008 15:17 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
I would replace the tnsnames.ora file on the Unix box with a copy of tnsnames.ora from a working Windows client via CUT & PASTE.

post the contents of the sqlnet.ora file (if any) from Unix box.
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308017 is a reply to message #308011] Thu, 20 March 2008 15:43 Go to previous messageGo to next message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
I did a cut and paste but no luck.

my sqlnet.ora
# SQLNET.ORA Network Configuration File: /oracle/product/9.2.0.3/network/admin/s
sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = smfbc.org

I also try including the below 2 lines for sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)

I try other combinations also, but still no luck.
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308022 is a reply to message #307780] Thu, 20 March 2008 15:53 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
>I am trying to connect to a window database from Unix from SQLPlus but keep getting the following error

Use CUT & PASTE to show us the WHOLE session.
One interpretation of the errors you previously posted is that you are not getting off the HP box.

also issue the following during session above

tnsping <tns_alias>

If you are getting to the Windows system, you will see entries in listener.log on the Windows box.

post the contents on tnsnames.ora from Unix box

Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308039 is a reply to message #308022] Thu, 20 March 2008 17:13 Go to previous messageGo to next message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
I just found out that I am able to connect if I specify the oracle sid as follow: sqplus user/password@RMANREP; therefore, I think that the content of TNSNAMES.ora and sqlnet.ora is correct. I am not sure why when using export ORACLE_SID does not work.
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308040 is a reply to message #307780] Thu, 20 March 2008 17:28 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
>I am not sure why when using export ORACLE_SID does not work
THINK about it!
If the database resides on some remote server, how/why do you expect Oracle to know on which server MYSID resides?
Oracle tries the only place it really knows about; the local system.

You'd benefit from reading Concepts Manual found at http://tahiti.oracle.com

[Updated on: Thu, 20 March 2008 17:29] by Moderator

Report message to a moderator

Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308041 is a reply to message #308040] Thu, 20 March 2008 17:35 Go to previous messageGo to next message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
I guess so; I was hoping UX/Oracle some sort mechanisms to make it works.
Thanks for the help.
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308047 is a reply to message #308039] Thu, 20 March 2008 18:30 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You have to set TWO_TASK in order to connect without specifying tnsalias in connect string.
Re: ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #308048 is a reply to message #308047] Thu, 20 March 2008 18:40 Go to previous message
pputh
Messages: 13
Registered: December 2007
Location: Sacramento
Junior Member
Thank you Brain!
Previous Topic: ODBC connection error with TNS-12154
Next Topic: Static Service registration for Listener
Goto Forum:
  


Current Time: Thu Dec 18 05:55:36 CST 2014

Total time taken to generate the page: 0.12080 seconds