Apps DBA Workshop

The system was not coming up for a few of the critical services went into maintenance mode. In this article, we will see how we can fix this issue. Login to the OS in maintenance mode: Enter user name for system maintenance (control-d to bypass): root Enter root password (control-d to bypass): single-user privilege assigned to root on /dev/console. Entering System Maintenance Mode May 22 12:44:51 su: 'su root' succeeded for root on /dev/console Oracle Solaris 11.4.49.126.2 Assembled August 2022 You have new mail. root@ijrpscrm-p-w2:~# Check the services impacted: root@ijrpscrm-p-w2:~# svcs -x svc:/system/filesystem/minimal:default (minimal file system mounts) State: maintenance since 2023-02-22T12:41:29 Reason: Start method exited with $SMF_EXIT_ERR_FATAL. See: http://support.oracle.com/msg/SMF-8000-KS See: /var/svc/log/system-filesystem-minimal:default.log Impact: 126 dependent services are not running. (Use -v for list.) svc:/network/rpc/smse...

In this blogpost we will see how we can create a mirrored zpool for the newly added hard disks. One of our customer upgraded the capacity of Oracle S7-2L Servers and we need to provision the new zpool for the newly added devices. Check the newly connected drives: root@IJRERPS72L:/dev/rdsk# echo | format Searching for disks...done AVAILABLE DISK SELECTIONS: 0. c0t5000C500BC16E423d0 /scsi_vhci/disk@g5000c500bc16e423 /dev/chassis/SYS/HDD0/disk 1. c0t5000C500BC16EB9Fd0 solaris /scsi_vhci/disk@g5000c500bc16eb9f /dev/chassis/SYS/HDD1/disk 2. c0t5000C500BC16D847d0 solaris /scsi_vhci/disk@g5000c500bc16d847 /dev/chassis/SYS/HDD2/disk 3. c0t5000C500BC16D42Bd0 solaris /scsi_vhci/disk@g5000c500bc16d42b /dev/chassis/SYS/HDD3/disk 4. c0t5000C500BC16F047d0 solaris /scsi_vhci/disk@g5000c500bc16f047 /dev/chassis/SYS/HDD4/disk 5. c0t5000C500BC16D...

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...

 Oracle Solaris 11 is one of the well known operating system and due to its powerful compute capacities, there are many customers who are still using it. This blogpost will help you for performing Oracle EBS 12.2 Installation OS pre-requisites in simple two steps. As a part of preparation just we need to install the two pakcages and the OS will be ready for Kickking off the Oracle E-Business suite application. 1 - solaris-desktop 2 - oracle-ebs-server-R12-preinstall These packages will be installed using the Oracle Solairs repository, so there should be a valid package repository available that is needed for installing the packages. Installation of solaris-desktop package: root@ijr-svp-ebsdb1:~# pkg install solaris-desktop Packages to install: 337 Mediators to change: 1 Services to change: 17 Create boot environment: No Create backup boot environment: No DOWNLOAD PKGS FILES XFER (MB) ...

We have encountered the following Error while creating the zpool on one of the Oracle Solaris Server. The zpool volume creation failed. root@SOLSRV-CDM1:~# zpool create drdata c0t5000CCA03C5D3274d0 c0t5000CCA03C591A18d0 c0t5000CCA03C5C8818d0 c0t5000CCA03C5BFC6Cd0 c0t5000CCA03C5D69F4d0 vdev verification failed: use -f to override the following errors: /dev/dsk/c0t5000CCA03C5D3274d0s0 is part of exported or potentially active ZFS pool u01. Please see zpool(8). /dev/dsk/c0t5000CCA03C5D3274d0s1 is part of exported or potentially active ZFS pool rpool. Please see zpool(8). /dev/dsk/c0t5000CCA03C5D3274d0s0 is part of exported or potentially active ZFS pool u01. Please see zpool(8). /dev/dsk/c0t5000CCA03C5D3274d0s1 is part of exported or potentially active ZFS pool rpool. Please see zpool(8). /dev/dsk/c0t5000CCA03C5D3274d0s2 is part of exported or potentially active ZFS pool u01. Please see zpool(8). /dev/dsk/c0t5000CCA03C5D3274d0s3 is part of exported or potentially active ZFS pool rpool. P...

Recently installation Solaris 11.4 operating environment where the repository was successfully confiured and installed started reporting the following errors when we were trying to install the new packages using the same repository. The following Error message is reported while we are trying to use the locally configured repository: root@ECMDB:~# pkg publisher Traceback (most recent call last):   File "/usr/bin/pkg", line 6702, in handle_errors     __ret = func(*args, **kwargs)   File "/usr/bin/pkg", line 6584, in main_func     api_inst = __api_alloc(mydir, provided_image_dir, pkg_image_used)   File "/usr/bin/pkg", line 1459, in __api_alloc     exact_match=exact_match)   File "/usr/lib/python2.7/vendor-packages/pkg/client/api.py", line 370, in __init__     cmdpath=self.cmdpath)   File "/usr/lib/python2.7/vendor-packages/pkg/client/image.py", line 236, in __init__     progtrack)   File "/usr/...

Pre-requisites  check for Oracle Database 12c failing on configuration of kernel parameters. Since version 11gR2 oracle Installer will generate fix-up scripts for those parameters which can be fixed by running fix-up scripts.  Pre-requisite check failed for kernel parameter "project.max-shm-memory" . - Execute the fix-up script from root user and check fix-up result. The fix-up result is successful but if we check again the pre-requisites are failing on the same kernel parameter. In solaris 9/10 we need to reboot the server for kernel parameters to be effective.  In Solaris 11 exit the Installer, then open new session with oracle user with which Installing the database, start the Installer and here it should read the newly configured kernel parameter. So no reboot is required. Thanks for reading. regards, X A H E E R 

Introduction:                   Oracle Solaris 11 uses Image packaging system (IPS). Oracle Solaris 11 Image packaging system  (IPS) is available to be Installed online over  the network or can be Installed using a local repository without an Internet connection. Introduction of IPS simplifies the Installation of Package(s) and its dependencies.  Before IPS, patch and package management was a tedious task, system administrators has to manually check all the dependencies before Installation of a package. IPS also simplifies the life a System Administrators.                Oracle releases periodic updates of package(s)  for the repositories and these updates are generally available to the customers as Support Repository Update (SRU). Support Repositories are available to download for customers who have valid support ID contract for Oracle Solaris 11.These updates includes u...