Re: ORA-0106 - Cannot shutdown database....

Two methods to resolve this:

edit your *own local* sqlnet.ora (unless you are on the server of course) create a new entry and add (server=dedicated) after (port=<number>)

Hth,

Sybrand Bakker, Oracle DBA

"Walter T Rejuney" <BlueSax_at_Unforgetable.com> wrote in message news:39B6E288.7F7752AA_at_Unforgetable.com...
> I have a database configured to use shared servers. When I try to shut
> down the database using Enterprise Manager (running on the same machine
> as the database) I receive an ORA-106 message. I went to MetaLink and
> found that the problem is that I need to be connected via a dedicated
> server and that the way to enforce this is via sqlnet.ora using the
> parameter USE_DEDICATED_SERVER=ON. I'm wondering though - since
> sqlnet.ora on the server is read on the server side when the listener is
> turned on would this also affect other clients that make connections? Is
> there some alternative way to make a unique tnsnames.ora entry that I
> can use solely when I want to shut down the database?
>
Received on Wed Sep 06 2000 - 23:51:24 CDT