Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannont connect to database in dedicated server mode

565285Mar 6 2007 — edited Mar 7 2007
Dear 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2007
Added on Mar 6 2007
7 comments
893 views