3.7.0 HP StorageWorks MxDB-Oracle-HiAv installation and administration guide HP MxDB-Oracle-HiAv for Linux (AG513-96009, June 2009)

ORACLE_SID=OLTP1
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
ORACLE_HOSTNAME=OLTP1.customer.com
Unlock dbconsole users for this database
In the session you created with the proper environment variables, unlock the dbsnmp
and sysman user accounts. Use the Oracle sqlplus command line utility to run the
commands. For example:
$ sqlplus / as sysdba
alter user dbsnmp account unlock;
alter user sysman account unlock;
Create the OEM repository for this database
Use the command line tool emca to create the repository. This tool has many varied
and obscure options so caution should be used when running it. In 10g and later,
each database has its own OEM repository that exists as the schema of the user
sysman. Create the OEM repository within the same command window or another
window. If a different window is used, the ORACLE_HOSTNAME, ORACLE_HOME,
and ORACLE_SID environmental variables must be set appropriately for the database
in that window.
The tool will prompt you for the following values. Be cautious and enter the input
carefully.
Database SID:
Listener port number:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
Create the repository using this command:
$ emca –config dbcontrol db –repos recreate
Answer the prompts as they appear. After completing the last prompt, wait for the
command to complete. (This may take a few minutes.)
MxDB-Oracle-HiAv installation and administration guide 63