| shutdown of database [message #64490] |
Wed, 02 February 2005 01:50  |
sharad
Messages: 6
Registered: January 2002
|
Junior Member |
|
|
i am not able to shutdown the database when i am log in as system. error message says in sufficent privalege.
pl help
sharad
|
|
|
|
| Re: shutdown of database [message #64491 is a reply to message #64490] |
Wed, 02 February 2005 02:53  |
Sreedhar Reddy
Messages: 55
Registered: January 2002
|
Member |
|
|
Pleae tell me what verison you are using.
are you trying to shutdown or trying to login.
If you want to shut down log in as sys as sysdba.
and try shuting down.
grant connect,resoure to the user...which you are loging on.
|
|
|
|
| Re: shutdown of database [message #109418 is a reply to message #64490] |
Thu, 24 February 2005 09:36 |
dbalaji_oracle
Messages: 4
Registered: February 2005
|
Junior Member |
|
|
if you are connecting to a version lowe rthan 8i then u can connec t as internal at the sql prompt and use the shutdown immdeiate command
if 8i/9i and above then
SQL>conn sys as sysdba ;
SQL> shutdown immediate ;
or grant sysdba privilige to any user
then log on as the user as sysdba
then try shutdown
hipe this works
with regards
DBAlaji
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
