Si de un momento a otro ocurre que no puedes acceder a tu sitio de Oracle Enterprise Manager y estás seguro que el nombre de usuario y clave es correcto.
Solo es cuestion de que revises el estado del usuario en la base de datos, para lo cual, debes ingresar al servidor donde tienes instalado el oracle enterprise manager 12c.
Ingresas por sqlplus y digitas los siguientes comandos para revisar el estado de los usuarios.
et pages 400 set lines 400 column USERNAME format a40; column ACCOUNT_STATUS format a20; column CREATED format a15; column PROFILE format a30; select username, account_status, created, profile from dba_users order by 1; exit;
La salida será algo parecido a lo siguiente
USERNAME ACCOUNT_STATUS CREATED PROFILE ---------------------------------------- -------------------- --------------- ------------------------------ ANONYMOUS EXPIRED & LOCKED 28-JUL-15 DEFAULT APEX_040200 EXPIRED & LOCKED 28-JUL-15 DEFAULT APEX_PUBLIC_USER EXPIRED & LOCKED 28-JUL-15 DEFAULT APPQOSSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT AUDSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT CLOUD_ENGINE_USER EXPIRED & LOCKED 28-JUL-15 DEFAULT CLOUD_SWLIB_USER EXPIRED & LOCKED 28-JUL-15 DEFAULT CTXSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT DBSNMP EXPIRED & LOCKED 28-JUL-15 DEFAULT DIP EXPIRED & LOCKED 28-JUL-15 DEFAULT DVF EXPIRED & LOCKED 28-JUL-15 DEFAULT DVSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT FLOWS_FILES EXPIRED & LOCKED 28-JUL-15 DEFAULT GSMADMIN_INTERNAL EXPIRED & LOCKED 28-JUL-15 DEFAULT GSMCATUSER EXPIRED & LOCKED 28-JUL-15 DEFAULT GSMUSER EXPIRED & LOCKED 28-JUL-15 DEFAULT LBACSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT MDDATA EXPIRED & LOCKED 28-JUL-15 DEFAULT MDSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT MGMT_VIEW OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE OJVMSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT OLAPSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT ORACLE_OCM EXPIRED & LOCKED 28-JUL-15 DEFAULT ORDDATA EXPIRED & LOCKED 28-JUL-15 DEFAULT ORDPLUGINS EXPIRED & LOCKED 28-JUL-15 DEFAULT ORDSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT OUTLN EXPIRED & LOCKED 28-JUL-15 DEFAULT SI_INFORMTN_SCHEMA EXPIRED & LOCKED 28-JUL-15 DEFAULT SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED 28-JUL-15 DEFAULT SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 28-JUL-15 DEFAULT SYS OPEN 28-JUL-15 DEFAULT SYSBACKUP EXPIRED & LOCKED 28-JUL-15 DEFAULT SYSDG EXPIRED & LOCKED 28-JUL-15 DEFAULT SYSKM EXPIRED & LOCKED 28-JUL-15 DEFAULT SYSMAN OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSMAN_APM OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSMAN_MDS OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSMAN_OPSS EXPIRED 05-SEP-18 DEFAULT SYSMAN_RO EXPIRED & LOCKED 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSTEM OPEN 28-JUL-15 DEFAULT WMSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT XDB EXPIRED & LOCKED 28-JUL-15 DEFAULT XS$NULL EXPIRED & LOCKED 28-JUL-15 DEFAULT 43 rows selected. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
En mi caso encontré que estaba bloqueada la cuenta del usuario sysman_opss. Para lo cual entonces lo que hice fue definir la misma clave que tenía originalmente el usuario.
Lo hice con la siguiente sentencia sql
select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('&&username') and u.user# = d.user_id
El sistema me pide el nombre de usuario y escribo el usuario correspondiente , luego el sistema me devuelve la cadena encriptada de la clave que tiene dicho usuario.
Enter value for username: SYSMAN_OPSS
old 1: select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('&&username') and u.user# = d.user_id
new 1: select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('SYSMAN_OPSS') and u.user# = d.user_id
C
--------------------------------------------------------------------------------
alter user "SYSMAN_OPSS" identified by values 'D1238796CAFA32C3';
SQL> alter user "SYSMAN_OPSS" identified by values 'D1238796CAFA32C3';
User altered.
SQL>
Como puede verse, he ejecutado la sentencia que el sistema me devuelve para poder activar de nuevo el usuario con su clave original.
Repaso nuevamente el listado de usuarios y su estado.
USERNAME ACCOUNT_STATUS CREATED PROFILE ---------------------------------------- -------------------- --------------- ------------------------------ ANONYMOUS EXPIRED & LOCKED 28-JUL-15 DEFAULT APEX_040200 EXPIRED & LOCKED 28-JUL-15 DEFAULT APEX_PUBLIC_USER EXPIRED & LOCKED 28-JUL-15 DEFAULT APPQOSSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT AUDSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT CLOUD_ENGINE_USER EXPIRED & LOCKED 28-JUL-15 DEFAULT CLOUD_SWLIB_USER EXPIRED & LOCKED 28-JUL-15 DEFAULT CTXSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT DBSNMP EXPIRED & LOCKED 28-JUL-15 DEFAULT DIP EXPIRED & LOCKED 28-JUL-15 DEFAULT DVF EXPIRED & LOCKED 28-JUL-15 DEFAULT DVSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT FLOWS_FILES EXPIRED & LOCKED 28-JUL-15 DEFAULT GSMADMIN_INTERNAL EXPIRED & LOCKED 28-JUL-15 DEFAULT GSMCATUSER EXPIRED & LOCKED 28-JUL-15 DEFAULT GSMUSER EXPIRED & LOCKED 28-JUL-15 DEFAULT LBACSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT MDDATA EXPIRED & LOCKED 28-JUL-15 DEFAULT MDSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT MGMT_VIEW OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE OJVMSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT OLAPSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT ORACLE_OCM EXPIRED & LOCKED 28-JUL-15 DEFAULT ORDDATA EXPIRED & LOCKED 28-JUL-15 DEFAULT ORDPLUGINS EXPIRED & LOCKED 28-JUL-15 DEFAULT ORDSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT OUTLN EXPIRED & LOCKED 28-JUL-15 DEFAULT SI_INFORMTN_SCHEMA EXPIRED & LOCKED 28-JUL-15 DEFAULT SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED 28-JUL-15 DEFAULT SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 28-JUL-15 DEFAULT SYS OPEN 28-JUL-15 DEFAULT SYSBACKUP EXPIRED & LOCKED 28-JUL-15 DEFAULT SYSDG EXPIRED & LOCKED 28-JUL-15 DEFAULT SYSKM EXPIRED & LOCKED 28-JUL-15 DEFAULT SYSMAN OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSMAN_APM OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSMAN_MDS OPEN 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSMAN_OPSS OPEN 05-SEP-18 DEFAULT SYSMAN_RO LOCKED 28-JUL-15 MGMT_INTERNAL_USER_PROFILE SYSTEM OPEN 28-JUL-15 DEFAULT WMSYS EXPIRED & LOCKED 28-JUL-15 DEFAULT XDB EXPIRED & LOCKED 28-JUL-15 DEFAULT XS$NULL EXPIRED & LOCKED 28-JUL-15 DEFAULT 43 rows selected. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Con esto ya puedes intentar acceder a OEM 12c.
Sin respuestas