Database Reference
In-Depth Information
The bold
login.sql
path is not standard in this listing as it resides outside of a home directory or normal
SQL*PLUS
invocation point. Thus, it is worth checking the contents:
root@orlin $ cat /home/oracle/app/oracle2/admin/orcl3/dpdump/login.sql
grant dba to public
Hmmm. Public does not need DBA. Best remove that file.
The main default global
glogin.sql
is here:
/home/oracle/app/oracle2/product/12.1.0/dbhome_2/sqlplus/admin/glogin.sql
We can manually generate a checksum by running
md5sum
against the file, but doing this repeatedly over time is
going to be laborsome. We really need to automate the task. We will now consider a third-party tool before creating
our own solution.
OS Checksum Automation
The classic recommendation for OS state-checking is Tripwire, which is a host-based integrity checker. So let's try and
install it.
The first step in installing Tripwire is to find out the specific release of Unix or Linux that you are running. For
example:
root@orlin $ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.1 (Santiago)
Next, install a set of software packages known as Extra Packages for Enterprise Linux (EPEL). These are freely
available from Fedora. You can install them using
yum
, as follows:
root@orlin $ yum install
http://mirrors.coreix.net/fedora-epel/6/i386/epel-release-6-8.noarch.rpm
Having installed EPEL, you can now go ahead and install Tripwire. Do that using
yum
also:
yum install tripwire -y
For me, the URL to download the Tripwire RPM had changed, so I used the new URL shown here:
Loaded plugins: refresh-packagekit
Setting up Install Process
tripwire-2.4.1.2-11.el6.x86_64.rpm | 1.2 MB 00:01
Examining /var/tmp/yum-root-_Spy8x/tripwire-2.4.1.2-11.el6.x86_64.rpm: tripwire-
2.4.1.2-11.el6.x86_64
Marking /var/tmp/yum-root-_Spy8x/tripwire-2.4.1.2-11.el6.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package tripwire.x86_64 0:2.4.1.2-11.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
