| ORA-00405: compatibility type "LOB Retention" [message #61002] |
Fri, 19 March 2004 01:19  |
Sachin
Messages: 52
Registered: May 2001
|
Member |
|
|
I am trying to connect to Orracle and get this message number of times, I am not able to understand what is causing teh problem. Can you please suggest me whats happening here?
Here is the code:
sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Mar 19 03:22:44 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
Error accessing package DBMS_APPLICATION_INFO
You may need to install the Oracle Procedural option
SET APPINFO requires Oracle Server Release 7.2 or later
SQL> startup force pfile=t_init1.ora
ORACLE instance started.
Total System Global Area 219907312 bytes
Fixed Size 742640 bytes
Variable Size 201326592 bytes
Database Buffers 16777216 bytes
Redo Buffers 1060864 bytes
Database mounted.
ORA-00402: database changes by release 9.2.0.0.0 cannot be used by release 8.1.0.0.0
ORA-00405: compatibility type "LOB Retention"
Thanks
Sachin
|
|
|
|
| Re: ORA-00405: compatibility type "LOB Retention" [message #61015 is a reply to message #61002] |
Fri, 19 March 2004 12:17  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
It looks like you have compatible set to 8.1.0.0 and are using a 9i database feature(lob retention) and hence the issue. Either you need to reset the compatible parameter to 9.2.0.0 or remove the new database changes that are not supported in 8.1 ,if you want to operate the 9i database with 8.1 compatibility.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
