foalabs

 RMAN-12012: multiple records for DISK parallelism found in catalog Error: While running RMAN backup getting below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-12010: automatic channel allocation initialization failed RMAN-12012: multiple records for DISK parallelism found in catalog Solution: Connect to sqlplus as sysdba and run below  exec dbms_backup_restore.resetconfig; Re-run Rman backup

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory While starting apache in Oracle Apps R12, below error is encountered. Error: -------- 20/08/29 06:35:31 Start process -------- /bispapps/apps122/Apps/inst/apps/VIS_ebsvis/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd /bispapps/apps122/Apps/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory Cause:  The library was missing. Solution: 1. Shut down all Oracle Application Services. 2. As the LINUX root user, create a soft link as follows: ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2 3. Startup all Oracle Application Services. For Linux 7   c opy  old version of libgdbm.so.2.0.0  this from any Linux 6 or 5 box. Download from here The same steps works in Linux 8 as well.

 How to Install Mac OS on Virtual Box Download MAC Catalina OS ISO by clicking below image Before starting the VM, open the VM settings and make the following changes: System > Processor > Processor(s) is 2 or more. System > Acceleration > uncheck Enable Nested Paging. Display > Screen > Video Memory is 128MB. USB > USB 3.0 Controller. Command before starting the Virtual Machine Open terminal and run below cd /usr/bin/ (For Windows user go to "C:\Program Files\Oracle\VirtualBox\" from command prompt) VBoxManage modifyvm "MacOS" --cpuidset 00000001 000106e5 00100800 0098e3fd bfebfbff VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiSystemProduct" "iMacOS11,3" VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiSystemVersion" "1.0" VBoxManage setextradata "MacOS" "VBoxInternal/Devices/efi/0/Config/DmiBoardProduct" "Iloveapple...

  How to Create macOS Catalina ISO File Please note these steps need to be performed on a Apple Mac System to generate an iso. Steps: 1) Download macOS Catalina From App Store or Apple download 2) Please note once you download it will be in dmg format. 3) Open Terminal in MAC.  from the top-right corner open up Spotlight.  Type in Terminal and hit Enter. 4)  Mount it to your macOS hdiutil attach /tmp/Catalina.dmg -noverify -mountpoint /Volumes/Catalina 5) Create macOS Catalina Installer sudo /Applications/Install\ macOS\ Catalina.app/Contents/Resources/createinstallmedia --volume /Volumes/Catalina --nointeraction 6) Unmount Catalina Disk hdiutil detach /volumes/Install\ macOS\ Catalina 7) Convert the DMG file to an ISO file hdiutil convert /tmp/Catalina.dmg -format UDTO -o ~/Desktop/Catalina.cdr 8) Rename and Move to Desktop mv ~/Desktop/Catalina.cdr ~/Desktop/Catalina.iso Now we can use this iso on any system and install on virtual machines.

 Query to find the profile assigned to a Responsibility in Oracle Apps Query: select distinct * from (SELECT  b.user_profile_option_name "Long Name" ,   a.profile_option_name "Short Name" ,   NVL(g.responsibility_name,c.level_value)  "Level Value" ,   c.PROFILE_OPTION_VALUE "Profile Value" FROM apps.fnd_profile_options a ,   apps.FND_PROFILE_OPTIONS_tL b ,   apps.FND_PROFILE_OPTION_VALUES c ,   apps.FND_USER d ,   apps.FND_USER e ,   apps.FND_RESPONSIBILITY_tL g ,   apps.FND_APPLICATION h WHERE 1                   =1 AND a.profile_option_name = b.profile_option_name AND a.profile_option_id   = c.profile_option_id AND a.application_id      = c.application_id AND c.last_updated_by     = d.user_id (+) AND c.level_value         = e.user_id (+) AND c.level_value         = g.responsibility_id (+)...

Download Oracle EBS Software|R12.2.0|Oracle E-Business Suite

 APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM Error: APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs. Shut down the concurrent managers. Set the basepath environment variable for the application. Restart the concurrent managers. (VARIABLE=) Routine AFPEOT cannot construct the name of an executable file for your concurrent request 122917706. Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager Cause: Custom Top is registered and not set in the ENV while starting the concurrent services. Query to Check whether the Env is set for the Particular Concurrent Request : select variable_name,value from fnd_env_context e ,fnd_concurrent_processes p ,fnd_concurrent_...

 

 ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments Error : After DB upgrade , as part of R12 dbtier post-installation procedure, required to run adstats.sql and getting the following error declare * ERROR at line 1: ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [1350], [1], [23], [], [], [], [], [], [], [], [], [] ORA-06512: at "SYS.DBMS_STATS", line 25335 ORA-06512: at "SYS.DBMS_STATS", line 25877 ORA-06512: at line 3 ORA-06512: at line 33 Cause: ORA_NLS10 variable not set. Solution : 1. Make sure that $ORACLE_HOME/nls/data/old/cr9idata.pl executed to create $ORACLE_HOME/nls/data/9idata as per Database upgrading notes. 2. Make sure that the ORA_NLS10 environment variable is set to the full path of the nls/data/9idata directory: echo $ORA_NLS10 export ORA_NLS10=$ORACLE_HOME/nls/data/9idata 3- If the instance was not started with ORA_NLS10 set correctly restart it. 4- Retest the issue by running adstats.sql a...

How to setup UDEV instead of ASM libraries for ASM on Linux In this post I am going to share how to use UDEV on Linux server for ASM disk in place for ASMlib. It will help to directly allot the raw disk to your asm disk group.It can be used in Red Hat, Oracle, Centos Linux variants using UDEV. Udev is the mechanism used to create and name /dev device nodes corresponding to the devices that are present in the system. Udev uses matching information provided by sysfs with rules provided by the user to dynamically add the required device nodes. Steps to use udev for ASM 1. Attach a raw disk to the server. 2. Use lsblk or fdisk -l command to find the new added disk names. example: /dev/sdg /dev/sde /dev/sdf /dev/sdc /dev/sdd 3. Find the ID_Serial for each associated disk, if we directly use the disk name it might get chnaged after the server reboot. udevadm info --query=property /dev/sdg udevadm info --query=property /dev/sde udevadm info --query=property /dev/sdf udevadm info --query=prope...