Home » RDBMS Server » Backup & Recovery » relink ORACLE_HOME with EXPORT process (Oracle 10gR2 10.2.0.5, RHEL 5.5)
relink ORACLE_HOME with EXPORT process [message #672598] Fri, 19 October 2018 05:27 Go to next message
reym21
Messages: 238
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,
Re: relink ORACLE_HOME with EXPORT process [message #672599 is a reply to message #672598] Fri, 19 October 2018 05:41 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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?
Re: relink ORACLE_HOME with EXPORT process [message #672600 is a reply to message #672599] Fri, 19 October 2018 05:53 Go to previous messageGo to next message
reym21
Messages: 238
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,
Re: relink ORACLE_HOME with EXPORT process [message #672601 is a reply to message #672600] Fri, 19 October 2018 05:56 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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?
Re: relink ORACLE_HOME with EXPORT process [message #672602 is a reply to message #672601] Fri, 19 October 2018 06:05 Go to previous messageGo to next message
reym21
Messages: 238
Registered: February 2010
Location: Philippines
Senior Member

@gazzag

Sir,

A single ORACLE_HOME of 10g 10.2.0.5.

Thanks.
Re: relink ORACLE_HOME with EXPORT process [message #672603 is a reply to message #672602] Fri, 19 October 2018 06:12 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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 Go to previous messageGo to next message
EdStevens
Messages: 1148
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.

Re: relink ORACLE_HOME with EXPORT process [message #672609 is a reply to message #672601] Fri, 19 October 2018 08:40 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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
Re: relink ORACLE_HOME with EXPORT process [message #672630 is a reply to message #672609] Sat, 20 October 2018 09:01 Go to previous messageGo to next message
EdStevens
Messages: 1148
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
Smile
Re: relink ORACLE_HOME with EXPORT process [message #672632 is a reply to message #672600] Sat, 20 October 2018 09:30 Go to previous message
John Watson
Messages: 8082
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"?
Previous Topic: FRA maintenance with Flashback on, but no RMAN backup
Next Topic: Flashback logs and guranteed restore point
Goto Forum:
  


Current Time: Thu Dec 12 15:39:30 CST 2019