Want to connect Oracle 11g from SQL Navigator on Windows
521639Apr 3 2009 — edited Apr 7 2009Hi brothers,
I'm a new ora man, and having a issue need your help.
I installed Ora 11g on linux (Ubuntu 8.10) and SQL Navigator 11g on WindowsXP. Now, I want to use SQL Navigtor to connect database server. I tried many times but it still fails with me. I read some articles on Internet but they were not useful to me.
Here is some information about my system.
Linux : 192.168.0.82
Windows : 192.168.0.230
(+I can ping from Windows to Linux+)
$ lsnrctl stat
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 03-APR-2009 16:18:15
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 03-APR-2009 08:33:41
Uptime 0 days 7 hr. 44 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/kimngoc-desktop/listener/alert/log.xml
Listening Endpoints Summary...
+(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kimngoc-desktop)(PORT=1521)))+
Services Summary...
Service "intrepid" has 1 instance(s).
Instance "intrepid", status READY, has 1 handler(s) for this service...
Service "intrepidXDB" has 1 instance(s).
Instance "intrepid", status READY, has 1 handler(s) for this service...
Service "intrepid_XPT" has 1 instance(s).
Instance "intrepid", status READY, has 1 handler(s) for this service...
The command completed successfully
$ps -afe | grep -i listener
oracle 5383 1 0 08:33 ? 00:00:00 /u01/app/oracle/product/11.1.0/orasample/bin/tnslsnr LISTENER -inherit
oracle 19705 6600 0 16:23 pts/0 00:00:00 grep -i listener
Pls help solve this problem if you can.