| OEM - target database is not existed [message #630999] |
Wed, 07 January 2015 09:35  |
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 #632286 is a reply to message #632285] |
Wed, 28 January 2015 11:10  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
