oracle12c密码登录失败,【译】解决Oracle12c Cloud Control登录验证出错问题

我是真的跟随这篇文章解决了我EM12C不能登录的问题。不是随便乱找一篇文章翻译的。

解决Oracle12c Cloud Control登录验证出错问题

前几天我试图登录我的EM12c R4环境与SSA_ADMINISTRATOR用户，我得到了以下错误 :

Authentication failed. If problem persists, contact your system administrator.

我很确定我的密码是正确的，所以我试了下SYSMAN用户————仍然有同样的错误。为了确认我有正确的密码，我用SYSMAN用户试图登录到存储库数据库，是成功的，所以我知道，奇怪的错误发生了。

SQL> connect sysman/

Enter password:

Connected.

因此，我转到…/em/EMGC_OMS1/sysman/log/emams.log，看到以下错误

2015-05-18 21:22:06,103 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR audit.AuditManager auditLog.368 - Could not Log audit data, Error:java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition

ORA-06512: at "SYSMAN.MGMT_AUDIT", line 492

ORA-06512: at "SYSMAN.MGMT_AUDIT", line 406

ORA-06512: at line 1

Which led me to believe that the JOB_QUEUE_PROCESSES was set to 0, but it wasn’t the case, it was set to 50, but it is actually not a correct limit, so I bumped it up to 1000 as per documentation and tried to rerun the EM12c repository DBMS Scheduler jobs as per the documentation in 1498456.1

导致我相信是JOB_QUEUE_PROCESSES的问题的原因是它被设置成了0.但不是这个问题，因为我把它设置成了50.但是50依然不是一个正确的值。所以我又根据文档把它提升到1000，然后根据文档1498456.1尝试重新运行EM12C的调度job

SQL> show parameter JOB_QUEUE_PROCESSES

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

job_queue_processes integer 50

SQL> alter system set JOB_QUEUE_PROCESSES=1000 scope = both;

System altered.

SQL> show parameter both

SQL> show parameter job

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

job_queue_processes integer 1000

SQL> connect / as sysdba

Connected.

SQL> alter system set job_queue_processes = 0;

System altered.

SQL> connect sysman/

Connected.

SQL> exec emd_maintenance.remove_em_dbms_jobs;

PL/SQL procedure successfully completed.

SQL> exec gc_interval_partition_mgr.partition_maintenance;

PL/SQL procedure successfully completed.

SQL> @$OMS_HOME/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql SYSMAN

old 11: AND owner = upper('&RECOMPILE_REPOS_USER')

new 11: AND owner = upper('SYSMAN')

old 26: dbms_utility.compile_schema(upper('&RECOMPILE_REPOS_USER'),FALSE);

new 26: dbms_utility.compile_schema(upper('SYSMAN'),FALSE);

old 41: WHERE owner = upper('&RECOMPILE_REPOS_USER')

new 41: WHERE owner = upper('SYSMAN')

old 84: AND owner = upper('&RECOMPILE_REPOS_USER')

new 84: AND owner = upper('SYSMAN')

old 104: AND ds.table_owner = upper('&RECOMPILE_REPOS_USER')

new 104: AND ds.table_owner = upper('SYSMAN')

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

SQL> connect / as sysdba

Connected.

SQL> alter system set job_queue_processes = 1000;

System altered.

SQL> connect sysman/

Enter password:

Connected.

SQL> exec emd_maintenance.submit_em_dbms_jobs;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

后来，我启动了OMS。但即使我修复了调度工作任务的错误，仍然有相同的报错。当时我在emoms.log中看到了如下的错误：

2015-05-18 22:29:09,573 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN auth.EMRepLoginFilter doFilter.450 - InvalidEMUserException caught in EMRepLoginFilter: Failed to login using repository authentication for user: SSA_ADMIN

oracle.sysman.emSDK.sec.auth.InvalidEMUserException: Failed to login using repository authentication for user: SSA_ADMIN

因此我按照文档1493151.1所述，做了对SYSMAN.MGMT_AUDIT_MASTER表的更新，然后跑了MGMT_AUDIT_ADMIN.ADD_AUDIT_PARTITION存储过程

oracle $ sqlplus

Enter user-name: sysman

Enter password:

SQL> update mgmt_audit_master set prepopulate_days=5 where prepopulate_days is null;

1 rows updated. (这里我实践的时候是0)

SQL> select count(1) from mgmt_audit_master where prepopulate_days is null;

COUNT(1)

----------

0

SQL> exec mgmt_audit_admin.add_audit_partition;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

当我做了以上动作之后，我可以用所有的admin权限账户正确登录我的EM12C。

结论就是

即使没有将JOB_QUEUE_PROCESSES设置为0，这也是它失败的原因，因为它是该参数的一个比较低的值，所以小心设置这个参数，得确保遵从最新的安装指南。