The Musings of CrashSensei

Random thoughts caught by the InterWeb

Configure Oracle Enterprise Manager 13c

By crashsensei | January 5, 2018 | 0 Comment

Configure OEM Database Connect to the database as SYSMAN Create a more restrictive password verification function CREATE OR REPLACE FUNCTION cstm_mgmt_verify_function (username varchar2, password varchar2, old_password varchar2) RETURN boolean IS n boolean; m integer; differ integer; digitcount integer; charcount integer; punctcount integer; digitarray varchar2(20); punctarray varchar2(25); chararray varchar2(52); BEGIN digitarray:= ‘0123456789’; chararray:= ‘abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ’; punctarray:=’!”#$%&()”*+,-/:;<=>?_’; –Check […]

Continue Reading

Patching Oracle Database 12c Single Instance

By crashsensei | December 4, 2017 | 0 Comment

Stage the software Download the latest OPatch version Browse to Patch 6880880 For the Platform select Linux x86-64 Click the Download button Download the latest Oracle Database patches Login to My Oracle Support Click on Patches & Updates Click on Recommended Patch Advisor Enter Oracle Database for the Product. Enter 12.2.0.1.0 for the Release. Enter […]

Continue Reading

Install Oracle Enterprise Manager 13c

By crashsensei | November 30, 2017 | 0 Comment

Configure environment Update the LinearSoft oracle.conf file sed -i “s/LSOFT_ORACLE_EM=.*/LSOFT_ORACLE_EM=yes/g” /etc/linearsoft/oracle.conf Create the middleware home mkdir /opt/oracle/app/oracle/middleware mkdir /opt/oracle/app/oracle/agent mkdir /opt/oracle/emrepo/swlib chown oracle:oinstall /opt/oracle/app/oracle/middleware chown oracle:oinstall /opt/oracle/app/oracle/agent chown oracle:oinstall /opt/oracle/emrepo/swlib ln -s /opt/oracle/emrepo/swlib /opt/oracle/app/oracle/swlib Create OEM Database Launch DBCA Login or Switch to the Oracle user su – oracle Setup the DISPLAY environment variable if needed [ `env | grep DISPLAY` […]

Continue Reading

Install Oracle Database 12c Single Instance on OL7

By crashsensei | November 17, 2017 | 0 Comment

Intro This article is a continuation of the “Installing Oracle Linux 7”. Install Binaries Launch the Installer Login or Switch to the Oracle user su – oracle Setup the DISPLAY environment variable if needed [ `env | grep DISPLAY` ] && echo “Display already set” || \ export DIPLAY=<MACHINE-NAME>:0.0 Setup the ORACLE_BASE environment variable export ORACLE_BASE=/opt/oracle/app/oracle […]

Continue Reading

Installing Oracle 12c RAC One Node

By crashsensei | November 2, 2017 | 0 Comment

Intro This article is a continuation of the “Preparing Oracle Linux 7 for bubba” Initial Setup Login or Switch to the Grid user su – grid Extract the grid software image mkdir -p /opt/oracle/app/grid/product/12.2.0/grid unzip /opt/oracle/dump/linuxx64_12201_grid_home.zip -d /opt/oracle/app/grid/product/12.2.0/grid Login as the Root user su – root Install Cvuqdisk Setup the environment vars CVUQDISK_GRP=oinstall export CVUQDISK_GRP Install the cvuqdisk RPM […]

Continue Reading

Preparing OL7 for Oracle Software

By crashsensei | October 27, 2017 | 0 Comment

Intro This article is a continuation of the “Installing Oracle Linux 7”. Configure the OS Create directories Note: This directory structure differs from the standard Oracle recommended setup but falls more in-line with Linux directory standards Oracle DB mkdir -p /opt/oracle/app mkdir /opt/oracle/dump Oracle EM mkdir -p /opt/oracle/app mkdir /opt/oracle/dump mkdir /opt/oracle/dbstore mkdir /opt/oracle/emrepo Setup accounts […]

Continue Reading

Installing Oracle Linux 7

By crashsensei | October 16, 2017 | 0 Comment

Intro This is  simple tutorial for installing and configuring Oracle Linux 7 for usage with a Oracle 12c database.  For instructions on installing Oracle 12c database software please refer to the ABC post Install Environment VMWare virtual machine CPUs One Node: 10 cores Enterprise Manager: 8 cores Memory One Node: 64GB Enterprise Manager: 16GB Single […]

Continue Reading

Hello world!

By crashsensei | August 28, 2017 | 1 Comment

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Continue Reading