Step By Step install Oracle 19cR2 Database on OEL 7.6 (64-Bit)

Basic Installation

  • Boot from the DVD. Use the up arrow to pick the “Install Oracle Linux 7.0” option and hit the return key.
  • Select the appropriate language and select the “Set keyboard to default layout for selected language” option, then click the “Continue” button.

Click the “I want to proceed.” button on the pre release software warning screen.

  • You are presented with the “Installation Summary” screen. You must complete any marked items before you can continue with the installation. Depending on your requirements, you may also want to alter the default settings by clicking on the relevant links.

 

  • Click the “Installation Destination” link.
  • If you are happy to use automatic partitioning of the whole disk, click the “Done” button to return to the previous screen.

 

 

  • If you want to modify the partitioning configuration, click the “Continue” button and work through the partitioning screens.
  • It would be advisable to click on the “Software Selection” link and pick the following options if you want a GUI console.
    • Base Environment > Server with GUI
    • Add-ons for Selected Environment > Compatibility Libraries
    • Add-ons for Selected Environment > Development Tools

    Once you have completed your selections, click the “Done” button.

  • Once you have completed your alterations to the default configuration, click the “Begin Installation” button.
  • Click the “Root Password” link.

Enter the root password and click the “Done” button.

  • Click the “User Creation” link.
  • Enter the user details and select the “Make this user administrator” option, then click the “Done” button.

Wait for the installation to complete. When prompted, click the “Reboot” button.

Click the “License Information” link. Check the “I accept the license agreement” checkbox and click the “Done” button. When you return to the previous screen, click the “Finish Configuration” button.

 

Decide if you want to use Kdump and click the “Forward” button.

Decide if you want to set up software updates and click the “Forward” button. If you chose not to register with ULN, you will need to confirm you decision also.

Click the “Forward” button.

 

  • Finish Updates Setup
  • On the sign-in screen, click on the user you want to log in as
  • Enter the password and click the “Sign In” button.
  • Accept the language by clicking the “Next” button.
  • Accept the input sources by clicking the “Next” button.
  • Click the “Start using Oracle Linux Server” button.Thank You
  • Install Vmware tools to do some internal works.

  • While installing Oracle 19c binaries on OEL 7.6. First, we need to download the software then unzip it on oracle home and start runInstaller from the software location.
  • Select a “Set Up Software Only” and click next.
  • Select on “Single instance database Installation” and click on next.
  • Select on “Enterprise Edition” and click on next .
  • Put the Oracle Base and click on next
  • Put the “Inventory Directory” and click on next
  • Select appropriate group and click on next

  • Provide the root password if you want to run the scripts automatically.
  • Check the prerequisite for installation
  • Review the summary page and click on install
  • After Installation progress completed.
  • To complete the installation on click on close.

Load bash profile then run dbca

  • Log in as the Oracle software owner.
  • Go to a command prompt.
  • Type dbca.
  • You see a splash screen and another screen with options

Select Create a Database option to create a new Db

  • Select the Create a Database option.

    You are presented with the option of using a default configuration or an advanced one.

  • If you Select the Advanced option.
  • Click Next.

You’ll see output. Optional database templates are shown:

  • General Purpose
  • Data Warehouse
  • Custom Database

 

As i selected the Typical configuration provide Location of Datafile and FRA then provide password

Set the Oracle Home and connect to Sqlplus

we are successfully completed binary installation and Database installation of Oracle 19c

Catch Me On:- Hariprasath Rajaram 

Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba                      FB Group:https://www.facebook.com/groups/894402327369506/             FB Page: https://www.facebook.com/dbahariprasath/?               Twitter: https://twitter.com/hariprasathdba

Step by Step Oracle TimesTen In-Memory Database Installation On Linux

In this article, we will see the step by step installation of Oracle TimesTen In-Memory Database 11.2.2 and TimesTen Applications Database Cache 11.2.2 on RHEL 6.8.

Download the Oracle TimesTen Database Software from here.

Create an operating system group for the TimesTen instance administrators
group.

Create ttadmin group:-

$ /usr/sbin/groupadd -g 54331 ttadmin

Create /etc/TimesTen directory:-

$ mkdir /etc/TimesTen

Assign ownship permission to group ttadmin to directory /etc/TimesTen:-

$ chgrp -R ttadmin /etc/TimesTen
$ chmod -R 775 /etc/TimesTen
$ ls -ltrhd /etc/TimesTen/ls -ltrhd /etc/TimesTen/
drwxrwxr-x. 2 root ttadmin 4.0K Dec 23 13:21 /etc/TimesTen/

Create user oratta with group ttadmin:-

$ /usr/sbin/useradd -u 54331 -g ttadmin oratta
$ id oratta
uid=54331(oratta) gid=54331(ttadmin) groups=54331(ttadmin)

Create and change ownership to the directories to oratta as owner and group ttadmin:-

$ mkdir -p /oradb/app/oratta/TimesTen
$ chown -R oratta:ttadmin /oradb/app/oratta

Login as oratta user and start installation:-

$ su – oratta
$ unzip the TimesTen software
$ tar -zxvf timesten112280.linux8664.tar.gz
$ cd linux8664
$ ./setup.sh

NOTE: Each TimesTen installation is identified by a unique instance name.
The instance name must be a non-null alphanumeric string, not longer
than 255 characters.

Please choose an instance name for this installation? [ tt1122 ]
Instance name will be ‘tt1122’.
Is this correct? [ yes ]

Of the three components:

[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only

Which would you like to install? [ 1 ]

Of the following options :

[1] /home/oratta
[2] /mnt/hgfs/shared/Softwares/oracle/Timesten
[3] Specify a location
[q] Quit the installation

Where would you like to install the tt1122 instance of TimesTen? [ 1 ] 3
Please specify a directory to install TimesTen? [ /home/oratta ] /oradb/app/oratta/TimesTen
Where would you like to create the daemon home directory? [ /oradb/app/oratta/TimesTen/tt1122/info ]

The daemon logs will be located in /oradb/app/oratta/TimesTen/tt1122/info
Would you like to specify a different location for the daemon logs? [ no ]
Installing into /oradb/app/oratta/TimesTen/tt1122 …
Uncompressing …

NOTE: If you are configuring TimesTen for use with Oracle Clusterware, the
daemon port number must be the same across all TimesTen installations
managed within the same Oracle Clusterware cluster.

NOTE: All installations that replicate to each other must use the same daemon
port number that is set at installation time. The daemon port number can
be verified by running ‘ttVersion’.

The default port number is 53396.

Do you want to use the default port number for the TimesTen daemon? [ yes ]
The daemon will run on the default port number (53396).

NOTE: For security, we recommend that you restrict access to the
TimesTen installation to members of a single OS group. Only members of
that OS group will be allowed to perform direct mode connections to
TimesTen, and only members of that OS group will be allowed to perform
operations that access TimesTen data stores, TimesTen files and shared
memory. The OS group defaults to the primary group of the instance
administrator. You can default to this group, choose another OS group
or you can make this instance world-accessible. If you choose to make
this instance world-accessible, all database files and shared memory
are readable and writable by all users.

Restrict access to the the TimesTen installation to the group ‘ttadmin’? [ yes ]

NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.

Would you like to enable PL/SQL for this instance? [ yes ]

In order to use the ‘Oracle TimesTen Application-Tier Database Cache’ feature in any databases
created within this installation, you must set a value for the TNS_ADMIN
environment variable. It can be left blank, and a value can be supplied later
using <install_dir>/bin/ttModInstall.

Please enter a value for TNS_ADMIN (s=skip)? [ ] /oradb/app/oracle/product/11.2.0.4/db_1/network/admin

TNS_ADMIN will be set to /oradb/app/oracle/product/11.2.0.4/db_1/network/admin
You can change TNS_ADMIN later by running <install_dir>/bin/ttmodinstall.

NOTE: It appears that you are running version 4 or higher of the g++
compiler. TimesTen ships with multiple sets of client libraries and server
binaries : one built for compatibility with g++ 3.4.6 and one with
g++ 4.1.0. The installer has created links to the 4.1.0 library in the
<install_dir>/lib directory and to the 4.1.0 server binary in the
<install_dir>/bin directory. If you want to use a different compiler,
please modify the links to point to the desired library and server binary.

Installing server components …
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53397 ]
Do you want to install the Quick Start Sample Programs and the TimesTen Documentation? [ no ] yes
Where would you like to install the Quick Start and doc directories (s=skip)? [ /oradb/app/oratta/TimesTen/tt1122 ]
The TimesTen documentation has been installed in /oradb/app/oratta/TimesTen/tt1122.

The TimesTen Quick Start applications can take up to 64 Mbytes of disk space.
Depending on how your system is configured, you may not want to create the
Quick Start DemoDataStore directory in the default location,
/oradb/app/oratta/TimesTen/tt1122/info/DemoDataStore

Where would you like to create the DemoDataStore directory? [ /oradb/app/oratta/TimesTen/tt1122/info ]
Creating /oradb/app/oratta/TimesTen/tt1122/info/DemoDataStore …

Installing client components …

Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]

NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.

Run the ‘setuproot’ script :
$ cd /oradb/app/oratta/TimesTen/tt1122/bin
$ ./setuproot -install
This will move the TimesTen startup script into its appropriate location.

The startup script is currently located here :
‘/oradb/app/oratta/TimesTen/tt1122/startup/tt_tt1122’.

The Quickstart home page can be accessed here :
‘/oradb/app/oratta/TimesTen/tt1122/quickstart/index.html’

The 11.2.2.8 Release Notes are located here :
‘/oradb/app/oratta/TimesTen/tt1122/README.html’

Starting the daemon …
TimesTen Daemon startup OK.
End of TimesTen installation.

Set the Timeten Environment like below:-

$ cd /oradb/app/oratta/TimesTen/tt1122/bin
$ . ttenv.sh

LD_LIBRARY_PATH set to /oradb/app/oratta/TimesTen/tt1122/lib:/oradb/app/oratta/TimesTen/tt1122/ttoracle_home/instantclient_11_2

PATH set to /oradb/app/oratta/TimesTen/tt1122/bin:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/oci:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/odbc:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/odbc/xla:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/jdbc:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/odbc_drivermgr:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/proc:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/ttclasses:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/ttclasses/xla:/oradb/app/oratta/TimesTen/tt1122/ttoracle_home/instantclient_11_2:/oradb/app/oratta/TimesTen/tt1122/ttoracle_home/instantclient_11_2/sdk:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oratta/bin

CLASSPATH set to /oradb/app/oratta/TimesTen/tt1122/lib/ttjdbc6.jar:/oradb/app/oratta/TimesTen/tt1122/lib/orai18n.jar:/oradb/app/oratta/TimesTen/tt1122/lib/timestenjmsxla.jar:/oradb/app/oratta/TimesTen/tt1122/3rdparty/jms1.1/lib/jms.jar:.

TNS_ADMIN set to /oradb/app/oracle/product/11.2.0.4/db_1/network/admin

Verify the version:-

$ ttversion
TimesTen Release 11.2.2.8.0 (64 bit Linux/x86_64) (tt1122:53396) 2015-01-20T08:36:31Z
Instance admin: oratta
Instance home directory: /oradb/app/oratta/TimesTen/tt1122
Group owner: ttadmin
Daemon home directory: /oradb/app/oratta/TimesTen/tt1122/info
PL/SQL enabled.

$ ttstatus
TimesTen status report as of Sun Dec 23 14:10:09 2018

Daemon pid 16248 port 53396 instance tt1122
TimesTen server pid 16257 started on port 53397
————————————————————————
Accessible by group ttadmin
End of report

 

 

 

 

 

 

 

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba

Support Freshers And Fellow Oracle DBAs Using Social Media

My primary goal for starting the below initiatives are to help my fellow DBAs in  Oracle world and make www.oracledbwr.com a one stop solution for Oracle Technologies.

Telegram Group ( More than 2.5K DBA’s in the Group)

https://t.me/joinchat/I_f4DkeGfZvN1z5wyt_f4w

Whatsapp Group:-(Each Group 257 members)

Oracledbwr Group 1
https://chat.whatsapp.com/E3jbDiQsPjBDsv7Q3jfHaU
Oracledbwr Group 2
https://chat.whatsapp.com/LwqWsSoM7vcCKk340sS4Pe
Oracledbwr Group 3
https://chat.whatsapp.com/IZeMkIt3SxWJD3DqxpVJF2
Oracledbwr Group 4
https://chat.whatsapp.com/Iir0n0UK0KX79YuEFD9w8S
Oracledbwr Group 5
https://chat.whatsapp.com/EcQHNyy32110bdyrXPkUev
Oracledbwr  Group 6
https://chat.whatsapp.com/GxwYyrBWTxWKTkgurpPWr9
Oracledbwr Group 7
https://chat.whatsapp.com/Ee6hv8ruSVmAArFqNmMStH
Oracledbwr Group 8
https://chat.whatsapp.com/D7zZTl2fIV60HLhXWo2swK
Oracledbwr Group 9
https://chat.whatsapp.com/L7qkE3jwGUD1JgS0qcXYDF

Videos Library

I have uploaded the Performance Tuning,GoldenGate,RAC And Dataguard Videos for the below link to download.

https://mega.nz/#F!d00GTQQb!XKuAkQ6LQo7oi711-0ViiA

Documents Library

I have uploaded the Oracle DBA documents, interview questions and materials

Link to download

https://mega.nz/#F!7m5nlDaL

Encryption key

!gwbONpJRzF_b-H-DtnCxLQ

Social Media sites 

LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba                      FB Group:https://www.facebook.com/groups/894402327369506/             FB Page: https://www.facebook.com/dbahariprasath/?               Twitter: https://twitter.com/hariprasathdba
Google+: https://plus.google.com/u/0/+HariPrasathdba

Oracle AIOUG Chennai Chapter -Are You Ready For Oracle Cloud Database Service Part-1

This session is about Are You Ready For Oracle Cloud Database Service Part-1. Below topics will be covered with Live Demo using oracle cloud account.

Introduction to cloud
Creating database Cloud Service
Administering Database Cloud Service
Backing Up and Restoring Databases on Database Cloud Service
Data Guard in Oracle Cloud
Using Oracle DBaaS Monitor
Patching Database Cloud Service
Migrating Oracle Databases to Database Cloud Service

Download the presentation Are You Ready For Living In The Oracle Cloud – 1

Special Thanks To Aioug Chennai Chapter Team

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

Reference:-

All India Oracle Users Group – Chennai Chapter

Chennai, IN
1,835 Oracle Enthusiasts

What is AIOUG?AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongou…

Next Meetup

AIOUG Chennai Chapter – Feb 2019 Meetup

Saturday, Feb 23, 2019, 9:15 AM
8 Attending

Check out this Meetup Group →

Oracle AIOUG Chennai Chapter -Oracle 12c Multitenant Database Session

This session is about Oracle 12c Multitenant Database Session. Below topics will be covered with Live Demo using oracle vmbox

Oracle Multitenant Database Architecture
Overview of Multitenant : (CDB) & (PDB)
Multitenant : Create and Configure a (CDB) & (PDB)
Multitenant : Startup and Shutdown (CDB) & (PDB)
Multitenant : Manage Users and Privileges
Multitenant : Cloning pluggable database
Multitenant : Backup and Recovery (CDB) & (PDB)
Multitenant : Migrate a (Non-CDB) to a (PDB)

 

 

Download the presentation Oracle Database 12c Multitenant Architecture

Special Thanks To Aioug Chennai Chapter Team

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

Reference:-

All India Oracle Users Group – Chennai Chapter

Chennai, IN
1,835 Oracle Enthusiasts

What is AIOUG?AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongou…

Next Meetup

AIOUG Chennai Chapter – Feb 2019 Meetup

Saturday, Feb 23, 2019, 9:15 AM
8 Attending

Check out this Meetup Group →

Oracle AIOUG Chennai Chapter -Database Security Assessment Tool

This session is about Database Security Assessment Tool. Below topics will be covered with Live Demo using oracle vmbox.

Database Security Assessment
DBSAT Overview and Flow
Advantages
How to download, configure and execute
Gather data and preparing reports
Interpreting the report
Summary

 

 

Download the presentation DBSAT – Oracle Database Security Assessment Tool

Special Thanks To Aioug Chennai Chapter Team

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

Reference:-

All India Oracle Users Group – Chennai Chapter

Chennai, IN
1,835 Oracle Enthusiasts

What is AIOUG?AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongou…

Next Meetup

AIOUG Chennai Chapter – Feb 2019 Meetup

Saturday, Feb 23, 2019, 9:15 AM
8 Attending

Check out this Meetup Group →

Oracle AIOUG Chennai Chapter -Oracle Flashback Deep Dive

This session is about Oracle Flashback Deep Dive. Below topics will be covered with Live Demo using oracle vmbox.

History of Oracle Flashback Technologies
Flashback Architecture Overview
Flashback Technologies Transformation Since V9
Flashback Advanced use cases
Flashback Query
Flashback Table
Flashback Drop
Flashback Versions Query
Flashback Transaction Query
Flashback Query Functions
Flashback Database
Flashback Data Archive
Flashback Pluggable Database (PDB)
Temporal Validity

 

Download the presentation Oracle Database Flashback12R2

Special Thanks To Aioug Chennai Chapter Team

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

Reference:-

All India Oracle Users Group – Chennai Chapter

Chennai, IN
1,835 Oracle Enthusiasts

What is AIOUG?AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongou…

Next Meetup

AIOUG Chennai Chapter – Feb 2019 Meetup

Saturday, Feb 23, 2019, 9:15 AM
8 Attending

Check out this Meetup Group →

Oracle AIOUG Chennai Chapter-Oracle Cloud Migration Methods And Techniques

This session is about Oracle Cloud Migration Methods And Techniques. Below topics will be covered with Live Demo from On-Premises to  oracle cloud account.

Introduction
Migrating Oracle Databases to Database Cloud Service
Demo

 

 

Download the presentation Oracle Cloud Migration Methods 

Special Thanks To Aioug Chennai Chapter Team

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

Reference:-

All India Oracle Users Group – Chennai Chapter

Chennai, IN
1,835 Oracle Enthusiasts

What is AIOUG?AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongou…

Next Meetup

AIOUG Chennai Chapter – Feb 2019 Meetup

Saturday, Feb 23, 2019, 9:15 AM
8 Attending

Check out this Meetup Group →

Oracle AIOUG Chennai Chapter -Oracle Dataguard Deep Dive-2

This session is about Oracle Dataguard Deep Dive-2. Below topics will be covered with Live Demo using oracle cloud account.

18c/12c Dataguard New Features
Far Sync Instances
Data Guard Active Standby Database
Plugging An Oracle 12c Pluggable Database Into A Data Guard Container Database
SYSDG Privilege
Recover Standby Database Using Service Names

Dataguard Broker

Introduction to Oracle Data Guard
Oracle Data Guard Broker: Overview
Creating a Data Guard Broker Configuration
Configuring Data Protection Modes
Performing Role Transitions
Using Flashback Database in a Data Guard Configuration
Enabling Fast-Start Failover
Managing Client Connectivity
Monitoring a Data Guard Configuration
Optimizing a Data Guard Configuration

 

Download the presentation

Oracle Data Guard Broker Session-1

Oracle Data Guard Broker Session-2

Oracle Data Guard Broker Session-4

Oracle Datagurard Broker Session-3

Special Thanks To Aioug Chennai Chapter Team

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

Reference:-

All India Oracle Users Group – Chennai Chapter

Chennai, IN
1,835 Oracle Enthusiasts

What is AIOUG?AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongou…

Next Meetup

AIOUG Chennai Chapter – Feb 2019 Meetup

Saturday, Feb 23, 2019, 9:15 AM
8 Attending

Check out this Meetup Group →

Oracle AIOUG Chennai Chapter – Oracle Dataguard Deep Dive-1

This session is about Oracle Dataguard Deep Dive-1. Below topics will be covered with Live Demo using oracle VmBox.

Introduction
History of Oracle Dataguard
Types of Standby Databases
Physical standby database
Logical standby database
Oracle Active Data Guard(11g)
Snapshot standby database (11g)
Cascading standby database
Far Sync Instance(12c)
Heterogeneous DataGuard

 

Download the presentation Oracle Datagurad-Deep Drive 1

Special Thanks To Aioug Chennai Chapter Team

Hariharaputhran Vaithinathan
Harish Panduranga Rao
Justin Michael Raj
Veeratteshwaran Sridhar

Reference:-

All India Oracle Users Group – Chennai Chapter

Chennai, IN
1,835 Oracle Enthusiasts

What is AIOUG?AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongou…

Next Meetup

AIOUG Chennai Chapter – Feb 2019 Meetup

Saturday, Feb 23, 2019, 9:15 AM
8 Attending

Check out this Meetup Group →