OraFAQ Forum: Backup & Recovery » relink ORACLE

Home » RDBMS Server » Backup & Recovery » relink ORACLE_HOME with EXPORT process (Oracle 10gR2 10.2.0.5, RHEL 5.5)

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

relink ORACLE_HOME with EXPORT process [message #672598]

Fri, 19 October 2018 05:27

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Gurus,

Good day!

I just want to validate with your expertise if
I can execute the relink of ORACLE_HOME while I had on-going export dump.
This server have 2 instances/dBs sharing the same ORACLE_HOME.
DB1 had export on-going, while DB2 had problem connecting to RMAN
using "rman target /". Is it fine to do this, I'm not sure if it
would affect data in my EXPORT process.

Thank you for your time.
Best regards,

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672599 is a reply to message #672598]

Fri, 19 October 2018 05:41

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You shouldn't relink the Oracle home while there are processes running. Did the export of DB1 terminate successfully? What was the "problem" connecting to DB2 with RMAN that made you think you should do this?

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672600 is a reply to message #672599]

Fri, 19 October 2018 05:53

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

@gazzag

Sir,

Thank you very much for your confirmation.
The said dB server crashed due to disk failure.
The 1st dB (which had EXPORT on-going) had been FORCE OPEN after recovery
while the 2nd dB had problem of ORA-01096 - program compatibility
(also after recovery).

Regards,

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672601 is a reply to message #672600]

Fri, 19 October 2018 05:56

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Error Message
ORA-01096: program version (string) incompatible with instance (string)

Cause
A program is trying to connect to an instance using a different version of code than the database was started with. This is not allowed.

Action
Either relink the program with the same version as the database or restart the database using the old version of code.

How many Oracle homes are on that server?

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672602 is a reply to message #672601]

Fri, 19 October 2018 06:05

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

@gazzag

Sir,

A single ORACLE_HOME of 10g 10.2.0.5.

Thanks.

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672603 is a reply to message #672602]

Fri, 19 October 2018 06:12

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Is everything OK now? (apart from your Oracle version)

Edit: [addendum]

[Updated on: Fri, 19 October 2018 06:12]

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672607 is a reply to message #672600]

Fri, 19 October 2018 08:33

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

reym21 wrote on Fri, 19 October 2018 05:53

@gazzag

Sir,

Thank you very much for your confirmation.
The said dB server crashed due to disk failure.
The 1st dB (which had EXPORT on-going) had been FORCE OPEN after recovery
while the 2nd dB had problem of ORA-01096 - program compatibility
(also after recovery).

Regards,

Please cite the source that indicated a re-link was the solution to your ORA-01096.

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672609 is a reply to message #672601]

Fri, 19 October 2018 08:40

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

gazzag wrote on Fri, 19 October 2018 11:56

Error Message
ORA-01096: program version (string) incompatible with instance (string)

Cause
A program is trying to connect to an instance using a different version of code than the database was started with. This is not allowed.

Action
Either relink the program with the same version as the database or restart the database using the old version of code.

How many Oracle homes are on that server?

Possibly a case of ready, fire, aim, Ed Wink

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672630 is a reply to message #672609]

Sat, 20 October 2018 09:01

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

gazzag wrote on Fri, 19 October 2018 08:40

gazzag wrote on Fri, 19 October 2018 11:56

Error Message
ORA-01096: program version (string) incompatible with instance (string)

Cause
A program is trying to connect to an instance using a different version of code than the database was started with. This is not allowed.

Action
Either relink the program with the same version as the database or restart the database using the old version of code.

How many Oracle homes are on that server?

Possibly a case of ready, fire, aim, Ed Wink

Report message to a moderator

Re: relink ORACLE_HOME with EXPORT process [message #672632 is a reply to message #672600]

Sat, 20 October 2018 09:30

John Watson
Messages: 8963
Registered: January 2010
Location: Global Village

Senior Member

Quote:

The 1st dB (which had EXPORT on-going) had been FORCE OPEN after recovery

What do you mean by "force open"?

Report message to a moderator

Previous Topic:	FRA maintenance with Flashback on, but no RMAN backup
Next Topic:	Flashback logs and guranteed restore point

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 00:41:05 CST 2025