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.
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.
[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
Copyright (c) 1991, 2014, Oracle. All rights reserved.
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************
No comments:
Post a Comment