OraFAQ Forum: Networking and Gateways » Remote Connection Problem

Home » RDBMS Server » Networking and Gateways » Remote Connection Problem (Oracle 11gR2(11.2.0.4.0) Linux Red Hat)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Remote Connection Problem [message #673625]

Tue, 27 November 2018 23:41

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 4952 times)

Report message to a moderator

Re: Remote Connection Problem [message #673629 is a reply to message #673625]

Wed, 28 November 2018 00:53

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Remote Connection Problem [message #673632 is a reply to message #673629]

Wed, 28 November 2018 01:26

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?

Report message to a moderator