How to start EM console in Oracle 10g

I am starting EM console from browser at http://bobik:5500/em
but it requested Database Credentials and Host Credentials

Where can I get Host Credentials?
I've installed DB on computer with WinXP and no users so when I start this computer it is not required any login/password.
LVL 2
serg111Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

schwertnerCommented:
Answer with the Windows user name and password
0
peterside7Commented:
Go in control panel ... user accounts

And look there if you see a user you could use.
If not create one, and use it for your host credential.
Pierre
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
schwertnerCommented:
Look in the administration settings for an OS user. May be you can find one there.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

trickys77Commented:
When I installed 10g  I had to specify a password for SYS and SYSTEM at minimum......

In the em console in the host info put in your computer user & pass and in the system put in SYS or SYSTEM as the user and the password you specified for it.

Your password you would have had to enter when you installed XP....you wouldn't be able to install without it.  Try going into the user accounts section in the control panel and click on change an account...select administratrator and click change my password.......this is time to try and guess which password you entered!!!

Documentation on getting started can be found at http://www.oracle.com ...u need to register but this is free!

I can recommend the windows 32 bit 2 day database guide....very handy!

Good Luck!!!

P.s. If you want windows to ask for the password when you log on, click on the change the way users log on button in the user account menu...the option is there for it.
0
serg111Author Commented:
Ok, password was disabled so I enabled it now and got some "progress"

It tells me that "Account is locked" when I try to login as SYSDBA username SYSTEM,SYS or SYSDBA

P.S. I've just downloaded and installed database from oracle.com
0
peterside7Commented:
Do you have a dba group assign to the user you're working with.

Can you just try to connect not as sysdba ?
with system/manager

Pierre
0
serg111Author Commented:
peterside7

1) How can I check it?

2)username SYSTEM
password manager
give same error :-(

but I can login to SQLPLUS "/ as sysdba"
and I can login to iSQLPLUS as scott/tiger
0
trickys77Commented:
Glad I could be of some help :o)


When you login to the em console under the host info use SYS and the password, and select sysdba from the drop down list.

SYSTEM should work but SYS def. has dba access by default.

Hope this helps.
0
serg111Author Commented:
I did, but it tells me "Account is locked"...
0
MikeOM_DBACommented:
Try:

User: sysadm
Password: OEM_TEMP

0
serg111Author Commented:
Same problem...

 
   SQLException
 
 
 
ORA-28000: the account is locked  
 
0
peterside7Commented:
Sorry for the delay, I just got back ...

Try this:

ALTER USER PORTAL_PUBLIC ACCOUNT UNLOCK;
while connected with  sqlplus "/ as sysdba"

and read the following :

Errors
  ORA-28000 the account is locked
  HTTP-503 Service Unavailable

  Symptoms
  Accessing Portal gives "Service Temporarily Unavailable." error in browser
  1. For http://middletier:port - Http server page comes up
  2. For http://middletier:port/pls/portal - There is the error, "Service Temporarily Unavailable"

  error_log shows the following error:
  [error] mod_plsql: /pls/portal/portal.home
  HTTP-503 ORA-28000 Client Logon Failed with error : 28000
  [error] mod_plsql: /pls/portal_sso/portal_sso.wwsso_home.home HTTP-503 ORA-28000 Client Logon Failed with error : 28000

  Cause
  In the database, PORTAL_PUBLIC account is locked

  Fix
  Unlock the PORTAL_PUBLIC account.

  ALTER USER PORTAL_PUBLIC ACCOUNT UNLOCK;

  Check that status that it is unlocked.

  select username,account_status,lock_date,profile from dba_users where username
  in ('PORTAL_PUBLIC')


0
peterside7Commented:
Did you try it ? is it working ?
0
serg111Author Commented:
Also it tells me
SYSDBA and SYSOPER does not exist...
0
MikeOM_DBACommented:
What about:

User: sysman
Password: OEM_TEMP
???

0
peterside7Commented:
Just wandering.
Did you just installed a database or did you also installed OEM in it's own repository ?
0
serg111Author Commented:
SYSMAN login tells me "Account is locked"


I did install a database that I've downloaded from oracle.com
It was standard installation.

But after installation I have added password for this WinXP so I can login to OEM (see above)
0
lk9984Commented:
Just installed 10g 10.1.0 on my Windows 2000
went to the password screen and left SYS and SYSTEM unlocked.  Chose the same password for each.
could not find anything that made sense after the initial install so I continued with the instructions to create a new database.  This time it did allow me to select SAMPLES. and when it finished I was able to open browser http://<my computer name>:5500/em/console/logon/logon
When I use SYS or SYTEM and the password I get ORA-28009 connection to sys should be as sysdba or sysoper.
I opened a DOS window and somehow got sqlplus started?? Monkeyed around and at enter user-name: CONN AS SYSDBA lead to Enter password: and my common password was accepted
Connected to:
Oracle Databse 10g Enterprise Edition Release 10.1.0.2.0 - Production with the Partitioning, OLAP and Data Mining Options.

SQL>Grand DBA to SYS
Grant succeeded.
Went back to browser window but still getting the same problem.
Tried a bunch of combinations with SYSDBA and SYS there but no cigar.
Back at the DOS window
SQL> create user myUser identified by pswd;
User created.
SQL> grant dba to myUser;
Grant succeeded.

Tried to use myUser and pswd in browser get Your username and /or password are invalid
Very frustrated.  Even if I get past this part I have no idea where the MEAT is!  I am just trying to follow the 2 day DBA.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.