Re: emca fails to create database control repository with ORA-01034

Are you sure your listener is running and can accept connections to the 
database:

lsnrctl status
Check that your database is listed here and is accepting connections.


sqlplus blah/blah@db_name

TNSNAMES.ORA configured correctly?

Are you sure you have entered the right passwords entered for SYS and DBSNMP?

Do you have a password file created?

Database running in restricted mode?

My guess is that the answer to one of these questions is no...

RF


 
Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle  (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

----- Original Message ----
From: Francisco Rodera <trek1s@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Monday, February 11, 2008 1:52:29 PM
Subject: emca fails to create database control repository with ORA-01034


Hello,

After 
installing 
Oracle 
10.2.0.3 
(on 
RHEL 
5) 
software 
and 
successfully
creating 
a
database 
(named 
"10gr2") 
I'm 
trying 
to 
setup 
EM 
Database 
Control.

This 
is 
the 
command 
I 
execute:

***********************************************************
$ 
emca 
-config 
dbcontrol 
db 
-repos 
create

STARTED 
EMCA 
at 
Jan 
18, 
2008 
8:52:20 
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: 
10gr2
Listener 
port 
number: 
1521
Password 
for 
SYS 
user:
Password 
for 
DBSNMP 
user:
Invalid 
username/password. 
[ORA-01034: 
ORACLE 
not 
available]
*****************************************************

I 
don't 
know 
why 
it 
says 
"Oracle 
not 
available" 
since 
both 
instance
and 
listener 
are 
up 
and 
running.

EMCA 
log 
reports 
this:
************************************
Jan 
18, 
2008 
8:53:02 
AM 
oracle.sysman.emcp.util.GeneralUtil
initSQLEngine
CONFIG: 
SQLEngine 
connecting 
with 
SID: 
10gr2, 
oracleHome: 
/oracle/app/
oracle/product/10.2.0, 
and 
user: 
SYS
Jan 
18, 
2008 
8:53:02 
AM 
oracle.sysman.emcp.util.GeneralUtil
initSQLEngine
CONFIG: 
SQLEngine 
created 
successfully 
and 
connected
Jan 
18, 
2008 
8:53:02 
AM 
oracle.sysman.emcp.DatabaseChecks
validateUserCredentials
CONFIG: 
Failed 
to 
update 
account 
status.
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException:
ORA-01034: 
ORACLE 
not 
available

at 
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:
1467)
at
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:
694)
at
oracle.sysman.emcp.DatabaseChecks.updateAccountStatus(DatabaseChecks.java:
1049)
at
oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:
1017)
at
oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:
2702)
at
oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:
591)
at
oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java:
2249)
at
oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:
2275)
at
oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:
2302)
at
oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:
946)
at
oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:
469)
at
oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:418)
***********************************

Environment 
seems 
correctly 
configured:

[ora10@pegasus 
~]$ 
env 
| 
grep 
ORA
ORACLE_SID=10gr2
ORACLE_HOSTNAME=pegasus
ORACLE_BASE=/oracle/app/oracle/
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/
[ora10@pegasus 
~]$ 
hostname
pegasus

And, 
I 
insist, 
both 
instance 
and 
listener 
are 
up 
as 
well 
as 
users 
SYS,
DBSNMP 
and 
SYSMAN 
are 
unlocked. 
(I've 
verified 
this 
several 
times)

Metalink 
and 
google 
have 
not 
been 
helpful 
regarding 
this 
problem 
:(

Need 
help 
or 
advice 
on 
this, 
please.

Thanks 
in 
advance.
--
http://www.freelists.org/webpage/oracle-l





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

Other related posts: