Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why does DBCA 12c Create SYSMAN Account in D/B that does not contain OEM Repository

gpafogartyOct 23 2013 — edited Oct 24 2013

A couple of months ago I installed Oracle Database 11.2.0.3 on an AIX7.1 server. I used the DBCA to create an 11gR2 database to hold the repository for OEM 12c. I had the DBCA usean Oracle supplied template that configured the database for use as the home of the OEM repository (EM 12.1.0.3 Small Deployment). I installed OEM 12c on a Windows server and had it create its repository in the SYSMAN schema of the database on the AIX server.

I used the Console for OEM 12c to install the Oracle Management Agent on the AIX server. It discovered the targets on that server and can manage them all. They were the agent, listener, and repository database.

Recently I used the Oracle 11gR2 DBCA on the AIX server to create several more databases. None of them will hold an OEM repository. I did notinstruct the DBCA to use Oracle's repository template. I selected template "General Purpost or Transaction Processing". The DBCA created account SYSMAN in each of the new databases. The account is locked.

What is the sysman account used for in non-repository databases? I checked in one of the new databases and found there are 3554 objects in the sysman schema. In the OEM Grid Control 10.2.0.2 system I am coming from the sysman account exists in only the repository database. Does anyone know of an Oracle document that explains the purpose of the sysman account in non-repository databases?

Thank you,

Bill

This post has been answered by gpafogarty on Oct 24 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 21 2013
Added on Oct 23 2013
2 comments
1,141 views