Knowledge transfer to Wisdom

Oracle 12c:--ORA-65096: invalid common user or role name

Command prompt SQL> create user 12ctest identified by 12ctest; create user 12ctest identified by 12ctest * ERROR at...
Recover database when online redolog file is corrupted.

Oracle Database can be operates in two modes. 1. Archive log mode (The archive logs are generated and online backup is possible) ...
What happen during begin backup mode in oracle ?

Below activity happen during begin backup mode. DBWn checkpoints the tablespace (writes out all dirty blocks as of a given SCN...
Oracle DBA Interview Questions

Oracle DBA interview 09-Feb-2012 :- 1)What are the basic steps in upgrading 10g to 11g? 2)What is the difference between opatch napply ...
ORA-16401: archivelog rejected by RFS

Errors found in the alertlog file of oracle database. Tue Sep 27 12:09:10 2011 Errors in file /home/app/oracle/admin/pri/bdump/pri_arcr_4...
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

Solution of the Error Step 1: Check permission on /etc/hosts $ ls -l /etc/hosts -rw-r--r-- 1 root root 153 Nov 24 2007 /etc/hosts Not...
ORA-28007: the password cannot be reused

SQL> alter user "BACMONIT" IDENTIFIED BY VALUES 'xxxxxxx'; alter user "BACMONIT" IDENTIFIED BY VALUES '...
to check current temporary tablespace usage

--------- current tempoary tablespace usage --------------- SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_...
How to modify ASM diskgroup redundancy to external.

Steps to convert the asm disk group redundancy from normal to external DB: ==== shutdown immediate; startup mount; backup device t...
RMAN Recovery scenarios

Pre-requisite for RMAN RMAN recovery scenarios require that the database is in archive log mode, and that backups of datafiles, ...

Pages

Home

Labels

Interview
RMAN
oracle 12c
oracle scritpts

Watermark theme. Powered by Blogger.