Home » Infrastructure » Unix » Unable to start EM on Solaris 10 Oracle db 10.2
Unable to start EM on Solaris 10 Oracle db 10.2 [message #398945] Sun, 19 April 2009 23:56 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

I am unable to start my em console on oracle 10g R2. I have set up a test database from my live environment. Both database are in open mode. They are similar except the hostname are not the same. when i am starting the em on the test database. it is referencing on the live database. the hostname of the live database is appearing on the em of the test database. moreover, i am able to log in as system on the test database and that it. if i try to move to the next features on the em, it send it on the login page of the em.

i have try to recreate the DB Control configuration and repository,
but still it does not work.


Please help???????????



sailesh
Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #398947 is a reply to message #398945] Mon, 20 April 2009 00:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please help???????????
Let me summarize.
You have a problem.

Based upon what you have posted how could/can anyone reproduce your situation?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.


Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #399013 is a reply to message #398947] Mon, 20 April 2009 05:10 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>i have try to recreate the DB Control configuration and repository,
but still it does not work

Why?

Post log.

Babu
Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #399026 is a reply to message #399013] Mon, 20 April 2009 05:34 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

I have been able to solve the problem, follow the procedures below:

1. Logon sqlplus as sys
2. drop user sysman cascade;
3. drop role MGMT_USER;
4. drop user MGMT_VIEW cascade;
5. drop public synonym MGMT_TARGET_BLACKOUTS;
6. drop public synonym SETEMVIEWUSERCONTEXT;
7. exit sqlplus

Delete DB Control Configuration Files using EMCA scripts

In 10.2g run, $emca -deconfig dbcontrol db

Create Database Console

To create the configuration files and repository for Database Console, run:

$ emca -config dbcontrol db -repos create


Now it should work, because for me it is working.


Here is the log:


2006-01-09 10:06:42 Thread-1 WARN http: snmehl_connect: connect failed
to (i2dbuat:1830): A remote host refused an attempted
connect operation. (error = 79)
2006-01-09 10:06:48 Thread-1 WARN http: snmehl_connect: connect failed
to (i2dbuat:5500): A remote host refused an attempted
connect operation. (error = 79)
2006-01-09 10:07:12 Thread-1 ERROR http: 6: snmehl_read: error on read:
A connection with a remote socket was reset by that s
ocket. (error = 73)
2006-01-09 10:08:47 Thread-1 WARN http: snmehl_connect: connect failed
to (i2dbuat:5500): A remote host refused an attempted
connect operation. (error = 79)
2006-01-09 10:11:18 Thread-1 WARN http: snmehl_connect: connect failed
to (i2dbuat:5500): A remote host refused an attempted
connect operation. (error = 79)
2006-01-09 10:13:48 Thread-1 WARN http: snmehl_connect: connect failed
to (i2dbuat:5500): A remote host refused an attempted
connect operation. (error = 79)
Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #399035 is a reply to message #399026] Mon, 20 April 2009 06:00 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Thanks for the feedback.

Babu
Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #399038 is a reply to message #399035] Mon, 20 April 2009 06:07 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi Babu,

Have u been able to do it?

Thanks,

Sailesh
Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #399061 is a reply to message #399038] Mon, 20 April 2009 07:17 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Hello,

I hope your problem already re-solved. Before dropping user/role you need post your emca log file. That's helps to everyone.

As per your method it's should work (I know the metalink document)

Babu
Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #399076 is a reply to message #399061] Mon, 20 April 2009 08:04 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
hi babu,

Please find the errors:

Test#more emca_2009-04-17_07-00-35-PM.log
Apr 17, 2009 7:00:35 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-config' set to true
Apr 17, 2009 7:00:35 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'UPDATE_EMAIL' set to true
Apr 17, 2009 7:00:35 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'dbcontrol' set to true
Apr 17, 2009 7:00:35 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Apr 17, 2009 7:00:35 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: ORACLE_HOME value: /oracle/app/oracle/product/10.2
Apr 17, 2009 7:00:35 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 17, 2009 7:00:35 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_HOME value: /oracle/app/oracle/product/10.2
Apr 17, 2009 7:00:38 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID value: cnp1
Apr 17, 2009 7:00:38 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 17, 2009 7:00:38 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: This is expected, as we might be calling it from a non-rac home
Apr 17, 2009 7:00:38 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: Error retrieving the local node for the cluster


Thanks,


Sailesh
Re: Unable to start EM on Solaris 10 Oracle db 10.2 [message #399120 is a reply to message #399076] Mon, 20 April 2009 14:19 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


AS per your log; Let me know error message.

OR Try to post complete log.

Babu
Previous Topic: Oracle forms10g for AIX system
Next Topic: unix shell script
Goto Forum:
  


Current Time: Tue Dec 03 11:38:29 CST 2024