Sign in to follow this  
Followers 0
WorkingForTheMan

Oracle Database / Server

15 posts in this topic

I won't bother posting my problem(s) in case its a waste of time, but I have absolutely no knowledge of it at all (other than googling, and I've been doing that all day to no avail!), and have what seems an unfixable problem with enterprise manager..

So can anyone help?

Share this post


Link to post
Share on other sites
its not an error as such...

Using Windows 2003 server and oracle 10g(!)

OEM was accessed through web browser using http://localhost:5500/em..but this stopped working after 5 mins..'Internet explorer was unable to display the web page'...only way to get it working again was to stop and restart the service in window services...then 5 mins later would go down again

Looking at log files it seems to say that access is denied to something or other...not at work at the mo so can't access log files, but was someting along the lines of 'OEM started with a PID of 1234, then 30 seconds later 'unable to find PID 1234, forcing exit of OEM'

After most of the day googling it seemed the solution was to reconfigure the OEM by doing something like

emca -deconfig dbcontrol db -repos drop

emca -config dbcontrol db -repos create

(it asks me for various passwords and the listener port??)

but thats made matters worse! it throws up an error about the listener, and now the service won't start at all (it doesn't even exist in the services so I can't restart it from there!

database still up and running and working fine, but no OEM

It would help if I had a clue what I'm doing! I'm a complete beginner to oracle, today is the first time I've used anything other than OEM, but as we have no DBA or techinical support its up to me to fix it! way out of my depth!

Share this post


Link to post
Share on other sites
If OEM is just browser based GUI then there could be a whole heap of simple reasons why it doesn't appear- presumably it is Java based, have you the right version of Java, has IE defaulted to some security mode, has the port changed, firewall etc?

Share this post


Link to post
Share on other sites
[quote name='WorkingForTheMan' timestamp='1335464097' post='909023607']
I won't bother posting my problem(s) in case its a waste of time, but I have absolutely no knowledge of it at all (other than googling, and I've been doing that all day to no avail!), and have what seems an unfixable problem with enterprise manager..

So can anyone help?
[/quote]

You would be better advised posting on a specialist Oracle DBA forum

You will also need to provide more details from the log since the actual error message may merely be a symptom of something else that has gone wrong

Off Topic at HPC is really for discussing politicians with bad wigs and the other major issues facing modern civilisation

BTW you do not mention how the problem started. Has OEM been recently installed or has it been working fine and just blown up today. If the latter and the configuration has not been changed then it suggests that either something outside of OEM is responsible or that you are suddenly blowing some resource limit (the fact that the system starts and then dies after 5 minutes suggests you may have a problem with the latter).. Edited by stormymonday_2011

Share this post


Link to post
Share on other sites
[quote name='thecrashingisles' timestamp='1335468478' post='909023701']
Fubra have a lot of experience with database issues.
[/quote]

No need to rub it in.

Share this post


Link to post
Share on other sites
[quote name='stormymonday_2011' timestamp='1335468290' post='909023697']
You would be better advised posting on a specialist Oracle DBA forum

You will also need to provide more details from the log since the actual error message may merely be a symptom of something else that has gone wrong

Off Topic at HPC is really for discussing politicians with bad wigs and the other major issues facing modern civilisation

[/quote]

I know I'm just clutching at straws really.. I don't have access to logs etc at the moment so was hoping someone might just say 'oh yeah thats simple just double click this icon and all will be fine!' :P

Share this post


Link to post
Share on other sites
[quote name='WorkingForTheMan' timestamp='1335469277' post='909023713']
I know I'm just clutching at straws really.. I don't have access to logs etc at the moment so was hoping someone might just say 'oh yeah thats simple just double click this icon and all will be fine!' :P
[/quote]

Sadly I am not an Oracle DBA (I have not touched it since the days of Oracle 7 and Forms3) but I have plenty of grey hairs from working on other databases from CA-IDMS, through DB2, to SQL Server.

My top tip is don't thrash about blindly and don't tinker with the OEM configuration until you have some idea what exactly is causing the issue

Bitter experience has taught me that no matter how much managers shout for quick fixes doing nothing is better than doing something stupid and making things worse.

Write down the problem (keep it simple) and then list possible causes (permissions and policies, ports, firewalls, listeners, browser settings,applets etc) and investigate them one by one.

Check ALL the available logs including both those generated by Oracle and Windows.

These forums might be place to start looking for help

https://forums.oracle.com/forums/thread.jspa?threadID=1083604
http://www.orafaq.com/forum/t/127736/2/


BTW does the machine in question have a fixed IP address or is DHCP enabled ? Is the loopback adaptor installed ? Edited by stormymonday_2011

Share this post


Link to post
Share on other sites
Your asking in the wrong place:

try asking the question here:
[url="http://serverfault.com/"]http://serverfault.com/[/url]

or perhaps even here if they are too long haired and grumpy on server fault.
[url="http://stackoverflow.com/"]http://stackoverflow.com/[/url]

Share this post


Link to post
Share on other sites
[quote name='stormymonday_2011' timestamp='1335470681' post='909023740']
My top tip is don't thrash about blindly and don't tinker with the OEM configuration until you have some idea what exactly is causing the issue
[/quote]

oops too late!

[quote name='stormymonday_2011' timestamp='1335470681' post='909023740']
Bitter experience has taught me that no matter how much managers shout for quick fixes doing nothing is better than doing something stupid and making things worse.
[/quote]

indeed, I shall be telling them this tomorrow

[quote name='stormymonday_2011' timestamp='1335470681' post='909023740']

These forums might be place to start looking for help

https://forums.oracle.com/forums/thread.jspa?threadID=1083604
http://www.orafaq.com/forum/t/127736/2/
[/quote]

Thanks, will post on there in the morning

Share this post


Link to post
Share on other sites
Tell your work that they need to go Apple from top to bottom, you'll never have any IT issues ever again.
Buckers

Share this post


Link to post
Share on other sites
[quote name='WorkingForTheMan' timestamp='1335469277' post='909023713']
I know I'm just clutching at straws really.. I don't have access to logs etc at the moment so was hoping someone might just say 'oh yeah thats simple just double click this icon and all will be fine!' :P
[/quote]

Oh yeah thats simple just double click this icon and all will be fine! -> :)

Share this post


Link to post
Share on other sites
[quote name='WorkingForTheMan' timestamp='1335465827' post='909023656']
its not an error as such...

Using Windows 2003 server and oracle 10g(!)

OEM was accessed through web browser using http://localhost:5500/em..but this stopped working after 5 mins..'Internet explorer was unable to display the web page'...only way to get it working again was to stop and restart the service in window services...then 5 mins later would go down again

Looking at log files it seems to say that access is denied to something or other...not at work at the mo so can't access log files, but was someting along the lines of 'OEM started with a PID of 1234, then 30 seconds later 'unable to find PID 1234, forcing exit of OEM'

After most of the day googling it seemed the solution was to reconfigure the OEM by doing something like

emca -deconfig dbcontrol db -repos drop

emca -config dbcontrol db -repos create

(it asks me for various passwords and the listener port??)

but thats made matters worse! it throws up an error about the listener, and now the service won't start at all (it doesn't even exist in the services so I can't restart it from there!

database still up and running and working fine, but no OEM

It would help if I had a clue what I'm doing! I'm a complete beginner to oracle, today is the first time I've used anything other than OEM, but as we have no DBA or techinical support its up to me to fix it! way out of my depth!
[/quote]
I'm an Oracle DBA. This error is a common problem. We had it recently too. Can't remember what the fix was exactly though. I'm not at work for a couple of days but when I get back I'll check it out and post the fix.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0