My Learning

In the process of R12.2 upgrade Generating database context file (adbldxml.pl) and running autoconfig (adautocfg.sh) throw java error. Database 11g(11.2.0.3.0) R12 12.2(Upgrading)  bash-3.2$ perl adbldxml.pl Starting context file generation for db tier.. Using JVM from /u01/oracle/ERP/db/tech_st/11.2.0/appsutil/jre/bin/java to execute java programs.. APPS Password: The log file for this adbldxml session is located at: /u01/oracle/ERP/db/tech_st/11.2.0/appsutil/log/adbldxml_11201201.log UnsatisfiedLinkError exception loading native library: njni11 java.lang.UnsatisfiedLinkError: /u01/oracle/ERP/db/tech_st/11.2.0/lib/libnjni11.so: /u01/oracle/ERP/db/tech_st/11.2.0/lib/libnjni11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch) Could not Connect to the Database with the above parameters, Please answer the Questions below Enter Hostname of Database server:xxxx Enter Port of Database server: 1521 Enter SID

Virtual machine virtual disk grows very huge over time despite the fact that the guest os is not taking the space shown by the vmware virtual disk files. This examples shows how to reclaim unused space using command line tools like vmware-mount and vmware-vdiskmanager. The size of the virtual machine partitions, output of ls from the guest os   The total used space is only 10gb or so The size of the virtual disk files on the host To list the partition on a virtual partition use vmware-mount -p ex: vmware-mount -p /u02/vm/vm_test_for_prod_handson/vm_test_for_prod_handson.vmdk Partition has to be mounted to prepare it for shrinking, create a folder to mount the virtual machine partition mkdir /tmp/vm Mount the virtual disk partition vmware-mount /u02/vm/vm_test_for_prod_handson/vm_test_for_prod_handson.vmdk 1 /tmp/vm (This will mount the first partition) Now start pre

Online Patching Enablement patch: 13543062:R12.AD.C. ORA-44305: service ebs_patch is running ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_SERVICE", line 454 ORA-06512: at "SYS.DBMS_SERVICE", line 375 ORA-06512: at "APPS.AD_ZD_PREP", line 308 ORA-06512: at line 4 Checked the error message with oerr utility oerr ora 44305 44305, 0000, "service %s is running" // *Document : Yes // *Cause    : The specified service was running. // *Action   : This message is informational only. Actually the line 308 in package APPS.AD_ZD_PREP is where the error is happening. The  line 308 in the package APPS.AD_ZD_PREP is executing the procedure dbms_service.start_service, as the service is already running the said error was thrown. So dbms_service.stop_service is executed explicitly to stop the service and adctrl is used to restart the failed worker. The adpatch continued to run and completed successfully.

Data refreshing on e-business was queit challenging to do, our developers needed an instance with fresh data (ie: previous day data). As rapid clone needs manual intervention we had to find a way to do it everyday with an automated way. This is one of the methods used. This method assumes already a cloned instance is running for which only data has to be refreshed. The method requires the source database to be down for the database backup.   On the source server connect to sqlplus and issue "alter database backup controlfile to trace", This step has to be done whenever database undergoes some structural changes like adding datafile/logfile. Shutdown the source database and make a backup of datafiles. Move the generated trace file and backed up data files to the destination.  Modify the generated trace file to to match the destination database Clear everything up to "Set #2. RESETLOGS case" Change " CREATE CONTROLFILE REUSE DATABAS

Oracle R12 12.1.3 Office 2013 To create document successfully do the following steps Add the site in trusted sites on explorer (Tools > Internet Options > Security > Sites) Open excel File > Options > Trust center                Click on Trust Center settings Select Disable all macros with notification Check Trust access to the VBA project object model Click Ok Now the document will get created but add in tab will be missing with oracle options Right Click on the Ribbon area and click customize ribbon Select Main Tabs from “Choose command from List” Create a New Tab Select Macro and select BneCreateOracleMenu and Click Add Click on the New Tab > BneCreateOracleMenu This will Display addin with oracle options Save the file as macro enabled work book. Use this file for future upload

  After creating new bank account and adding payment documents, on payment screen after selecting the newly created bank account payment document field is showing “list of values contains no entries” The payment profile option was also defaulting to US NACHA IAT (there are no other profile to select) instead of   laser check format which is actually selected as default format while creating payable documents with manage payment documents Selected format during payment document creation Created a new PPP and issue was solved. Go to setup>payment > payment administrator  Click on the payment process profile Select processing type as printed and complete the creation process

While duplicating, RMAN was continuously  giving the error "RMAN-00571 auxiliary file name xxx conflicts tiwh a file used by the target database" Here is what oerr utility has to say about the error oerr RMAN 5001 5001, 1, "auxiliary file name %s conflicts with a file used by the target database" // *Cause: RMAN is attempting to use the specified file name as a restore //         destination in the auxiliary database, but this name is already //         in use by the target database. // *Action: Use the CONFIGURE AUXNAME command to specify a name for the data //          file that does not conflict with a file name in use by the //          target db.   The cause of the error was the database file name. Rman by default prevents the datafiles and online redo logs  to have the same name as target to avoid overwriting of original database files. I was actually duplicating to a different host with same location as target database with the same file name so

Not able to select VMware worksation bios set up. The delay at boot is too little to select the bios To increase the delay edit the .vmx file and add an entry like bios.bootDelay = "10000" . This will make system wait 10 seconds 

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