Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Any idea what the default login is? none of my oracle accounts are working.

share|improve this question

3 Answers 3

If you want to login with scott/hr/whatever schema. Then login with SQL*plus using that account by just going to

http://localhost:5560/isqlplus

localhost represents your system. You can enter the IP address of the database server if you are remotely accessing the database. In connect identifier add database name (for example orcl), we can access a normal user like hr or scott, because these users don't have access to manipulate the database.

That's why they can't work on em:1158. Only limited users like sys/system can access on em:1158 to manipulate the database.

share|improve this answer
up vote 1 down vote accepted

Hey, I got it, you have to log in as SYS as sysdba. I swear I had tried that, but it works now.

share|improve this answer

You will need to unlock the SCOTT/HR/whatever schema you've created / want to work on.

Login into SQL*Plus as sysdba and then proceed with

ALTER USER <USERNAME> ACCOUNT UNLOCK;

Once unlocked, login to the Enterprise manager, the default URL should be http://<ip-address-of-database-server>:1158/em

share|improve this answer
    
I did that. I made my own user account, and I just unlocked scott, set his password, granted all privileges to him and it still says login operation failed. I'm sure I'm missing something obvious but I'm too new to this to know... –  Stu Feb 25 '10 at 15:58
    
what privileges have you granted ? Can you login via SQL*Plus using that account ? –  Sathya Feb 25 '10 at 18:15

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.