Hi everybody,
i'm using XE 10g for more than 1 year. There wasnt any problem on Win Xp. I could connect without any troubles to XE via TOAD. I've got new laptop with Win 7 Home Premium. Installed XE 10g, and can use through IE and sqlplus CLI. But cant connect via TOAD.
I set up setting on TOAD and clicked connect and got error:
[error screen from TOAD|[URL=http://img132.imageshack.us/i/77701405.jpg/]
]
my tnsname.ora has these strings:
XE=
+(DESCRIPTION=+
+(ADDRESS= (PROTOCOL = TCP)(HOST = rustam)(PORT = 1521)+
+)+
+(CONNECT_DATA=+
+(SERVICE_NAME = XE)+
+)+
+)+
i checked tnsping, and here is result of this command:
C:\Users\Rustam>tnsping rustam
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-APR-2
+010 21:20:32+
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTO
COL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (0 msec)
listener.ora has these strings:
XE =
+(DESCRIPTION_LIST =+
+(DESCRIPTION =+
+(ADDRESS = (PROTOCOL = TCP)(HOST = rustam)(PORT = 1521))+
+)+
+)+
LISTENER =
+(DESCRIPTION_LIST =+
+(DESCRIPTION =+
+(ADDRESS = (PROTOCOL = TCP)(HOST = rustam)(PORT = 1521))+
+)+
+)+
and result of lsnrctl status is:
C:\Users\Rustam>lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 20-APR-2010 21:32
+:08+
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 20-APR-2010 20:52:05
Uptime 0 days 0 hr. 40 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
+(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))+
+(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rustam)(PORT=1521)))+
+(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rustam)(PORT=8080))(Presentation=HTT+
P)(Session=RAW))
Services Summary...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
So i have some question
1. why during tnsping i use default tnsnames.ora file where all settings by default?
2. my win 7 is 64 bit, but tnsping and lsnrctl says for 32 bit..
regards and thanks,
rustam