How to create SYSMAN user in Oracle database Step by Step

Step 1:  Below details will be required to create SYSMAN user.

Example:

Oracle Home =>  /eu01/app/oracle/product/11.2.0.4/dbhome_1        

Username    =>   SYSMAN                                                   

Password    =>   sys123

Temporary tablespace name  => TEMP

Verify On/Off              => ON

Step 2: The script emRepository.sql actually creates SYSMAN user in the database if it does not exists. This script is located in the below directory.

$ORACLE_HOME/sysman/admin/emdrep/sql/emreposcre.sql 

emRepository.sql is normally run when you create a new Database. 

DBCA puts the scripts in $ORACLE_BASE/admin/<DB>/scripts.

The script emRepository.sql calls an another sql script emreposcre.sql by passing below 5 parameters :

• Oracle Home
• Username
• Password
• Temporary tablespace name
• Verify On/Off

Take the values of above parameters and enter these values  in runtime.

SQL> @?/sysman/admin/emdrep/sql/emreposcre.sql 

SQL> select username,account_status from dba_users where username='SYSMAN';