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

gpafogarty Oct 23, 2013 2:24 PM

Currently Being Moderated

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

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

sxkumar Oct 23, 2013 2:42 PM (in response to gpafogarty)

Currently Being Moderated

For pre-12c database, SYSMAN schema is created by default by DBCA to enabled DB Control.
Report Abuse

Like (0)
2. Re: Why does DBCA 12c Create SYSMAN Account in D/B that does not contain OEM Repository

gpafogarty Oct 24, 2013 7:03 AM (in response to sxkumar)

Currently Being Moderated

Thank you for that information. After reading your comment I found Oracle Support document,
"Troubleshooting EMCA Failures Due to SYSMAN and Other Existing Objects During Configuration (Doc ID 1110043.1)".
One paragraph in it states,
"When the Database Configuration Assistant (DBCA) is used for creating a database, the DBCA provides an option for the user to choose whether the Enterprise Manager Database Control should be configured in this database. Even if this option is not selected, the DBConsole repository under the SYSMAN schema is still created by the DBCA tool."

That describes what happened to me. DBCA created accounts sysman and mgmt_view, and the DBConsole repository, even though I selected "Configure Enterprise Manager" instead of "Configure Database Control for local management". I will likely use emca to drop these users and remove the repository from the three databases where is is not needed.

Thanks,
Bill
Report Abuse

Like (0)

Go to original post

Actions

Legend

Correct Answers - 10 points
Helpful Answers - 5 points