My Learning

Database Backup and Recovery User's Guide says 'The autobackup occurs whenever a backup record is added. If the database runs in ARCHIVELOG mode, then an autobackup is also taken whenever the database structure metadata in the control file changes " http://docs.oracle.com/cd/E25178_01/backup.1111/e10642/rcmconfb.htm#i1017907 Out of curiosity to see how exactly it works,  just added a tablespace and checked my control file autobackup location to see the auto generated backup of controlfile. When i did 'ls' it was not showing any recent controlfile autobackups. I rechecked all my configuration to make sure all setup is done right. After about 10 minutes i listed again  autobackup location, now i can see a new autobackup file is generated. I spent sometime searching on google to see how long it takes and if the time it takes is configurable. I did not get much on its time lag . Spending sometime on MOS searching for auto controlfile backup generation time ...

Database  - 11.2.0.1.0 I was wondering how 'archive log list' is showing an archive log destination  without setting any of relevant archive log destination or db recovery parameters. LOG_ARCHIVE_DEST LOG_ARCHIVE_DEST_n DB_RECOVERY_FILE_DEST SQL> archive log list ; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 8 Current log sequence 10 SQL> show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string SQL> show parameter db_recovery NAME TYPE VALUE ...

I have tables a and b with character field as its primary key foreign key relation. The primary key field is with char(5) and foreign key field is with char(50). When I tried to insert to child table selecting from primary key column i get "ORA-02291". After giving little rest to brain I figured out whats going wrong. When insert is fired to column with char data type of child table, oracle is appending spaces on top of the value coming from primary key column (because its a char field!!!) . So primary key column value + spaces to fill the character field that makes the child a different value, that's the reason for ORA-02291. This is how it works SQL> create table a(id number,rel char(5)) ; Table created. SQL> create table b(id number,rel char(5)) ; Table created. SQL> create table c(id number,rel char(50)) ; Table created. SQL> alter table a add(constraint a_pk primary key (rel)); Table altered. SQL> alter table b add(c...

Void option on Payment actions screen is disabled while trying to void a payment. Oracle application R12(12.1.3) The payment is done for a prepayment and the prepayment is already applied to a standard invoice. Oracle actually restrict voiding a payment for a prepayment already   applied to an invoice To void the payment  Go to prepayment applications and unapply any invoices applied Query for the invoice to which you have applied the prepayment (now the invoice should have new distribution line and status must have changed to ‘Needs revalidation’) Validate the invoice and create accounting Go back to payment screen and query the payment you want to void Click the Actions Button Void check box should be enabled now

Accessing oracle application 11i 11.5.10.2 on IE8, works on both XP and windows 7 If you try to access oracle applications 11i 11.5.10.2 forms on IE8 it installs jinitiator but when the form link is clicked to open the form explorer just closes abruptly. oracle recommends upgrading to Sun JRE native plugin (Oracle JInitiator 1.3 for E-Business Suite 11i - Forms version 6.0.8.x [ID 552692.1]) The workaround to get it working on IE8 is this way go to Oracle Java Archive website and download Java SE Runtime Environment 6u13 (jre-6u13-windows-i586-p.exe) Install the JRE 6u13 (jre-6u13-windows-i586-p.exe) After installation has finished successfully copy the jvm.dll from java jre 6u13 installation directory (C:\Program Files (x86)\Java\jre6\bin\client) to the jinitiator direcotry (C:\Program Files (x86)\Oracle\JInitiator 1.3.1.21\bin\hotspot) Rename the the old jvm.dll file in the (C:\Program Files (x86)\Oracle\JInitiator 1.3.1.21\bin\hotspot) directory Now open exp...

OS: OEL 5.7 Application : R12.1.3 DB 11.2.0.3 adcfgclone on dbtier fails with RC-00110 - error displayed on terminal RC-50014: Fatal: Execution of AutoConfig was failed Raised by oracle.apps.ad.clone.ApplyDBTechStack - from ApplyDBTier_%.log file Post cloning process of dbtier with adcfgclone kept giving me this error RC-00110: Erro occurred while relinking of ApplyDBTechStack    The log files was showing the error : Autoconfig could not successfully instantiate the following files Adcrdb.sh INSTE8 RC-50014:   Checked the location shown in the log file and found the file was available   /u04/oracle/ERPCLONE/db/tech_st/11.2.0/appsutil/install/ERPCLONE_bkp Digging further showed me  that the script autoconfig complaining about  “adcrdb.sh”   is not available on the target system $db_home/ appsutil/template direcotry . I don’t know how it got missed from copying the source to target ! bash-3.2$ pwd /u04/oracl...

Retiring   asset showed this error “Set up the retirement convention for this retirement date” The prorate daily calendar was not entered for the current financial year, once we entered the program completed successfully