Joel Garry wrote:
>
> 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.
The problem seems to be in the tnsnames.ora file. Make sure the port
number is the same for both the instances. You had 1521 for A and 1526
for B. Try changing Port for A to 1526. Hopefull that should work
Nat
Received on Thu May 21 1998 - 10:43:04 CDT
