Oracle Apps DBA

My Photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Sunday, 14 December 2014

Oracle Database 12c fix-up scripts not fixing up the kernel parameters on Oracle Solaris 11.2

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 

Oracle Database 12c Installation failed with Error "network/lib/ins_net_client.mk" on Oracle Solaris 11.2

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/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: sh[2]: /usr/ccs/bin/as: not found [No such file or directory]

INFO: *** Error code 127

INFO: make: Fatal error: 
INFO: Command failed for target `
INFO: ntcontab.o
INFO: '
INFO: 

INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/u01/oradb/oracle/product/12.1.0/dbhome_1/network/lib/ins_net_client.mk'. See '/u01/oradb/oraInventory/logs/installActions2014-12-14_09-04-46AM.log' for details.
Exception Severity: 1

Cause:

Installer is not able to find the binary "/usr/ccs/bin/as" in its location.

soladmin@soltest2:~$ /usr/ccs/bin/as
bash: /usr/ccs/bin/as: No such file or directory
soladmin@soltest1:~$ ls -lrt /usr/ccs/bin/as
/usr/ccs/bin/as: No such file or directory
soladmin@soltest2:~$ 

Solution:

There is a missing package "developer/assembler"  in Oracle Solaris 11.2  OS. You actually need not have to abort the Installation. Just Install this missing package and retry Installation it should work.

soladmin@soltest2:~$ pkg info developer/assembler
pkg: info: no packages matching the following patterns you specified are
installed on the system.  Try specifying -r to query remotely:

        developer/assembler
soladmin@soltest2:~$ 

-The mentioned above package is not Installed on the host. Make sure you have Full IPS repository configured to Install this missing package.

root@soltest2:~# pkg publisher
PUBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F file:///IPS/
root@soltest2:~# pkg search assembler
INDEX       ACTION VALUE                                          PACKAGE
pkg.fmri    set    solaris/developer/assembler                    pkg:/developer/assembler@0.5.11-0.175.2.0.0.37.0
pkg.summary set    Converts assembler source code to object code. pkg:/developer/assembler@0.5.11-0.175.2.0.0.37.0
root@soltest2:~# 

Install pakcage:

root@soltest2:~# pkg install solaris/developer/assembler

pkg install: The following pattern(s) did not match any allowable packages.  Try
using a different matching pattern, or refreshing publisher information:

	solaris/developer/assembler
root@soltest2:~# pkg install assembler
           Packages to install:  1
       Create boot environment: No
Create backup boot environment: No
DOWNLOAD                                PKGS         FILES    XFER (MB)   SPEED
Completed                                1/1           6/6      0.2/0.2    0B/s

PHASE                                          ITEMS
Installing new actions                         13/13
Updating package state database                 Done 
Updating package cache                           0/0 
Updating image state                            Done 
Creating fast lookup database                   Done 
Updating package cache                           1/1 
root@soltest2:~# 

soladmin@soltest2:~$ pkg info assembler
          Name: developer/assembler
       Summary: Converts assembler source code to object code.
      Category: Development/Other Languages
         State: Installed
     Publisher: solaris
       Version: 0.5.11
 Build Release: 5.11
        Branch: 0.175.2.0.0.37.0
Packaging Date: April 14, 2014 01:02:41 PM 
          Size: 625.46 kB
          FMRI: pkg://solaris/developer/assembler@0.5.11,5.11-0.175.2.0.0.37.0:20140414T130241Z
soladmin@soltest2:~$ 

oracle@soltest2:~$ ls -lrt /usr/ccs/bin/as
-rwxr-xr-x   1 root     bin       632072 Dec 14 09:28 /usr/ccs/bin/as
oracle@soltest2:~$ 

After Installation of package the binary is now available and Installer should proceed further without any Issues. Just click on "retry"



- Installation completed successfully without any Issues.

Thanks for reading.

regards,
X A H E E R

Thursday, 11 December 2014

Adding swap space to Solaris 11.2

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  VALUE  SOURCE
rpool/swap  volsize   5G     local
root@soltest1:~#

 Set new size for SWAP volume


 Its very simple in Solaris 11 to re-size the SWAP volume.

regards,
X A H E E R