Monday, October 13, 2014

Enterprise Manager 12c No Special Characters for SYSMAN account

While doing an upgrade of Oracle Enterprise Manager 12c from to I encountered an error which caused the upgrade to fail. Please keep in mind you cannot do a direct path upgrade from EM to you will first need to apply Bundle Patch (BP1) to the binaries and then you can upgrade from BP1 --> or and then finally you can upgrade to

From the upgrade logs the error stack is below.

INFO: Schema Creation status: FAILURE 
SEVERE: Schema Creation is failed 
INFO: opss Schema Creation. 
INFO: to create OPSS schema 
INFO: APM Schema Creation. 
INFO: Component is already created 
INFO: plug-in MDS Schema Configuration has failed its perform method 

Cannot change password for sysman_mds java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option 

ERROR:MDS java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option 

java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option 

The Upgrade basically failed due to special character(s) in the SYSMAN password. Please make sure you do not have any special characters in the SYSMAN password such as *,#,!, etc Just use a good combination of alpha and number characters.

Since the upgrade failed I had to fallback and do the following to restart the upgrade all over again for this issue.

1.) Restore the database, inventory and OMS Middleware Home from backup.
2.) Startup database and listener
3.) Start the OMS
4.) Change the SYSMAN password that doesn't use special character(s), procedure below.

<OMS_HOME>/bin/emctl config oms -change_repos_pwd

Please note changing the SYSMAN password will change it on both the OMS and on the repository database.

No comments:

Post a Comment