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
Linux
This is a quick install guide for an Oracle Standard installation on Linux
VERSION DISCLAIMER: <DLPversion> = 115.8, 16.0, 16.0.1 or 16.0.2 |
Oracle 19c Implementation Guide: Implementing the Database
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
Download additional software:
yum install nano zip unzip
- This will install "nano", "zip", and "unzip"
- You may see a message indicating that one or more of these is already installed. That is perfectly fine, you can install any missing utilities and move on.
Create the Environment Variables:
Environment Variables Quick Install Guide for Linux
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/
Installing Oracle:
Add appropriate user groups, for this scenario we will use the rhel group "dba" for all oracle required groups.
useradd oracle
passwd oracle
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/
yum install -y bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make smartmontools sysstat
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)
)
)
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.nis.labs.broadcom.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