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

Post #7

BRIGHT DBA · Independent DBA Consultant

24/7 Managed Database Services

Remote DBA services from an independent senior Oracle and PostgreSQL consultant: monitoring, backup, patching, tuning, high availability and migration, with a DBA you can talk to directly.

OraclePostgreSQLReliableSecureScalable

What you get

  • Round-the-clock monitoring and alerting
  • Fast response when something breaks
  • Tested backups and recovery
  • A predictable monthly cost instead of a full-time hire
  • A senior DBA who knows your systems
What We Manage

Everything your databases need to stay healthy

One person responsible for availability, performance and recoverability, so problems are caught before your users notice them.

📡

24/7 Monitoring & Alerting

Continuous checks on availability, space, sessions, locks, replication lag and slow queries, with alerts that reach a person.

💾

Backup & Recovery

Backup strategy, verification and regular restore tests with RMAN, pgBackRest and point-in-time recovery.

🔧

Patching & Upgrades

Planned patching and version upgrades with rollback plans and minimal downtime.

🚀

Performance Tuning

Find and fix slow SQL, tune statistics, memory and I/O, and keep performance steady as data grows.

🛡️

High Availability & DR

Data Guard, RAC, Patroni and repmgr, designed, built and tested with switchover drills.

🔁

Migrations

Zero-downtime migrations with GoldenGate, between versions and platforms, including Oracle to PostgreSQL.

Our Specialities

Deep expertise where it matters

🔴

Oracle

RAC, Data Guard, GoldenGate, Exadata, multitenant, RMAN backup and recovery, patching, upgrades and performance tuning.

View Oracle DBA services →
🐘

PostgreSQL

Patroni, repmgr, HAProxy and pgBackRest, streaming replication, point-in-time recovery, tuning and version upgrades.

View PostgreSQL DBA services →
🔀

Oracle to PostgreSQL Migration

Cut licence costs by moving to PostgreSQL. We assess, plan and migrate your databases with minimal downtime.

Learn more →
How We Support You

Clear, direct and easy to work with

💬

Direct chat channel

A WhatsApp or Slack channel for quick questions and updates, so you talk to the DBA, not a ticket queue.

📞

Incident calls

When something critical breaks, we join a live call on Zoom or Meet and work the problem with your team.

📊

Monthly health report

A clear report on performance, capacity, backups and risks, with recommendations.

🔐

Security & access review

Regular checks of users, privileges and patch levels to keep your databases safe.

📘

Runbooks & documentation

Your procedures documented, so recovery and routine tasks do not depend on one person.

⏱️

Agreed response targets

Response times are agreed per plan, matched to how critical each database is.

Service Plans

Choose the level of cover you need

Every plan is scoped to your environment. Pricing is a custom quote, and response targets are agreed per plan.

Essential

Business-hours care

For smaller environments that need regular attention.

  • Monitoring during business hours
  • Daily backup checks
  • Monthly health report
  • Email and WhatsApp support
Standard · Most popular

24/7 coverage

For production systems that cannot go down.

  • 24/7 monitoring and alerting
  • Incident response with agreed targets
  • Planned patching and maintenance
  • Monthly review with recommendations
Premium

Proactive and complete

For critical, high-availability databases.

  • Everything in Standard
  • Proactive performance tuning
  • Disaster recovery drills
  • Priority response and named DBA
How It Works

Up and running in four steps

1

Book a call

Tell us about your databases and what worries you.

2

Assessment

We review your databases and agree the scope and plan with you.

3

Onboarding

We set up monitoring, access and runbooks, then take over.

4

We run it

We watch, maintain and report on your databases every month.

FAQ

Frequently asked questions

What is included in a managed database plan?

Depending on the plan: monitoring, backup checks, patching, performance tuning and regular reports. We agree the exact scope with you before we start.

What response time do you offer?

Response targets are agreed per plan, based on how critical your databases are to your business.

Which databases do you manage?

Oracle (including RAC, Data Guard, GoldenGate and Exadata) and PostgreSQL.

Can you help us migrate from Oracle to PostgreSQL?

Yes. We assess your Oracle databases, plan the move and carry it out with minimal downtime, using the tools that suit your case.

How do you handle backups and recovery?

We set up and monitor backups, for example RMAN for Oracle and pgBackRest for PostgreSQL, and we test restores regularly so recovery is proven, not assumed.

How do you access our systems, and is it secure?

Access is agreed up front, through your VPN or bastion host, with named accounts and the least privileges needed. Confidentiality terms are part of the agreement.

Do you work with databases in the cloud?

We can manage databases running on cloud servers. Tell us your setup and we will confirm what we can support.

How do we get started?

Book a call or send us a message. We begin with an assessment of your environment and then propose a plan.

Talk to Us

Let us look after your databases

Book a call, or tell us what you run and what keeps you up at night. We will get back to you soon with a proposal.

Tell us what you need

💬