My Learning

Define audit group Security>Audittrail>Groups see documentation for more info Note: When you first create the audit group the group status will be 'Enable Requested'  this will automatically be changed to 'Enabled' once th e  AuditTrail Update Tables concurrent request is run Define columns to be audited Security > AuditTrail>Tables Enable auditing for schema owners Security > Audittrail>install Enable ‘AuditTrail Activate’ profile option Submit the AuditTrail Update Tables concurrent request If Request fails with   “Fatal error in fdasql, quitting Fatal error in fdacv, quitting Fatal error in fdaupc, quitting “ check this out  Fatal error in fdasql

While running  AuditTrail Update Tables concurrent request on e-business suite R12(12.1.3) as part of audittrail enable process the request completed with  Fatal error in fdasql, quitting.... Fatal error in fdacv, quitting.... Fatal error in fdaupc, quitting  error.     To fix the issue Check if you have enabled auditing for  APPLSYS,APPS and the application schema owner you want to audit, if not enable the auditing for the schema you wish to audit. And also check the logfile to see if its failing at View AP_SYSTEM_PARAMETERS_ALL_AC1,  If so change the group status for the Audit Group AP_SYSTEM_PARAMETERS_ALL to disable – purge table   Now submit the   AuditTrail Update Tables program again

Configuration Action Creating domain has failed please check logs for details Few lines from install log file oracle.as.provisioning.exception.ASProvWorkflowException: Error Executing workflow. at oracle.as.provisioning.engine.WorkFlowExecutor._createDomain(WorkFlowExecutor.java:686) ........ ....... oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81) at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:86) at java.lang.Thread.run(Thread.java:662) Few from orainstall .out as well Creating Weblogic Domain. oracle.as.provisioning.exception.ASProvWorkflowException at oracle.as.provisioning.weblogic.ASDomain._createDomain(ASDomain.java:2630) at oracle.as.provisioning.weblogic.ASDomain.createDomain(ASDomain.java:2476) ....................................... ........................................  at oracle.as.provisioning.engine.WorkFlowE

Each time autoconfig is run it creates a folder under [inst_top]/admin/out/ . The name of folder is the the date and time of autoconfig run in the mmddhhmi format , This contains resote.sh script with many other files including  context_file. On running autoconfig it automatically creates a folder with different files for that autoconfig run. After autoconfig run If you find something wrong( like application is not accessible because of last modification) stop the application tier services and go to the relevant autoconfig folder and run restore.sh script to restore previous autoconfig configuration. The restore.sh will not actually restore the context_file but this will restore all the settings prior to this autoconfig run.(if you had a faulty configuration before, of course restore.sh will restore only those configurations) After restore.sh is run start up the services(don't run autoconfig), access the application, check the modifications and correct the modifications caus

Scenario Restore the database and recover up to the last available archived log sequence.Auto Controlfile backup is generated before sometime disaster happened (lost all controlfiles, datafiles and redologfiles).After the autobackup of controlfile generation there had been few archive logs generated but not backed up.  Steps Restore the controlfile Restore the datafiles Catalogue the archived logs manually of which controlfile is not aware of recover the database open the database with resetlogs Connect to rman and set dbid RMAN> restore controlfile from '/u02/bkp/TESTCLONE/bkpcontrl_c-1057140170-20130324-01' Starting restore at 25-MAR-2013 14:32:10 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=358 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u04/oracle/TESTclonedata/cntrl01.dbf output file name=/u04/oracle/TESTclonedata/cntrl02