Oracle Info Hub

Step by Step Installation of 12c Non Container database in OEL6

This post describes us how to install 12c release 1 database in Oracle Enteprise Linux 6.

Step 1: Install Oracle Enterprise Linux 6.

http://vkoracleappsdbahub.blogspot.in/2018/05/step-by-step-how-to-install-oel-6-64.html

Step 2: Download 12c software

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html

Step 3: Steps to install 12c database

Copy the software to Linux sever and make it ready for installation.

[root@localhost software]# chmod 777 12102/

[oracle@localhost software]# ls
12102

[oracle@localhost software]#

Set the display environment to open GUI

[root@silver ~]# xhost +

access control disabled, clients can connect from any host

[root@silver ~]#

Run the runInstaller

[oracle@silver database]$ ls

install response rpm runInstaller sshsetup stage welcome.html

[oracle@silver database]$ ./runInstaller

Deselect security updates option and click "Next"

Click on "Yes"

Select "Create and configure a database" and click "Next"

Select "Sever class" and click "Next"

Select "Single instance database installation" and click "Next"

Select "Advanced Installation" and click on "Next"

Select default "English" language and click "Next"

Select "Enterprise Edition" and click "Next"

Select software base and home location and click "Next"

Select Inventory location and click "Next"

Select default value and click "Next"

Provide Global database name. Deselect Container database option and click "Next"

Click on "Character Sets" tab and select AL32UTF8 character set.

Click on "Sample schemas" tab

Select sample schemas option if required and lick Next.

Select datafiles location and click "Next"

We can register this database in Enterprise Manager if required or can be register later. Click "Next"

Enable recovery if required or click on "Next"

Provide password for schemas and click "Next"

Select "Yes"

Select dba as the group and click "Next"

Click on "Fix & Check again"

Execute "runfixup.sh" as root and click on 'OK"

[root@silver ~]# /tmp/CVU_12.1.0.2.0_oracle/runfixup.sh

All Fix-up operations were completed successfully.

[root@silver ~]#

Click on "Install"

Execute above scripts as root user and click on "OK"

[root@silver Packages]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to dba.

The execution of the script is complete.

[root@silver Packages]# /u01/app/oracle/product/12.1.0/dbhome_1/root.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u01/app/oracle/product/12.1.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

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 script.

Now product-specific root actions will be performed.

[root@silver Packages]#

Connect to database and find the name and version.

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

SILVER READ WRITE

SQL> select banner from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

PL/SQL Release 12.1.0.2.0 - Production

CORE 12.1.0.2.0 Production

TNS for Linux: Version 12.1.0.2.0 - Production

NLSRTL Version 12.1.0.2.0 - Production

SQL>

[oracle@silver database]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 19-MAY-2018 16:23:19

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=silver.apps.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 19-MAY-2018 15:46:09

Uptime 0 days 0 hr. 37 min. 9 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/silver/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=silver.apps.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=silver.apps.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/SILVER/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "SILVER.apps.com" has 1 instance(s).

Instance "SILVER", status READY, has 1 handler(s) for this service...

Service "SILVERXDB.apps.com" has 1 instance(s).

Instance "SILVER", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@silver database]$

*******Thanks for your patience to view our post************

How to install OEL 6 - 64 bit on Oracle Virtual Box.

This post assumes that we have already installed Virtual Box in windows machine and downloaded OEL6 software and kept ready for installation.

Step 1: Prepare Virtual Box to install linux.

Start Virtual Box and click on "New".

Provide Name, Type and version of Linux and click on "Next".

Provide RAM size how much you want to allocate to Linux server

from host RAM. (Example I have 16 GB RAM in windows machine. I have allocated 4 GB RAM to Linux server) and click on "Next".

Leave the default value and click on "Next"

Leave the default values and click on "Next".

Select "Dynamically allocated" and click on "Next"

Provide hard disk size how much want to allocate and click on "Create". If you leave default value in blank it will create virtual machine in "C" drive. Otherwise you can locate it wherever you want by selecting the location.