-
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
-
yet no mention of the error
-
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
-
your tnsnames file is wrong then, try deleting your sqlnet.ora
-
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:
-
what service_names is you listener listening for
-
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.
-
Any ideas how to troubleshoot this?
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|