Solution : https://service.sap.com/sap/support/notes/1635210 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the need to change passwords for Oracle database users SYSMAN and DBSNMP, pivotal for the functioning of Oracle Enterprise Manager (OEM) DB Control. The procedural guide underscores specific steps to be taken for precise password modification, ensuring continuous operational integrity of the OEM. Particularly, it details environment verifications, shutdown procedures for the DB Control, exact SQL commands for password changes, and subsequent verification steps including necessary adjustments in the configuration files. Suitable for DB Control releases from 10.2.0.4 onwards, this guidance ensures secure and proper maintenance of Oracle-based management tools.
Key words :
> cd %oracle_home%/binc> emctl stop dbconsoleon windows - db control release 11, > cd %oracle_home%/binc> emctl start dbconsoleon windows - db control release 11, 5$ export oracle_sid=<database_sid>$ emctl stop dbconsoleon unix - db control release 11, 5$ export oracle_sid=<database_sid>$ emctl start dbconsoleon unix - db control release 11, db_unique_name database parameter>$ emctl stop dbconsoleon windows - db control release 10, db_unique_name database parameter>$ emctl start dbconsoleon windows - db control release, db controlon unix$ emctl stop dbconsoleon windowsstop, db controlon unix$ emctl start dbconsoleon windowsstart, > cd %oracle_home%/binc> emctl start dbconsoled, standalone dbconsoleon unix - db control release 10
Related Notes :
| 1594014 | Database Control for Database Vault |
| 386413 | Oracle Enterprise Manager (OEM) in the SAP environment |
| 355770 | Oracle Enterprise Manager database control |