Oracle DBA

Saturday, 11 February 2017

crontab entry

How to schedule cron job

Any Value *

value list separator ,

range of values -

step values /

uses :

1 2 3 4 5 <command or script with path>

Example

<MIN> Minute 0 to 59

<HRS> Hours 0 to 24

<DOM> Day of Month 1 to 31 as per month days

<MON> Month 1 to 12

<DOW> Day of Week 1 to 7

1. Execute a cron job every 5 Minutes

*/5 * * * * /home/ramesh/backup.sh

Note: In the same way, use */10 for every 10 minutes, */15 for every 15 minutes, */30 for every 30 minutes, etc.

2. Execute a cron job every 5 Hours

0 */5 * * * /home/ramesh/backup.sh

Note: In the same way, use */2 for every 2 hours, */3 for every 3 hours, */4 for every 4 hours, etc.

3. Execute a job every 5 Seconds

Cron job cannot be used to schedule a job in seconds interval. i.e You cannot schedule a cron job to run every 5 seconds. The alternative is to write a shell script that uses ‘sleep 5’ command in it.

$ cat every-5-seconds.sh
#!/bin/bash
while true
  do
   /home/ramesh/backup.sh
    sleep 5
done

$ nohup ./every-5-seconds.sh &

4. Execute a job every 5th weekday

This example is not about scheduling “every 5 days”. But this is for scheduling “every 5th weekday”.

The 5th field is DOW (day of the week). If you specify * in this field, it runs every day. To run every Friday, specify either 5 of Fri in this field.

The following example runs the backup.sh every Friday at midnight.

        0 0 * * 5 /home/ramesh/backup.sh

        (or)

        0 0 * * Fri /home/ramesh/backup.sh

5.  Execute a job every 5 months

There is no direct way of saying ‘every 5 months’, instead you have to specify what specific months you want to run the job. Probably you may want to run the job on 5th month (May), and 10th month (Oct).

The fourth field is for Months. If you specify * in this field, it runs every month. To run for the specific month, you have to specify the number that corresponds to the month. For example, to run the job on May and Oct, you should specify 5,10 (or) you can simply use the 3 letter acronym of the month and specify May,Oct.

The third field is for DOM (Day of the Month). If you specify * in this field, it runs every day of the month. If you specify 1 in this month, it runs 1st of the month.

The following example runs the backup.sh twice a year. i.e 1st May at midnight, and 1st Oct at midnight.

0 0 1 5,10 * /home/ramesh/backup.sh

(or)

0 0 1 May,Oct * /home/ramesh/backup.sh

############################ RMAN Database FULL Backup #######################

00 00 * * * /home/oracle/RMANBACKUP_SCRIPTS/RMAN_FULL.sh > /home/oracle/RMANBACKUP_SCRIPTS/ORACLE_RMAN_FULL_backup_`date +\%d-\%b-\%Y_\%H_\%M_\%S`.log

############################ RMAN Database INCREMENTAL Backup #############

#Backup every 2 hours

00 02,04,06,08,10,12,14,16,18,20,22 * * * /home/oracle/RMANBACKUP_SCRIPTS/RMAN_INCREMETAL.sh > /home/oracle/RMANBACKUP_SCRIPTS/ORACLE_RMAN_INC_BACKUP_`date +\%d-\%b-\%Y_\%H_\%M_\%S`.log

############################ RMAN ARCHIVE Backup #############

#Archive backup in every 30 Minutes

30 * * * * /home/oracle/RMANBACKUP_SCRIPTS/RMAN_ARCHIVE.sh > /home/oracle/RMANBACKUP_SCRIPTS/ORACLE_RMAN_ARCHIVE_backup_`date +\%d-\%b-\%Y_\%H_\%M_\%S`.log

RMAN Backup Scripting

vi /home/oracle/RMANBACKUP_SCRIPTS/RMAN_FULL.sh

######### RMAN FULL backup Scripts ###################################

#!/bin/ksh
ORACLE_UNQNAME=oracle; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=oracle; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
mkdir /home/oracle/TEST_2016/ORACLE_"$(date +"%d-%m-%Y")"
test=/home/oracle/TEST_2016/ORACLE_"$(date +"%d-%m-%Y")"
rman target=/ << EOF
RUN {
ALLOCATE CHANNEL ch1 TYPE DISK FORMAT '$test/%d_DB_FULL_%u_%s_%p';
sql 'ALTER SYSTEM SWITCH LOGFILE ';
sql 'ALTER SYSTEM SWITCH LOGFILE ';
sql 'ALTER SYSTEM SWITCH LOGFILE ';
sql 'ALTER SYSTEM CHECKPOINT';
BACKUP DATABASE PLUS ARCHIVELOG;
BACKUP SPFILE;
BACKUP CURRENT CONTROLFILE;
delete force noprompt archivelog all backed up 2 times to disk;
DELETE FORCE NOPROMPT EXPIRED BACKUP DEVICE TYPE DISK;
DELETE FORCE NOPROMPT OBSOLETE;
RELEASE CHANNEL ch1;
}
EXIT;$HOME/`date +\%Y\%m\%d\%H\%M\%S`-cron.log
EOF

------------------------------------------------------------------------------------------------------------------------------

chmod u+x /home/oracle/RMANBACKUP_SCRIPTS/RMAN_FULL.sh

vi /home/oracle/RMANBACKUP_SCRIPTS/RMAN_INCREMETAL.sh

########RMAN INCREMENTAL backup Scripts########################################

rman target=sys/Oracle_4U@emrep << EOF
RUN {
ALLOCATE CHANNEL ch1 TYPE DISK FORMAT '$test/%d_DB_INC_%u_%s_%p';
sql 'ALTER SYSTEM SWITCH LOGFILE ';
sql 'ALTER SYSTEM SWITCH LOGFILE ';
sql 'ALTER SYSTEM SWITCH LOGFILE ';
sql 'ALTER SYSTEM CHECKPOINT';
BACKUP INCREMENTAL LEVEL 1 DATABASE;
RELEASE CHANNEL ch1;
}
EXIT;

EOF

----------------------------------------------------------------------------------------------------------------------------------

chmod u+x /home/oracle/RMANBACKUP_SCRIPTS/RMAN_INCREMETAL.sh

vi /home/oracle/RMANBACKUP_SCRIPTS/RMAN_ARCHIVE.sh

##################### RMAN ARCHIVE backup Scripts##########################
ORACLE_UNQNAME=oracle; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=oracle; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
test=/home/oracle/TEST_2016/ORACLE_"$(date +"%d-%m-%Y")"
rman target=/ << EOF
RUN {
ALLOCATE CHANNEL ch1 TYPE
DISK FORMAT '$test/%d_ARCHIVE_%u_%s_%p';
BACKUP ARCHIVELOG ALL delete input;
RELEASE CHANNEL ch1;
}
EXIT;
EOF

-------------------------------------------------------------------------------------------------------------------------------------

chmod u+x /home/oracle/RMANBACKUP_SCRIPTS/RMAN_ARCHIVE.sh

1. Every day RMAN Full Backup

2. Every 2 hours RMAN Incremental Backup

3. Every Hours RMAN Archive Backup

4. Every Day Gather stats of schema

5. Every week crontab backup

6. Every Month reducing alert logfile size

7. Every Day copy RMAN backup of shared storage

8. Every week purging database recycle bin.

9. Record every minute active inactive session and Events in log file daily basis.

10. Record Database health in text file daily basis and Zip health report file monthly basis.

Copy all file and folder created today under directory /home/oracle/TEST_2016/

vi /home/oracle/RMANBACKUP_SCRIPTS/CP_RMAN_FILES.sh

find /home/oracle/TEST_2016/ORACLE_`date +"%d-%m-%Y"` -ctime -1 -type d -exec cp -avr "{}" /home/oracle/TEST_2016/SHARED_STORAGE/ORACLE_RMAN_BACKUP/ \;

chmod u+x /home/oracle/RMANBACKUP_SCRIPTS/CP_RMAN_FILES.sh

#################### crontab entry ##############################

00 23 * * * /home/oracle/RMANBACKUP_SCRIPTS/CP_RMAN_FILES.sh > /home/oracle/RMANBACKUP_SCRIPTS/BACKUP_COPY_LOG/RMAN_BACKUP_COPY_LOG_`date +\%d-\%b-\%Y_\%H_\%M_\%S`.log

echo `date +"%d-%m-%Y" --date="-7 day"`

vi /home/oracle/RMANBACKUP_SCRIPTS/RM_RMAN_BACKUP_FOLDER_SHARED_LOCATION.sh

find /home/oracle/TEST_2016/SHARED_STORAGE/ORACLE_RMAN_BACKUP/ORACLE_`date +"%d-%m-%Y" --date=" 0 day"` -ctime 0 -type d -exec rm -rf "{}" \;

chmod u+x /home/oracle/RMANBACKUP_SCRIPTS/RM_RMAN_BACKUP_FOLDER_SHARED_LOCATION.sh

=============crontab entry==========================================

30 00 * * * /home/oracle/RMANBACKUP_SCRIPTS/RM_RMAN_BACKUP_FOLDER_SHARED_LOCATION.sh > /home/oracle/RMANBACKUP_SCRIPTS/BACKUP_COPY_LOG/RMAN_BACKUP_REMOVE_LOG_`date +\%d-\%b-\%Y_\%H_\%M_\%S`.log

Wednesday, 16 November 2016

RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name

RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name

RMAN-08138 : Reason of RMAN-08138 is RMAN DELETION policy

while we deleting archivelogs files using RMAN, RMAN checks whether archivelog file has been taken backup N times to Disk or Tape before deleting archivelog files.

Default : ARCHIVELOG DELETION POLICY TO NONE

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTPRY are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'F:\ORCL_BACKUP\TEST_BACKUP\02_FEB_2016\TEST_%d_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\APP\DILIPBAKSHI\PRODUCT\11.2.0\DBHOME_2\DATABASE\SNCFTESTPRY.ORA'; # default

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTPRY are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'F:\ORCL_BACKUP\TEST_BACKUP\02_FEB_2016\TEST_%d_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\APP\DILIPBAKSHI\PRODUCT\11.2.0\DBHOME_2\DATABASE\SNCFTESTPRY.ORA'; # default

RMAN> backup archivelog all FORMAT 'F:\temp\Temp3\Backup\RMAN_BACKUP\%n_ARCHIVE_BKP_%p_%s_%D_%M_%Y_%U' delete input;

Starting backup at 17-NOV-16

using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1686 RECID=2307 STAMP=928106656
channel ORA_DISK_1: starting piece 1 at 17-NOV-16
channel ORA_DISK_1: finished piece 1 at 17-NOV-16
piece handle=F:\TEMP\TEMP3\BACKUP\RMAN_BACKUP\TESTPRYX_ARCHIVE_BKP_1_1693_17_11_2016_KTRL4Q5H_1_1 tag=TAG20161117T104712 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

channel ORA_DISK_1: deleting archived log(s)

RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name =F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC

thread=1 sequence=1686

Finished backup at 17-NOV-16

Starting Control File and SPFILE Autobackup at 17-NOV-16
piece handle=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\AUTOBACKUP\2016_11_17\O1_MF_S_928147640_D2THC29D_.BKP comment=NONE

Finished Control File and SPFILE Autobackup at 17-NOV-16

Note : According to above policy RMAN will not delete those Archivelog files which have not been backed up 2 Times to Disk

RMAN> list archivelog all backed up 1 times to DISK;

RMAN> list archivelog all backed up 0 times to DISK;

List of Archived Log Copies for database with db_unique_name TESTPRY
=====================================================================
Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
2307    1    1686    A 16-NOV-16
Name:F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC

2308    1    1687    A 16-NOV-16
Name:F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_17\O1_MF_1_1687_D2THGPLY_.ARC

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

old RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name TESTPRY are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'F:\ORCL_BACKUP\TEST_BACKUP\02_FEB_2016\TEST_%d_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\APP\DILIPBAKSHI\PRODUCT\11.2.0\DBHOME_2\DATABASE\SNCFTESTPRY.ORA'; # default

RMAN>

RMAN> backup archivelog all FORMAT 'F:\temp\Temp3\Backup\RMAN_BACKUP\%n_ARCHIVE_BKP_%p_%s_%D_%M_%Y_%U' delete input;

Starting backup at 17-NOV-16

current log archived
using channel ORA_DISK_1
skipping archived log file F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC; already backed up 1 time(s)
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=1687 RECID=2308 STAMP=928147759
input archived log thread=1 sequence=1688 RECID=2309 STAMP=928149066
channel ORA_DISK_1: starting piece 1 at 17-NOV-16
channel ORA_DISK_1: finished piece 1 at 17-NOV-16
piece handle=F:\TEMP\TEMP3\BACKUP\RMAN_BACKUP\TESTPRYX_ARCHIVE_BKP_1_1695_17_11_2016_KVRL4RIB_1_1 tag=TAG20161117T111106 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_17\O1_MF_1_1687_D2THGPLY_.ARC RECID=2308 STAMP=928147759
archived log file name=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_17\O1_MF_1_1688_D2TJQK8D_.ARC RECID=2309 STAMP=928149066
channel ORA_DISK_1: deleting archived log(s)
archived log file name=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\ARCHIVELOG\2016_11_16\O1_MF_1_1686_D2S7B6YJ_.ARC RECID=2307 STAMP=928106656
Finished backup at 17-NOV-16

Starting Control File and SPFILE Autobackup at 17-NOV-16
piece handle=F:\APP\DILIPBAKSHI\FLASH_RECOVERY_AREA\TESTPRY\AUTOBACKUP\2016_11_17\O1_MF_S_928149073_D2TJQW31_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 17-NOV-16

Note : This time No RMAN-08138: warning raised.

Friday, 11 March 2016

Script for USER AUDIT which oracle database user created new user

col OS_USERNAME format a15
col USERNAME format a15
col USERHOST format a15
col TERMINAL format a20
col ACTION format a10
col GRANTEE format a30
col OS_PROCESS format a30
select dba_audit_trail.OS_USERNAME,
  dba_audit_trail.USERNAME,
  dba_audit_trail.USERHOST,
  dba_audit_trail.TERMINAL,
  dba_audit_trail.TIMESTAMP,
  dba_audit_trail.ACTION,
  dba_audit_trail.ACTION_NAME,
  dba_audit_trail.GRANTEE,
  dba_audit_trail.SESSIONID,
  dba_audit_trail.SESSIONID,
  dba_audit_trail.OS_PROCESS,
  dba_audit_trail.LOGOFF_TIME,
  dba_audit_trail.SQL_TEXT
from dba_audit_trail
where dba_audit_trail.USERNAME IN (select grantee from dba_role_privs
         where granted_role IN (select role from role_sys_privs where PRIVILEGE like 'CREATE USER'))
and dba_audit_trail.SQL_TEXT like 'create%';

Friday, 4 March 2016

DELETE TABLE DATA USING CURSOR

create or replace PROCEDURE EMPMAST.DELETE1_DATA_From_INDIA_EMP
AS
v_city INDIA_EMP.CITY%TYPE;
CURSOR del_cursor1 IS SELECT DistrictName INTo v_city
                                           FROM ( select DistrictName
                                                         from    EMPMAST.DISTRICT_MASTER
                                                         ORDER BY dbms_random.value ) WHERE rownum = 1;
BEGIN
OPEN del_cursor1;
LOOP
FETCH del_cursor1 into v_city;
EXIT WHEN del_cursor1%NOTFOUND;
DELETE from EMPMAST.INDIA_EMP;
COMMIT;
END LOOP;
dbms_output.put_line('TOTLA '||sql%rowcount||' Deleted');
CLOSE del_cursor1;
end DELETE1_DATA_From_INDIA_EMP;
/

DELETE FROM EMPMAST.INDIA_EMP WHERE CITY=(select DistrictName from    EMPMAST.DISTRICT_MASTER ORDER BY dbms_random.value ) WHERE rownum = 1);

Tuesday, 16 February 2016

ORA-31608: specified object of type OBJECT_GRANT not found

SQL> SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','DILIP') from dual;
ERROR:
ORA-31608: specified object of type OBJECT_GRANT not found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 3915
ORA-06512: at "SYS.DBMS_METADATA", line 5826
ORA-06512: at line 1

no rows selected
SQL>
SQL>
SQL>
SQL> grant select on dual to dilip;
Grant succeeded.
SQL> SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','DILIP') from dual;
DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT','DILIP')
--------------------------------------------------------------------------------
GRANT SELECT ON "SYS"."DUAL" TO "DILIP";

Oracle DBA

ORACLE

Total Pageviews

Saturday, 11 February 2017

crontab entry

Wednesday, 16 November 2016

RMAN-08138: WARNING: archived log not deleted - must create more backups archived log file name

Friday, 11 March 2016

Script for USER AUDIT which oracle database user created new user

Friday, 4 March 2016

DELETE TABLE DATA USING CURSOR

Tuesday, 16 February 2016

ORA-31608: specified object of type OBJECT_GRANT not found

Followers