Can any other user apart from internal who can shutdown and startup the database.
What should be the privileges given to the user.
Printable View
Can any other user apart from internal who can shutdown and startup the database.
What should be the privileges given to the user.
The user who had the dba privileges can shut/start up the database. The dba/osdba group person will also be able to do the following.
user as dba
user as osdba
Sam
No I am not able to shutdown/startup the database even after giving the role of dba to a user. Can you give the sequence of how to go about...?
what are your current privileges on the system. To startup or shut down the database you should belong to sysdba/dba group on the system.
If you are not in the groups, add your system loging name into one of these groups and follow the following commands:
NOTE: if you know the sys password then you could do it as shown below.
$ svrmgrl
SVRMGR> connect sys@<SID> as sysdba
connected
SVRMGRL>startup pfile=$ORACLE_BASE/admin/<SID>/pfile/init<SID>.ora
This should do the work.
Sam
Connect internal and grant sysdba to anyuser that you want to use for startup/shutdown.
Cheers,
Vinod Kumar.
Sembavan ... Thanks a lot it worked