Re: HELP! Can connect locally through IPC, but not through TCP/IP

On Tue, 19 May 1998 20:45:44 GMT, Dave Snyder <dsnyder_at_netgenics.com> wrote:
>Hi everyone,
>
> I recently set up a second oracle instance on a solaris 2.5 box
>running oracle 7.3.3... I can connect to both instances through server
>manager as well as sqlplus. In addition, I can connect to instance A
>(this was an instance set up on this machine by a consultant and has
>worked all along ) from remote machines using sqlplus. I cannot,
>however, connect to instance B (the instance I set up) remotely or using
>the TCP/IP loopback (i.e. sqlplus user/passwd_at_sid ) When I try, I get
>the following error:
>
>ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>SVR4 Error: 2: No such file or directory
>
>I know this will happen when the instance is not running, but I am
>positive it is, as I can connect using svrmgrl. Since I know very
>little about the listener.ora and sql*net setup, I have included the
>pertinent files in this post. If anyone has any ideas, I would really
>appreciate hearing them...
>

Perhaps you've set ORACLE_HOME wrong?

>
>oratab:
>----------------------------------------------------------------------
>A:/database/home/oracle:Y
>B:/database/home/oracle:Y
>----------------------------------------------------------------------
>
>
>listener.ora
>----------------------------------------------------------------------
>SQLNET.AUTHENTICATION_SERVICES = (NONE)
>
>USE_PLUG_AND_PLAY_LISTENER = ON
>USE_CKPFILE_LISTENER = OFF
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= A.world)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= A)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= B.world)
> )
> (ADDRESS=
> (PROTOCOL=IPC)
> (KEY= B)
> )
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (Host = host1.dev.netgenics.com)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (Host = host1.dev.netgenics.com)
> (Port = 1526)
> )
> )
>STARTUP_WAIT_TIME_LISTENER = 0
>CONNECT_TIMEOUT_LISTENER = 10
>TRACE_LEVEL_LISTENER = OFF
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = A.world)
> (SID_NAME = A)
> (ORACLE_HOME = /database/home/oracle)
> (PRESPAWN_MAX = 10)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = B.world)
> (SID_NAME = B)
> (ORACLE_HOME = /database/home/oracle)
> (PRESPAWN_MAX = 10)
> )
> )
>-----------------------------------------------------------------------
>
>tnsnames.ora
>-----------------------------------------------------------------------
>A =
> (DESCRIPTION =
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (Host = host1.dev.netgenics.com)
> (Port = 1521)
> )
> (CONNECT_DATA =
> (SID = A)
> )
> )
>B =
> (DESCRIPTION =
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (Host = host1.dev.netgenics.com)
> (Port = 1526)
> )
> (CONNECT_DATA =
> (SID = B)
> )
>)
>------------------------------------------------------------------------
>
>
>
>--
>------------------------------------
>David Snyder (dsnyder_at_netgenics.com)
>
>NetGenics, Inc.
>1717 East 9th St., Suite 1550
>Cleveland, OH 44114-2803
>
>216-861-4007 voice
>216-861-4777 fax
>------------------------------------
>
>

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.