OraFAQ Forum: Networking and Gateways » ORA-27101: shared memory realm does not exist (connect from unix to window db)

Home » RDBMS Server » Networking and Gateways » ORA-27101: shared memory realm does not exist (connect from unix to window db) (9.2.0.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-27101: shared memory realm does not exist (connect from unix to window db) [message #307780]

Wed, 19 March 2008 19:34

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!

Report message to a moderator

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

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?

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Is Oracle RDBMS running on the Windows system?

Report message to a moderator

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

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Possibly ORACLE_SID settings problem.

Report message to a moderator

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

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!

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

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.

Report message to a moderator

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

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You have to set TWO_TASK in order to connect without specifying tnsalias in connect string.

Report message to a moderator

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

pputh
Messages: 13
Registered: December 2007
Location: Sacramento

Junior Member

Thank you Brain!

Report message to a moderator

Previous Topic:	ODBC connection error with TNS-12154
Next Topic:	Static Service registration for Listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 17:48:18 CST 2024