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
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
Archived means whether the archive is generated or not on primary and applied means whether the archive applied on standby or not. Enjoy.
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
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
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.
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
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
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
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