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  |
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 |
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sat May 03 17:35:06 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
