Oracle DBA

Video Tutorial – Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS June 27, 2011

Filed under: DBA,Oracle — gaphydba @ 11:26 am

Oracle Grid Control managing  lots of databases and application servers  It can manage multiple instances of Oracle deployment  platform.Click here for the video tutorial of how to install Oracle 10gR2 Grid Control.

 

SYSDBA v/s SYSOPER July 20, 2010

Filed under: DBA,Oracle — gaphydba @ 6:16 am

SYSDBA and SYSOPER are administrative privileges required to perform high-level administrative operations such as creating, starting up, shutting down, backing up, or recovering the database. The SYSDBA system privilege is for fully empowered database administrators  the highest system privilege in oracle  But SYSOPER system privilege is limited than SYSDBA. SYSOPER system privilege allows a user to perform basic operational tasks, but without the ability to look at user data.

In the following section, the following listed the operation that a user can perform who is authenticated as SYSDBA and SYSOPER system privilege.

SYSDBA:
• Perform STARTUP and SHUTDOWN operations
• ALTER DATABASE: open, mount, back up, or change character set
• CREATE DATABASE
• DROP DATABASE
• CREATE SPFILE
• ALTER DATABASE ARCHIVELOG
• ALTER DATABASE RECOVER
• Includes the RESTRICTED SESSION privilege
• Allows a user to connect as user SYS.

SYSOPER
• Perform STARTUP and SHUTDOWN operations
• CREATE SPFILE
• ALTER DATABASE OPEN/MOUNT/BACKUP
• ALTER DATABASE ARCHIVELOG
• ALTER DATABASE RECOVER (Complete recovery only. Any form of incomplete recovery, such as UNTIL TIME|CHANGE|CANCEL|CONTROLFILE requires connecting as SYSDBA.)
• Includes the RESTRICTED SESSION privilege
• Allows a user to perform basic operational tasks, but without the ability to look at user data