Create Oracle software grid home directories:
Logout from grid and login as root, then perform the following:
mkdir -p /u01/app/oracle
mkdir -p /u01/app/grid
mkdir -p /u01/app/12.1.0/grid
chown -R grid:oinstall /u01
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
Configuring Xming to enable GUI to install software:
Once Xming is installed, run the application called 'XLaunch' and verify that the settings are as
shown:
Save the configuration click finish and close XLaunch
Configuring PuTTy
After installing PuTTy, double-click on the PuTTy icon on the desktop and configure as shown:
The most important setting is the X11 Forwarding. Without that set, the X-window system
cannot find your PC for display. Save the configuration by typing a name (i.e. secu) in the box
under 'Saved Sessions' on the Sessions screen. Press the Save button to save the configuration.
Click Open to open the terminal window or Cancel to close PuTTy.
The next time PuTTy is run, the session named “secu” will be shown. Select “secu” with the
mouse and click Open to launch.
Get into software location folder:
[grid@vlltcsecudb01 12.1.0.2]$ ls -ltr
total 2481496
drwxrwxrwx 1 root root 4096 Jul 7 2014 database
drwxrwxrwx 1 root root 4096 Jul 7 2014 grid
Switch to grid user to install the grid software:
[grid@vlltcsecudb01 12.1.0.2]$ cd grid
[grid@vlltcsecudb01 database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3682 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4094 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-12_01-01-20AM. Please
wait ...
ASM Disks pre-configured by UNIX team reflects here:
Check CRS services status:
[grid@vlltcsecudb01 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE vlltcsecudb01 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE vlltcsecudb01 STABLE
ora.asm
ONLINE ONLINE vlltcsecudb01 Started,STABLE
ora.ons
OFFLINE OFFLINE vlltcsecudb01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE vlltcsecudb01 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE vlltcsecudb01 STABLE
Install Oracle database software:
[oracle@vlltcsecudb01 12.1.0.2]$ ls -ltr
total 2481496
drwxrwxrwx 1 root root 4096 Jul 7 2014 database
drwxrwxrwx 1 root root 4096 Jul 7 2014 grid
[oracle@vlltcsecudb01 12.1.0.2]$ cd database
[oracle@vlltcsecudb01 database]$ ls -ltr
-rwxrwxrwx 1 root root 500 Feb 7 2013 welcome.html
-rwxrwxrwx 1 root root 8533 Jul 7 2014 runInstaller
drwxrwxrwx 1 root root 0 Jul 7 2014 rpm
drwxrwxrwx 1 root root 0 Jul 7 2014 sshsetup
drwxrwxrwx 1 root root 0 Jul 7 2014 response
drwxrwxrwx 1 root root 0 Jul 7 2014 stage
drwxrwxrwx 1 root root 0 Dec 24 23:05 install
[oracle@vlltcsecudb01 database]$ ./runInstaller
[oracle@vlltcsecudb01 database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3682 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4094 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-01-13_01-01-16AM. Please
wait ...
Create an Oracle database:
Configure a dedicate database Listener
Configure a dedicate database Listener (this is different from the default Listener running in the gird):
Create the Database
Run dbca (Database Creation Assistant) to create a database
Creating Container Database SECUCDB with one Pluggable Database QA17PDB
Did not enable Fast Recovery Area and archiving.
Run DBCA to Create one more Pluggable Database QA01PDB
Test the Enterprise Manager Database Express
If you want to test from hosting machine, use the url https://10.7.68.41:5500/em/login
Login to putty:
oracle@vlltcsecudb01 ~$=>echo $ORACLE_SID
secucdb
oracle@vlltcsecudb01 ~$=>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 17 02:54:59 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show con_id
CON_ID
------------------------------
Display the list of available services for the root and the PDBs.
SQL> select name, con_id from v$active_services order by 1;
NAME CON_ID
---------------------------------------------------------------- ----------
SYS$BACKGROUND 1
SYS$USERS 1
qa01pdb.fisdev.local 4
qa03pdb.fisdev.local 5
qa17pdb.fisdev.local 3
secucdb.fisdev.local 1
secucdbXDB 1
7 rows selected.
SQL> col PDB_NAME for a15
SQL> select pdb_name, status from cdb_pdbs;
PDB_NAME STATUS
--------------- ---------
QA17PDB NORMAL
PDB$SEED NORMAL
QA01PDB NORMAL
QA03PDB NORMAL
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
QA17PDB READ WRITE
QA01PDB READ WRITE
QA03PDB READ WRITE
SQL> select tablespace_name, con_id from cdb_tablespaces where con_id=1;
TABLESPACE_NAME CON_ID
------------------------------ ----------
SYSTEM 1
SYSAUX 1
UNDOTBS1 1
TEMP 1
USERS 1
SQL> col FILE_NAME for a47
SQL> select file_name, con_id from cdb_data_files where con_id=1;
FILE_NAME CON_ID
----------------------------------------------- ----------
+DATA/SECUCDB/DATAFILE/users.262.931580935 1
+DATA/SECUCDB/DATAFILE/undotbs1.269.931580935 1
+DATA/SECUCDB/DATAFILE/system.261.931580889 1
+DATA/SECUCDB/DATAFILE/sysaux.270.931580847 1
SQL> select file_name, con_id from cdb_temp_files where con_id=1;
FILE_NAME CON_ID
----------------------------------------------- ----------
+DATA/SECUCDB/TEMPFILE/temp.264.931580985 1
Use the Easy Connect syntax to connect to the PDB unless a net service name is configured in the
tnsnames for
the PDB service.
SQL> connect sys/welcome1@vlltcsecudb01:1522/qa17pdb.fisdev.local as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
QA17PDB
SQL> show con_id
CON_ID
------------------------------
SQL> disconnect
connect to the PDB after tnsnames configured
SQL> connect sys/welcome1@QA17PDB as sysdba;
Connected.
SQL> show con_name
CON_NAME
------------------------------
QA17PDB
SQL> show con_id
CON_ID
------------------------------
SQL> connect sys/welcome1@QA01PDB as sysdba
Connected.
SQL> show con_name
CON_NAME
------------------------------
QA01PDB
SQL> show con_id
CON_ID
------------------------------
