Oracle Database Discussions

Took all of 1.2 seconds to search for this in documentation:
http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/repository.htm#sthref785

I am really confused now, The documentation says, it creates SYSMAN user automatically and ask for password, But when I was creating repository it did not ask me for SYSMAN password, it asked for SYS/SYSTEM password and then Repository Owner which I set to user OEMREPOWNER.
I logged in to OEMREP database and query dba_users and I did not see SYSMAN user there.
Where should I be looking ? I am using Oracle 9i.

This thing called the Internet - something called Google, searching on "oracle 9i default passwords" - here is one hit from it:

http://download.oracle.com/docs/cd/B10501_01/win.920/a95490/username.htm

In Oracle 9i the default password for SYSMAN is oem_temp.
Google did it but I was counting on this forum.

Steve, though it should be there the username sysman does not appear to be included in your reference unless search just missed it.

-- Mark D Powell --

The information is readily available.
Why ask this forum? Anyway, this is a discussion forum, not a Q & A forum.

--
Sybrand Bakker
Senior Oracle DBA

I am also having the same problem....
sysman is not present in the list of user search via this query
connect as sysdba...
select username from dba_users;;;
it shows all the users but not the sysman,,,,
so how can i connect to oracle management server ?
secondly in services running in xp ,, oralce management server service is stopped ...
and when i try to restart it ,,, it does not do so ,, and shows messages ""
started and stoped as no useful work is done ,,, some thing like this ..
please assist me what to do

Please do not reopen a thread of more than a year old.
Also, please read the installation documentation.
SYSMAN is not a database user, and has never been a database user.
Also, did you look
a) in any documentation
b) oms.nohup

---------------
Sybrand Bakker
Senior Oracle DBA

well thanks for replyig me , i found the solution ,,,,
by the way why oracle made things so tough,,, i mean i did the same task of importing the files in Sql Server an it was just on few click but oracle.....huh

Hi user8660773,

I have the same problem, installed 9i and created the DB.
I do not have the SYSMAN schema.

Now I created the repository but unable to login as I do not have SYSMAN.
How to go around this issue.

Thanks in advance.

Found the solution.
SYSMAN is not an Oracle user. It is related to OMS. This user does not appear in DBA_USERS.
When ever the console asks for the password for the first time give the defailt password as OEM_TEMP. Then it prompts for new password.
Change it and use the new password in the subsequent logins.

Really?

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select username
  2  from dba_users
  3  where username like 'SYSM%'
  4  order by 1;

USERNAME
------------------------------
SYSMAN

SQL> conn sysman
Enter password: 
Connected.
SQL> exit