Failure to connect to my Oracle Database
IonutCApr 21 2012 — edited Apr 21 2012Hi guys,
I installed Oracle db Enterprise 11gR2 on a linux machine running CentOS 6.2.
It installed succesfully.
I configured the listener on the linux, i created a database, i started an instance, etc.. you can see the output of the lsnrctl status command :
+[oracle@r3tard ~]$ lsnrctl status+
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 21-APR-2012 10:29:04
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 21-APR-2012 10:28:05
Uptime 0 days 0 hr. 0 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /home/oracle/app/oracle/diag/tnslsnr/r3tard/listener/alert/log.xml
Listening Endpoints Summary...
+(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=r3tard)(PORT=1521)))+
Services Summary...
Service "mydb" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
Service "mydbXDB" has 1 instance(s).
Instance "mydb", status READY, has 1 handler(s) for this service...
The command completed successfully
Now i try to connect from a windows machine, i installed Oracle Client, configured tnsnames.ora but it seems that my connection times up. All the firewalls are disabled, and since is my home network there is no other packet filtering.
Can someone give me a hint ? I'm a beginner in all this oracle thing and maybe i did something wrong...
Here you have listener.ora from the linux machine and tnsnames.ora from the windows machine :
listener.ora*
+# listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora+
+# Generated by Oracle configuration tools.+
LISTENER =
+(DESCRIPTION_LIST =+
+(DESCRIPTION =+
+(ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT = 1521))+
+)+
+)+
ADR_BASE_LISTENER = /home/oracle/app/oracle
tnsnames.ora*
+# tnsnames.ora Network Configuration File: C:\Users\Sharky\Documents\product\11.2.0\client_1\network\admin\tnsnames.ora+
+# Generated by Oracle configuration tools.+
MYDB =
+(DESCRIPTION =+
+(ADDRESS_LIST =+
+(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.104)(PORT = 1521))+
+)+
+(CONNECT_DATA =+
+(SERVICE_NAME = mydb)+
+)+
+)+
Thanks in advance!!