Advanced Queue Quickie: Errors and Privileges

File this one under the misleading-errors department. One of my developers was working with a new queue. He pinged me when he got this error trying to create a job that used the queue:ERROR at line 1:ORA-27373: unknown or illegal event source queueORA-06512: at "SYS.DBMS_ISCHED", line 124ORA-06512: at "SYS.DBMS_SCHEDULER", line... [Read More]

NOFILENAMECHECK Parameter Causes DUPLICATE DATABASE To Ignore DB_CREATE_FILE_DEST?

Last week I was creating a new testing database from a backup of our demo database, both under Oracle 11.2.0.3. I grabbed one of my old scripts to handle the duplicate function, which looked similar to this:connect auxiliary /;run {        duplicate database to testdb                backup location '$BACKUPDIR'                nofilenamecheck;}One important difference... [Read More]
Tags: 11gR2 rman oracle