Joords Oracle DBA blog

Make log shipping to work without copying password file from primary to physical standby when changing sys password on primary? Sometimes in a dataguard configuration the user SYS must be changing because of security policies. This results in a failed redolog shiping problem as describe by Harald van Breederode " Password file maintenance in a Data Guard environment " In this blogpost Harald was also mentioning redo transport authentication by an other Oracle user then SYS. To use an other Oracle user then SYS for redo transport authentication you have to do the following steps: In Oracle 11gR1 Oracle has introduced an new init.ora parameter called REDO_TRANSPORT_USER,  with this parameter Oracle can activate the redo transport authentication to be done by an other user then the default  user SYS.

External tables exists since Oracle version 9i, enable to view a file as if it were data in a database. To simplyfy the Extract, Transform, and Load (ETL) processes oracle had added a parameter  PREPROCCESS   to sqlloader for extrations by external tables. The  PREPROCESSING    parameter is introduced in Oracle version 11Gr2 which allow ETL processes handle any type of file without additional out-of-line action. (For example execute a shell script, unzip).

How to startup a database in rman for restricted sessions. You would say conform SQLPLUS SQLPLUS SQL> startup restrict RMAN RMAN> startup restrict It's not working, the word restrict generate an error inside RMAN.

Download the demo EBR zip file

DBMS_PARALLEL_EXECUTE package contains API's to chunk a table into smaller units and execute those chunks in parallel. The DBMS_PARALLEL_EXECUTE package allows a workload associated with a base table to be broken down into smaller chunks which can be run in parallel. This process involves several distinct stages. I was forgotten the power of this   " Do-it- yourself  (DIY) parallelism by Asktom "  now available as package "DBMS_PARALLEL_EXECUTE "since version 11g

One of the problem is hard coded oracle passwords in batch scripts executed by schedulers. Often used is using function to get a password from a file located on the system. This file could be encrypted or plain text. With this function it is possible to hide the password in script and on OS platform. Do you know Secure External Password Store