I have created a new user USER1. I want to connect OEM for this user. So -
grant connect, resource to user1;
grant select_catalog_role to user1;
To create a new DBControl repository:
emca -config dbcontrol db -repos create
To start a DB Console:
emctl start dbconsole
Managing the agent:
oracle@terminus ~$ set ORACLE_SID=sid
oracle@terminus ~$ echo $ORACLE_SID
THRP
oracle@terminus ~$ emctl stop agent
Stopping Oracle Enterprise Manager 10g Database Control Stopped.
Agent is not running.
oracle@terminus ~$ emctl start agent
Starting agent .... started.
oracle@terminus ~$ emctl start dbconsole
oracle@terminus ~$ emctl status agent
Agent is Running and Ready
When error:
emca -config dbcontrol db -repos recreate
Oracle Enterprise Manager (OEM) is a set of systems management tools provided by Oracle Corporation for managing the Oracle environment and automate tasks.
Database control: OEM application for managing a single Oracle Database.
Grid control: OEM's web based interface for centrally managing all your Oracle environments from a single point.
Implementation: OEM creates a SYSMAN schema in the Oracle DB to store metadata and statistics. SYSMAN also acts as the super-administrator account for first-time login. The default password for SYSMAN is oem_temp.
grant connect, resource to user1;
grant select_catalog_role to user1;
To create a new DBControl repository:
emca -config dbcontrol db -repos create
To start a DB Console:
emctl start dbconsole
Managing the agent:
oracle@terminus ~$ set ORACLE_SID=sid
oracle@terminus ~$ echo $ORACLE_SID
THRP
oracle@terminus ~$ emctl stop agent
Stopping Oracle Enterprise Manager 10g Database Control Stopped.
Agent is not running.
oracle@terminus ~$ emctl start agent
Starting agent .... started.
oracle@terminus ~$ emctl start dbconsole
oracle@terminus ~$ emctl status agent
Agent is Running and Ready
When error:
emca -config dbcontrol db -repos recreate
Oracle Enterprise Manager (OEM) is a set of systems management tools provided by Oracle Corporation for managing the Oracle environment and automate tasks.
Database control: OEM application for managing a single Oracle Database.
Grid control: OEM's web based interface for centrally managing all your Oracle environments from a single point.
Implementation: OEM creates a SYSMAN schema in the Oracle DB to store metadata and statistics. SYSMAN also acts as the super-administrator account for first-time login. The default password for SYSMAN is oem_temp.
