Home » RDBMS Server » Networking and Gateways » Solaris 9, 10g network not connecting/object does not exist
Solaris 9, 10g network not connecting/object does not exist [message #140233] Mon, 03 October 2005 00:22 Go to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Why do I get 'Object does not exist?'

my tnsnames.ora looks like this
>cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u04/app/oracle/product/10.1.0.2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
MGW_AGENT =
(DESCRIPTION=
   (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC)(KEY=EXTPROC)))
   (CONNECT_DATA= (SID=mgwextproc) (PRESENTATION=RO)))
os2p_BEQ =
  (DESCRIPTION =
   (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /u04/app/oracle/product/10.1.0.2)
        (argv0 = oracleos2t)
        (args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
        (envs = 'ORACLE_HOME=/u04/app/oracle/product/10.1.0.4,ORACLE_SID=os2t')
    )
  )
oem =
(DESCRIPTION=
   (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC)(KEY=EXTPROC)))
   (CONNECT_DATA= (SID=mgwextproc) (PRESENTATION=RO)))
os2t =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = solarsystem)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = os2t)
    )
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

My listener.ora looks like this:
 LISTENER =
  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
        (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))   
 SID_LIST_os2t
 SID_LIST_LISTENER=
   (SID_LIST=
        (SID_DESC=
        BEQUEATH CONFIG
          (GLOBAL_DBNAME=os2t.deltacollege.edu)
         (SID_NAME=os2t)                        
          (ORACLE_HOME=/u04/app/oracle/product/10.1.0.2
         (PRESPAWN_MAX=20)
          (PRESPAWN_LIST=
           (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
         )
        )
       )

When I start the listener it says there are no supported services?:
lsnrctl start

LSNRCTL for Solaris: Version 10.1.0.2.0 - Production on 02-OCT-2005 21:47:28

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting /u04/app/oracle/product/10.1.0.2/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.1.0.2.0 - Production
System parameter file is /u04/app/oracle/product/10.1.0.2/network/admin/listener.ora
Log messages written to /u04/app/oracle/product/10.1.0.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=207.62.178.30)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=solarsystem)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.1.0.2.0 - Production
Start Date                02-OCT-2005 21:47:28
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u04/app/oracle/product/10.1.0.2/network/admin/listener.ora
Listener Log File         /u04/app/oracle/product/10.1.0.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


Re: Solaris 9, 10g network not connecting/object does not exist [message #140265 is a reply to message #140233] Mon, 03 October 2005 05:14 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Please post the complete error message. Also, tell us what you do when you get it?

Best regards.

Frank
Previous Topic: Solaris 9, 10g how to start OEM
Next Topic: random ports (again)
Goto Forum:
  


Current Time: Wed Apr 24 05:28:58 CDT 2024