- Remove all Jobs and Events currently registered against this database.
- Stop the Intelligent Agent
Oracle7 / 8i % lsnrctl dbsnmp_stop
Oracle9i / 10g / 11g % agentctl stop
- Edit the $ORACLE_HOME/network/admin/snmp_rw.ora file. Add the following parameter:
SNMP.CONNECT..NAME=
SNMP.CONNECT..PASSWORD=
The variableis the exact listing of the database name as it appears in the snmp_ro.ora file. Ifis the default (DBSNMP), there is no need to specify the user here. Only the password is required.
On UNIX, set the following permission on the "SNMP_RW.ORA" file:%chmod 600 snmp_rw.ora
- Change the DBSNMP password on the database. You can use either Security Manager, Sqlplus, or Server Manager. If you use SQLPlus or Server Manager, you can issue the following command:
SQL> alter user "dbsnmp" identified by "newpassword";
- Stop and restart the Intelligent Agent.
Tips and good resources for all.. Oracle, Big data, Hadoop, Unix, Linux