Oracle for humans

How to Install and configure Oracle gateway for MS SQL server

2014-07-28T17:38:00.000+02:00

In this demo VMware Fusion (or for Windows VMware workstation), Enterprise-R5-U5-Server-i386-dvd.iso, Oracle Database Gateways 11g Release 2 (11.2.0.1.0) for Linux x86-64 will be used.

--> Make a directory for gateway software installation by running following commandmkdir -p /data/app/gateway

Go to the installation directory end run the runInstaller:

[oracle@samir gateways]$ pwd
/mnt/hgfs/SOFTWARE/gateways
[oracle@samir gateways]$ ./runInstaller

Choose next
-->

Choose the name and the location for the software (the directory we made three steps above), also if you want you select different or additional language you can do that now.

Name = oracle2mssqlserver
Path = /data/app/gateway

-->

For available components choose Oracle database gateway for Microsoft SQL server

Check dependencies

--> In the next screen we will need following:

1. SQL server database server host name : mssqlserver
2. SQL server Database server port number : 1433
3. SQL server instance name : WINMINI-MSSQL\SAMIR
4. SQL server database name : home

--> NB

The port number and the server instance name can be detected on two different ways:

Open "SQL Server Configuration Manager" and check properties of "Network Configuration" , scroll down and find portnr.

Running following query in MS SQL database can show you juist servername
select @@ServerName

Press “Next”

Check summary end press install.

-->

In a moment you have to run the root.sh script

-->

As root run following script in the terminal:

/data/app/oracle/root.sh
[root@samir Server]# /data/app/gateway/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /data/app/gateway
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: n
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: n
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: n
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

Press OK

-->

If you already have one listener, you can manually add the required lines or you can use the GUI to add the default LISTENER.

-->

I add the listener entries manually.

Press CANCEL followed by YES

Done

Hopefully there should be no error errors, but check log file just in case.

Configuration assistant "Oracle Net Configuration Assistant" failed
-----------------------------------------------------------------------------
The "/data/app/gateway/cfgtoollogs/configToolFailedCommands" script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.

cat /data/app/gateway/cfgtoollogs/configToolFailedCommands
# Copyright (c) 1999, 2009, Oracle. All rights reserved.
/data/app/gateway/bin/netca /orahome /data/app/gateway /orahnam oracle2mssqlserver /instype custom /inscomp client,oraclenet,server /insprtcl tcp /cfg local /authadp NO_VALUE /responseFile /data/app/gateway/network/install/netca_typ.rsp

No errors, I have canceled installation of listener.

Press NEXT + exit.

Next step will be Gateway configuration:

-->

In directory /data/app/gateway/ dg4msql/admin/ you can find files that Oracle produced during the installation.

One od them is initdg4msql.ora , in which the important setting for connection to the MSSQL server are stored.

You don’t need to change anything here.

cat initdg4msql.ora

HS_FDS_CONNECT_INFO=[mssqlserver]:1433//home
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

Lets check Listener.
-->

Lines necessary for listener are written in red.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl01)
(ORACLE_HOME = /data/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl01)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl02)
(ORACLE_HOME = /data/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl02)
)
(SID_DESC =
(SID_NAME=dg4msql)
(ORACLE_HOME=/data/app/gateway)
(PROGRAM=dg4msql)
(ENVS=LD_LIBRARY_PATH=/data/app/gateway/dg4msql/driver/lib;/data/app/oracle/product/11.2.0/dbhome_1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = samir)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /data/app/oracle

lsnrctl

LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 29-OCT-2013 10:57:26
Uptime 0 days 8 hr. 57 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /data/app/oracle/diag/tnslsnr/samir/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=samir)(PORT=1521)))
Services Summary...
Service "dg4msql" has 1 instance(s).
Instance "dg4msql", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl01" has 2 instance(s).
Instance "orcl01", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl01", status READY, has 1 handler(s) for this service...
Service "orcl01XDB" has 1 instance(s).
Instance "orcl01", status READY, has 1 handler(s) for this service...
Service "orcl02" has 1 instance(s).
Instance "orcl02", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

--> Check tnsnames , add following red block to tnsnames.ora

ORCL02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = samir)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl02)
)
)
ORCL01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = samir)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl01)
)
)
dg4msql =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST=samir)(PORT=1521))
(CONNECT_DATA = (SID=dg4msql))
(HS=OK)
)

-->

Lets check if we now have connection from the Oracle database to the MSSQL server database:

[oracle@samir ~]$ sqlplus / as sysdba
SQL> ; select name from v$database;
NAME
---------
ORCL01

create public database link micro
connect to "ja"
identified by "******"
using 'dg4msql';

SQL> select count (*) from racun@micro;
COUNT(*)
----------
19434

SQL> desc myracun
ERROR:
ORA-04043: object myracun does not exist

SQL> create view myracun
as
select * from racun@micro
/
View created.

SQL> desc myracun
Name Null? Type
----------------------------------------- -------- ---------------
Datum NOT NULL VARCHAR2(12)
Rekening NOT NULL NVARCHAR2(34)
Begunstigde NOT NULL NVARCHAR2(45)
Tegenrekening NOT NULL NVARCHAR2(34)
Bedrag NOT NULL NUMBER(9,2)
Mutatiecode NOT NULL NVARCHAR2(45)
Mededelingen NOT NULL NVARCHAR2(260)
Mutatiepost NOT NULL NVARCHAR2(45)

SQL> select count (*) from myracun;
COUNT(*)
----------
19434
NB
-->

Make sure that you use the user with the correct password from MSSQL database, in this case database “home”.

Video tutorial - Oracle 12cR1 - Target Database

2014-07-28T14:51:00.004+02:00

Target Database

How to Restore saved appliance and configure it
How to rename new appliance using system-config-network-tui, attach new network card and configure it
How to Install Oracle 12cR1 RDBMS and create database
How to configure Firefox and Adobe Flash player for Enterprise Manager data Control 12c

Please note that you can change quality for all videos up to 1080p HQ and watch it in full screen.

Video tutorial - Oracle 12cR1 - How to Install Oracle RDBMS and Oracle 12cR1 on ASM

2014-07-28T14:51:00.001+02:00

Oracle RDBMS and Oracle 12cR1 on ASM

How to Install Oracle RDBMS and Oracle 12cR1 on ASM
How to Install Oracle RDBMS 12cR1 On Oracle Linux
How to Using DBCA to Create and Configure a Database 12cR1 on ASM
How to Configure database as container database
How to Configure configure container database with PDB's (pluggable databases).
https://www.youtube.com/watch?v=h61hPiF_6Xc

Please note that you can change quality for all videos up to 1080p HQ and watch it in full screen.

Video tutorial - Oracle 12cR1 - How to Create ASM instance for a Stand-Alone Server

2014-07-28T14:49:00.001+02:00

ASM instance 12c

How to Export Appliance for backup or clone
How to Install GRID infra structure for a Stand-Alone Server
How to Create ASM instance
How to Create ASM disk groups with "asmca" or manually

Probably you will like to save this image for later so that you don't have to install same thing again and again. First 1 min and 49 sec show how to export and save appliance for reuse.

Please note that you can change quality for all videos up to 1080p HQ and watch it in full screen.

Video tutorial - Oracle 12cR1 - How to Instal Oracle Linux 6.5 and Oracle ASM library driver on Oracle Virtual Box

2014-07-28T14:49:00.000+02:00

VirtualBox Oracle ASM library driver

How to Instal Oralce Linux and Oracle ASM library driver on Virtual Box
How to prepare and configure Oracle Virtual Box for Linux and ASM.
How to prepare Virtual Box for Oracle Linux 6.5
How to install Oracle Linux 6.5 on Virtual Box
How to install external tools
How to install kernel-uek-devel-"$(uname -r)" by Oracle for automatically complete default operating system configurations
How to install the Oracle RDBMS Pre-Install RPM
How to install Oracle Grid Infrastructure and Oracle Database releases
How to update Linux release.

Please note that you can change quality for all videos up to 1080p HQ and watch it in full screen.

How to Install Oracle 11r2 database on ASM

2010-05-21T16:01:00.001+02:00

NB. To enlarge image click on 
    If you want to size down image just click two time on it.

In this demo VMware Fusion (for Windows VMware workstation),
Enterprise-R5-U5-Server-i386-dvd.iso, Oracle Database Grid Infrastructure, Oracle 11gR2 and ASMlibs will be used.

Database creation

Log on as oracle user and run runInstaler.

cd /mnt/hgfs/SOFTWARE/database
./runInstaler

Since this is only a test installation we do not want to receive email from Oracle, therefore:

Install database software only:

Single instance database installation:

Languages = English

Enterprise edition, for extra option you should select “Select Option”

Use default for Oracle Base end Software Location
Oracle_base=/data/app/oracle

DBA group i default group

Click on "Fix & Check again"

run the root.sh script and accept defaults

Select “ignore all” and click “Next”.

Create new listener using netca
[oracle@oraasm-primary bin]$ netca

Oracle Net Services Configuration:
Configuring Listener:LISTENER
Listener configuration complete.
Oracle Net Listener Startup:
Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0

[oracle@oraasm-primary bin]$ crsctl status resource ora.LISTENER.lsnr
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on oraasm-primary
or
[oracle@oraasm-primary bin]$ srvctl config listener
Name: LISTENER
Home: /data/app/11.2.0/grid
End points: TCP:1521
[oracle@oraasm-primary bin]$

update orataf file
cat >> /etc/oratab << EOF
rdbms112:/data/app/oracle/product/11.2.0/dbhome_1:N
EOF

Execute the next command in terminal as oracle user
[oracle@oraasm-primary bin]$ . oraenv -v

ORACLE_SID = [+ASM] ? rdbms112
The Oracle base for ORACLE_HOME=/data/app/oracle/product/11.2.0/dbhome_1 is /data/app/oracle
[oracle@oraasm-primary bin]$ dbca

On the next screen select “use the same Administrative password for all accounts”. For production installations this might not be appropriate but it is acceptable for this demonstration.

Click “next” and then “YES”
1. Select “automatic Storage Management (ASM)
2. Click “Browse” and select the disk group you want to use for data files (DG1)

Specify asmsnmp password specific to ASM: oracle

Choose space for FRA.

Mark “Enable Archiving”
Keep default: “Next”

Keep default: “Next”

Highlight “Create Database” and “generate database creation scripts” buttons. It is always useful to be able to review the scripts after installation.

Done. We have now an Oracle database running on Linux enterprise using ASM as storage.

How to install and configure ASM

2010-05-21T12:38:00.001+02:00

In this demo VMware Fusion (for Windows VMware workstation),
Enterprise-R5-U5-Server-i386-dvd.iso, Oracle Database Grid Infrastructure, Oracle 11gR2 and ASMlibs will be used.

Installing Automatic Storage Management (ASM)

For Linux systems Oracle provides a custom device driver known as ASMLib, which is recommended for most ASM installations on Linux. ASMLib is available for free download from OTN.
Determine the Version of ASMLib you need
ASMLib 2.0 is delivered as a set of three RPM packages.
• oracleasmlib-2.0 - the ASM libraries
• oracleasm-support-2.0 - utilities needed to administer ASMLib
• oracleasm - a kernel module for the ASM library that is specific to each kernel
Each Linux distribution has its own set of ASMLib 2.0 packages (OEL 5 uses the same RPMs as Red Hat Enterprise Linux 5 AS). Within each distribution, each kernel version has a corresponding oracleasm package.

Install asmlibs

First determine which kernel you are using by logging in as root and running the following command:
[root@oraasm-primary Server]# uname -rm
2.6.18-194.el5 i686

The example shows that this is a 2.6.18 kernel, patch level 5, for Enterprise Linux 5 on 32-bit x86 compatible hardware (i686).
Use this information to find the correct ASMLib packages on OTN:
1. Point your Web browser to http://www.oracle.com/technology/tech/linux/asmlib/index.html
2. Select the link for your version of Linux (OEL5 users may use the Red Hat Enterprise Linux 5 AS).
3. Download the oracleasmlib and oracleasm-support packages for your version of Linux. The files are grouped by architecture (AMD64 / Intel em64t for x86_64, IA64 for Itanium, and IA32 for x86).
At the top of each section is a Library and Tools heading. Download both of the files under this heading - these are the support utilities and ASM libraries (oracleasm-support and oracleasmlib, respectively).
4. Next, download the oracleasm package corresponding to your kernel. In the example above, the oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm package was used. Note that there are two or three drivers listed under most of
the kernel versions.
For example:
Drivers for kernel 2.6.18-194.el5
* oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm
* oracleasm-support-2.1.3-1.el5.i386.rpm
* oracleasmlib-2.0.4-1.el5.i386.rpm
5. Next, install the packages by executing the following command as root:
rpm -Uvh oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm oracleasm-support-2.1.3-1.el5.i386.rpm oracleasmlib-2.0.4-1.el5.i386.rpm

[root@oraasm-primary SOFTWARE]# rpm -Uvh oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm oracleasm-support-2.1.3-1.el5.i386.rpm oracleasmlib-2.0.4-1.el5.i386.rpm
warning: oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:oracleasm-support ########################################### [ 33%]
2:oracleasm-2.6.18-194.el########################################### [ 67%]
3:oracleasmlib ########################################### [100%]
[root@oraasm-primary SOFTWARE]#

Configuring ASMLib

Before using ASMLib, you must run a configuration script to prepare the driver. Run the following command as root, and answer the prompt questions as shown in the example below.
[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting without typing an
answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]

Execute the "fdisk" command to partition the disks that will be used for the ASM storage. We will first format disks from sdb to sdg. The following output shows the expected fdisk output for the sdb disk.

First check disks

[root@oraasm-primary SOFTWARE]# ls -l /dev/sd*
brw-r----- 1 root disk 8, 0 Apr 24 2010 /dev/sda
brw-r----- 1 root disk 8, 1 Apr 24 16:51 /dev/sda1
brw-r----- 1 root disk 8, 2 Apr 24 2010 /dev/sda2
brw-r----- 1 root disk 8, 16 Apr 24 2010 /dev/sdb
brw-r----- 1 root disk 8, 32 Apr 24 2010 /dev/sdc
brw-r----- 1 root disk 8, 48 Apr 24 2010 /dev/sdd
brw-r----- 1 root disk 8, 64 Apr 24 2010 /dev/sde
brw-r----- 1 root disk 8, 80 Apr 24 2010 /dev/sdf
brw-r----- 1 root disk 8, 96 Apr 24 2010 /dev/sdg

Then execute the fdisk command:
[root@oraasm-primary SOFTWARE]# fdisk /dev/sdb

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-652, default 1): press "enter"
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-652, default 652): press "enter"
Using default value 652

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
Repeat the same procedure for /dev/sdc, /dev/sdd, /dev/sde, /dev/sdf, /dev/sdg

Next you instruct the ASM driver which disks to use. Oracle recommends that each disk contain a single partition for the entire disk. See Partitioning the Disks at the beginning of this section for an example of creating disk partitions.
Mark disks to be used by ASMLib by running the following command as root:
/etc/init.d/oracleasm createdisk DISK_NAME device_name

[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
Marking disk "VOL1" as an ASM disk: [ OK ]
[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1
Marking disk "VOL2" as an ASM disk: [ OK ]
[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm createdisk VOL3 /dev/sdd1
Marking disk "VOL3" as an ASM disk: [ OK ]
[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm createdisk VOL4 /dev/sde1
Marking disk "VOL4" as an ASM disk: [ OK ]
[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm createdisk VOL5 /dev/sdf1
Marking disk "VOL5" as an ASM disk: [ OK ]
[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm createdisk VOL6 /dev/sdg1
Marking disk "VOL6" as an ASM disk: [ OK ]

Verify that ASMLib has marked the disks:
[root@oraasm-primary SOFTWARE]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4
VOL5
VOL6
[root@oraasm-primary SOFTWARE]#

Installing Oracle GRID software

Download Oracle Database 11g Release 2 Grid Infrastructure from Oracle site, uncompress files and copy them to the shared directory.
Login in as oracle user and go to the directory where you saved Oracle installation software.

run ./runInstaller

Select Grid Infrastructure Only

Languages: English

Dba group will be the default group for all

Select for YES

We already made our directory structure in /data/app and this will be used.
ORACLE_BASE = /data/app/oracle

After you click “next” you have to wait for couple of seconds until the next screen is displayed.
Select NEXT on following screen.

Select "Fix & Check Again" on following screen.

Start new terminal session and type the following command:

[oracle@oraasm-primary ~]$ su
Password:
[root@oraasm-primary oracle]# /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh

Click on "OK" button.

The “Swap size” and the “Network Time Protocol” warnings can be ignored at this stage.
Mark “Ignore all” and click “Next” and on the next screen click “Finish”.

Press FINISH
Installation will take approximately 10 min

The next stage is the root.sh script.

Startanextra terminal and use the su command to log in as root
Step one:
run /data/app/oraInventory/orainstRoot.sh

Second step:
run /data/app/11.2.0/grid/root.sh and accept defaults.

Read the screen output and run the scripts as requested. Here the next step is executed as:
/data/app/11.2.0/grid/perl/bin/perl -I/data/app/11.2.0/grid/perl/lib -I/data/app/11.2.0/grid/crs/install /data/app/11.2.0/grid/crs/install/roothas.pl

Click 'OK' on “Execute Configuration scripts” to finish the installation

Creating an ASM instance

Start a terminal session as “oracle” user. To set up oratab add the following line to /etc/oratab

cat >> /etc/oratab << EOF
+ASM:/data/app/11.2.0/grid:N
EOF

[oracle@oraasm-primary ~]$ . oraenv -v
ORACLE_SID = [+ASM] ?
The Oracle base for ORACLE_HOME=/data/app/11.2.0/grid is /data/app/oracle

Create the init+ASM.ora file in $ORACLE_HOME/dbs
cat >> /data/app/11.2.0/grid/dbs/init+ASM.ora << EOF
instance_type=asm
large_pool_size=12M
remote_login_passwordfile=exclusive
EOF

Check if cssd is running:
[oracle@oraasm-primary ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.cssd ora.cssd.type OFFLINE OFFLINE
ora.diskmon ora....on.type OFFLINE OFFLINE

NO cssd is offline.
[oracle@oraasm-primary ~]$ crs_start ora.cssd
Attempting to start `ora.cssd` on member `oraasm-primary`
Attempting to start `ora.diskmon` on member `oraasm-primary`
Start of `ora.diskmon` on member `oraasm-primary` succeeded.
Start of `ora.cssd` on member `oraasm-primary` succeeded.

Check now again.
[oracle@oraasm-primary ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.cssd ora.cssd.type ONLINE ONLINE oraa...mary
ora.diskmon ora....on.type ONLINE ONLINE oraa...mary
[oracle@oraasm-primary ~]$

Up & running, ok.
We should create spfile for our +ASM instance

[oracle@oraasm-primary ~]$ srvctl status asm
PRCR-1001 : Resource ora.asm does not exist
[oracle@oraasm-primary ~]$ srvctl add asm -p /data/app/11.2.0/grid/dbs/initASM.ora
[oracle@oraasm-primary ~]$ srvctl status asm
ASM is not running.
[oracle@oraasm-primary ~]$ srvctl start asm
[oracle@oraasm-primary ~]$ srvctl status asm
ASM is running on oraasm-primary

srvctl modify asm -p /data/app/11.2.0/grid/dbs/spfile+ASM.ora

SQL> sho parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /data/app/11.2.0/grid/dbs/spfile+ASM.ora

Creating DISKGROUPS

col PATH format a10
col name format a10
col FAILGROUP format a10
col label format a10
set lines 200

SELECT name
, type
, round (total_mb/1024 ,2) "Total GB"
, round (free_mb/1024 ,2) "Free GB"
, round (free_mb/total_mb*100 ,2) " Free %"
, round (usable_file_mb /1024 ,2)"Usable GB"
, required_mirror_free_mb/ 1024 "Required Mirros GB"
FROM V$ASM_DISKGROUP;

No rows

SELECT path
, round (OS_MB /1024 , 2) OS_GB
, round (TOTAL_MB/1024 , 2) TOTAL_GB
, round (FREE_MB/1024 , 2 ) FREE_GB
, round (HOT_USED_MB/1024 , 2 ) HOT_USED_GB
, round (COLD_USED_MB/1024 , 2 ) COLD_USED_GB
, FAILGROUP
, LABEL
FROM V$ASM_DISK
order by name;

We can now make disk groups in sql*plus or using asmca.
Start asmca in a terminal session.
Select Create

Mark disks you want to add to diskgroup and then click “Show advanced options” button

Set Database Compatibility to 10.2
Set new group name, for exaple DG1
Click OK

Next we create diskgroup in sql*plus:
CREATE DISKGROUP FRA NORMAL REDUNDANCY
DISK 'ORCL:VOL3',
'ORCL:VOL4'
ATTRIBUTE 'au_size'='4M',
'compatible.asm' = '11.2',
'compatible.rdbms' = '10.2'
/
Diskgroup created.

Now we have the storage and the next step is database creation.

NEXT "How to Install Oracle 11r2 database on ASM"

How to install Oracle Enterprise Linux R5

2010-05-18T22:38:00.002+02:00

In this demo VMware Fusion (for Windows VMware workstation),
Enterprise-R5-U5-Server-i386-dvd.iso, Oracle Database Grid Infrastructure, Oracle 11gR2 and ASMlibs will be used.

Oracle Linux 5r5

Close Settings screen and click on “Start Up” button.

Linux Installation will start now.

Select Skip

Welcome to Oracle Unbreakable Linux

Next:
Select language -> NEXT
Select keyboard -> NEXT
Warning -> YES (6x for each disk)

Mark “sda” disk 14331 MB as the only disk to be used during installation

Custom layout

Select "New"

Create boot partition, 100MB.

Select "New"

Create Swap partition 1GB (1024MB).

Select "New"

Create root partition from free space.

Click next.

Select default for GRUB.

Network device

On this screen we can choose hostname.

Where are you?

Enter root password (and forget it immediately ☺)
Select for “Software Development”

Click “Next” to begin installation.

Ok, reboot.
After reboot you are in the WELCOME screen, just follow the screen instructions.
This is test installation, therefore we do not need firewall
Firewall -> Disables + YES.
SELinux -> Disable + YES.
Date and time.

Create user, we could create user ‘oracle’ here, but I prefer to create users later.

The next step is the “Sound card” step and as the last step, Finish + one more reboot.

Next I recommend installing VMware Tools.
Log on as root
Select “Virtual Machine” -> “Install VMware Tools”

At this stage a new window appears with two files.
Start Terminal session “Applications -> Accessories -> Terminal”
Go to /tmp and execute the following commands:
• cd /tmp
• cp /media/VMware\ Tools/VMwareTools-8.2.4.232708.tar.gz .
** please notice “.” at end of command line and of course you can have other version of VMware tools file
• tar xzf VMwareTools_4.2.4.232708.tar.gz
• cd vmware_tools_distrib
• ./vmware-install.pl
• accept all defaults

Reboot the virtual machine.
Now you can use the shared folders inside the virtual machine. On my host machine I already have all software installations saved in a directory which I share with my virtual machine with the name “SOFTWARE”.

cd /mnt/hgfs/"the name of shared directory"

Anyway, we should continue with the Linux installation.
Connect Linux image to CD ROM and mount it:
1. Click on CD/DVD symbol on the bottom of screen and select “Choose Disk Image”
2. Click again on the same symbol and select “Connect CD/DVD”

Brows to your Linux iso file and select it.

Now click on the same CD/DVD symbol and select “Connect CD/DVD”
You should have the DVD mounted to your machine.

cd /media/Enerprise\ Linux\ DVD\ nnnnnn/Server
Install missing Linux packages.

rpm -Uvh elfutils-libelf-devel* glibc-devel-2* glibc-headers-2* gcc-4* libgomp-4* gcc-c++-4* libstdc++-devel-4* compat-libstdc++-33*

rpm -Uvh sysstat-* libaio-devel-* sysstat* unixODBC-* unixODBC-devel-*

To verify that ALL the required packages are installed on your system run the following command:

rpm -q compat-libstdc++-33 elfutils-libelf-devel glibc-devel-2.5 gcc gcc-c++ libaio-devel libstdc++-devel unixODBC unixODBC-devel sysstat binutils elfutils-libelf glibc glibc-common libaio libgcc libstdc++ make

Configuring Linux for Oracle

Now that the Linux software is installed, you need to configure it for Oracle.
Create Oracle groups and the user account.
Create Linux groups and user account that will be used to install and maintain the Oracle Database software. The user account name is “oracle”, and the group name is “dba”. Execute the following commands as root:
[root@oraasm-primary Server]# /usr/sbin/groupadd dba
[root@oraasm-primary Server]# /usr/sbin/useradd -m -g dba oracle
[root@oraasm-primary Server]# id oracle
uid=500(oracle) gid=500(dba) groups=500(dba)

[root@oraasm-primary Server]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

Create Directories

Issue the following commands as root to create directories to store Oracle software:
[root@oraasm-primary Server]# mkdir -p /data/app/oracle
[root@oraasm-primary Server]# chown -R oracle:dba /data/app
[root@oraasm-primary Server]# chmod -R 775 /data/app

Configuring the Linux Kernel Parameters

Oracle Database 11g requires the kernel parameter settings shown below. The values provided are minimum required values. If your system uses larger values, do not modify them here. Linux allows modification of most kernel parameters while the system is up and running therefore there is no need to reboot the system to change kernel parameters.

kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144

Note that OEL 5 already has values defined for kernel.shmall and kernel.shmmax. Use the default values if the same or larger than the required values. Check file /etc/sysctl.conf.

In my case I only had to add the following lines:
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144

execute the following command as root:
cat >> /etc/sysctl.conf << EOF
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=262144

EOF

If you are following this document and have just installed Linux, the kernel parameters have the default values and you can just cut and paste the following commands while logged in as root:
/sbin/sysctl -p

Setting shell limits for the oracle user
Oracle recommends setting limits on the number of processes and open files for each Linux account . To make these changes, execute the following commands as root:
cat >> /etc/security/limits.conf << EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

EOF

cat >> /etc/pam.d/login << EOF
session required pam_limits.so
EOF

Change the default profile for bash and ksh and the default login script for cshell.
cat >> /etc/profile << EOF
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF

cat >> /etc/csh.login << EOF
if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
umask 022
endif
EOF

next “How to install and configure ASM”

How to setup VMware virtual machine

2010-05-18T22:17:00.004+02:00

In this demo VMware Fusion (for Windows VMware workstation),
Enterprise-R5-U5-Server-i386-dvd.iso, Oracle Database Grid Infrastructure, Oracle 11gR2 and ASMlibs will be used.

Setting up VMware for Linux Installation

Start your VMware Fusion (for Windows VMware workstation).
Select “create New in menu -> File”

Select “Continue without disc” if you do not have installation DVD and you want to use Oracle's Enterprise-R5-U5-Server-i386-dvd.iso image file instead.

Use operating system installation disc image file and click continue

Click continue.

The next panel is titled “Finish” but in reality this is not the case. Next some customization of the image must be done.
Click “Customize Setting” button,

Create directory and select the file name for the image. I created directory oracle11r2onASM and I named my
image file oracle11r2ASM.vmwarevm

The next panel, “System settings”, is for customization settings:

Sharing directories between virtual and host PCs is very useful and I use this feature a lot.
Select sharing option and Select which directory you want to share between host and virtual machines.
1. Mark “Share folders on your Mac”
2. Press “+” to add directory
3. Select the directory you want to share
4. Press Add

5. To add more directories repeat steps 2-4

Press on “Show All” to see all the settings again.

Select “Processors & RAM”
My virtual machine will be set for 2 processor cores and 3GB (3072 MB) of RAM.

Select “Display”
Mark “Accelerate 3D Graphics” on.

Select “Network”
Mark “Share the Mac’s Network connection (NAT)” on.

Select “Hard Disks”
At this stage we need to make some decisions. How much space we need?
How menu disks we need for ASM? How big the disks have to be?

For the OS and the Oracle software I reserved 20GB and each disk that we use in ASM will be 5GB.
1. Select “Disk size” to be 20GB
2. Select pre-allocate disk space
3. Press “Apply”
4. Press “+” button to add new disk
5. Select “Disk size” to be 5GB
6. Press “Apply”
7. Repeat steps 4-6 five more time

Now we have 6 disks to be used inside ASM

Close Settings screen and click on “Start Up” button.

Linux Installation will start now.

next "How to install Oracle Enterprise Linux R5"