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


 

U.S. government sues Oracle for tens of millions of dollars June 18, 2010

Filed under: Oracle — gaphydba @ 4:37 am

The U.S. government is suing Oracle Corp. for denying it significant discounts on software purchases the vendor routinely gave to its commercial customers. The government is claiming damages as high as $169 million in the Oracle lawsuit.Go and read it

 

SOME Errors in Oracle and their solutions June 10, 2010

Filed under: Errors,IT,Oracle — gaphydba @ 4:20 pm
Tags:

SQL> ORA 12545 Connect failed because target host or object does not exist

Cause: The address specified is not valid, or the program being connected to does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps “oracle” is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.

SQL> ORA-12541: TNS no listener

Cause: Listener for the source repository has not been started.

Action: Start the Listener on the machine where the source repository resides.

manually u cant do by  $ORACLE_HOME/bin/lsnrctl start FOR UNIX IN CASE  ON WINDOWS goto control panel / services
u can see the listenerservice for the sid u have created.
start it!

ORA-01665: controlfile is not a standby controlfile

Then ‘copy’ standby control file to other host and be sure its being used.

1) use an unusual name when you create it
2) verify it is transferred successfully
3) verify it is going in the right location by examining spfilE

4. verify that you are using the control file that you think you created in the alter database command. use the TO ‘c:\somwhere\stdby.ctl’ option of the command.

 

Is IT Suffering from Too Much Specialization? April 12, 2010

Filed under: Uncategorized — gaphydba @ 1:22 pm

Is IT suffering from too much specialization? click here

 

East Africa gets high-speed web July 23, 2009

Filed under: Information technology,Tanzania,Uncategorized — gaphydba @ 3:40 pm

The first undersea cable to bring high-speed internet access to East Africa has gone live.More click here

 

One-In-Five Employers Use Social Networking Sites To Screen Applicants January 17, 2009

Filed under: Information technology,Networking — gaphydba @ 12:42 pm

t’s no secret that employers Google potential hires as part of their background check. It’s become standard procedure. But employers are also increasingly screening job candidates on popular social networking sites like Facebook and MySpace…..more