Home » RDBMS Server » Server Administration » ORA-01092 (Oracle 10g,Windows xp)
ORA-01092 [message #404917] Mon, 25 May 2009 07:52 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Hi all,

I face problem while upgrading patch set ( from 10.2.0.1.0 to 10.2.0.4.0 )on windows xp

after installing the patchset, i gave statup
i received such error

ORA-01092: ORACLE instance terminated. Disconnection forced

i searched in google , the solution i found was to restart
service .but still didn't work.

i found some errors in my alert log saying

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Please advice me on this.

Thanks
Re: ORA-01092 [message #404919 is a reply to message #404917] Mon, 25 May 2009 08:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

After apply the cpu patch on ORACLE_HOME did you start the database with "UPGRADE" option?

sql>startup upgrade

If not then shutdown the db and startup with upgrade option run the catcpu.sql (patch script) let them finish then shutdown and startup (without any other parameter).

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Above is not an error, just a message.

[Updated on: Mon, 25 May 2009 08:11]

Report message to a moderator

Re: ORA-01092 [message #404924 is a reply to message #404919] Mon, 25 May 2009 08:43 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Thanks for the response.

please confirm the steps

after startup upgrade , should i run catupgrd.sql or catcpu.sql in ORACLE_BASE\ORACLE_HOME\rdbms\admin\?

Re: ORA-01092 [message #404926 is a reply to message #404917] Mon, 25 May 2009 08:52 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>please confirm the steps
You should followed the steps in the Release Notes that came with the patchset.
Re: ORA-01092 [message #404928 is a reply to message #404924] Mon, 25 May 2009 09:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

As said above kindly follow the readme.txt file comes with patchset.

all steps are clearly mentioned in the readme.txt file.
Re: ORA-01092 [message #404945 is a reply to message #404928] Mon, 25 May 2009 10:34 Go to previous message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member



Thank you all for helping me in succeeding the patch set upgradation Smile
Previous Topic: Oracle 8i installation
Next Topic: Failed verification check
Goto Forum:
  


Current Time: Sun Dec 04 02:34:29 CST 2016

Total time taken to generate the page: 0.09257 seconds