Hi,

I am new to Oracle and wonder someone may help for the question.

In Oracle Database Concepts 10g Release, it said one can close a
database; unmount the database; and shutdown the database. What is
procedure to close and unmount a database?

Secondly what is best way to shutdown a database. In Windows, it seems
one of following: 1) SQL>shutdown normal 2) end three processes in
service of Control Panel. shutdown button from OEM doesn't work.

Your help will be appreciated,
-Hong

Hong Hsu wrote:

You are trying far too hard. Just turn off the machine.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Thanks Mr. Morgan.

I was afraid of shutdown database rudely.


DA Morgan wrote:

Hong Hsu wrote:
They are rarely, if ever, offended.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Best method for shutting down an Oracle server is "Shutdown normal". That
will quiese the database and perform an orderly termination.

If you simply shut down the machine, that is, terminate the process(es) the
database will have to undergo soft recovery when you start the server again.

"Hong Hsu" <honghsu (AT) comcast (DOT) net> wrote

sed wrote:

Of course it will do that anyway and of course it will take a few
seconds. But if that's important to you go for it. Sounds like nothing
but a waste of time to me.

PS: If any connection is logged on, an AQ or other process for example,
it will never shut down based on using NORMAL.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

When I issue 'shutdown normal' through SQL*Plus, it displays error:
ORA-01031: insufficient privileges. I use system or sys as user name
of SQL*Plus on Windows XP. Both have same error. No other Oracle
clients are connected to the server.

What is wrong here?
-Hong

DA Morgan wrote:

Hong Hsu wrote:

1) Open "Control Panel"
2) Click on "Scheduled Tasks"
3) On the toolbar, click on "Advanced"
4) Click on "AT Service Account"
5) Choose "This Account:"
6) Specify a Windows account name and password that is part of the
ORA_DBA or ORA_<SID>_DBA group
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Mr. Morgan,

I still have difficult to issue 'shutdown normal' after following your
instruction. I think the issue might be related to Wrong password for
user. Here is what it related:

After I login OEM using sys as user name and Connect As SYSDBA, I try to
enter Host Credentials and Database Credentials in order to shutdown
instance by clicking shutdown button. For Host Credential, I use user
name and password I used for login Windows XP where Oracle 10g is
running. For Database Credential, user name and password are the one I
used to login OEM. The Error Message is the same error:
RemoteOperationException: Wrong Password for user.

the database config is not right, but I don't know where exactly is
wrong. Thanks for your timing.
-Hong


DA Morgan wrote:

Hong Hsu wrote:

What documentation have you read?
And quite frankly why are you trying to do this at all?
It is completely unnecessary and serves no real purpose.

But the simple solution is to make your O/S user a member
of the ORA_DBA group.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)