Home » RDBMS Server » Enterprise Manager » can't run enterprise manager on standy database
can't run enterprise manager on standy database [message #203392] Wed, 15 November 2006 00:18 Go to next message
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)
Re: can't run enterprise manager on standy database [message #203396 is a reply to message #203392] Wed, 15 November 2006 00:42 Go to previous messageGo to next message
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.
Re: can't run enterprise manager on standy database [message #203402 is a reply to message #203396] Wed, 15 November 2006 00:51 Go to previous messageGo to next message
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
Re: can't run enterprise manager on standy database [message #203424 is a reply to message #203402] Wed, 15 November 2006 02:10 Go to previous messageGo to next message
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.
Re: can't run enterprise manager on standy database [message #203430 is a reply to message #203424] Wed, 15 November 2006 02:21 Go to previous message
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
Previous Topic: grid errors
Next Topic: Problem using Net Service Alias for OID
Goto Forum:
  


Current Time: Sat Dec 10 18:46:35 CST 2016

Total time taken to generate the page: 0.13051 seconds