| Shutdown Oracle Database10g! [message #187390] |
Sun, 13 August 2006 04:35  |
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 #187409 is a reply to message #187402] |
Sun, 13 August 2006 14:52  |
 |
Littlefoot
Messages: 21818
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>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
