OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01092 (Oracle 10g,Windows xp)

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

ORA-01092 [message #404917]

Mon, 25 May 2009 07:52

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

Report message to a moderator

Re: ORA-01092 [message #404919 is a reply to message #404917]

Mon, 25 May 2009 08:11

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

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\?

Report message to a moderator