Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
How I configure DBCA (10g) to work around ORA-12162?

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

2005-03-02       - By Ir Forex

Reply:     1     2  

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@(protected) 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@(protected) 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