Home » RDBMS Server » Server Administration » 8.1.7 Error
8.1.7 Error [message #233312] Wed, 25 April 2007 11:06 Go to next message
thedba
Messages: 4
Registered: April 2007
Location: USA
Junior Member
Hi Gurus,

This issue is eating my brain, but nothing seems to solve the problem. This is what I have and I did.

I have two HP-UX machines and one had Oracle 8i (8.1.7) installed with 4 databases running on it. I can do startup/shutdown etc on this machine without any issues.

Instead of installing Oracle on the second machine, I copied the Oracle install folders and files to the second machine. I did a file compare and everything is same. Now the problem starts. When I do the following after setting ORACLE_HOME and ORACLE_SID env variables

For the first two databases, I get the following message

sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 25 08:51:15 2007

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

connect / as sysdba
Connected to an idle instance.


After getting this message, I could start the database.

For the last two databases I am getting as below

sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 25 08:54:35 2007

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

connect / as sysdba
ERROR:
ORA-01096: program version (8.1.7.2.0) incompatible with instance (8.1.7.0.0)



Why I am getting this error only for the last two databases?

I tried relinking the executables as suggested in one of the Oracle metalink notes and nothing seems to help. Any one out there who had similar issues or could suggest a solution.

Thanks,
thedba
Re: 8.1.7 Error [message #233313 is a reply to message #233312] Wed, 25 April 2007 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora-01096: program version (%s) incompatible with instance (%s)
 *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.

Regards
Michel
Re: 8.1.7 Error [message #233314 is a reply to message #233312] Wed, 25 April 2007 11:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you sure the relink was successful?
Were the semaphore settings same on both machines?
Are you sure that all 4 databases were in same version/ORACLE_HOME?

[Updated on: Wed, 25 April 2007 11:18]

Report message to a moderator

Re: 8.1.7 Error [message #233330 is a reply to message #233314] Wed, 25 April 2007 13:13 Go to previous messageGo to next message
thedba
Messages: 4
Registered: April 2007
Location: USA
Junior Member
Mahesh,

Thank you for the quick replies. The relink was successful. I didn't have any errors in the log. But my wonder is why two of the databases are OK and the other two has issues on one machine and all of them behave normally on the other. I checked the semaphores and they are same.

Michel,

I saw that error message explanation and that is why I went for the relinking commands and that doesn't resolve the issue.

Thanks,
thedba
Re: 8.1.7 Error [message #233352 is a reply to message #233330] Wed, 25 April 2007 15:44 Go to previous messageGo to next message
thedba
Messages: 4
Registered: April 2007
Location: USA
Junior Member
Hi,

One more observation. I could do connect internal. Only connect / as sysdba has the issue.

Thanks
thedba
Re: 8.1.7 Error [message #233880 is a reply to message #233352] Fri, 27 April 2007 17:48 Go to previous message
thedba
Messages: 4
Registered: April 2007
Location: USA
Junior Member
I was able to resolve this by doing a connect internal and shutdown abort to release the semaphores and then connect as sysdba and startup the databases. Everything is working as normal.

Thanks,
thedba
Previous Topic: JVM
Next Topic: oracle 9i database installation
Goto Forum:
  


Current Time: Wed Dec 07 03:22:10 CST 2016

Total time taken to generate the page: 0.05466 seconds