| need ideas on troubleshooting connection problem [message #113254] |
Thu, 31 March 2005 19:11  |
 |
psteve
Messages: 9
Registered: March 2005
Location: New England
|
Junior Member |
|
|
HI, any help is greatly appreciated.
I have a development environment with 9i forms and reports on one machine and a 9.1 database on another. (both Windows)
I installed 10g alongside the 9i on the database machine for evaluation several months ago.
Recently, I wanted to create a new 9i db, but the 10g was interfering, and the 9i configuration assistant died without ever opening a window. So I decided to just go with 10g. I had no trouble making several 10G databases.
But I cannot get forms to connect to any of them. 9i is on 1521 only and 10G is on 1526 only. Windows services shows that both listeners are running.
I configured TNSNAMES.ora on the development machine and tnsping sees all the 9i and 10g databases just fine. I even get 0 msec and 10 msec response times. Tnsping prints the names of the files it is using for configuration, and they are the right ones ( the ones in the 9iDS hierarchy---the development machine has an old 8.1.7 db on it, but I don't think that is an issue.)
All the 9i and 10g databases are up and accessible from SQL plus running on the database machine.
But on the client machine, neither forms, reports, SQL Plus, nor a development tool I use can connect to the 10g databases. They can all connect to the 9i databases. Attempts to connect to the 10G databases always timeout. Since tnsping is working, I am stumped.
What should I be trying to troubleshoot this problem?
|
|
|
|
|
|
|
|
|
|
| Re: need ideas on troubleshooting connection problem [message #113362 is a reply to message #113349] |
Fri, 01 April 2005 11:25  |
|
psteve
Messages: 9
Registered: March 2005
Location: New England
|
Junior Member |
|
|
Thanks again,
>>Please look into sqlnet.log in the clientside.
>>post the relevant contents.
>>also sqlnet.ora/listener.ora/tnsnames.ora.
First, the sqlnet.log client side was missing.
After adding logging directory and file to sqlnet.ora, it does log, but it was intermittent. Sometimes the connections attempts make entries in the log and sometimes they do not. I attributed that to the 8.1.7 database on the client. I removed that installation completely, but that did not solve the problem.
Here is the log generated by one attempt to connect from within the report builder (it created three entries):
***********************************************************************
Fatal NI connect error 12535, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=152.122.10.89)(PORT=1526))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=hoss)(CID=(PROGRAM= C:\oracle\oraDS\bin\rwbuilder.exe)(HOST=AVIS01)(USER=pax))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.0.1.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.0.1.3.0 - Production
Time: 01-APR-2005 10:52:03
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\oracle\oraDS\bin\rwbuilder.exe)(HOST=AVIS01)(USER=pax))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.0.1.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.0.1.3.0 - Production
Time: 01-APR-2005 10:52:03
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\oracle\oraDS\bin\rwbuilder.exe)(HOST=AVIS01)(USER=pax))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.0.1.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.0.1.3.0 - Production
Time: 01-APR-2005 10:52:03
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 2
nt OS err code: 0
Here is tnsnames.ora/sqlnet.ora There is no listener.ora on the client
# TNSNAMES.ORA Network Configuration File: C:\oracle\oraDS\network\admin\tnsnames.ora
# Generated by Oracle configuration tools. (HOSS only, the others were manually created.)
HOSS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.122.10.89)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = hoss)
)
)
ITIMS01.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.122.10.89)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = itims01.zz)
)
)
AVIS.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.122.12.179)(PORT = 1521))
)
(CONNECT_DATA =
(SID = AVIS)
)
)
HOSS.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.122.10.89)(PORT = 1526))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hoss)
)
)
IDEV.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.122.10.89)(PORT = 1521))
)
(CONNECT_DATA =
(SID = IDEV)
)
)
# SAP 24-Mar-2005
# SQLNET.ORA Network Configuration File: C:\oracle\oraDS\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.
LOG_FILE_CLIENT = sqlnet.log
LOG_DIRECTORY_CLIENT = c:\temp
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
#NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
>>is there any sqlnet tracing enabled?
>>did you cross check the severside configs
... Yes all databases are up and accessible from SQLPlus on the server
>>In the server machine, use 9i as a client to talk to 10g ( both databases are local. )
I needed to add TNSnames.ora entries, but yes 9i SQLPlus on the server can connect to the 10G databases
|
|
|
|
|
|
|
|
|
|
| Re: need ideas on troubleshooting connection problem [message #234445 is a reply to message #113385] |
Tue, 01 May 2007 11:26 |
iahmed@apqc.org
Messages: 2
Registered: March 2007
Location: Houston, TX
|
Junior Member |
|
|
Seems like I am having similiar issues with connectivity. When I try to use teh ODBC datasource by trying to connect MSACCESS to Oracle 10g it gives me the follwoing errors in sqlnet.ora .
Teh firewall setting you mentioned is it on teh server or shoudl I talk to teh network admin guy ??? I appreciate your response, thanks in advance.
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE)(HOST=D620XP04)(USER=iahmed))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 01-MAY-2007 10:47:53
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
ns secondary err code: 0
nt main err code: 530
TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS
nt secondary err code: 126
nt OS err code: 0
|
|
|
|
|
|
| Re: need ideas on troubleshooting connection problem [message #355842 is a reply to message #234452] |
Mon, 27 October 2008 23:25 |
altafhk
Messages: 45
Registered: June 2007
Location: Islamabad
|
Member |
|
|
I have the same problem with listener.
LSNRCTL> status
Message 1053 not found; No message file for product=network, facility=TNS...
We are using Oracle 10.2.0.1 RAC on Redhat Linux. The system shows all variables and CRS services fine. In fact, we have been using the system for 2 years.
[oracle@acmds2 bin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....db1.srv application ONLINE ONLINE acmds1
ora....db2.srv application ONLINE ONLINE acmds2
ora....cmdb.cs application ONLINE ONLINE acmds1
ora....b1.inst application ONLINE ONLINE acmds1
ora....b2.inst application ONLINE ONLINE acmds2
ora.acmdb.db application ONLINE ONLINE acmds2
ora....S1.lsnr application ONLINE ONLINE acmds1
ora.acmds1.gsd application ONLINE ONLINE acmds1
ora.acmds1.ons application ONLINE ONLINE acmds1
ora.acmds1.vip application ONLINE ONLINE acmds1
ora....S2.lsnr application ONLINE ONLINE acmds2
ora.acmds2.gsd application ONLINE ONLINE acmds2
ora.acmds2.ons application ONLINE ONLINE acmds2
ora.acmds2.vip application ONLINE ONLINE acmds2
We have hardware level firewall, whereas OS services show:
Firewall is stopped.
We cannot connect with SQL Plus locally on Node1; the system shows error:
ORA-01031: insufficient privileges
The listener of Node2 is available to connect applications with Node1 and Node2. If Node2 goes down, then the system would be down although we have clustering environment. How can I resolve the issue?
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
