Home » RDBMS Server » Networking and Gateways » Remote Connection Problem (Oracle 11gR2(11.2.0.4.0) Linux Red Hat)
Remote Connection Problem [message #673625] Tue, 27 November 2018 23:41 Go to next message
mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka
Member
Dear All,
I have created database(11gR2 11.2.0.4.0) in Linux Redhat Linux on VM.
Database is properly functioning on the server(i.e tns is working and listener is functioning properly).
From remote PC ping command successful to server.
In remote PC the tns file is coppied from Server.
But when I ping tns it return following error:

TNS-12535: TNS:operation timed out

How to solve this or which part I check to identify the actual problem.

Your advice will be appreciated.

Regards

Mahmud
  • Attachment: Error.jpg
    (Size: 56.76KB, Downloaded 3735 times)
Re: Remote Connection Problem [message #673629 is a reply to message #673625] Wed, 28 November 2018 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TNS-12535: TNS:operation timed out
 *Cause: The requested operation could not be completed within the time out
 period.
 *Action: Look at the documentation on the secondary errors for possible
 remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
 Turn on tracing to gather more information.


Set your firewall to let Oracle pass through.

Re: Remote Connection Problem [message #673632 is a reply to message #673629] Wed, 28 November 2018 01:26 Go to previous messageGo to next message
mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka
Member
Thanks for your quick reply.

In SQLNET.log I have found the following error:
Wed Nov 28 10:08:59 2018


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

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production
Time: 28-NOV-2018 10:08:59
Tracing not turned on.
Tns error struct:
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
Client address: <unknown>
Wed Nov 28 10:09:41 2018
Directory does not exist for read/write [C:\Oracle\Middleware\Oracle_FRHome4\log] [C:\Oracle\Middleware\Oracle_FRHome4\log\diag]
Wed Nov 28 10:10:14 2018


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

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.1.0.7.0 - Production
Time: 28-NOV-2018 10:10:14
Tracing not turned on.
Tns error struct:
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
Client address: <unknown>
Wed Nov 28 10:37:30 2018
Directory does not exist for read/write [C:\Oracle\Middleware\Oracle_FRHome4\log] [C:\Oracle\Middleware\Oracle_FRHome4\log\diag]

Now What can I do?



Re: Remote Connection Problem [message #673634 is a reply to message #673632] Wed, 28 November 2018 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Make sure that you

Quote:
Set your firewall to let Oracle pass through.

and post (formatted) your connection string and sqlnet.ora and tnsnames.ora.

[Updated on: Wed, 28 November 2018 01:40]

Report message to a moderator

Re: Remote Connection Problem [message #673640 is a reply to message #673634] Wed, 28 November 2018 03:01 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What does the following show?
$ telnet <database_server> 1521
As Michel says, firewall is the most likely culprit.
Re: Remote Connection Problem [message #673646 is a reply to message #673640] Wed, 28 November 2018 04:41 Go to previous messageGo to next message
mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka
Member
Thanks for your cooperation.
I got the solution.

Re: Remote Connection Problem [message #673647 is a reply to message #673646] Wed, 28 November 2018 05:05 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What was it?
Previous Topic: ORA-12514: TNS
Next Topic: Set tnsnames.ora
Goto Forum:
  


Current Time: Thu Mar 28 18:48:40 CDT 2024