Setup and Refresh Local Solaris IPS

Download Latest SRU (Both Repository and Installation Guide) from
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=528645295474932&id=1672221.1&displayIndex=8&_afrWindowMode=0&_adf.ctrl-state=15fchlf0j1_53


The IPS binaries are same for Sparc and X86-64

Assume the files are downloaded in /solarisIPS/download

Unzip the installation guide only, and  install-repo.ksh can be found
Use 11.2.12.6 as sample here.

# mkdir -p /solarisIPS/11.2.12.6/

# ./install-repo.ksh -d /solarisIPS/11.2.12.6/ -c -v

root@goweek01:/solarisIPS# pkg info entire
          Name: entire
       Summary: Incorporation to lock all system packages to the same build
   Description: This package constrains system package versions to the same
                build.  WARNING: Proper system update and correct package
                selection depend on the presence of this incorporation.
                Removing this package will result in an unsupported system.
      Category: Meta Packages/Incorporations
         State: Installed
     Publisher: solaris
       Version: 0.5.11
 Build Release: 5.11
        Branch: 0.175.2.1.0.2.1
Packaging Date: September 23, 2014 10:49:40 PM
          Size: 5.46 kB
          FMRI: pkg://solaris/entire@0.5.11,5.11-0.175.2.1.0.2.1:20140923T224940Z

root@goweek01:/solarisIPS/downloads# pkg publisher
PUBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F http://pkg.oracle.com/solaris/release/

# pkg set-publisher -G '*' -M '*' -g file:///solarisIPS/11.2.12.6 solaris

root@goweek01:/solarisIPS/11.2.12.6# pkg set-publisher -G '*' -M '*' -g file:///solarisIPS/11.2.12.6 solaris
root@goweek01:/solarisIPS/11.2.12.6# pkg publisher
PUBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F file:///solarisIPS/11.2.12.6/

# pkg set-publisher -G '*' -M '*' -g http://pkg.oracle.com/solaris/release/ solaris

# pkgrecv -s http://pkg.oracle.com/solaris/release/ -d /solarisIPS/11.2.12.6 solaris '*'

# pkg update

            Packages to remove:   4                                                                                                                                 
           Packages to install:  36                                                                                                                                 
            Packages to update: 284                                                                                                                                 
            Packages to change:   1                                                                                                                                 
           Mediators to change:   1                                                                                                                                 
       Create boot environment: Yes                                                                                                                                 
Create backup boot environment:  No                                                                                                                                 
DOWNLOAD                                PKGS         FILES    XFER (MB)   SPEED                                                                                     
Completed                            325/325   17884/17884  481.0/481.0    0B/s                                                                                     

PHASE                                          ITEMS
Removing old actions                       3692/3692
Installing new actions                   11695/11695
Updating modified actions                15099/15099
Updating package state database                 Done
Updating package cache                       288/288
Updating image state                            Done
Creating fast lookup database                   Done
Updating package cache                           1/1

A clone of solaris exists and has been updated and activated.
On the next boot the Boot Environment solaris-1 will be     
mounted on '/'.  Reboot when ready to switch to this updated BE.

Updating package cache                           1/1

---------------------------------------------------------------------------
NOTE: Please review release notes posted at:                              

http://www.oracle.com/pls/topic/lookup?ctx=solaris11&id=SERNS
---------------------------------------------------------------------------

root@goweek01:~# pkg info entire
          Name: entire
       Summary: entire incorporation including Support Repository Update (Oracle Solaris 11.2.12.6.0).
   Description: This package constrains system package versions to the same
                build.  WARNING: Proper system update and correct package
                selection depend on the presence of this incorporation.
                Removing this package will result in an unsupported system.  For
                more information see:
                https://support.oracle.com/rs?type=doc&id=1672221.1
      Category: Meta Packages/Incorporations
         State: Installed
     Publisher: solaris
       Version: 0.5.11 (Oracle Solaris 11.2.12.6.0)
 Build Release: 5.11
        Branch: 0.175.2.12.0.6.0
Packaging Date: July 15, 2015 02:05:32 PM
          Size: 5.46 kB
          FMRI: pkg://solaris/entire@0.5.11,5.11-0.175.2.12.0.6.0:20150715T140532Z
root@goweek01:~# pkg publisher
PUBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F file:///solarisIPS/11.2.12.6/
root@goweek01:~# pkg list -af entire
NAME (PUBLISHER)                                  VERSION                    IFO
entire                                            0.5.11-0.175.2.12.0.6.0    i--
entire                                            0.5.11-0.175.2.1.0.2.1     ---
entire                                            0.5.11-0.175.2.1.0.2.0     ---
entire                                            0.5.11-0.175.2.0.0.42.0    ---
entire                                            0.5.11-0.175.1.0.0.24.2    ---
entire                                            0.5.11-0.175.0.10.1.0.0    ---
entire                                            0.5.11-0.175.0.0.0.2.0     ---
entire                                            0.5.11-0.151.0.1           ---

Oracle: Check User Locks

sqlplus system/******** <<ENDSQL> /dev/null
clear buffer
set feedback off
set pause off
column USERID FORMAT A9;
column SID FORMAT 6;
column USER_B FORMAT A9;
column SID_B FORMAT 6;
spool $HOME/userlocks
SELECT rtrim(DECODE(request,0,'Holder: ','Waiter: ')|| v1.sid ||' - ' ||V2.USERNAME) "Session",
       lmode,
       v1.request,
       v2.STATUS,
       v2.COMMAND,
       v2.PROCESS "OS PROCESS",
       v1.type
  FROM V\$LOCK V1,
       V\$SESSION V2
 WHERE (V1.id1, V1.id2, V1.type) IN (SELECT id1, id2, type
                                       FROM V\$LOCK
                                      WHERE request>0)
   AND V1.SID = V2.SID
 ORDER BY v1.id1, v1.request;
/

spool off
ENDSQL

ORA-01858: a non-numeric character was found where a numeric was expected

OS: Solaris 10
JVM Container: WAS 8.0

Problem:

[16/07/15 8:59:58:235 EDT] 00000016 BusinessExcep E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "init" on bean "BeanId". Exception data: <openjpa-2.1.2-SNAPSHOT-r422266:1333100 fatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-01858: a non-numeric character was found where a numeric was expected

Solution:

Set Environment Variable LC_ALL to en_US.UTF-8
echo "Set Locale to use en_US.UTF-8"

LC_ALL=en_US.UTF-8; export LC_ALL

locale

WebSphere: French Character Problem in created file

# cat start_was.sh
#!/bin/sh

echo "Set Locale to use en_US.UTF-8"

LC_ALL=en_US.UTF-8; export LC_ALL

locale

cd /opt/IBM/WebSphere/AppServer/bin
echo "Starting IBM Deployment Manager"
./startManager.sh -profileName $1

echo "Starting NodeAgent"
./startNode.sh -profileName $2

echo "Starting WAS"
./startServer.sh -profileName $2 server1

locale