Sunday, August 7, 2016

oracle sysman default password password set

      How To Set Oracle SYSMAN User Default Password

SYSMAN is not an Oracle user. It is related to OMS. This user does not appear in DBA_USERS.
When ever the console asks for the password for the first time give the default password as OEM_TEMP. Then it prompts for new password.
Change it and use the new password in the subsequent logins.

Its very simple first you check below query for  sysman user and then conn sys  (put your desire password) click here

[oracle@awback01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 7 13:15:21 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select username
    from dba_users
    where username like 'SYSM%'
    order by 1;  2    3    4

USERNAME
------------------------------
SYSMAN

SQL> conn sysman
Enter password:
Connected.
SQL> show user
USER is "SYSMAN"


When ever the console asks for the password for the first time give the defailt password as OEM_TEMP. Then it prompts for new password.
Change it and use the new password in the subsequent logins. 


No comments:

Post a Comment