Oracle 19c Quick Install Guide for Linux
Article ID: 273868
Updated On:
Products
Issue/Introduction
This is a Quick Install guide for the Oracle Database Server
For the full "DLP Quick Install Guides" please visit the following link: DLP Quick Install Guides
Environment
Linux
Cause
This is a quick install guide for an Oracle Standard installation on Linux
Resolution
|
VERSION DISCLAIMER: <DLPversion> = 15.8, 16.0, 16.0.1 or 16.0.2 |
Oracle 19c Implementation Guide: Implementing the Database
Download the Oracle Software: https://support.broadcom.com/group/ecx/productfiles?sellable=DAT71262&release=19&os=&servicePk=0&language=EN
Installation zip: LINUX.X64_<ORACLEversion>_db_home.zip
Installation_Tools.zip: This is found in the DLP Platform Package "Symantec_DLP_<DLPversion> _Platform_Lin-IN_<DLPfullversion>.zip"
Stand Alone Installation: When installing Oracle on its own server, please note that you MUST install the Oracle Client on the Enforce Server.
RHEL Server Registration: RHEL Registration Quick Install Guide for Linux
Firewalld:
DLP on RHEL: How to open firewalld ports
Create the Environment Variables:
Environment Variables Quick Install Guide for Linux
Downloading the Oracle Tools: Extract the "Symantec_DLP_<version>_Platform_Lin-IN_<DLPfullversion>.zip" file
- Browse the installation directory for "DLP\<DLPversion>\New_Installs\Oracle_Configuration\<ORACLEversion>_64_bit_Installation_Tools_Lin.tar.gz"
- Create the following directory on your Linux Server…
mkdir /OracleInstallers/install_tools
Once the files are copied in, update the permissions with.
chmod 755 *With the permissions updates we will now unzip the tar file to /OracleInstallers/install_tools:
- Unzip the "<ORACLEversion>_64_bit_Installation_Tools_Lin.tar.gz" into the new "/OracleInstallers/install_tools" directory.
tar -xvf <ORACLEversion>_64_bit_Installation_Tools_Lin.tar.gz -C /OracleInstallers/install_tools/
Preparing system for oracle install:
oracle_prepare.sh
The oracle_prepare.sh script is used to create the oracle environment variables, oracle user, and oracle filesystem user, used under /opt/oracle/product/<version>/db_1
oracle_set_env.sh
The oracle_set_env.sh will set the following environment variables (optional)
- ORACLE_BASE
- ORACLE_HOME
- ORACLE_SID
- PATH
- LD_LIBRARY_PATH
oracle_template_copy.sh
the oracle_template_copy script will copy the dbt to the correct directory.
1. edit the oracle_template_copy.sh. Make sure the below has the following contents.
TEMP_PATH=../templates/singleinstance
TEMPLATE=Oracle_19.3.0.0_Template_for_64_bit_Linux.dbt
#
cp -v $TEMP_PATH/$TEMPLATE $ORACLE_HOME/assistants/dbca/templates/
2. run the script to copy the template file to the correct location.
X11 redirection:
You can accomplish this in a couple of ways.
1. Using ubuntu desktop client
- create ssh key pair for ssh authentication
ssh-keygen - copy the ssh key to oracle account on remote oracle server.
ssh-copy-id -i .ssh/id.pub oracle@<ipaddress of oracle server> - ssh with X11 forwarding switch
ssh -v -X oracle@<ipaddressoforacleserver> - you will need to install xterm on the oracle server.
yum install xterm
2. using windows and putty.exe
Installing Oracle:
/opt/oracle/product/19.3.0.0/db_1/runInstaller -noconfig -responseFile /home/oracle/oracle_install/responsefiles/ singleinstance/Oracle_19.3.0.0_Enterprise_Edition_Installation_Linux.rsp
Substitute Oracle_19.3.0.0_Standard_Edition_Installation_Linux.rsp if you are running Oracle 19c Standard Edition.
DBCA:
- Open a command prompt, and execute one of the following commands.
- Run the command for your database environment:
- $ORACLE_HOME/bin/dbca-createDatabase-progressOnly-responseFile /home/oracle/oracle_install/responsefiles/singleinstance Oracle_19.3.0.0_DBCA_Linux.rsp
Add appropriate user groups, for this scenario we will use the rhel group "dba" for all oracle required groups.
useradd oracle
passwd oracle
- For this example, we used the password "<Your Password>".
- The BAD PASSWORD error message is expected and not an issue.
groupadd -g 54321 oinstall
groupadd -g 54322 dba
usermod -g oinstall -G dba oracle
mkdir -p /opt/oracle/product/<ORACLEversion>/db_1
chown -R oracle:oinstall /opt/oracle/
System requirements for Oracle 19c and RHEL 8: https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/supported-red-hat-enterprise-linux-8-distributions-for-x86-64.html
For RHEL 8.x install the following reqs:
yum install bc binutils elfutils-libelf elfutils-libelf-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make policycoreutils policycoreutils-python-utils smartmontools sysstat fontconfig-devel
Setting up Oracle User variables
1. edit the /home/oracle/.bash_profile
2. add the following exports
export ORACLE_HOME=/opt/oracle/product/<oracleversion>/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=protect3. save the file.
4. run the following command to load the variables source /home/oracle/.bash_profile
If an error INS-80191 Unexpeted error while executing the action state: "supportOScheck"
see: https://knowledge.broadcom.com/external/article?articleNumber=223441
su - oracle
cd /OracleInstallers/
unzip LINUX.X64_<ORACLEversion>_db_home.zip -d /opt/oracle/product/<ORACLEversion>/db_1
cd /opt/oracle/product/<ORACLEversion>/db_1/
./runInstaller -silent -responseFile /OracleInstallers/install_tools/oracle_install/responsefiles/singleinstance/Oracle_<ORACLEversion>_Standard_Edition_Installation_Linux.rsp
su - root
/opt/oracle/oraInventory/orainstRoot.sh
/opt/oracle/product/<ORACLEversion>/db_1/root.sh
su - oracle
cd /OracleInstallers/install_tools/oracle_install/responsefiles/singleinstance/
nano Oracle_<ORACLEversion>_DBCA_Linux.rsp
#-----------------------------------------------------------------------------
#templateName={ORACLE_HOME}/assistants/dbca/templates/Oracle_<ORACLEversion>_Template_for_64_bit_Linux.dbt
templateName=/OracleInstallers/install_tools/oracle_install/templates/singleinstance/Oracle_<ORACLEversion>_Template_for_64_bit_Linux.dbt
#-----------------------------------------------------------------------------
sysPassword=<Your Sys Password>
#-----------------------------------------------------------------------------
systemPassword=<Your System Password>
#-----------------------------------------------------------------------------
serviceUserPassword=<Your Service User Password>
cd /opt/oracle/product/<ORACLEversion>/db_1/bin/
./dbca -silent -createdatabase -responsefile /OracleInstallers/install_tools/oracle_install/responsefiles/singleinstance/Oracle_<ORACLEversion>_DBCA_Linux.rsp
./netca -silent -responsefile /opt/oracle/product/<ORACLEversion>/db_1/assistants/netca/netca.rsp
(this will not create the tnsname.ora for us, we will create it later)
nano /opt/oracle/product/<ORACLEversion>/db_1/network/admin/tnsnames.ora
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
PROTECT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = protect)
)
)
SQLNET.AUTHENTICATION_SERVICES=(none)
nano /opt/oracle/product/<ORACLEversion>/db_1/network/admin/sqlnet.ora
lsnrctl stop
nano /opt/oracle/product/<ORACLEversion>/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/<ORACLEversion>/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = /opt/oracle/product/<ORACLEversion>/db_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:/opt/oracle/product/<ORACLEversion>/db_1/bin/oraclr19.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dhcp-10-252-164-86.example.net)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = PROTECT))
)
)SECURE_REGISTER_LISTENER = (IPC)
lsnrctl start
lsnrctl status
sqlplus /nolog
connect sys/<password> as sysdba
ALTER SYSTEM SET local_listener = '(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PROTECT)))' SCOPE=both;
ALTER SYSTEM REGISTER;
exit
lsnrctl services
sqlplus /nolog
@/OracleInstallers/install_tools/oracle_install/scripts/oracle_create_user.sql
Additional Information
For additional guides please see the "Getting Started with Data Loss Prevention"
To provide feedback please click on the "Feedback" link or send an email to "[email protected]"
Feedback
