1. Modify the DBSNMP password: to reconfigure the DBCONSOLE, enter the DBSNMP password. However, any password will display an error and must be modified in advance. Sqlgt; alteruserdb
1. Modify the DBSNMP password: to reconfigure the DBCONSOLE, enter the DBSNMP password. However, any password will display an error and must be modified in advance. Sqlgt; alter user db
1. Modify the DBSNMP password:
To reconfigure the DBCONSOLE, you need to enter the DBSNMP password, but any password will display an error and must be modified in advance.
SQL> alter user dbsnmp identified by xxx;
2. delete users created on the early DBCONSOLE:
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop user sysman cascade;
3. Delete the objects created on the early DBCONSOLE:
SQL> drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
SQL> drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
4. re-create DBCONSOLE: (if it is in windows, first Delete the DBCONSOLE service in the Registry and restart the computer)
$ Emca-config dbcontrol db-repos create
As prompted, enter SID first, and then enter Y to continue;
Enter port 1521, SYS password, DBSNMP password, SYSMAN password, and Y
Complete.
These are common examples. However, if you try it yourself, the following problems may occur:
1. When dbsnmp is entered and the sysman password is entered, the cursor blinks and float. Do not know the reason, but force the input to continue.
2. An error will be reported. Check the log, saying that there is an object public synonym mgmt_availblity already associated. Execute the preceding statement again and add the statement to drop the object.