Apps DBA Workshop

I received an Incident from one our customer that all standard concurrent requests in EBS R12.1.3  are not completing and its continuously in status "Running Normal" forever. This issue was reported on of their recently cloned TEST/UAT Environment. Environment details: EBS : 12.1.3 DB   : 12.1.0.2 OS   : IBM-AIX -6.1 (64-bit) If we check the log file for any standard concurrent request there is no error reported. Below is the concurrent manager logfile for Active users: Cocurrent log:  --------------------  +---------------------------------------------------------------------------+  Application Object Library: Version : 12.0.0  Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.  FNDSCURS module: Active Users  +---------------------------------------------------------------------------+  Current system time is 30-OCT-2021 16:25:07  +---------------------------------------------------------------------------+  +--------------

 In one of our customer environment we were trying to upload the iso image on KVM storage domain, but when we were trying to upload the image we encountered following error: [root@oraovm REST]# python upload_to_storagedomain.py -l oraovm -u admin@internal -c /etc/pki/ovirt-engine/ca.pem --sdd-name NFS-ISO-DATA -t ISO /home/os_files/SW_DVD9_Win_Server_CORE_2016_64Bit.iso Enter engine Login password:- Creating disk... Traceback (most recent call last): File "upload_to_storagedomain.py", line 179, in main() File "upload_to_storagedomain.py", line 117, in main disk = create_disk() File "upload_to_storagedomain.py", line 101, in create_disk name = arg.sdd_name File "/usr/lib64/python2.7/site-packages/ovirtsdk4/services.py", line 7074, in add return self._internal_add(disk, headers, query, wait) File "/usr/lib64/python2.7/site-packages/ovirtsdk4/service.py", line 223, in _internal_add context = self._connection

Installation of Oracle Database 12cR1 on Oracle Solaris 11.2 (X86-64Bit) failed with error " network/lib/ins_net_client.mk " though all pre-requisites checks was successful. Installation failed on the following screen: Error log content from the Installation logfile: INFO: rm -f ntcontab.* INFO: (if [ "assemble" = "compile" ] ; then \ /u01/oradb/oracle/product/12.1.0/dbhome_1/bin/gennttab > ntcontab.c ;\ cc -c ntcontab.c ;\ rm -f /u01/oradb/oracle/product/12.1.0/dbhome_1/lib/ntcontab.o ;\ mv ntcontab.o /u01/oradb/oracle/product/12.1.0/dbhome_1/lib/ ;\ /usr/ccs/bin/ar rv /u01/oradb/oracle/product/12.1.0/dbhome_1/lib/libn12.a /u01/oradb/oracle/product/12.1.0/dbhome_1/lib/ntcontab.o ; fi) INFO: (if [ "assemble" = "assemble" ] ; then \ /u01/oradb/oracle/product/12.1.0/dbhome_1/bin/gennttab > ntcontab.s ;\ /usr/ccs/bin/as -m64 -Kpic -o ntcontab.o ntcontab.s ;\ rm -f /u01/oradb/oracle/product/12.1.0/db

I was Installing Oracle Database 12c on Oracle Solaris 11.2 and the pre-requisites for database Installation failed for SWAP memory requirement. The configured swap memory on the server is 1GB and the Physical memory of the server is 4GB. There should be at least 4GB of SWAP memory configured to avoid this error. This is article will help to Increase the SWAP memory of the system without any downtime. We can add additional SWAP memory online using zfs commands. - Identify the current volume using for SWAP: root@soltest1:~# swap -l swapfile dev swaplo blocks free /dev/zvol/dsk/rpool/swap 303,1 8 2097144 2097144 - Identify the size of the current SWAP space: root@soltest1:~# zfs get volsize rpool/swap NAME PROPERTY VALUE SOURCE rpool/swap volsize 1G local - Set new size for SWAP volume root@soltest1:~# zfs set volsize=5g rpool/swap root@soltest1:~# zfs get volsize rpool/swap NAME PROPERTY VAL