Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've just installed an Oracle 11g Standard Edition Database. It ran successfully and everything, however when going to Oracle Enterprise Manager Im not really sure what my "username" would be.

I entered a password during the installer, and I tried SYS and my password connecting as "Normal" and "SYSDBA". However, I'm not really sure what my username is meant to be. Is it just that I haven't set up a username/password for this yet?


share|improve this question

2 Answers 2

up vote 1 down vote accepted

Here is the Oracle 11.2 installation document describing the administrator user accounts after installation. Once logged in, you would change passwords with the syntax

alter user system identified by mynewpassword;
share|improve this answer
It says the DBA role is created with every account but doesn't actually list a default password? – user1031 Jul 23 '13 at 20:50
The SYS and SYSTEM accounts are assigned the DBA role. The DBA role does not have a password, the accounts do. The DBA role is created with every installation. You could grant the DBA role to another user if needed. – Henry Helgen Jul 23 '13 at 20:59

The best account to login to the Oracle Enterprise Manager Database Control (EMDC) is the SYSMAN user account; with it, you are logging in as the proper EMDC super user. Use NORMAL, not AS SYSDBA.

Alternatively, you can use SYSTEM (specifying AS SYSDBA).

This is per 11.1 manual:

The same manual describes how to, being in EMDC, convert another "normal" database user (the one you use in sqlplus) into an EMDC-capable user. Or, from within EMDC, you can create a new user: a database user that is both EMDC-capable and sqlplus-capable from the beginning.

As SYSMAN wouldn't have a password by default after install, you need to assign it. Just become an OS user which is in dba group (typically this OS user is called oracle). This is for Linux, but it is similar enough in Windows. Then issue:

export ORACLE_HOME=/your/path/bla/bla/db_1
$ORACLE_HOME/bin/sqlplus /nolog
connect / as sysdba
-- here this should let you in without password
-- if this displays "idle instance", you probably need to STARTUP
alter user sysman identified by "MyPass!@#$";
alter user sysman account unlock;
share|improve this answer
+1 That helped me. Thanks :) – qwerty Sep 11 '14 at 15:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.