Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle access on a home LAN

911413Jan 16 2012 — edited Jan 17 2012
I am attempting to access oracle on a home LAN. I can ping the machine which hosts the database (10.1.1.3), but any attempt to make a database connection from my local host (10.1.1.0) has failed. SQL developer reports "the network adapter could not establish a test connection". I'm accessing the server's oracle listener port (1521). Google chrome can't open "//localserver:5500/em" either. I have set up instant client on the local host.

environment variables (localhost is 10.1.1.0)

ORACLE_HOME = F:\app\Roger\product\11.2.0\client_1
ORACLE_SID = orcl

tnsnames.ora on local host

<data source alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

I can map network drives on the oracle server (10.1.1.3) from the local host and all machines on the LAN can access the internet through the gateway on the proxy server (10.1.1.1). Of course Oracle is fully functional on 10.1.1.3 itself.

Is a firewall blocking access or is there something else preventing database access from my localhost? The local host has XP service pack 2. The proxy server has Norton antivirus installed, but I don't think I use the gateway for anything other than internet access. The local host has spyware doctor installed, but I still have problems even if I disable the spyware service. I'm getting the impression Oracle is far easier to administer on any operating system other than windows.

Any suggestions appreciated.

/////////////////////////////////////////////////////////////////////

basic LAN config (all machines run windows XP):

local host machine
static IP = 10.1.1.0
-----------------------------------------
Proxy internet server machine

static gateway IP = 10.1.1.1 (LAN card 1)
Internet IP is dynamic and is shared. (LAN card 2)
-----------------------------------------
Oracle server machine

static IP = 10.1.1.3

The DNS for all static addresses is 192.168.0.1
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2012
Added on Jan 16 2012
6 comments
2,144 views