Tag Archives: brightdba

Install 18c

Install Oracle 18c Release 3 on RHEL 6.8

Pre-requisites already been taken care like memory, swap, kernel parameters, add groups, profile and users…etc

Contents
___________________________________________________________________________________________________

1. Hardware Requirements
2. Verify OS version
3. Unzip 18c Binaries
4. Set the DISPLAY Environment
5. Invoke ./runInstaller
6. Verify
___________________________________________________________________________________________________

1. Hardware Requirements

The first thing we need to verify the hardware requirements for an Oracle 18c Release 3

— Check Physical RAM.
# grep MemTotal /proc/meminfo
We need at least 8192 MB of physical RAM. <----

— Check Swap Space.
# grep SwapTotal /proc/meminfo/*
RAM up to 1024MB then swap = 2 times the size of RAM
RAM between 2049MB and 8192MB then swap = equal to the size of RAM
RAM more than 8192MB then swap size = 0.75 times the size of RAM

We need at least 8192 MB of swap <----


-– Check space available in /tmp
# df -h /tmp/*
You need to have at least 2048 MB of space in the /tmp directory. <---

-– Check space for Oracle Software and pre-configured database.
# df -h

Space requirement for Oracle 18c Software:
Enterprise Edition 14G  <----

—- To determine whether the system architecture can run the software, enter the following command:

# grep "model name" /proc/cpuinfo

This command displays the processor type. Verify that the processor architecture matches the Oracle software release that you want to install. If you do not see the expected output, then you cannot install the software on this system.


2. Verify OS version

[oracle@rac1 product]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.8 (Santiago)
[oracle@rac1 product]$


3. Unzip 18c Binaries

NOTE: You can't edit oracle home location while installation using OUI. It will pickup automatically ORACLE HOME location, where you have unzipped database binaries. Hence directly unzip in ORACLE HOME location and then start ./runInstaller

After unzip, it will NOT keep all files in single directory.

[oracle@rac1 ]cd /u02/app/oracle/product/18c
[oracle@rac1 18c]$ ls -ltr
total 4457672
-rw-r--r--. 1 oracle dba 4564649047 Jul 25 20:26 LINUX.X64_180000_db_home.zip
[oracle@rac1 18c]$

[oracle@rac1 18c]$ unzip LINUX.X64_180000_db_home.zip

[oracle@rac1 18c]$ ls -ltr
total 4457972
-rw-r--r--.  1 oracle dba        852 Aug 18  2015 env.ora
-rw-r--r--.  1 oracle dba       2927 Oct 14  2016 schagent.conf
-rwxr-x---.  1 oracle dba       1783 Mar  8  2017 runInstaller <----
drwxr-x---.  7 oracle dba       4096 Feb  7 23:11 xdk
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 wwg
drwxr-xr-x.  4 oracle dba       4096 Feb  7 23:11 usm
drwxr-xr-x.  5 oracle dba       4096 Feb  7 23:11 suptools
drwxr-xr-x.  6 oracle dba       4096 Feb  7 23:11 srvm
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 sqlj
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 slax
-rw-r-----.  1 oracle dba         10 Feb  7 23:11 root.sh.old.1
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 relnotes
drwxr-xr-x.  4 oracle dba       4096 Feb  7 23:11 racg
drwxr-xr-x.  5 oracle dba       4096 Feb  7 23:11 R
drwxr-xr-x.  4 oracle dba       4096 Feb  7 23:11 owm
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 oss
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 ordim
drwxr-xr-x.  4 oracle dba       4096 Feb  7 23:11 oracore
drwxr-xr-x.  5 oracle dba       4096 Feb  7 23:11 olap
drwxr-xr-x.  4 oracle dba       4096 Feb  7 23:11 mgw
drwxr-xr-x.  2 oracle dba       4096 Feb  7 23:11 log
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 has
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 dv
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 diagnostics
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 dbjava
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 data
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:11 css
drwxr-xr-x.  6 oracle dba       4096 Feb  7 23:12 plsql
drwxr-xr-x.  2 oracle dba       4096 Feb  7 23:12 dbs
drwxr-xr-x.  2 oracle dba       4096 Feb  7 23:12 utl
drwxr-xr-x.  2 oracle dba       4096 Feb  7 23:12 instantclient
drwxr-xr-x. 13 oracle dba       4096 Feb  7 23:12 dmu
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:12 ucp
drwxr-xr-x.  3 oracle dba       4096 Feb  7 23:12 jdbc
drwxr-xr-x.  2 oracle dba       4096 Feb  7 23:12 QOpatch
drwxr-xr-x.  4 oracle dba       4096 Feb  7 23:12 ords
drwxr-xr-x.  5 oracle dba       4096 Feb  7 23:13 sdk
drwxr-xr-x.  6 oracle dba       4096 Feb  7 23:13 apex
drwxr-xr-x. 22 oracle dba       4096 Feb  7 23:13 sqldeveloper
drwxr-xr-x.  8 oracle dba       4096 Feb  7 23:13 odbc
drwxr-xr-x. 11 oracle dba       4096 Feb  7 23:14 ctx
-rwx------.  1 oracle dba        786 Feb  7 23:14 root.sh.old
drwxr-x---. 14 oracle dba       4096 Jun  4 03:20 OPatch
drwxr-xr-x.  6 oracle dba       4096 Jul 18 19:17 sqlplus
-rwx------.  1 oracle dba        638 Jul 18 19:18 root.sh
drwxr-xr-x.  2 oracle dba       4096 Jul 18 19:39 jlib
drwxr-xr-x.  5 oracle dba       4096 Jul 18 19:41 sqlpatch
drwxr-xr-x.  7 oracle dba       4096 Jul 18 19:44 jdk
drwxr-xr-x. 13 oracle dba       4096 Jul 18 19:44 rdbms
drwxr-xr-x.  6 oracle dba       4096 Jul 18 19:44 precomp
drwxr-xr-x.  5 oracle dba       4096 Jul 18 19:44 perl
drwxr-xr-x.  7 oracle dba       4096 Jul 18 19:44 ord
drwxr-xr-x.  7 oracle dba       4096 Jul 18 19:44 opmn
drwxr-xr-x.  5 oracle dba       4096 Jul 18 19:44 nls
drwxr-xr-x. 10 oracle dba       4096 Jul 18 19:44 network
drwxr-xr-x.  9 oracle dba       4096 Jul 18 19:44 md
drwxr-xr-x. 10 oracle dba       4096 Jul 18 19:44 ldap
drwxr-xr-x.  8 oracle dba       4096 Jul 18 19:44 javavm
drwxr-xr-x.  5 oracle dba       4096 Jul 18 19:44 hs
drwxr-xr-x.  4 oracle dba       4096 Jul 18 19:44 drdaas
drwxr-xr-x.  3 oracle dba       4096 Jul 18 19:44 demo
drwxr-xr-x.  7 oracle dba       4096 Jul 18 19:44 cv
drwxr-xr-x.  6 oracle dba       4096 Jul 18 19:44 crs
drwxr-xr-x.  9 oracle dba       4096 Jul 18 19:44 assistants
drwxr-xr-x.  8 oracle dba       4096 Jul 18 19:44 oui
drwxr-xr-x.  3 oracle dba      16384 Jul 18 19:44 lib
drwxr-x---. 13 oracle dba       4096 Jul 18 19:44 inventory
drwxr-xr-x.  5 oracle dba       4096 Jul 18 19:44 deinstall
drwxr-xr-x.  4 oracle dba       4096 Jul 18 19:44 clone
drwxr-xr-x.  2 oracle dba       4096 Jul 18 19:44 bin
drwxr-xr-x.  2 oracle dba       4096 Jul 18 19:44 addnode
drwxr-xr-x. 10 oracle dba       4096 Jul 18 19:53 install
-rw-r--r--.  1 oracle dba 4564649047 Jul 25 20:26 LINUX.X64_180000_db_home.zip
[oracle@rac1 18c]$


4. Set the DISPLAY Environment

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

export DISPLAY=192.168.2.3:0.0;


5. Invoke ./runInstaller

Start the Oracle Universal Installer (OUI) by issuing the following command.

[oracle@rac1 ~]$ cd /u02/app/oracle/product/18c/
[oracle@rac1 18c]$ ./runInstaller         <-----
Launching Oracle Database Setup Wizard...

















6. Verify

[oracle@rac1 bin]$ export ORACLE_HOME=/u02/app/oracle/product/18c
[oracle@rac1 bin]$ ./sqlplus

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Jul 27 13:16:55 2018
Version 18.3.0.0.0

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

Enter user-name:

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com

RAJASEKHAR AMUDALA

Welcome to Bright DBA website.  

Please use the menu bar (or) Index below to navigate for Oracle/MS SQL Server/MySQL/MariaDB/DB2 LUW, PostgreSQL DBA articles !!!

Topics
DBA Monitor
OS
Database
Network
Storage
Install Oracle
Install Oracle 10gR2
Install Oracle Software in silent mode 11gR2
Install Oracle Software in silent mode 12cR2
Install Oracle 18c using OUI - GUI
Install Oracle 19c using OUI - GUI
Install Oracle Software in silent mode 19c
YouTube - Install Oracle Database 19c on Linux 7
Deinstall Oracle
Deinstall Oracle 11gR2
Deinstall Oracle 11gR2 Client on Windows
Deinstall Oracle 18c
Deinstall Oracle 19c
Create Database Oracle
Create Database in silent mode 11gR2
Create Non-CDB Oracle Database 12c on Linux using DBCA (GUI)
CREATE NON-CONTAINER DATABASE ON ORACLE 12C IN SILENT MODE USING DBCA
CREATE PLUGGABLE DATABASE MANUALLY USING SEED(PDB$SEED)
CREATE NEW PLUGGABLE DATABASE (PDB2) BY CLONING AN EXISTING PLUGGABLE DATABASE (PDB1)
CREATE PLUGGABLE DATABASE USING DBCA (from PDB$SEED)
Convert 12.2 Non-CDB (NONCDB12C) as PDB (NONCDB12C) into CDB (CDB1)
Create Non-CDB Oracle Database 19c on Linux using DBCA (GUI)
CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA
YouTube - How to create Oracle Database using DBCA?
Drop Database
Delete database using DBCA silent mode 11gR2
How to Drop the Database Manually
How to Drop Pluggable Database Manually 12cR2
YouTube - How to Drop Database
Database Startup/Shutdown
HOW TO STARTUP/SHUTDOWN CDB AND PDB 12cR2
YouTube - How to Start Database
Youtube - How to Shutdown Database
How to connect to Database
YouTube - How to connect to Database as SYSDBA
YouTube - How to connect to Database Remotely using SQL Developer?
Proxy User and Connect Through
Database Patching / Rollback
Patch Terminology
Apply Database Patch on 12.2 - Release Update
Oracle 18c Database Patching
Apply Database Patch on 19c - Release Update
How To Apply Database PSU Patch where Standby in Place 11gR2
ROLLBACK DATABASE RELEASE UPDATE from Oracle Database 12.2.0.1
Datapump
SCHEMA REFRESH FROM 11G TO 12C PDB
Backup and Restore - Database Refresh
How to Backup ORACLE_HOME binaries and Oracle INVENTORY
RMAN Catalog
RMAN Database Restore RAC – RAC
RMAN Database Restore from ASM (NON-RAC) TO ASM (NON-RAC)
RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC)
RMAN ACTIVE DUPLICATION ASM TO ASM without downtime
Backup Based RMAN Duplicate Database
Database Upgrade
Upgrade Oracle Database Manually from 11.2.0.4 to 12.2.0.1
Upgrade Oracle Database from 11.2.0.4 to 12.2.0.1 using DBUA
Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA
Upgrade Oracle Database Manually from 12.2.0.1 to 19c (NON-CDB)
Upgrading Oracle Database from 11.2.0.4 to 12.2.0.1 where Physical Standby in Place
Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby
Dataguard - Configuration
Creating Active Data Guard Physical Standby Environment
Creating Active Data Guard Physical Standby Environment on ASM
Covert Physical Standby database to Snapshot Standby database R/W mode
Convert Snapshot database to Physical Standby database
Configure Cascading Standby Database on 11G
How to setup Data Guard Broker Configuration
DG Broker Error – ORA-16714
Disable Data Guard Broker Before Patch or Upgrade
Creating Physical Standby Active DataGuard Configuration in 12.2.0.1 Container Database
How to Create Physical Standby Database using RMAN Backup Without Using Duplicate Command
How to Create Physical Standby Database using RMAN Backup With Duplicate Command
12c DG Broker Configuration
Upgrading Oracle Database from 11.2.0.4 to 12.2.0.1 where Physical Standby in Place
Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby
Create RAC Physical Standby Database using RMAN Active Duplicate Command
Dataguard - Switchover
Performing Switchover with No Broker (Manual)
Performing Switchover with DG Broker
Dataguard - Failover
Failover with DG Broker (No-Flashback)
Failover with No DG Broker (No Flashback) / Failover using Manual Method
Reinstate a failed over Data Guard using Flashback Database
Failover with No DG Broker using Flashback Database
Dataguard - Patching
How To Apply Database PSU Patch where Standby in Place
Dataguard - Other
How to Enable Real Time Apply
Refresh Standby Database using RMAN Incremental SCN Backup - Huge GAP
Resetlogs on Primary Database where Standby in place
How to drop the standby redo logs
ASM
How to move ASM SPFILE from +DATA to +VOTE diskgroup
ASM Commands - Non-RAC
Instantiating disk: failed while creating ASM disk
After server reboot, CSSD and ASM are not came up automatically
RAC
RAC Install 11.2.0.3
Upgrade RAC GI to 11.2.0.4 from 11.2.0.3
Downgrade RAC GI to 11.2.0.3 from 11.2.0.4
root.sh failed with ORA-29783 on RAC
Delete Node from Cluster in 11gR2 (11.2.0.3)
Add Node to 11gR2 Oracle RAC Cluster (11.2.0.3)
Delete Node without remove GI and RDBMS binaries
Add Node Back to Cluster which was deleted without removing GI and RDBMS binaries
How to take OCR backup on 11.2.0.4
How to display Oracle Cluster name
How to Move/Relocate OCR from +DATA to +VOTE diskgroup
Restore loss of all VOTE disks
Cluster Startup Issues
Cluster Verification Utility Command Reference
How to Configure OSWatcher
Create RAC Physical Standby Database using RMAN Active Duplicate Command
Create ACFS File System on RAC
Performance Tuning
About Oracle Statistics
Oracle Histograms
Export and Import schema statistics from one database to another
How to Disable CONTROL_MANAGEMENT_PACK_ACCESS
Generate/Customize Explain Plan
Monitoring Progress of a SQL Execution Plan / sql query is really hanged or not
STATSPACK Utility
ASH Report – ASH (Active Session History) Reports
AWR Report – AWR (Automatic Workload Repository) reports
How to mark SQL_ID as Colored
Troubleshooting Flow For Long Running Queries
How to run SQL Tuning Advisor Manually
How to Install SQLT
How to Run SQLT
How to Create Custom SQL Profile
How to Uninstall SQLT
How to Enable Trace
Trace Analyzer TRCANLZR (TRCA)
DB Generic
How to change SQL prompt to show connected user and database name
How to change Archive destination
Enable the database in Archivelog mode
How to Recover Loss of DATA (Without a Backup!) using Oracle Flash Back Query
Proxy User and Connect Through
ORA-00054 resource busy and acquire with NOWAIT specified
How to find Blocking Sessions
Create Service using DBMS_SERVICE
Error TNS-12543 while connect to a remote database on a Linux
How to Change MAX_STRING_SIZE on Physical Standby Environment
OEM
Steps to configure Oracle 11g OEM DBConsole manually for database
Enable Oracle Enterprise Manager Express 12c
Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0) Installation on Oracle Linux 64 bit
Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) Installation on Oracle Linux 64 bit
Add Database Target on EM Cloud Control 13c
How to upgrade the Enterprise Manager 13.1 Cloud Control OMSPatcher to the Latest Version
Apply Oracle Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718 for Oracle Management Service
Apply Patch on Oracle Management Agent 13c Release 1 (13.1.0.0.0)
Database Link
Database link
DBMS SCHEDULER
How to Create and Monitor DBMS_SCHEDULER Jobs
Enable/Disable JOBS during Maintenance
Microsoft SQL Server DBA
Steps to Install Microsoft SQL Server Express 2014
How to Install Only SQL Server Management Studio
Create Database using the SQL Server Management Studio
Enable TCP/IP Connection
Allow Remote Connection
Authentication Method
How to Create SQL Server Authenticated Login in SQL Server
How to create Windows Authentication Login in SQL Server
How to Create Windows Group Authentication Login in SQL Server
Create a new domain user account in Windows Server 2016
Microsoft SQL Server – Backup and Recovery
Recovery Models
Database Backup: FULL,DIFFERENTIAL and T-LOG
Restore & Recover Database
MySQL DBA
Install MySQL 8 on Linux 7 Using RPM Packages
Create MySQL Database
Create New User Account in MySQL
Grant/Revoke Privileges in MySQL
Create Roles in MySQL
MySQL – Backup/Restore
How To Backup MySQL Database Using mysqldump?
How to Restore Database from Single MySQL Database Backup?
How to Restore A Single Database From A Backup File Which Contains Multiple Databases?
How To Restore Single Table From Full Database Backup in MySQL?
MySQL – Replication
How To Configure MySQL Master-Slave Replication? (One-Way Replication)
MariaDB DBA
Install MariaDB with yum on Linux7 -- Coming soon !!!
Create MariaDB Database --- Coming soon !!!
Create New User Account in MairaDB --- Coming soon !!!
Grant/Revoke Privileges in MariaDB --- coming soon !!!!
Create Roles in MariaDB -- Coming soon !!!
MariaDB – Backup/Restore
Coming Soon !!!
Coming Soon !!!
MariaDB – Replication
How To Configure Maria Master-Slave Replication? (One-Way Replication) -- Coming soon !!!
MariaDB MaxScale Set up
Setup MaxScale -- Coming soon !!!
Load Balancing -- Coming soon !!!
Switchover -- Coming soon !!!
Failover -- Coming soon !!!
PostgreSQL DBA
How to Install PostgreSQL 13 ON RHEL 7?
How to START/STOP PostgreSQL 13 ON RHEL 7?
How to Create Database in PostgreSQL?
Linux
Download Oracle files on Linux via wget
How to Install SQL Developer on Linux
How to Disable the Firewall on Linux 6
DBA Scripts
Oracle DBA Sheet v5.8
Oracle DBA Sheet v6.1
DBA Daily Report
GoldenGate
Installing Oracle GoldenGate V11.2.x for Oracle 10gR2 on Linux x86-64
Unidirectional DML Replication
Zero Downtime Migration
DDL Replication
GoldenGate 12C Installation
Integrated Capture
Oracle GoldenGate Replication between MySQL 5.5 to Oracle 12c
Oracle GoldenGate Security – Credential Store for Database Logins
ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
Installing Oracle GoldenGate 19.1.0.0 for Oracle DB 12c on Linux 7
Install Oracle GoldenGate 19.1.0.0.4 for Oracle Database 19c on Linux 7