OraFAQ Forum: Enterprise Manager » can't run enterprise manager on standy database

Home » RDBMS Server » Enterprise Manager » can't run enterprise manager on standy database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can't run enterprise manager on standy database [message #203392]

Wed, 15 November 2006 00:18

parekh_hiten
Messages: 3
Registered: November 2006
Location: mumbai

Junior Member

hello every1..
my satndby database is working fine .. i have installed oracle 10g R2 on windows server 2003 .. i m trying to run enterprise manager but its not working .. i even tried to create repository using the EMCA batch file but its not creating repository .. i have done the following things ..

STARTED EMCA at Wed Oct 25 12:33:46 GMT+05:30 2006
Enter the following information about the database to be configured
Listener port number: 1521
Database SID: ORCL
Service name: ORCLSTBY
Email address for notification:
Email gateway for notification:
Password for dbsnmp:
Password for sysman:
Password for sys: :
Password for sys:
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ D:\oracle\product\10.1.0\db_1
Enterprise Manager ORACLE_HOME ................ D:\oracle\product\10.1.0\db_1

Database host name ................ drdb.parle.biz
Listener port number ................ 1521
Database SID ................ ORCL
Service name ................ ORCLSTBY
Email address for notification ...............
Email gateway for notification ...............

-----------------------------------------------------------------
Do you wish to continue? [yes/no]: yes
Oct 25, 2006 12:34:04 PM oracle.sysman.emcp.EMConfig checkConfiguration
WARNING: 'shared_pool_size' must be greater than or equal to 80 MB.
Oct 25, 2006 12:34:04 PM oracle.sysman.emcp.EMConfig checkConfiguration
SEVERE: 'job_queue_processes' must be greater than or equal to 1. Fix the error
(s) and run EM Configuration Assistant again in standalone mode.
Could not complete the configuration. Refer to the log file for details

i also checked this error which results into a patch code or an error code as EMCA 3456232

please help me ..
waiting for some replies ..
Parekh Hiten
(DBA)

Report message to a moderator

Re: can't run enterprise manager on standy database [message #203396 is a reply to message #203392]

Wed, 15 November 2006 00:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi parekh.

OEM is not running. then first check services.

cmd>set oracle_sid=''
cmd>emctl status dbconsole ( if stop )
cmd>emctl start dbconsole

or if you want to create new repository then first delete old one.

go through below link for complete assistance for EMCA.

http://www.akadia.com/services/ora_dbconsole.html

and about ur error. you hitting bug.

Bug 3456232 EMCA may give misleading errors
refer metalink note : 3456232.8

hope this helps.
Mohammad Taj.

Report message to a moderator

Re: can't run enterprise manager on standy database [message #203402 is a reply to message #203396]

Wed, 15 November 2006 00:51

parekh_hiten
Messages: 3
Registered: November 2006
Location: mumbai

Junior Member

thanks taj ..

but the problem is during the installation of oracle10g i did not create database thru DBCA .. i just took the cold backup of the production database and created standbycontrol file .. i started SQLPLUS and all my databases n tablespaces were fine on standby side ... but during installation it created OEM agents n services ... but its not showing OracleDbConsole service ... so how can i create an OracleDBConsole service ...

please help '
thanks
Hiten PArekh

Report message to a moderator

Re: can't run enterprise manager on standy database [message #203424 is a reply to message #203402]

Wed, 15 November 2006 02:10

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi parekh.

How to create OracleDBConsole.

first go through below link and perform step by step .
http://www.dbtips.com/change_db_port_oracle10g.htm

then go through below link and perform step by step.
http://www.dbtips.com/OracleDBConsole_manual_recreation.htm

if production db then try first on test enviourment.

hope this helps.
Mohammad Taj.

Report message to a moderator

Re: can't run enterprise manager on standy database [message #203430 is a reply to message #203424]

Wed, 15 November 2006 02:21

parekh_hiten
Messages: 3
Registered: November 2006
Location: mumbai

Junior Member

hi there ..
i had already tried out the solutions you provided me ... m still searching for some new solutions ... actually thru DBCA m getting Insufficient Privileges ORA 01031 error wen i try to connect my standby database ...

regards
Hiten Parekh

Report message to a moderator

Previous Topic:	grid errors
Next Topic:	Problem using Net Service Alias for OID

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:32:42 CDT 2024