Take the 2-minute tour ×
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?

Thanks

share|improve this question
add comment

2 Answers

up vote 2 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? –  Mercfh 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
add comment

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: http://docs.oracle.com/cd/B28359_01/install.111/b32002/rev_precon_db.htm#autoId1

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
export ORACLE_SID=XE
$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;
exit
share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.