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!
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.
# 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!!!!
What is your Global Database name in Listener.ORA?
It should be DEV.ZA.TISCALI.COM
Turn on logging and tell us the result !
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
Use the net8 utility on the client to configure it there and test it from the net8 utility.
Quote:
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
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
That is one of the clients that's trying to connect using a 9i client
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
This is becoming kinda urgent, my box has been down for 3 days!
Please help!
Check the sqlnet.ora file for names.default_domain. If that entry is present (company.com, for example), then your tnsnames.ora entry must be cimdb.company.com, not just cimdb.
My guess is that your setting is ZA.TISCALI.COM, which is why a connection to DEV.ZA.TISCALI.COM would work, but one to CIMDB.ZA.TISCALI.COM would not because all you have is CIMDB in the tnsnames.ora file. Plain and simple, that's what it is.
Why dont you open a tar with Oracle if you need urgent help?