Remote database Administration in oracle

We can remotely administer oracle database using such as Enterprise Manager grid control and SQL*PLUS, a client command-line tool.

To allow users to remotely administer and specifically to shutdown and restart a database, The database should be configured to allow remote connections by privileged users.

Here are some of the configurations that should be made on the database:

• The Remote_login_passwordfile parameter  should be set to EXCLUSIVE on the SPFILESID.ora or initSID.ora initialization parameter files either using Alter system  command on SQL*PLUS or by simply adding the parameter on initSID.ora initialization parameter file and recreate SPFILESID.ora from pfile to reflect the changes.
• Password file should created and users must be added to the file.
• grant SYSDBA privilege to the users that are added to the password file.