2012/02/04

SOA Suite Installation on Oracle Linux 5.7

Valentine's Day 2012 V
According to Oracle official web page currently the SOA Suite can be installed only on 32-bit JVM.
In this article, we will install WebLogic, RCU, SOA Suite and JDeveloper.

OS Package Installation

compat-db-4.1.25-9
sysstat-5.0.5-1

Kernel Parameters OS Resource Limitation

/etc/security/limits.conf
*    hard    nofile    4096
*    soft     nofile    4096
image

Install WebLogic

In the Welcome windows, Next
image
Select Create a new Middleware Home, and give the Middleware Home Directory, then Next
image
opt out I wish to receive security updates via My Oracle Support, then Next
image
Choose Typical as Install type, this will install WebLogic Server & Oracle Coherence, then Next
image
Specify the directory of WebLogic Server and Oracle Coherence, then Next
image
Review the Installation Summary, if no problem, then Next
image
Installing
image
opt out the Run Quickstart then Done
image

Install RCU DB Schemas

In Welcome window, Next
image
Choose Create, then Next
image
Give the database connection information, then Next
image
After the check, then OK
image
Accept the default new Prefix DEV, opt-in the SOA and BPM Infrastructure, this will automatically opt-in Metadata Services under AS Common Schemas, then Next
image
After the check again, then OK
image
Give the password for all schemas, then Next
image
Review the Tablespaces, then Next
image
Because we do not have any tablespaces in previous review, so OK
image
Tablespaces created, then OK
image
Review the Summary, then Create
image
Repository created, then Close
image

Install SOA Suite

Give the JDK location under previous WebLogic Middleware Home
image
Accepted the default. You should have a group named oinstall already. Then OK
image
Need root privileges to run the createCentralInventory.sh
image
Logon as root and go to the directory previous dialog specified run the createCentralInventory.sh
image
Go back to the previous dialog, then OK
image
In Welcome screen, Next
image
Choose Skip Software Updates, then Next
image
Make sure the Prerequisite Checks are all passed, then Next
image
Specify the Oracle Middleware Home and accept the default name for Oracle Home Directory (this will be our DOMAIN_HOME), then Next
image
Accept the WebLogic Server as Application Server, then Next
image
Review the Installation Summary, then Install
image
Installing
image
Completed, then Next
image
Installation Complete, Finish
image

Configure SOA Suite

Under $DOMAIN_HOME/common/bin
./config.sh
image
Choose Create a new WebLogic domain, then Next
image
Check the following products, then Next
image
Give the Domain name, Domain location, and Application location, then Next
image
Give weblogic password, then Next
image
Choose Development Mode and Sun SDK, then Next
image
Check all the Component Schema, give the password (Created in RCU), and connection information, then Next
image
All the Component Schema tested, then Next
image
Check only Administration Server, then Next
image
Use default value for Administration Server, then Next
image
Review Configuration Summary then Create
image
Creating New Domain
image
Done
image

Install JDeveloper

In the Welcome window, Next
image
Choose Create a new Middleware Home, and give a new directory for JDeveloper, then Next
image
Choose Complete as Install Type, then Next
image
Confirm the directories are all right, then Next
image
Review the Installation Summary, then Next
image
JDeveloper installing...
image
uncheck the Run Quickstart, then Done
image

Install SOA Extension on JDeveloper

Choose Default Role when you first time run the JDeveloper, then OK
image
Depends on you want to report your usuage to Oracle or not, then OK
image
In menu Help > Check for Updates
image
In Welcome window, Next
image
Check Oracle Fusion Middleware Products and Official Oracle Extensions and Updates, then Next
image
Check Oracle BPM Studio 11g and Oracle SOA Composite Editor, then Next
image
The update is downloading...
image
Extension installed, Finish
image
Yes and restart the JDeveloper
image

Appendix

cd $DOMAIN_HOME/bin
./startWebLogic.sh to start the SOA Platform
We will see the SOA Platform is running and accepting requests to know the server is ready.
image
Browse yoursoaserverip:7001/console
image
Logon as weblogic and password you specified previously, then Login
image
We will see the server is ready, Yay!
image

Reference Oracle SOA Suite 11g Installations Document

2012/01/31

Oracle Database 11gR2 Installation (Oracle Linux 5.7)


Memory Requirement

Minimum: 1 GB of RAM
Recommended: 2 GB of RAM or more
To determine the RAM size, enter the following command:
# grep MemTotal /proc/meminfo

Available RAMSwap Space Required
Between 1 GB and 2 GB1.5 times the size of the RAM
Between 2 GB and 16 GBEqual to the size of the RAM
More than 16 GB16 GB


# grep SwapTotal /proc/meminfo

Package Requirment


The following or later version of packages for Asianux 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 must be installed:
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2

Oracle ODBC Drivers


On Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5:


  • unixODBC-2.2.11 (32-bit) or later

  • unixODBC-devel-2.2.11 (64-bit) or later

  • unixODBC-2.2.11 (64-bit) or later

Create Required Operating System Groups and Users


The following local operating system groups and users are required if you are installing Oracle Database:


  • The Oracle Inventory group (typically, oinstall)

  • The OSDBA group (typically, dba)

  • The Oracle software owner (typically, oracle)

  • The OSOPER group (optional. Typically, oper)

To determine whether these groups and users exist, and if necessary, to create them, follow these steps:


  1. To determine whether the oinstall group exists, enter the following command:
    # more /etc/oraInst.loc

    If the output of this command shows the oinstall group name, then the group exists.
    If the oraInst.loc file exists, then the output from this command is similar to the following:
    inventory_loc=/u01/app/oraInventory
    inst_group=oinstall

    The inst_group parameter shows the name of the Oracle Inventory group, oinstall.

  2. To determine whether the dba group exists, enter the following command:
    # grep dba /etc/group

    If the output from this commands shows the dba group name, then the group exists.

  3. If necessary, enter the following commands to create the oinstall and dba groups:
    # /usr/sbin/groupadd oinstall
    # /usr/sbin/groupadd dba

  4. To determine whether the oracle user exists and belongs to the correct groups, enter the following command:
    # id oracle

    If the oracle user exists, then this command displays information about the groups to which the user belongs. The output should be similar to the following, indicating that oinstall is the primary group and dba is a secondary group:
    uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)

  5. If necessary, complete one of the following actions:


    • If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, then enter the following command:
      # /usr/sbin/usermod -g oinstall -G dba oracle

    • If the oracle user does not exist, enter the following command to create it:
      # /usr/sbin/useradd -g oinstall -G dba oracle

      This command creates the oracle user and specifies oinstall as the primary group and dba as the secondary group.

  6. Enter the following command to set the password of the oracle user:
    # passwd oracle

Configuring Kernel Parameters


Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following:
Note:
Include lines only for the kernel parameter values to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the minimum value, then specify the larger value.
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
 
sysctl –p 
 
Check Resource Limits for the Oracle Software Installation Users

If necessary, update the resource limits in the /etc/security/limits.conf configuration file for the installation owner. For example, add the following lines to the /etc/security/limits.conf file:
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              soft    stack   10240

Creating Required Directories

# mkdir -p /u01/app/
# chown -R oracle:oinstall /u01/app/
# chmod -R 775 /u01/app/



Installation


./runInstaller

uncheck the checkbox, then Next

image

Yes

image

Create and configure a database, then Next

image

Choose Server Class, then Next



image

Choose Single instance database installation, then Next

image

Choose Typical install, then Next

image

Give Global database name, and Administrative password, note that there are some restrictions about the password, then Next

image

Give the oracle inventory directory and specify the oraInventory Group Name to oinstall, then Next

image

This part is weired, I cannot pass it, so I choose Ignore All, then Next

image

We're ready to install the database software, Finish

image

dbca is running

image

to keep use the same administrator password click OK

image

when the installer prompt you the instruction logon as root and run the script in specified directories

orainstRoot.sh

image

root.sh

image

The prompt screen, after finish previous two steps, then OK

image

The database in installed, enterprise manager can be accessed via https://yourhostname:1158/em

image



Recommended Postinstallation Tasks


Backup root.sh ->  just copy the root.sh to some where else

utlrp.sql ->

. /usr/local/bin/oraenv

image

sqlplus / as sysdba

@?/rdbms/admin/utlrp.sql

image

cd $ORACLE_HOME/bin

./genclntst

image

Reference Oracle Official Document

Appendix


5.2.8 Enabling and Disabling Database Options

When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the chopt tool. See Example 5-1.
The chopt tool is a command-line utility that is located in the ORACLE_HOME/bin directory. The syntax for chopt is:
chopt [ enable | disable] db_option

The possible values for db_option are described in the following table:

































ValueDescription
dmOracle Data Mining RDBMS Files
dvOracle Database Vault
lbacOracle Label Security
olapOracle OLAP
partitioningOracle Partitioning
ratOracle Real Application Testing
ode_netOracle Database Extensions for .NET 1.x
ode_net_2Oracle Database Extensions for .NET 2.0

Example 5-1 Complete Example of Running the Chopt Tool
To enable the Oracle Label Security option in your Oracle binary files, use the following command:
cd %ORACLE_HOME%
srvctl stop database -d myDb
chopt enable lbac
srvctl start database -d myDb

Oracle Enterprise Manager Cloud Control Installation(Oracle Linux)


The installation begins…

We've done the previously prerequisite check
opt-out the option of security update via My Oracle Support if you don't have a Oracle Support account, then Next

image


Yes
image
Skip the Software Updates, then Next
image
Next
image
We'll install a Simple Enterprise Manager System, and Middleware Home Location is the where you want to install the software (binary), Next
image
Input the Administrator Password twice and give the repository database connection information, then Next

image
Because my default Oracle 11g R2 database will install Database Control automatically, we need to follow the instruction to remove that Database Control on repository database.
image
Do the following instruction
cd $ORACLE_HOME/bin
emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys_password> -SYSMAN_PWD <sysman_password>
image
Answer Yes
image
These are something need to be set on repository database, we can do this later, OK

image
We're ready to install the Enterprise Manager Cloud Control 12c, Install

image

After few hours installation (mine is 5 hours, slow machines!)
image
logon as root cd to the directory that installer told you and run allroot.sh

image
Back to the screen and press OK
image
https://ol57ap.telus.net:7102/console
image
After login
image

2012/01/28

Oracle Database 11g Release 2(11.2) Express Edition Installation(Oracle Linux)


Package Requirements

  • glibc should be greater than or equal to 2.3.4-2.41
  • make should be greater than or equal to 3.80
  • binutils should be greater than or equal to 2.16.91.0.5
  • gcc should be greater than or equal to 4.1.2
  • libaio should be greater than or equal to 0.3.104
 

Kernel Parameter Requirements

Table 2 Kernel Parameter Settings Required for Oracle Database XE
Kernel Parameter Setting
semmsl
250
semmns
32000
semopm
100
semmni
128
shmmax
4294967295
shmmni
4096
shmall
2097152
file-max
6815744
VERSION
2.4.21
ip_local_port_range
9000–65500


Installation

rpm -ivh downloads/oracle-xe-11.2.0-1.0.x86_64.rpm
 

Configuration




  • A valid HTTP port for the Oracle Application Express (the default is 8080)

  • A valid port for the Oracle database listener (the default is 1521)

  • A password for the SYS and SYSTEM administrative user accounts

  • Confirm password for SYS and SYSTEM administrative user accounts

  • Whether you want the database to start automatically when the computer starts (next reboot)
 

Usuage


To start the database manually, run this command as root user:
# /etc/init.d/oracle-xe start

To stop the database manually, run the following command as root user:
# /etc/init.d/oracle-xe stop
 
Referenced from Oracle 


2012/01/27

Expand existing disk on VM Oracle Linux


VMWare Client Setting

Change the Hard Disk by double click
image
Utilities > Expand

image
Change the Maximum disk size to desired size, and Expand
image

Oracle Linux Setting


Turn on your Oracle Linux, type fdisk /dev/sda
p to see current partion status
n for new partition
give 3 to use next partition number, currently is 2
we use the whole increased space so accept the default cylinder parameter
and w to write the partition table to disk and exit
image
The result message want us to do a reboot, so do it.

image
After reboot still logon as root
pvcreate /dev/sda3
to create a physical volume
image
vgextend VolGroup00 /dev/sda3
to add the physical volume to volume group
image
vgdisplay
to see current Volume Group
image
We have 20G free to add volume group
lvextend -L+20G /dev/VolGroup00/LogVol00
image
resize2fs /dev/VolGroup00/LogVol00
image
Congratulation! You’ve sucessfully increase new space and can be used in your Oracle Linux on VMWare

Reference url
http://www.techotopia.com/index.php/Adding_a_New_Disk_to_an_RHEL_5_Volume_Group_and_Logical_Volume
http://echenh.blogspot.com/2010/04/how-to-extend-lvm-on-vmware-guest-os.html

RPM Usuage

To remove a rpm package
rpm -e <package name>

To install a rpm package
rpm -ivh <package name>

To query a rpm name
rpm -qa  <part of package name> Valentine's Day 2012 V

Oracle Enterprise Manager Cloud Control Installation Precheck(Oracle Linux)

OS Library

For example, if you run the command on a 32-bit system, you should see something similar to the following:
glibc-devel-2.3.4-2.43(i386)
glibc-headers-2.3.4-2.43(i386)
glibc-2.3.4-2.43(i686)
compat-glibc-headers-2.3.2-95.30(i386)
glibc-profile-2.3.4-2.43(i386)
glibc-utils-2.3.4-2.43(i386)
glibc-kernheaders-2.4-9.1.103.EL(i386)
glibc-common-2.3.4-2.43(i386)
compat-glibc-2.3.2-95.30(i386)

For example, if you run the command on a 64-bit system, you should see something similar to the following:
glibc-common-2.3.4-2.43(x86_64)
glibc-devel-2.3.4-2.43(x86_64)
glibc-profile-2.3.4-2.43(x86_64)
glibc-headers-2.3.4-2.43(x86_64)
glibc-utils-2.3.4-2.43(x86_64)
glibc-2.3.4-2.43(x86_64)
 
And sysstat-5.0.5
 

Kernel Parameter Requirements


For installing an OMS or a Management Agent on Unix operating systems (32-bit or 64-bit), set the kernel.shmmax parameter to a value 1 byte less than 4 GB or 4294967295.
Oracle recommends this value to avoid lack of memory issues for other applications and to enable a complete and successful core file generation under any and all circumstances.
To verify the value assigned to kernel.shmmax parameter, run the following command:
cat /proc/sys/kernel/shmmax
To set the value for kernel.shmmax parameter, run the following command:
sysctl -w kernel.shmmax=<new value>
 
Reference from Oracle Document
 

unzip Issue

 
But I could not install it via runInstaller at all.
After some research there is a solution for this
 

EM Cloud Control 12c RunInstaller Command Fails Before Launching Installer GUI With java.lang.NullPointerException In oraInstall_xxx.err File [ID 1369904.1]
The "unzip" binary provided by Oracle is in fact not able to correctly unzip the provided zip files for the Cloud Control installation.
Another release of the unzip should be downloaded from here: https://updates.oracle.com/unzips/unzips.html
The following version is needed:
# LINUX Intel (32bit and 64bit - Large file support)
Once this utility has been downloaded, proceed as described below :
oracle@vmtestoraem12c:/u01/app/software/em12c/ [rdbms1120] gzip -d unzip60_lnx.Z
oracle@vmtestoraem12c:/u01/app/software/em12c/ [rdbms1120] chmod u+x unzip60_lnx
oracle@vmtestoraem12c:/u01/app/software/em12c/ [rdbms1120] ./unzip60_lnx em12_linux64_disk1of2    



Thanks to Yann Neuhaus, he recorded the detail of this.



Other notice


unzip the em12_linux64_disk1of2.zip & em12_linux64_disk2of2.zip into the same folder