Oracle DBA Tips and Techniques

By Arjun Raja

MANUAL INSTALLATION OF DB CONTROL

Posted by Gavin Soorma on June 29, 2009

To manually install and administer a database using DBCONTROL –

cd $ORACLEHOME/bin
oraofsap(DATABASE)@xxxxx:pwd
/u01/app/oracle/product/10.2/bin

./emca -config dbcontrol db -repos create

STARTED EMCA at Oct 23, 2008 10:23:59 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: test
Listener port number: 1521
Password for SYS user: ——– ENTER SYS PASSWORD
Password for DBSNMP user:——ENTER DBSNMP PASSWORD
Password for SYSMAN user: – no user exists so just give any password.
Email address for notifications (optional): Enter
Outgoing Mail (SMTP) server for notifications (optional):
—————————————————————–

You have specified the following settings

Database ORACLE_HOME …………… /u01/app/oracle/product/10.2

Database hostname ……………. xxxxxx.xxxxx.com
Listener port number ……………. 1521
Database SID ……………. test
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………

—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: Y
Oct 23, 2008 10:26:36 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2/cfgtoollogs/emca/test/emca_2008-10-23_10-23-58-AM.log.
Oct 23, 2008 10:26:40 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …

Oct 23, 2008 10:30:52 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Oct 23, 2008 10:31:07 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
Oct 23, 2008 10:32:04 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Oct 23, 2008 10:32:04 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Oct 23, 2008 10:33:48 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 23, 2008 10:33:48 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://xxxxxx.xxxxx.com:1158/em <<<<<<<<<<< – use the I.P address also -https://10.254.203.177:1158/em
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 23, 2008 10:33:48 AM
oracle(DATABASE)@xxxxx:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: