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

Sybrand Bakker wrote:

> 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?
> >

I found the solution. I just created a special service name on the server that enforces the dedicated server connection. Once I did that the problem was solved. Received on Thu Sep 07 2000 - 19:43:00 CDT