Cannont connect to database in dedicated server mode
565285Mar 6 2007 — edited Mar 7 2007Dear community,
I can connect to a database if i've the following entry in my tnsnames.ora (client) using SQLPlus "sqlplus user/password@orcl"
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SERVER = SHARED)
)
)
Changing the entry to
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SERVER = DEDICATED)
)
)
Has the effect that sqlplus seems to hang. Only CTRL+C brings me back to the command prompt.
I enabled tracing on the Server an got the following (many lines deleted, i hope no important ones):
[...]
[02-MAR-2007 18:12:37:664] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[02-MAR-2007 18:12:37:664] nsopen: unable to open transport
[02-MAR-2007 18:12:37:664] nsmfr: 1644 bytes at 0xf6beaf8
[02-MAR-2007 18:12:37:664] nsmfr: 736 bytes at 0xf6be808
[02-MAR-2007 18:12:37:664] nsinh_hoff: unable to open connection
[...]
Using net8 on server-side has the same results. Connection by "sqlplus / as sysdba" runs.
I've no idea why it works no more. has anybody else an idea where to look?
In the following you can find some more Information which could be important to solve the problem.
Additional Information:
lsnrctl services gives the following output:
[...]
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 2 handler(s) for this service...
Handler(s):
"D000" established:3599 refused:0 current:91 max:1002 state:ready
DISPATCHER <machine: dbhost, pid: 1976>
(ADDRESS=(PROTOCOL=tcp)(HOST=dbhost.domain)(PORT=1092))
"DEDICATED" established:15 refused:0 state:ready
LOCAL SERVER
[...]
There are no changes on server side.
Environment:
Windows 2000 Server
Oracle Enterpise Edition 10.2.0.1
Kind regards
Torsten Schlüter