ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

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

  1. #1
    Join Date
    Jan 2002
    Posts
    96

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

    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!

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    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.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Jan 2002
    Posts
    96
    # 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!!!!

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    What is your Global Database name in Listener.ORA?
    It should be DEV.ZA.TISCALI.COM

    Turn on logging and tell us the result !
    Last edited by Raminder; 11-19-2002 at 09:07 AM.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Jan 2002
    Posts
    96
    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

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    Use the net8 utility on the client to configure it there and test it from the net8 utility.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    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
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  8. #8
    Join Date
    Jan 2002
    Posts
    96
    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

  9. #9
    Join Date
    Jan 2002
    Posts
    96
    That is one of the clients that's trying to connect using a 9i client

  10. #10
    Join Date
    Jan 2002
    Posts
    96
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width