| Local 9.2.0.1 db connection problem [message #67227] |
Thu, 19 February 2004 12:13  |
rericson
Messages: 3
Registered: February 2004
|
Junior Member |
|
|
I'm hoping someone can help with this issue before I wipe Oracle from my laptop and do a clean install. I can not connect to my locally loaded database created on WinXP through tnsnames.ora and listener.ora. The Oracle version I'm using is 9.2.0.1 and I have no problems connecting to remote databases on various servers. I just can't get to my locally created database from windows programs that rely on tnsnames.ora. (I can sql*plus to it from the cmd window). I searched all over the web for hints and nothing has worked so far. If I do a tnsping I get the following (lager is the db name):
C:>tnsping lager
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 19-FEB-2004 17:16:01
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
c:oracleora90networkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (
SID = lager)))
TNS-12541: TNS:no listener
The listener is actually started and works fine with remote databases.
Here's the listener.log with the errors I'm getting:
---------------
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 19-FEB-2004 14:58:38
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
System parameter file is C:oracleora90networkadminlistener.ora
Log messages written to C:oracleora90networkloglistener.log
Trace information written to C:oracleora90networktracelistener.trc
Trace level is currently 4
Started with pid=3156
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Miitek3)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long
|
|
|
|
|
|
| Re: Local 9.2.0.1 db connection problem [message #67230 is a reply to message #67229] |
Mon, 23 February 2004 10:40  |
rericson
Messages: 3
Registered: February 2004
|
Junior Member |
|
|
|
My issue continued to occur after a total re-install of the software; however, I did not totally wipe out all the registry entries this particular time as I've done on numerous other occasions. I'll try the sqlnet.ora and listener.ora suggestions.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
