| 8.1.7 Error [message #233312] |
Wed, 25 April 2007 11:06  |
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 #233330 is a reply to message #233314] |
Wed, 25 April 2007 13:13  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
