Oracle Database Monitoring with SYSDBA

[hoegh]

Can we connect as the user and invoke the AS SYSDBA Privilege as we are trying to connect on the standby oracle database on mount mode not open mode.

This is the current plug -in we are using
check_oracle_health

and this is the current command

Code: Select all

[[email protected] ~]$ source /usr/local/nagiosxi/etc/configwizards/oracle/oracle && /usr/local/nagios/libexec/check_oracle_health --connect "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.202.23.113)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=compellocdb_dr.lhc4net.lhc.com)(INSTANCE_NAME=compellocdb_dr)))" --user [b]dbtestusr[/b] --password <password> --mode connection-time --warning 1 --critical 5
CRITICAL - cannot connect to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.202.23.113)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=compellocdb_dr.lhc4net.lhc.com)(INSTANCE_NAME=compellocdb_dr))). ORA-01033: ORACLE initialization or shutdown in progress (DBD ERROR: OCISessionBegin)

I want to connect DB with dbtestusr AS SYSDBA

[jdunitz]

Hi!

Try "sysdba@dbtestusr", assuming dbtestusr has sysdb privs.

Does that help?
--Jeffrey