Re: emca fails to create database control repository with ORA-01034
Date: Mon, 11 Feb 2008 13:08:40 -0800 (PST)
Message-ID: <290159.76883.qm@web38909.mail.mud.yahoo.com>
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_at_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_at_gmail.com> To: oracle-l_at_freelists.org 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_at_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_at_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-lReceived on Mon Feb 11 2008 - 15:08:40 CST