Re: How to shut down in Oracle 8.1.6 instance in Multi-threaded configureation with Normal mode?

Sorry to be a pain, and not (apparently) answer your question, but:

1. Shutdown Normal will not kick Users off the system, but will wait (for ever, if need be) until they all log out themselves. Therefore...
2. How many Users are attached to your database when you issue the Shutdown Normal command?
3. And do they all dutifully log off when requested?
4. And if they don't, have you tried a select * from v$session, followed by a swift alter system kill session <sid>, <serial#>
5. And have you then been patient, whilst Oracle negotiates the shutdown with the Listener and Intelligent Agent?

The point being is that the shutdown commands don't suddenly change meaning just because you have Multi-threaded Server.

The other point being that there is no rule in the Oracle Universe that says 14 Users=Dedicated and 16 Users=MTS -the configuration of the database is entirely up to you, always. I've seen a 100-Concurrent User database configured as Dedicated Server -on the grounds that there was plenty of RAM, and 100 PGAs floating around the place wasn't going to be an issue. I dare say the wizards will make this sort of choice for you, on the reasonable grounds that multiple Users is always a candidate for MTS -but wizards can be told not to be so daft (and if they can't then it's a daft wizard, and you'd best return to the CLI pronto).

The only other point I'd make is that in 8.1.5, MTS was a bugger to set up: one extra space in the listener.ora or the tnsnames.ora, and the damned thing would fail to work. In 8.1.6, this is supposedly not the issue it was -but I still wouldn't say that MTS was exactly trivial to configure. Dodgy configurations might make for dodgy shutdowns... but I'll still place bets on Users still working in the system preventing the shutdown from taking effect.

Regards
HJR "Zhenming" <zmwang_at_maloca.com> wrote in message news:29tb6.304$0T2.23276447_at_nr1.ottawa.istar.net...
> After installation Oracle 8.1.6 on NT and created a database with Oracle
> Database Assistant Configuration, I find I cannot shut down a database
 with
> Shutdown normal either with Server Manager or Instance Manager without any
> other user connected. I remember when I created the database, I chose a
 100
> concurrent users, while Oracle's default is 15. if more than 15 users were
> chosed, Oracle will configured the database in Multi-threaded
 configuration,
> instead of dedicated server. If in this case, how can I use dedicated
 login
> to shutdown the database in Normal mode? Any help will be appreciated.
>
> Zhen
>
>
Received on Tue Jan 23 2001 - 23:20:03 CST