Oracle Database Monitoring with SYSDBA
Posted: Wed May 13, 2020 7:51 am
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
I want to connect DB with dbtestusr AS SYSDBA
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