Home » RDBMS Server » Server Administration » Shutdown Oracle Database10g!
Shutdown Oracle Database10g! [message #187390] Sun, 13 August 2006 04:35 Go to next message
ivanhou82
Messages: 2
Registered: August 2006
Junior Member
Hello!

I am new to ORACLE. Please, help me! I have installed Oracle Database10g Personal Edition and now my computer is running very slowly. I want to be able to stop the database (as to free resources)and start it at any time. But I can't stop it. When I log online as SYS with SYSDBA privileges and try to shutdown, it asks me for the host and database credentials. In the Preferences I set all of them with username SYS and same password (not SYS). But when I test, it writes that SYS should log on as SYSDBA (although I've logged as SYSDBA) and also the shutdown operation fails. So how can I easily stop this database?


Thank You very much!
Re: Shutdown Oracle Database10g! [message #187399 is a reply to message #187390] Sun, 13 August 2006 09:46 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
You can turn down the services in your control panel.That would free all your resources.
Re: Shutdown Oracle Database10g! [message #187401 is a reply to message #187399] Sun, 13 August 2006 10:45 Go to previous messageGo to next message
ivanhou82
Messages: 2
Registered: August 2006
Junior Member
Thank you! But how can I stop and start it normally using the database tools?
Re: Shutdown Oracle Database10g! [message #187402 is a reply to message #187390] Sun, 13 August 2006 10:52 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
shutdown normal
shutdown immediate
shutdown transactional

So many options ...
Re: Shutdown Oracle Database10g! [message #187409 is a reply to message #187402] Sun, 13 August 2006 14:52 Go to previous message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, you only *think* that you've logged in as SYSDBA (because SYS is a SYSDBA). Well, that's not enough - you have to tell that to Oracle. See this example; perhaps it'll be helpful.
C:\>sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Ned Kol 13 21:51:23 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown normal
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>


Previous Topic: error while starting setup.exe
Next Topic: Slight confusion regarding files
Goto Forum:
  


Current Time: Tue Dec 06 13:57:26 CST 2016

Total time taken to generate the page: 0.05242 seconds