Monday, February 14, 2011

Oracle 11.2.0.2 on OL6.0

It is not certified yet, but I wanted to check it out, just to see how it is behave differently.
Well, nothing special, following the Oracle 11gR2 installation Guide for Oracle Linux 5 is fine, except for one package (pdksh) which was not required on version 5 but was for version 4 (http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/pre_install.htm#CIHDDFAA).

So, I changed the limits values:
[root@orion4 ~]# tail -10 /etc/security/limits.conf
#ftp             hard    nproc           0
#@student        -       maxlogins       4

# End of file
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              soft    stack   10240
And installed the required RPMs from OL 6.0 DVD :
[root@orion4 Packages]# rpm -Uvh kernel-headers-2.6.32-71.el6.x86_64.rpm
warning: kernel-headers-2.6.32-71.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:kernel-headers         ########################################### [100%]
[root@orion4 Packages]# rpm -Uvh glibc-headers-2.12-1.7.el6.x86_64.rpm
warning: glibc-headers-2.12-1.7.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:glibc-headers          ########################################### [100%]
[root@orion4 Packages]# rpm -Uvh glibc-devel-2.12-1.7.el6.x86_64.rpm
warning: glibc-devel-2.12-1.7.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:glibc-devel            ########################################### [100%]
[root@orion4 Packages]# rpm -Uvh compat-gcc-34-3.4.6-19.el6.x86_64.rpm
warning: compat-gcc-34-3.4.6-19.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:compat-gcc-34          ########################################### [100%]
[root@orion4 Packages]# rpm -Uvh libaio-devel-0.3.107-10.el6.x86_64.rpm
warning: libaio-devel-0.3.107-10.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:libaio-devel           ########################################### [100%]
[root@orion4 Packages]#
[root@orion4 Packages]# rpm -Uvh compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm
warning: compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:compat-libstdc++-33    ########################################### [100%]
[root@orion4 Packages]#
[root@orion4 Packages]# rpm -Uvh elfutils-libelf-devel-0.148-1.el6.x86_64.rpm
warning: elfutils-libelf-devel-0.148-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:elfutils-libelf-devel  ########################################### [100%]
[root@orion4 Packages]#
[root@orion4 Packages]# rpm -Uvh ppl-0.10.2-11.el6.x86_64.rpm
warning: ppl-0.10.2-11.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:ppl                    ########################################### [100%]
[root@orion4 Packages]#  rpm -Uvh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm
warning: cloog-ppl-0.15.7-1.2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:cloog-ppl              ########################################### [100%]
[root@orion4 Packages]#
[root@orion4 Packages]# rpm -Uvh mpfr-2.4.1-6.el6.x86_64.rpm
warning: mpfr-2.4.1-6.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:mpfr                   ########################################### [100%]
[root@orion4 Packages]# rpm -Uvh cpp-4.4.4-13.el6.x86_64.rpm
warning: cpp-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:cpp                    ########################################### [100%]
[root@orion4 Packages]#  rpm -Uvh gcc-4.4.4-13.el6.x86_64.rpm
warning: gcc-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:gcc                    ########################################### [100%]
[root@orion4 Packages]#
[root@orion4 Packages]# rpm -Uvh libstdc++-devel-4.4.4-13.el6.x86_64.rpm
warning: libstdc++-devel-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:libstdc++-devel        ########################################### [100%]
[root@orion4 Packages]#  rpm -Uvh gcc-c++-4.4.4-13.el6.x86_64.rpm
warning: gcc-c++-4.4.4-13.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Preparing...                ########################################### [100%]
   1:gcc-c++                ########################################### [100%]

Then create group, user and folders :
[root@orion4 ~]# groupadd dba
[root@orion4 ~]# useradd -g dba oracle
[root@orion4 ~]# mkdir /apps
[root@orion4 ~]# chmod a+rwx /apps
[root@orion4 ~]# mkdir /oradata
[root@orion4 ~]# chown oracle:dba /oradata
[root@orion4 ~]# su - oracle
[oracle@orion4 ~]$ pwd
/home/oracle
[oracle@orion4 ~]$ vi .bash_profile
[oracle@orion4 ~]$ more .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/apps/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.2
export ORACLE_BIN=$ORACLE_HOME/bin
export PATH=$ORACLE_BIN:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

[oracle@orion4 ~]$

Then started the installer :

 OEL60_Oracle_002  
OEL60_Oracle_005
 OEL60_Oracle_007                 
I skipped a lot of screenshots, they are the same as my previous installation of 11.2.0.2 on OEL 5.3
The change is here below :
OEL60_Oracle_025 
pdksh is not available on OL6.0 package repository, take it from one of the previous versions.
[root@orion4 Packages]#
--> From OEL4.7 (Disk1) – or
http://public-yum.oracle.com/repo/OracleLinux/OL5/6/base/x86_64/
[root@orion4 RPMS]# pwd
/mnt/cdrom/Enterprise/RPMS
[root@orion4 RPMS]# rpm -Uvh pdksh-5.2.14-30.6.x86_64.rpm
warning: pdksh-5.2.14-30.6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID b38a8516: NOKEY
Preparing...                ########################################### [100%]
   1:pdksh                  ########################################### [100%]
[root@orion4 RPMS]#

Then it is continuing without any issue.
…<snipped>…
OEL60_Oracle_029    OEL60_Oracle_033

And eventually, we are able to connect onto the demo database I created during the installation :
[root@orion4 ~]# uname -a
Linux orion4.phoenix.nga 2.6.32-100.28.5.el6.x86_64 #1 SMP Wed Feb 2 18:40:23 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
[root@orion4 ~]# more /etc/redhat-release
Red Hat Enterprise Linux Server release 6.0 (Santiago)
[root@orion4 ~]#
[root@orion4 ~]# su - oracle
[oracle@orion4:/home/oracle]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 13-FEB-2011 17:30:03

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                13-FEB-2011 17:16:22
Uptime                    0 days 0 hr. 13 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /apps/oracle/product/11.2.0.2/network/admin/listener.ora
Listener Log File         /apps/oracle/diag/tnslsnr/orion4/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orion4.phoenix.nga)(PORT=1521)))
Services Summary...
Service "demo112" has 1 instance(s).
  Instance "demo112", status READY, has 1 handler(s) for this service...
Service "demo112XDB" has 1 instance(s).
  Instance "demo112", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@orion4:/home/oracle]$ export ORACLE_SID=demo112
[oracle@orion4:/home/oracle]$ sqlplus scott/demo112

SQL*Plus: Release 11.2.0.2.0 Production on Sun Feb 13 17:30:16 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-28000: the account is locked

Enter user-name: ^C
[oracle@orion4:/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Feb 13 17:30:25 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user scott account unlock;

User altered.

SQL> conn scott/tiger
ERROR:
ORA-28001: the password has expired

Changing password for scott
New password:
Retype new password:
Password changed
Connected.
SQL> desc emp
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
EMPNO                                     NOT NULL NUMBER(4)
ENAME                                              VARCHAR2(10)
JOB                                                VARCHAR2(9)
MGR                                                NUMBER(4)
HIREDATE                                           DATE
SAL                                                NUMBER(7,2)
COMM                                               NUMBER(7,2)
DEPTNO                                             NUMBER(2)

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL>

Enjoy it !

No comments: