DB Shutdown/Startup

[shrik_m]

Can any other user apart from internal who can shutdown and startup the database.
What should be the privileges given to the user.

[sambavan]

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

[shrik_m]

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...?

[sambavan]

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

[vinodkmg]

Connect internal and grant sysdba to anyuser that you want to use for startup/shutdown.

Cheers,
Vinod Kumar.

[shrik_m]

Sembavan ... Thanks a lot it worked