image

Daily Activities of Oracle Database Administrator

Daily Work of DBA: Check the Database Availability Check the Listener Availability Monitoring space Availability Viewing the Alert log file to analyze the ORA errors if any. Check tablespaces should not be used more that 95%. Viewing the temporary files, through the DBA_TEMP_FILES. Daily resolving the tickets by using Remedy ticketing tool. Taking backups by … continue reading

image

The flashback recovery area has run out of space …under different scenarios

The flashback recovery area has run out of space what different solution to overcome that issue. as we see some expert solution to this question lets add some scenarios on that,now i know how i increase-up the FRA say db_recovery_file_dest_size = 10G what happened when we reduced it to db_recovery_file_dest_size = 5G……? The flash recovery … continue reading

image

What is the difference between ‘archived’ and ‘applied’ on v$archived_log view ?

Archived means whether the archive is generated or not on primary and  applied means whether the archive applied on standby or not. Enjoy.  

image

Is there any way to decrypt the password of a user which is not database user ?

You can not decrypt the password because it is not stored encrypted in the database dictionary!The gibberish values that can be seen in DBA_USERS.PASSWORD column are not encrypted passwords, they are hash values of passwords plus  corresponding usernames. So they are obtained by implementing some hashing algorithm, not some encryption algorithm.There is a huge difference … continue reading

image

which process write error/message in atert log file ? which process perform rollback ?

Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, while other information is for Oracle Worldwide Support. Trace … continue reading

image

which process writes previous image to undo tablespace?

server process..Sounds like a trick question. I do not think there is (or can be) such a process. Every server process has to write undo information by itself as it updates the database blocks in the buffer cache. This cannot be deferred to a background operation.  

image

what is difference between index rebuilding and online index rebuilding ?

Solution 1 by Gaurang Tyagi. index can be rebuild online and offline , online means while u are rebuilding your index is available to users to use(in background it ll create a replica and ll use a virtual column for storing the values) and in offline index its not available “correct me if am wrong … continue reading

image

errors at datapump impdp expdp – ORA-39213: Metadata processing is not available

When i tried to export the database using the expdmp with the following command $expdp username/password dumpfile=export.dmp logfile=export.log full=y parallel=4 I got the following error. Error: With the Partitioning, OLAP and Data Mining options ORA-39006: internal error ORA-39213: Metadata processing is not available   How i solved it ? $sqlplus / as sysdba SQL>execute dbms_metadata_util.load_stylesheets … continue reading

image

ORA-12518 Tns: Listener could not hand off client Connection

What i did & resulted the above problem? $Sqlplus  / as sysdba SQL>show parameter proceses; -1500 SQL> show parameter sessions; SQL> alter system set processes=3000 scope=spfile; SQL>alter system set sessions=2500 scope=spfile; SQL> shutdown immediate; SQL> Startup open; ERROR: ORA-12518: TNS:listener could not hand off client connection. How I solved the problem ORA-12518 Tns: Listener could … continue reading

image

ORA-25153: Temporary Tablespace is Empty

Problem Description: During the Fine Grained Auditing , first i created the following script SQL>connect / as sysdba SQL>begin DBMS_FGA.ADD_POLICY( OBJECT_SCHEMA=>’CMS_USER’, OBJECT_NAME=>’hearing’, POLICY_NAME=>’hearing_policy’, AUDIT_COLUMN=>’hearing_title’, STATEMENT_TYPES=>’UPDATE,DELETE,SELECT’ ); END; After executing the above query , i run the following query SQL>connect cms_user/cms; SQL>select * from hearing Which result the error:  Temporary Tablespace is Empty What the Problem … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube