Re: SVRMGR on the way out?

From: David Van Zandt <dvanzandt_at_iquest.net>
Date: Mon, 16 Jul 2001 13:24:44 -0500
Message-ID: <5kG47.414$uD5.226417@news1.iquest.net>

I cannot vouch for your sources nor interpretation. Nor can I see what this complaint is meant to accomplish.
However, I have a hunch that if you re-read the release notes from OTN, IOUG, or METALINK, you may find the replacement syntax to be "connect sys as sysdba". Again, just a hunch.

Hope this helps in some way....

"Alanoly J. Andrews" <alanolya_at_invera.com> wrote in message news:e76061b9.0107160726.4ebc483b_at_posting.google.com...
> I've heard in this NG that Oracle 9i does away with "internal" and also
> the utility SVRMGR. All functions of SVRMGR are reportedly available in
> SQLPLUS. I know of at least one function which SVRMGR can do and SQLPLUS
> cannot (in Oracle 8i), ie to connect to an Oracle Instance which for some
> reason is in a "permanent" shutdown state. You can mimic this by starting
> the shutdown command and doing an interrupt (^C) before the shutdown
> completes. If you then quit from SQLPLUS or SVRMGR, you cannot re-connect
> with SQLPLUS. You will get a message saying that no connections are
allowed.
> But you CAN re-connect by doing SVRMGRL and "connect internal". You can
> then do "shutdown abort" and complete the shutdown process.
>
> Possibly there are some other such differences, too.
> I hope 9i has truly preserved all of SVRMGR's and INTERNAL's capabilities.
>
> Alanoly Andrews.
Received on Mon Jul 16 2001 - 13:24:44 CDT