Home » RDBMS Server » Networking and Gateways » need ideas on troubleshooting connection problem
need ideas on troubleshooting connection problem [message #113254] Thu, 31 March 2005 19:11 Go to next message
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 #113329 is a reply to message #113254] Fri, 01 April 2005 08:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Tnsping check the availability of listener.
Thats it.
check the sqlnet.ora in the concerned machine and comment out all the entries.

try again
Re: need ideas on troubleshooting connection problem [message #113346 is a reply to message #113329] Fri, 01 April 2005 09:37 Go to previous messageGo to next message
psteve
Messages: 9
Registered: March 2005
Location: New England
Junior Member
Thanks.
Unfortunately, it has not affected the behavior.
Steve
Re: need ideas on troubleshooting connection problem [message #113349 is a reply to message #113346] Fri, 01 April 2005 09:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please look into sqlnet.log in the clientside.
post the relevant contents.
also sqlnet.ora/listener.ora/tnsnames.ora.

is there any sqlnet tracing enabled?
did you cross check the severside configs

( you may have done any of following .if so ignore.)
>>All the 9i and 10g databases are up and accessible from SQL plus running on the database machine.

In the server machine, use 9i as a client to talk to 10g ( both databases are local. )

Re: need ideas on troubleshooting connection problem [message #113362 is a reply to message #113349] Fri, 01 April 2005 11:25 Go to previous messageGo to next message
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 #113363 is a reply to message #113254] Fri, 01 April 2005 11:27 Go to previous messageGo to next message
psteve
Messages: 9
Registered: March 2005
Location: New England
Junior Member
And, sorry, haven't tried tracing yet.
And I am not sure what it means to cross check the server configs.
Re: need ideas on troubleshooting connection problem [message #113382 is a reply to message #113363] Fri, 01 April 2005 13:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. Is there a firewall involved?
there might be a problem with port redirection.
2. a case with syntax erros.
tnsnames.ora entries are extremely sensitive to spaces and formatting.
Just copy/paste these entries and replace with your values.
  connectstring =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxx )(PORT = 1526))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mysid)
    )
  )


icon7.gif  Re: need ideas on troubleshooting connection problem [message #113385 is a reply to message #113382] Fri, 01 April 2005 13:59 Go to previous messageGo to next message
psteve
Messages: 9
Registered: March 2005
Location: New England
Junior Member
There is a firewall.
It shows 1521 nad 1526 open, but when I turn the firewall off it works.

Thank you very much!
Razz Razz Razz Razz Razz
Re: need ideas on troubleshooting connection problem [message #234445 is a reply to message #113385] Tue, 01 May 2007 11:26 Go to previous messageGo to next message
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 #234452 is a reply to message #234445] Tue, 01 May 2007 11:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Search this board for USE_SHARED_SOCKET
Re: need ideas on troubleshooting connection problem [message #355842 is a reply to message #234452] Mon, 27 October 2008 23:25 Go to previous message
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
Previous Topic: Cannot start listener
Next Topic: NetManager Connection Problem
Goto Forum:
  


Current Time: Thu Dec 08 12:37:43 CST 2016

Total time taken to generate the page: 0.09472 seconds