Stay at Home!! Be Safe!! Take Care!!

Thanks all my viewers for your support, I am an Oracle Ace now. For Any queries, please mail us at support@funoracleapps.com

RMAN-12012: multiple records for DISK parallelism found in catalog

No comments

 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

No comments :

Post a Comment

httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

No comments

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.


No comments :

Post a Comment

How to Install Mac OS on Virtual Box

No comments

 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"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/smc/0/Config/DeviceKey" "ourhardworkbythesewordsguardedpleasedontsteal(c)AppleComputerInc"

VBoxManage setextradata "MacOS" "VBoxInternal/Devices/smc/0/Config/GetKeyFromRealSMC" 1

VBoxManage setextradata "MacOS" VBoxInternal2/EfiGraphicsResolution 1920x1020


Start the Virtual Machine and follow the GUI.

No comments :

Post a Comment

How to Create macOS Catalina ISO File

No comments

 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.





No comments :

Post a Comment

Query to find the profile assigned to a Responsibility in Oracle Apps

No comments

 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 (+)
AND c.level_value         = h.application_id (+)
  --
AND c.level_id            = 10003
and b.language='US'
AND g.responsibility_name = '%&Responsibility Name%'
ORDER BY b.user_profile_option_name,  c.level_id
);

No comments :

Post a Comment

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

No comments

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

No comments :

Post a Comment

CentOS Installation on Virtual Box|CentOS 7|Oracle Virtual Box

No comments

No comments :

Post a Comment

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM

No comments

 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_requests r where p.concurrent_process_id =
e.concurrent_process_id and p.concurrent_process_id = r.controlling_manager and e.variable_name like '%CUSTOM_TOP%' and r.request_id = &request_id;

Solution :


Add the respective Top in env file

$APPL_TOP/admin/adovars.env

or 

Setup custom  environment file.

Restart concurrent managers.

No comments :

Post a Comment

Oracle Virtual Box Installation on Windows

No comments

 

No comments :

Post a Comment

ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:

No comments

 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 again as it should run successfully now.

No comments :

Post a Comment

How to setup UDEV instead of ASM libraries for ASM on Linux

No comments

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 fdiks -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=property /dev/sdc
udevadm info --query=property /dev/sdd

4. Go to cd /etc/udev/rules.d directory and add the new disk details in file 99-oracle-asmdevices.rules as below. Make sure to update ID_SERIAL with your correct value and disk owner and group should be correct based on the env. Also I will give a virtual name/symbolink for eash disk as oraasm01/02/03 etc.


ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c297a90d6a9681b1d2a5a1b88568"", GROUP=""dba"", SYMLINK+=""oraasm01"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c29906aa418e9822a0947ce9ad22"", GROUP=""dba"", SYMLINK+=""oraasm02"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c291823fef46b990dbc1fe7bebdf"", GROUP=""dba"", SYMLINK+=""oraasm03"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c2944397980b1b7f91a3d0c99e56"", GROUP=""dba"", SYMLINK+=""oraasm04"" OWNER=""oraasm"", MODE=""0660""
ACTION==""add|change"", SUBSYSTEM==""block"", ENV{ID_SERIAL}==""36000c2954d200a2927a1e815945e603d"", GROUP=""dba"", SYMLINK+=""oraasm05"" OWNER=""oraasm"", MODE=""0660"""


5. Reload the udev rules to identify the new disks.

udevadm control --reload-rules
udevadm trigger --type=devices --action=change


Note:
# #OL5
# /sbin/udevcontrol reload_rules

# #OL6 and OL7
# udevadm control --reload-rules

# #OL5 and OL6 : Not needed for OL7
# /sbin/start_udev

6. Verify the disk permissions and permissions

ls -l /dev/oraasm05
ls -l /dev/oraasm03
ls -l /dev/oraasm04
ls -l /dev/oraasm01
ls -l /dev/oraasm02

7. Make sure the ASM disk string should be set as  asm_diskstring='/dev/ora*' to identify the disks.

8. Attach the new disks to the diskgroup in asm now.



Example:

SQL> set pages 40000 lines 120
col PATH for a30
select DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH FROM V$ASM_DISK;
SQL> 
DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE    PATH
----------- ------- ------------ ------- -------- ------------------------------
          4 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm05
          2 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm03
          3 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm04
          0 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm01
          1 CACHED  MEMBER       ONLINE  NORMAL   /dev/oraasm02

No comments :

Post a Comment