OraFAQ Forum: Unix » Unable to start EM on Solaris 10 Oracle db 10.2

Home » Infrastructure » Unix » Unable to start EM on Solaris 10 Oracle db 10.2

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

Unable to start EM on Solaris 10 Oracle db 10.2 [message #398945]

Sun, 19 April 2009 23:56

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

Report message to a moderator

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

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.

Report message to a moderator

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

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

Report message to a moderator

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

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)

Report message to a moderator

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

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thanks for the feedback.

Babu

Report message to a moderator

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

sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS

Member

Hi Babu,

Have u been able to do it?

Thanks,

Sailesh

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 03:50:17 CDT 2025