changing the password for the user responsible for intelligent agent

[dasdeba]

Hi

Database - Oracle 9i rel 2
O/s - Sun Solaris ver 8/9

After creating a database, installing and configuring a management server, a user is created called DBSNMP which is used by intelligent agent . Now for security reason we should alter the password. For this we have to put the password in snmp_ro or snmp_rw.ora file, otherwise there will be a problem. Now I want to know which file needs to be changed and how ? whar should be the entry ? Can u give me a example ?

Regards

Deba

[sambavan]

Curtesy of Metalink:

1.  Stop the Intelligent Agent:
      On NT:        START->SETTINGS->CONTROL PANEL->SERVICES->ORACLEAGENT    STOP      

or from DOS
        NET STOP ORACLEAGENTXX

On UNIX:        %  lsnrctl dbsnmp_stop        

2.  Edit the "$ORACLE_HOME/net../admin/snmp_rw.ora" file.  Add the following     parameter:       

SNMP.CONNECT.service_name.NAME=username      
SNMP.CONNECT.service_name.PASSWORD=password      

The variable  is the exact listing of the databasename found      
in the visibleservices list in the snmp_ro.ora file.        

If username is the default (DBSNMP), there is no need to specify the user
here. Only the password is required.        


3.  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: 

        alter user "dbsnmp" identified by "newpassword";  4.  

Restart the Intelligent Agent.

In 9i to stop and strat the intelligent agent use:

agentctl stop
agentctl start

Sam