ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect

[charlton]

Hi there DBA's

This is kinda urgent.
Can't connect to database.
get the folowing error:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

1. I get a response when I do a TNSping to the DB
2. Can't connect to the same DB.

Checked TNSnames, sqlnet and listener.ora files?
Started / stopped Database and listener.
restarted box?

Nothing works.

Please Help!

[Tarry]

The service name in your client's tnsnames.ora file does not match with the listener on the server.
Check that it's the same...
And then you'll be able to connect.

[charlton]

# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

CIMDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.3)(PORT = 1521))
)



TNSNAMES <----- and i am sure it is port 1521





# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

DEV.ZA.TISCALI.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 196.15.152.24)(PORT = 1521))
)
(CONNECT_DATA =
(SID = CIMDB)
)
)

CIMDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.3)(PORT = 1521))
)
(CONNECT_DATA =
(SID = CIMDB)
)
)



PLEASE HELP!!!!

[Raminder]

What is your Global Database name in Listener.ORA?
It should be DEV.ZA.TISCALI.COM

Turn on logging and tell us the result !

[charlton]

This is what the log gives me!


System parameter file is D:\Oracle\Ora81\network\admin\listener.ora
Log messages written to D:\Oracle\Ora81\network\log\cimdb.log
Trace information written to D:\Oracle\Ora81\network\trace\cimdb.trc
Trace level is currently 0

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.3)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
19-NOV-2002 15:54:06 * (CONNECT_DATA=(SERVICE_NAME=CIMDB)(CID=(PROGRAM=D:\oracle\ora90\bin\sqlplus.exe)(HOST=JAVADEV)(USER= CharlesM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.53)(PORT=3534)) * establish * CIMDB * 0

[Tarry]

Use the net8 utility on the client to configure it there and test it from the net8 utility.

[Tarry]

Originally posted by charlton
This is what the log gives me!


System parameter file is D:\Oracle\Ora81\network\admin\listener.ora
Log messages written to D:\Oracle\Ora81\network\log\cimdb.log
Trace information written to D:\Oracle\Ora81\network\trace\cimdb.trc
Trace level is currently 0

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.3)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
19-NOV-2002 15:54:06 * (CONNECT_DATA=(SERVICE_NAME=CIMDB)(CID=(PROGRAM=D:\oracle\ora90\bin\sqlplus.exe)(HOST=JAVADEV)(USER=CharlesM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.53)(PORT=3534)) * establish * CIMDB * 0

[charlton]

This is what the log gives me!


System parameter file is D:\Oracle\Ora81\network\admin\listener.ora
Log messages written to D:\Oracle\Ora81\network\log\cimdb.log
Trace information written to D:\Oracle\Ora81\network\trace\cimdb.trc
Trace level is currently 0

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.3)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
19-NOV-2002 15:54:06 * (CONNECT_DATA=(SERVICE_NAME=CIMDB)(CID=(PROGRAM=D:\oracle\ora90\bin\sqlplus.exe)(HOST=JAVADEV)(USER= CharlesM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.53)(PORT=3534)) * establish * CIMDB * 0

[charlton]

That is one of the clients that's trying to connect using a 9i client

[charlton]

This is what my trace file is giving me!


CONNECTION REQUEST

nsevfnt: cxd: 0x12db898 stage 0: NS events set:
INCOMING CALL

nsevwait: event is 0x1, on 0
nsevwait: 1 posted event(s)
nsglhe: entry
nsmal: 420 bytes at 0x12db588
nsmal: 1712 bytes at 0x13326b8
nsopen: opening transport...
nttcon: entry
nttcon: toc = 3
nttcnp: entry
ntvlin: entry
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nttcnp: exit
nttcnr: entry
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttvlser: entry
nttvlser: valid node check on incoming node 10.0.1.3
nttvlser: Accepted Entry: 10.0.1.3
nttcnr: exit
nttcon: set TCP_NODELAY on 356
nttcon: exit
nsopen: transport is open
nsnainit: answer
nsnasvnainfo: NA disabled for this connection
nainit: entry
nagblini: entry
nau_gin: entry
nau_gparams: entry
nam_gbp: Reading parameter "sqlnet.authentication_required" from parameter file
nam_gbp: Parameter not found
nau_gparams: Using default value "FALSE"
nau_gslf: entry
nam_gic: entry
nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
nam_gic: Parameter not found
nam_gic: Found 0 items
nam_gic: exit
nau_gslf: Using default value "all available adapters"
nauss_set_state: entry
nauss_set_state: exit
nau_gslf: exit
nau_gparams: exit
nau_gin: exit
nagblini: exit
na_saveprot: entry
na_saveprot: exit
nacomin: entry
nas_init: entry
nas_init: exit
nau_ini: entry
naugcp_get_connect_parameters: entry
nauss_set_state: entry
nauss_set_state: exit
naugcp_get_connect_parameters: exit
nau_gettab: entry
nau_tadv: entry
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_fad: entry
nau_fad: exit
nau_tadv: exit
nau_gettab: exit
nau_sini: entry
nau_sini: exit
nau_ini: exit
naeeinit: entry
nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
nam_gbp: Parameter not found
nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_SERVER" from parameter file
nam_gnsp: Parameter not found
naequad: Using default value "ACCEPTED"
nam_gic: entry
nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_SERVER" parameter
nam_gic: Parameter not found
nam_gic: exit
naesno: Using default value "all available algorithms"
naeshow: entry
naeshow: exit
naeeinit: exit
naecinit: entry
nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_SERVER" from parameter file
nam_gnsp: Parameter not found
naequad: Using default value "ACCEPTED"
nam_gic: entry
nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" parameter
nam_gic: Parameter not found
nam_gic: exit
naesno: Using default value "all available algorithms"
naeshow: entry
naeshow: exit
naecinit: exit
nadisc: entry
nacomtm: entry
nacompd: entry
nacompd: exit
nacompd: entry
nacompd: exit
nacomtm: exit
nas_dis: entry
nas_dis: exit
nau_dis: entry
nau_fad: exit
nau_dis: exit
naeetrm: entry
naeetrm: exit
naectrm: entry
naectrm: exit
nagbltrm: entry
nau_gtm: entry
nau_gtm: exit
nagbltrm: exit
nadisc: exit
nainit: exit
nsnainit: NS Connection version: 310
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsnainit: "or" info flags: 0xd Translations follow:
native service(s) is (are) wanted
NA disabled remotely for this connection
NA services unavailable on both processes - negotiation not needed

nsnainit: "or" info flags: 0xd Translations follow:
native service(s) is (are) wanted
NA disabled remotely for this connection
NA services unavailable on both processes - negotiation not needed
"and" info flags: 0xd Translations follow:
native service(s) is (are) wanted
NA disabled remotely for this connection
NA services unavailable on both processes - negotiation not needed

nsopen: global context check-in (to slot 2) complete
nsopen: lcl[0]=0x1fefff, lcl[1]=0x12003, gbl[0]=0x783f, gbl[1]=0x2001, tdu=32767, sdu=8192
nsdo: cid=2, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=7, flg=0x4200, mvd=0
nsdo: nsctxrnk=0
nsanswer: deferring connect attempt; at stage 5
nsevreg: begin registration process for 2
nsevreg: sgt=0, evn=1, evt[2]=0x0
nsevreg: begin notification process for 2
nsevreg: rdm=0, sgt=0, evt[0]=0x20, [1]=0x20, [2]=0x0, nrg=0
nsevreg: registering for 0x20
nsglhe: exit
nsevwait: 2 registered connection(s)
nsevwait: 0 added to NT list for 0x8
nsevwait: 2 added to NT list for 0x2
nsevwait: 0 pre-posted event(s)
nsevwait: waiting for transport event (0 thru 2)...
ntctst: size of NTTEST list is 1 - not calling poll
nsevwait: 1 newly-posted event(s)
nsevfnt: cxd: 0x12db2b0 stage 5: NT events set:
READ

nsevfnt: cxd: 0x12db2b0 stage 5: NS events set:
OUTGOING CALL COMPLETE

nsprecv: reading from transport...
nttrd: entry
nttrd: socket 356 had bytes read=238
nttrd: exit
nsprecv: 238 bytes from transport
nsprecv: tlen=238, plen=238, type=1
nsevfnt: cxd: 0x12db2b0 stage 5: NT events set:
READ

nsevfnt: cxd: 0x12db2b0 stage 5: NS events set:
OUTGOING CALL COMPLETE

nsevdansw: at STAGE 5
nsdo: cid=2, opcode=68, *bl=2040, *what=8, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=14, flg=0x4204, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=8163
nscon: doing connect handshake...
nscon: recving a packet
nsprecv: 238 bytes from leftover
nsprecv: tlen=238, plen=238, type=1
nscon: got NSPTCN packet
nsconneg: vsn=310, lov=300, opt=0x0, sdu=2048, tdu=32767, ntc=0xa30a
nsconneg: vsn=310, gbl=0x1, sdu=2048, tdu=32767
nscon: got 180 bytes connect data
nsdo: nsctxrnk=0
nsevdansw: exit
nttctl: entry
nttctl: Clearing non-blocking mode
nsevwait: event is 0x20, on 2
nsevwait: 1 posted event(s)
nsglhe: entry
nsglfc: Assume establishing a connection: look for SID
nsglfc: command = establish
nttaddr2bnd: entry
nttaddr2bnd: exit
nsdo: cid=2, opcode=67, *bl=91, *what=10, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4204, mvd=0
nsdo: gtn=238, gtc=238, ptn=10, ptc=8163
nscon: sending NSPTRF packet
nspsend: plen=103, type=4
nttwr: entry
nttwr: socket 356 had bytes written=103
nttwr: exit
nspsend: 103 bytes to transport
nsdo: nsctxrnk=0
nstimarmed: no timer allocated
nsdo: cid=2, opcode=66, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4200, mvd=0
nsevunreg: cid=2, sgt=0, rdm=0
nsevunreg: 1 registered connection(s)
nsdo: nsctxrnk=0
nsclose: closing transport
nttdisc: entry
nttdisc: Closed socket 356
nttdisc: exit
nsclose: global context check-out (from slot 2) complete
nsmfr: 1712 bytes at 0x13326b8
nsmfr: 420 bytes at 0x12db588
nsglecmd: Deallocating cxd 0x12db2b0.
tnslsnr: entry
tnslsnr: entry
nttaddr2bnd: entry
nttaddr2bnd: exit
tnslsnr: connect string inst->lcxd[0]: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.3)(PORT=1521))
tnslsnr: exit
nsglhe: exit
nsevwait: 1 registered connection(s)
nsevwait: 0 added to NT list for 0x8
nsevwait: 0 pre-posted event(s)
nsevwait: waiting for transport event (0 thru 0)...
ntctst: size of NTTEST list is 1 - not calling poll