Jump to content


Photo
- - - - -

Oracle Database / Server


  • Please log in to reply
14 replies to this topic

#1 WorkingForTheMan

WorkingForTheMan

    HPC Poster

  • Members
  • PipPip
  • 216 posts

Posted 26 April 2012 - 06:14 PM

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?

#2 RichB

RichB

    HPC Guru

  • Members
  • PipPipPipPipPipPip
  • 5,769 posts
  • Location:London

Posted 26 April 2012 - 06:18 PM

Haha... good luck.




Oracle





:lol:

#3 petetong

petetong

    HPC Regular

  • Members
  • PipPipPip
  • 452 posts

Posted 26 April 2012 - 06:30 PM

Well it's better than that pile of shite known as SQL Server.

What's the error you are getting ?
I am a bomb technician. If you see me running try to keep up.

#4 WorkingForTheMan

WorkingForTheMan

    HPC Poster

  • Members
  • PipPip
  • 216 posts

Posted 26 April 2012 - 06:43 PM

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!

#5 Mikhail Liebenstein

Mikhail Liebenstein

    HPC Guru

  • Members
  • PipPipPipPipPipPip
  • 6,141 posts
  • Location:Dorking

Posted 26 April 2012 - 07:06 PM

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?

#6 stormymonday_2011

stormymonday_2011

    HPC Guru

  • Members
  • PipPipPipPipPipPip
  • 6,412 posts

Posted 26 April 2012 - 07:24 PM

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?


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, 26 April 2012 - 07:39 PM.

The certainty of misery is preferable to the the misery of uncertainty

#7 thecrashingisles

thecrashingisles

    I live on HPC!

  • Members
  • PipPipPipPipPipPipPip
  • 14,148 posts

Posted 26 April 2012 - 07:27 PM

Fubra have a lot of experience with database issues.

#8 stormymonday_2011

stormymonday_2011

    HPC Guru

  • Members
  • PipPipPipPipPipPip
  • 6,412 posts

Posted 26 April 2012 - 07:41 PM

Fubra have a lot of experience with database issues.


No need to rub it in.
The certainty of misery is preferable to the the misery of uncertainty

#9 WorkingForTheMan

WorkingForTheMan

    HPC Poster

  • Members
  • PipPip
  • 216 posts

Posted 26 April 2012 - 07:41 PM

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


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

#10 stormymonday_2011

stormymonday_2011

    HPC Guru

  • Members
  • PipPipPipPipPipPip
  • 6,412 posts

Posted 26 April 2012 - 08:04 PM

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


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.oracl...hreadID=1083604
http://www.orafaq.co...rum/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, 26 April 2012 - 08:27 PM.

The certainty of misery is preferable to the the misery of uncertainty

#11 AteMoose

AteMoose

    INTJ <- No S :(

  • Members
  • PipPipPipPipPipPipPip
  • 9,516 posts
  • Location:Wu, UK

Posted 26 April 2012 - 08:09 PM

Your asking in the wrong place:

try asking the question here:
http://serverfault.com/

or perhaps even here if they are too long haired and grumpy on server fault.
http://stackoverflow.com/
I have bought a newish (5 years) house in November 2006. I talked the vendor down 30% off peak 2004 price am am paying less than the 2002 price. I feel prices will continue to drop down to the 2001 price but saving for 5 years hopefully means i wont be stung. The price i am paying isn't much above the price the vendor paid for the place when it was new in 2000. However some idiot is trying to flog an identical house on my road for 55k above the price i paid, one month later!?!?! The housing market is frothy, no-one ever knows what the value of a house is, the value is what someone is willing to pay, make sure you pay alot less than the asking price.

Free to collect, like ebay but you dont pay, you just have to collect

QUOTE (sledgehead)If you make a living from something, you are a professional something: it is your profession. You could bake dog turds and flog them as ornaments. If that's how you make your living, you ARE a professional dog-turd baker. Period
QUOTE (Rolling Stone 13th July 2000)The first thing you need to know about Goldman Sachs is that it's everywhere. The world's most powerful investment bank is a great vampire squid wrapped around the face of humanity, relentlessly jamming its blood funnel into anything that smells like money.

QUOTE (Soon Not a Chain Retailer @ Aug 30 2009, 01:03 AM) Society should provide trampolines not safety nets.

QUOTE (GordonBrown Jan 27 2008 (warning about the coming inflation?))if you don't get the skills you wont get a job
if you get the skills you will earn ALOT of money

#12 WorkingForTheMan

WorkingForTheMan

    HPC Poster

  • Members
  • PipPip
  • 216 posts

Posted 26 April 2012 - 08:27 PM

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


oops too late!

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.


indeed, I shall be telling them this tomorrow

These forums might be place to start looking for help

https://forums.oracl...hreadID=1083604
http://www.orafaq.co...rum/t/127736/2/


Thanks, will post on there in the morning

#13 buckers

buckers

    HPC Veteran

  • Members
  • PipPipPipPip
  • 2,029 posts
  • Location:Hereford
  • About Me:Too many for my income !!! Still quite interested in girls, even after all these years.

Posted 27 April 2012 - 06:29 AM

Tell your work that they need to go Apple from top to bottom, you'll never have any IT issues ever again.
Buckers
IO, IO, it's off to work they go.....

#14 SHERWICK

SHERWICK

    I live on HPC!

  • Members
  • PipPipPipPipPipPipPip
  • 10,519 posts

Posted 27 April 2012 - 10:36 AM

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


Oh yeah thats simple just double click this icon and all will be fine! -> :)
The mighty neo liberal steam roller that crushed all before it from the 1980s to the beginning of the new millennium has morphed in recent years into a Charlie Carioli clown car that now can not go two yards without loud bangs, smoke pouring out of the engine and the doors dropping off. (by stormymonday_2011, posted amidst the Barclays Libor crisis on 02/07/2012)

Polster: why did you vote labour?
Labour voter: because I hate Margaret Thatcher
Polster: how old were you when she left Downing st?
Labour voter: 3
(by Robo1968, posted 10/05/2010)

From BBC HYS 15/05/2009:
"Last year, my MP's second home claim was 5,000 more than my total salary and now I find out that he's trying to charge me for cleaning his swimming pool!"

"Whatever your argument it's wrong." bendy, 21/02/2014

#15 the gardener

the gardener

    HPC Veteran

  • Members
  • PipPipPipPip
  • 1,888 posts

Posted 01 May 2012 - 10:33 PM

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!

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users