while installing Oracle Enterprise Manager 13c Cloud Control  i have faced the below errors:

ORA-01722: invalid number

ORA-06512: at “SYSMAN.EM_TARGET”, line 9634

ORA-06512: at “SYSMAN.EM_TARGET”, line 10403

ORA-06512: at “SYSMAN.EM_SYSTEM”, line 324

ORA-06512: at “SYSMAN.EM_SYSTEM”, line 242

ORA-06512: at “SYSMAN.MGMT_SYSTEM”, line 32

ORA-06512: at “SYSMAN.CFW_LIFECYCLE”, line 90

ORA-06512: at “SYSMAN.CFW_SERVICE_FAMILY”, line 58

ORA-06512: at line 15

 

To resolve this:

Set the following parameter:

 

SQL> alter system set optimizer_mode=all_rows scope=both;

 

Cheers ! 🙂