Oracle DBA

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

 

How to become an Oracle DBA July 19, 2010

Filed under: Uncategorized — gaphydba @ 12:17 pm

I came across a very useful article by Burleson Consulting how to become an Oracle DBA.

Every year, young computer professionals leave the hallowed halls and ivory towers of college and survey the landscape for computer jobs. They look at the salary surveys and drool at the average Oracle DBA salary of $100,000 and the prospect of earning up to $250,000 per year as a production DBA.  Many of them don’t know what a DBA does, but they sure like the money.

Continue