| 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 |
|
|
|
|
|
| Re: No Connection when specifying database name [message #466875 is a reply to message #466868] |
Wed, 21 July 2010 09:58  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
