Linux installation on Virtual Box

Creating the Virtual Machine:

- Specifying the RAM size for VM

-Creating Disk type

-Specifying the Machine location and name, defining the Virtual Hard drive size:

- Machine created and now selecting the ISO image for the OS:

- Performing test, it can be skipped:

> Next

>Language Selection

Basic Storage

Specifying Host Name:

Configuring Network (Ip and Subnet mask)

Coutry/Region Selection:

Setting the root password:

Create Customer layout (Partitioning the disks according to your needs)

Start Installation:

Reboot after installation:

Log in through root:

Step by Step Linux Installation (From Virtual Machine creation to Linux installation)

Creating Share Disks / Storages for Oracle RAC in Virtual Box (linux)

Creating shared disks for Oracle RAC on VB:

1- Click on Node1 and right click settings:

2- Click on storage: righ click> add SATA controller

3-  Select Sata Controller:

4- Sata Controller wiil be added:

5- Click the Plus sign on SATA controller added:

6- Choose create new disk:

7-  Choose Virtual Disk Image

8- Choose Fixed size

9- Give it a name and location:

10- Create the disk after specifying the paths:

11- Once the Disk is created, now its the time to mark it shareable, File>Vitual media manager>

12- All the disks added will be displayed, click on properties;

13- select Type>from normal to shareable

14- as below:

15- Apply the changes:

16- it will be mark as shareable:

17- Now click on other Node which you want these disk to be shareable, similarly enable sata disk control as done in Node 1:

19- Add disk>

20- Above we have to select choose existing disk> select it from location where we created for first node:

21- select the disk and click ok:

22- Now if you check the disk property from any node, it should be shareable as shown below:

ORA-01078: failure in processing system parameters

Most often with fresh DBAs after installing the oracle on linux and setting the environment faced below error message while starting the Database Instance:

ORA-01078: failure in processing system parameters

you did below like setting environment for the instance,i.e oracle sid and oracle home,base etc

[oracle@racnode1 ~]$ . db.env
[oracle@racnode1 ~]$ cat db.env
TMP=/tmp; export TMP
    TMPDIR=$TMP; export TMPDIR

    ORACLE_HOSTNAME=racnode1; export ORACLE_HOSTNAME
    ORACLE_UNQNAME=testdb; export ORACLE_UNQNAME
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
    ORACLE_SID=testdb; export ORACLE_SID
    PATH=/usr/sbin:$PATH; export PATH
    PATH=$ORACLE_HOME/bin:$PATH; export PATH

    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
    CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
[oracle@racnode1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 7 17:37:27 2018

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

Connected to an idle instance.

SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbs/inittestdb.ora'
SQL>

Issue:

Everything else is fine but issue is that oracle SID given during creation of DB is not matching with the environment variable set. In above scenario Oracle is trying to find pfile with name inittestdb.ora but actual file
initTESTDB.ora.

cd $ORACLE_HOME/dbs

-rw-r----- 1 oracle oinstall   39 Feb  7 16:36 initTESTDB1.ora


Solution:

Simple solution will be to set SID name according to SID name given during creation of DB.

Like:

login through oracle user

$ export ORACLE_SID=TESTDB;

OR setting it in enviroment variable file

oracle@racnode1 ~]$ vi db.env
TMP=/tmp; export TMP
    TMPDIR=$TMP; export TMPDIR

    ORACLE_HOSTNAME=racnode1; export ORACLE_HOSTNAME
    ORACLE_UNQNAME=TESTDB; export ORACLE_UNQNAME
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
    ORACLE_SID=TESTDB; export ORACLE_SID
    PATH=/usr/sbin:$PATH; export PATH
    PATH=$ORACLE_HOME/bin:$PATH; export PATH

    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
    CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH


[oracle@racnode1 ~]$ . db.env
[oracle@racnode1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 7 18:13:35 2018

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL>

Or as below:

When login through sqlplus , below error was noticed:

 If we check the Oracle Unique name and Oracle SID given is testdb:

Now setting both of the above variables to respective name:

Now setting the enviroment and run it again: