Home Directory

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory

luduing

Reviews(1)
byluduing, March 14, 2014
This is an excellent script. I had to made few changes for making it to work with Oracle 12c PDBs.

First, my sqlplus binary is 64 bits, so I edited the script changing it for 'sqlplus64'.

In Oracle 12c you can use a "Container" and put many datbases in there, as PDB. But in this case, they don't use the variable SID, instead, you must use SERVICE_NAME.

So, I changed this:
==> sub logon {
==> open (SQL,"sqlplus -s aloha/teste@\\(DESCRIPTION=\\(ADDRESS=\\(PROTOCOL=TCP\\)\\(Host=$host\\)\\(Port=$port\\)\\)\\(CONNECT_DATA=\\(SID=$sid\\)\\)\\) sub logon {
==> open (SQL,"sqlplus64 -s aloha/teste@\\(DESCRIPTION=\\(ADDRESS=\\(PROTOCOL=TCP\\)\\(Host=$host\\)\\(Port=$port\\)\\)\\(CONNECT_DATA=\\(SERVICE_NAME=$sid\\)\\)\\)racle 12c