Luduing Rodriguez

Fix for checking Oracle 12c PDB

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

Reviewed 12 years ago