Home » RDBMS Server » Enterprise Manager » OEM - target database is not existed (11.2.0.4)
OEM - target database is not existed [message #630999] Wed, 07 January 2015 09:35 Go to next message
bvo65
Messages: 25
Registered: November 2009
Location: US
Junior Member
Hello,

The OEM daemon (dbconsole) was not running since last year. It gave me hard time to start up dbconsole. Now it's started but I don't see any database targets. This is standalone database server. How can I add the target? I have tried to use 'emca -config all db -repos recreate (even create)" doesn't work.
first, I run:
emca -config all db -repos recreate
Database SID: AAL01

and it gives me errors below:

Jan 7, 2015: 9:26:01 AM oracle.emcp.DatabaseChecks checkDbAvailabilityImpl
WARNING: ORA-01024" Oracle not available
Jan 7, 2015: 9:26:01 AM oracle.emcp.DatabaseChecks throwDBUnavailableException SERVERE:
1) database may not be up
2) database is started setting environmnet varialbe ORACLE_HOME with trailing '/'. Reset ORACLE_HOME and bounce the database
For eg. Database is started setting environment varialbe ORACLE_HOME=/scratch/db .Reset ORACLE_HOME and bounce the database

The database is up and running. ORACLE_HOME does set to the right path

If I put Database SID = +ASM and I get more input entries:

emca -config all db -repos recreate
Database SID:+ASM
Central agent Home:/oracle/product/product/11.2.0/dbhome_1
Listener port number: 1521
Listerner ORACLE_HOME [/oracle/product/grid ]: (I enter for default)
Password for SYS user:
Jan 7, 2015: 9:34:01 AM oracle.emcp.DatabaseChecks checkDataGuardEnabled
WARNING: ORA-01507: database not mounted
Password for DBSNMP user:
Jan 7, 2015: 9:34:01 AM oracle.sysman.emcp.util.GeneralUtil initSqLEngineLoacly
WARNING: ORA-15000: command disallowed by current instance type null [ORA-01219: database not open: queries allowed on fixed tables/views only]

what I did wrong here? and how can I add the target into OEM Dbconsole?

thanks,

BN
Re: OEM - target database is not existed [message #632285 is a reply to message #630999] Wed, 28 January 2015 11:02 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Perhaps you need to start the "agent":
$ cd /oracle/product/product/11.2.0/dbhome_1/bin
$ ./emctl start agent

[Updated on: Wed, 28 January 2015 11:56] by Moderator

Report message to a moderator

Re: OEM - target database is not existed [message #632286 is a reply to message #632285] Wed, 28 January 2015 11:10 Go to previous message
bvo65
Messages: 25
Registered: November 2009
Location: US
Junior Member
agent can't start if you are using dbconsole. Only work if you are using grid control

you can check the status of agent and it's running.

also, I found both repository url pointed to one node... that's why if node1 is down, I can't check node2 using OEM/dbcontrol
Previous Topic: Tablespace Report
Next Topic: Issue while install and configure EM.
Goto Forum:
  


Current Time: Thu Mar 28 18:04:12 CDT 2024