Home » Infrastructure » Windows » No Connection when specifying database name (Oracle Embedded, 9.2.0.4.0, Windows Server 2003 64bit)
No Connection when specifying database name [message #466846] Wed, 21 July 2010 08:46 Go to next message
EnterTheUser
Messages: 2
Registered: July 2010
Junior Member
Hi all,

I recently posted this problem in the Oracle forums, but couldn't get a solution. Hoping someone here might have an idea.

I have an issue with an Oracle 9 database where I can connect if I do not specify a database to connect to but when i do specify one i get an error.

For example, my database is called WEB. If i open sqlplus and type connect username/password it will connect fine. If I type connect username/password@web I get an error.
The full error that appears in the log is:

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error

I have checked the tns entries and listener file and both are fine. Here are the entries:
TNSNAMES:

WEB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = web)
)
)

LISTENER:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\OraHome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ANY")
)
(SID_DESC =
(GLOBAL_DBNAME = web)
(ORACLE_HOME = D:\OraHome_1)
(SID_NAME = web)
)
)

This is on a Windows 64 bit machine (server 2003 64bit). It is a new Oracle install. It worked fine until the machine was rebooted remotely.

Here is a list of other things I have tried:
• Checked permissions on folders for SYSTEM user and Administrator.
• Added the USE_SHARED_SOCKET entry to the registry.
• Deleted and recreated the WEB database.
• Uninstalled and reinstalled Oracle.
• Created a second database to connect to.
• Modified the TNS listener to use localhost, computer name and IP address.
• Tried setting SQL Authentication services to NONE and NTS.
• Make sure all the services are started by local system account.

Any help would be appreciated.

[Updated on: Wed, 21 July 2010 08:48]

Report message to a moderator

Re: No Connection when specifying database name [message #466868 is a reply to message #466846] Wed, 21 July 2010 09:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error

Check disk (have a look at event log)
Check permission of user that starts the listener (which one is it?)

Regards
Michel
Re: No Connection when specifying database name [message #466875 is a reply to message #466868] Wed, 21 July 2010 09:58 Go to previous messageGo to next message
EnterTheUser
Messages: 2
Registered: July 2010
Junior Member
I checked the Event Viewer and the only thing there is when the database is started which is fine. The failed connections are not logged there but they are logged by Oracle, which is the error I pasted above.

In the services, it says the listener is started by Local System, if I restart the listener as the user I am logged in as, that user is a member of Administrator and ORA_DBA groups.
Re: No Connection when specifying database name [message #466882 is a reply to message #466875] Wed, 21 July 2010 10:41 Go to previous message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate trace on listener and sqlnet.
http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/lsnrctl.htm#sthref88
http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref592

Regards
Michel
Previous Topic: cpu utilization
Next Topic: How to validate prerequisite for ODP and Oracle Client connection
Goto Forum:
  


Current Time: Thu Dec 02 00:28:27 CST 2021