Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor

ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor

From: Ava Chun <voyager_at_inetnow.net>
Date: 1997/05/30
Message-ID: <5mldfk$ka0@news.inetnow.net>

When i use SQLPlus to connect to the database using User Name: SYSTEM Password: MANAGER Host String: ava3, i get the error, as follows:
"ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor"

The machine/server has 2 oracle instances: ORCL and AVA3. Each instance has its own NMPListener and service.

Instance Manager is reporting
AVA3 Services Status: started
Instance Status: started

Windows NT server service list shows the following: ORACLENMPListenerORCL status=started
ORACLENMPListenerAVA3 status=started
ORACLEServiceORCL status=started
ORACLEServiceAVA3 status=started
ORACLEStartORCL status=started
ORACLEStartAVA3 status=started
ORACLETCPListener status=started
ORACLETNSListener status=started

Below is the TNSNAMES.ORA file contents: Example1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 

(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)

    )
    (CONNECT_DATA = (SID = SID1)
    )
  )
Example2.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = 

(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Example3.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = 

(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = 

(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1526)
)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
avadb.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = 

(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1526)
)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
ava3.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = 

(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1526)
)

    )
    (CONNECT_DATA = (SID = ava3)
    )
  )

Below is the LISTENER.ORA file contents:

################
# Filename......: listener.ora
# Node..........: local.world

# Date..........: 24-MAY-94 13:23:20
################

LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=

(PROTOCOL= IPC)
(KEY= oracle.world)
) (ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
) (ADDRESS=
(PROTOCOL= IPC)
(KEY= ava3.world)
) (ADDRESS=
(PROTOCOL= IPC)
(KEY= ava3)
) (ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= VOYAGER)
(PIPE= ORAPIPE)
) (ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= voyager)
(Port= 1521)
) (ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= voyager)
(Port= 1526)
) (ADDRESS=
(COMMUNITY= SPX.world)
(PROTOCOL= SPX)
(Service= voyager_lsnr)
)

  )
LISTENER_ava3.world =
  (ADDRESS_LIST =
        (ADDRESS=

(PROTOCOL= IPC)
(KEY= ava3.world)
) (ADDRESS=
(PROTOCOL= IPC)
(KEY= ava3)
) (ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= voyager)
(Port= 1521)
) (ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= voyager)
(Port= 1526)
)

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME=h:\orant)

    )
    (SID_DESC =
      (SID_NAME = ava3)
      (ORACLE_HOME=h:\orant)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME=h:\orant)

    )
    (SID_DESC =
      (SID_NAME = ava3)
      (ORACLE_HOME=h:\orant)

    )
  )

Below is the SQLNETV2.CFG file contents: next_addendum=7
tns_filesize=2212

ALIAS_0=Example1.world

Example1.world_PROTOCOL=TCP
Example1.world_COMMUNITY=tcp.world
Example1.world_HOST=Production1
Example1.world_PORT=1521
Example1.world_SID=SID1

ALIAS_1=Example2.world

Example2.world_PROTOCOL=SPX
Example2.world_COMMUNITY=spx.world
Example2.world_SERVICE=Server_lsnr
Example2.world_SID=ORCL

ALIAS_2=Example3.world

Example3.world_PROTOCOL=NMP
Example3.world_COMMUNITY=nmp.world
Example3.world_SERVER=FinanceServer1
Example3.world_PIPE=ORAPIPE
Example3.world_SID=ORCL

ALIAS_3=Tcp-loopback.world

Tcp-loopback.world_PROTOCOL=TCP
Tcp-loopback.world_COMMUNITY=tcp.world
Tcp-loopback.world_HOST=voyager
Tcp-loopback.world_SID=ORCL

ALIAS_4=avadb.world

avadb.world_PROTOCOL=TCP
avadb.world_COMMUNITY=tcp.world
avadb.world_HOST=voyager
avadb.world_SID=ORCL

ALIAS_6=ava3.world

ava3.world_PROTOCOL=TCP
ava3.world_COMMUNITY=tcp.world
ava3.world_HOST=voyager
ava3.world_SID=ava3
Received on Fri May 30 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US