Acceso denegado al web de Oracle Enterprise Manager 12c

 

 

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.

 

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *