Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor
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)
)
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1526)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1526)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = voyager)
(Port = 1526)
)
Below is the LISTENER.ORA file contents:
################ # Filename......: listener.ora # Node..........: local.world
################
(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)
)
(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)
)
(SID_NAME = ORCL) (ORACLE_HOME=h:\orant)
(SID_NAME = ava3) (ORACLE_HOME=h:\orant)
(SID_NAME = ORCL) (ORACLE_HOME=h:\orant)
(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=ava3Received on Fri May 30 1997 - 00:00:00 CDT
![]() |
![]() |