DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Networking isssues

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Networking isssues

    Connecting from client(unix) to virtual server (NT).

    Checked with firewall team and amended the hosts file. I can ping the server from the client.

    Can't tnsping or sqlplus via the link. I've double checked the settings

    Any ideas?



    Client

    tnsnames.ora

    UTOUAT1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = uatbckuto01)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = UTOUAT1)

    sqlnet.ora

    NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
    names.default_domain=world
    names.default_zone=world

    Server

    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 9.2.0.4.0 - Produc
    tion
    Start Date 22-APR-2008 08:36:44
    Uptime 0 days 0 hr. 0 min. 2 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File c:\oracle\ora92\network\admin\listener.ora
    Listener Log File c:\oracle\ora92\network\log\listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=UATBCKUTO01.domain)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "UTOUAT1" has 1 instance(s).
    Instance "UTOUAT1", status UNKNOWN, has 1 handler(s) for this service...
    Service "UTOUAT2" has 1 instance(s).
    Instance "UTOUAT2", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yet no mention of the error

  3. #3
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    oh yes....

    /u1/app/oracle/product/1.0.2.2.2/network/admin$ tnsping utouat1

    TNS Ping Utility for Solaris: Version 8.1.7.0.0 - Production on 22-APR-2008 09:10:09

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    TNS-03505: Failed to resolve name

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    your tnsnames file is wrong then, try deleting your sqlnet.ora

  5. #5
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    Commented out sqlnet.ora

    /u1/app/oracle/product/1.0.2.2.2/network/admin$ tnsping utouat1

    TNS Ping Utility for Solaris: Version 8.1.7.0.0 - Production on 22-APR-2008 09:23:29

    (c) Copyright 1997 Oracle Corporation. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=uatbckuto01)(PORT=1521))
    OK (30 msec)
    /u1/app/oracle/product/1.0.2.2.2/network/admin$ sqlplus system/password@utouat1

    SQL*Plus: Release 8.1.7.0.0 - Production on Tue Apr 22 09:23:39 2008

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

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


    Enter user-name:

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what service_names is you listener listening for

  7. #7
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = UATBCKUTO01)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = c:\oracle\ora92)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = UTOUAT1)
    (ORACLE_HOME = c:\oracle\ora92)
    (SID_NAME = UTOUAT1)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = UTOUAT2)
    (ORACLE_HOME = c:\oracle\ora92)
    (SID_NAME = UTOUAT2)
    )
    )

    TRACE_LEVEL_LISTENER = ON
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_FILE_LISTENER = C:\oracle\ora92\network\trace\listener.trc

    C:\Documents and Settings\rgaskell>LSNRCTL SERVICES

    LSNRCTL for 32-bit Windows: Version 9.2.0.4.0 - Production on 22-APR-2008 10:23:
    04

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=UATBCKUTO01)(PORT=1521))
    )
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Service "UTOUAT1" has 2 instance(s).
    Instance "UTOUAT1", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Instance "UTOUAT1", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:13 refused:0 state:ready
    LOCAL SERVER
    Service "UTOUAT1XDB" has 1 instance(s).
    Instance "UTOUAT1", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:1002 state:ready
    DISPATCHER
    (ADDRESS=(PROTOCOL=tcp)(HOST=UATBCKUTO01.adcfs.co.uk)(PORT=1076)
    )
    Service "UTOUAT2" has 2 instance(s).
    Instance "UTOUAT2", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0
    LOCAL SERVER
    Instance "UTOUAT2", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:4 refused:0 state:ready
    LOCAL SERVER
    The command completed successfully
    Last edited by rgaskell; 04-22-2008 at 05:25 AM.

  8. #8
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    Any ideas how to troubleshoot this?

  9. #9
    Join Date
    Nov 2001
    Posts
    335
    show parameter services
    show parameter listener

    and post results:
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  10. #10
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    ok sqlplus timing out connecting to the server now

    Hosts file on client(unix):



    10.87.1.92 uatbckuto01








    nsclose: global context check-out (from slot 0) complete

    nscall: connecting...
    nttbnd2addr: port resolved to 1987
    nttbnd2addr: using host IP address: 10.87.8.104
    nsopen: opening transport...
    nttcnp: Validnode Table IN use; err 0x0
    nttcni: trying to connect to socket 11.
    ntt2err: soc 11 error - operation=1, ntresnt[0]=505, ntresnt[1]=145, ntresnt[2]=0
    nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=145, nt[2]=0; ora[0]=0, ra[1]=0, ora[2]=0
    nsopen: unable to open transport
    nioqper: error from nscall
    nioqper: nr err code: 0
    nioqper: ns main err code: 12535
    nioqper: ns (2) err code: 12560
    nioqper: nt main err code: 505
    nioqper: nt (2) err code: 145
    nioqper: nt OS err code: 0
    niqme: reporting NS-12535 error as ORA-12535




    ***********************************************************************

    Fatal NI connect error 12535, connecting to:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.87.1.92)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=UTOUAT1 )(CID=(PROGRAM=)(HO
    ST=CFGDAS)(USER=oracle))))


    VERSION INFORMATION:
    TNS for Solaris: Version 8.1.7.0.0 - Production
    TCP/IP NT Protocol Adapter for Solaris: Version 8.1.7.0.0 - Production
    Time: 23-APR-2008 08:38:24
    Tracing to file: /u1/app/oracle/product/1.0.2.2.2/network/trace/client.trc
    Tns error struct:
    nr err code: 0
    ns main err code: 12535
    TNS-12535: TNSperation timed out
    ns secondary err code: 12560
    nt main err code: 505
    TNS-00505: Operation timed out
    nt secondary err code: 145
    nt OS err code: 0



    hosts file is correct


    Looks like a firewall/NAT issue as its not resolving the correct IP address????

    nsclose: global context check-out (from slot 0) complete

    nscall: connecting...

    nttbnd2addr: port resolved to 1987

    nttbnd2addr: using host IP address: 10.87.8.104

    nsopen: opening transport...

    nttcnp: Validnode Table IN use; err 0x0

    nttcni: trying to connect to socket 11.

    ntt2err: soc 11 error - operation=1, ntresnt[0]=505, ntresnt[1]=145, ntresnt[2]=0

    nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=145, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0

    nsopen: unable to open transport

    nioqper: error from nscall

    nioqper: nr err code: 0

    nioqper: ns main err code: 12535

    nioqper: ns (2) err code: 12560

    nioqper: nt main err code: 505

    nioqper: nt (2) err code: 145

    nioqper: nt OS err code: 0

    niqme: reporting NS-12535 error as ORA-12535

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