CODEWITHSUNDEEP
oracle-databaseora-12170
kreamik
kreamik

Reputation: 627

cannot connect to oracle server from another oracle client only computer

I have one machine as webserver and another as oracle server, webserver: - centOS x64 - oracle client installed from http://dony-ramansyah.blogspot.com/2012/02/install-oracle-client-dan-oci8-di.html

oracle server - XP home x32

I cannot connect to oracle server,

Any suggestion?

on my oracle server (centOS)

lsnrctl.exe status :
Security ON: Local OS Authentication
Version: TNSLNR for 32-bit Windows: Version 11.2.0.2.0-Praction

on my oracle client (XP)

#sqlplus64 system/[email protected]/1521:XE :
ERROR: ORA-12170 TNS:Connect timeout occured

I think my oracle server block connection from outer ..

Upvotes: 0

Views: 3014

Answers (2)

Raje
Raje

Reputation: 3333

May be your firewall block your port. you can enable this by changing firewall setting. This is windows 7 configuration to access port Control panel->system and security->windows firewall->advanced setting->In bound rules-> new Rule(On right hand side)-> select port option with value as "1521" -> next next....

Upvotes: 1

Alex Poole
Alex Poole

Reputation: 191335

From comments: Your easy connect string is wrong; it should be @192.168.137.3:1521/XE. Your version is connecting to the default port, 1521, on the server at 192.168.137.3; but will then look for service name 1521:XE instead of just XE.

But since you're still connecting to the same port this shouldn't get an ORA-12170, as the network part is effectively the same. It would expect it to get an ORA-12514: TNS: listener does not currently know of service requested in connect descriptor. Perhaps the Windows version of SQL*Plus behaves slightly differently, though that seems unlikely; the trailing extra space and : in the question causes SQL*Plus to show usage information in Linux.

Upvotes: 1

Related Questions