re: How I configure DBCA (10g) to work around ORA-12162?

From: Ir Forex <ir4u4_at_yahoo.com>
Date: Wed, 2 Mar 2005 19:07:34 -0800 (PST)
Message-ID: <20050303030734.41981.qmail@web52805.mail.yahoo.com>

Hi again,

My query is now moot.

The only reason I needed to use DBCA was to setup OEM database control.

It turns out an easy way to setup
OEM database control is to use another utility named EMCA.

Here is the first EMCA command line I used:

$ORACLE_HOME/bin/emca -f /home/oracle/wrinkle/emcaParams.txt

result:

STARTED EMCA at Wed Mar 02 18:20:28 PST 2005 Password for dbsnmp: o
Password for sysman: o
Password for sys: o

Mar 2, 2005 6:20:42 PM oracle.sysman.emcp.EMConfig checkConfiguration SEVERE: Repository already exists. Fix the error(s) and run EM Configuration Assistant aga\ in in standalone mode.
Could not complete the configuration. Refer to the log file for details

According to the doc, I can use a command line arg to force the use of an existing repository.

I added a -r to the command line:

[oracle_at_royal wrinkle]$ $ORACLE_HOME/bin/emca -r -f /home/oracle/wrinkle/emcaParams.txt

STARTED EMCA at Wed Mar 02 18:26:10 PST 2005 Password for dbsnmp: o
Password for sysman: o
Password for sys: o

Mar 2, 2005 6:26:15 PM oracle.sysman.emcp.EMConfig updateReposVars INFO: Updating file /oracle/product/10.1.0.3/db/sysman/emdrep/config/repository.variables .\ ..
Mar 2, 2005 6:26:23 PM oracle.sysman.emcp.EMConfig addPortEntries INFO: Updating file /oracle/product/10.1.0.3/db/install/portlist.ini ... Mar 2, 2005 6:26:23 PM oracle.sysman.emcp.EMConfig updateEmdProps INFO: Updating file /oracle/product/10.1.0.3/db/sysman/config/emd.properties ... Mar 2, 2005 6:26:23 PM oracle.sysman.emcp.EMConfig updateConfigFiles INFO: targets.xml file is updated successfully Mar 2, 2005 6:26:23 PM oracle.sysman.emcp.EMConfig updateEmomsProps INFO: Updating file /oracle/product/10.1.0.3/db/sysman/config/emoms.properties ... Mar 2, 2005 6:26:23 PM oracle.sysman.emcp.EMConfig updateConfigFiles INFO: emoms.properties file is updated successfully

Mar 2, 2005 6:26:26 PM oracle.sysman.emcp.EMConfig startOMS
INFO: Starting the DBConsole ...
Mar 2, 2005 6:28:06 PM oracle.sysman.emcp.EMConfig perform

INFO: DBConsole is started successfully
Mar 2, 2005 6:28:06 PM oracle.sysman.emcp.EMConfig perform INFO: >>>>>>>>>>> The Enterprise Manager URL is http://royal.wrinkle.com:5500/em <<<<<<<<<<< Enterprise Manager configuration is completed successfully FINISHED EMCA at Wed Mar 02 18:28:08 PST 2005
[oracle_at_royal wrinkle]$

Here are the contents of emcaParams.txt:

EM_HOME=/oracle/product/10.1.0.3/db
ORACLE_HOME=/oracle/product/10.1.0.3/db
PORT=1521
SID=dev
HOST=royal
DBSNMP_PWD=o
SYSMAN_PWD=o

I shutdown the embedded app server with this command:

emctl stop dbconsole

I started it with this:

emctl start dbconsole

Here is the URL to remember:

http://royal:5500/em

-moi

Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 02 2005 - 22:10:44 CST