Re: 9iDB Security Hole?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 17 Apr 2002 15:19:47 +0100
Message-ID: <3cbd8484$0$227$ed9e5944@reading.news.pipex.net>

I get the below when setting compatible to 8.1.7.0.0. Now the error does point to my having done something 9i specific but I'm not clear what this is - the db is a clean 9i install.

SQL> startup pfile=c:\oracle\admin\<snip>\pfile\init.ora ORACLE instance started.

Total System Global Area 118255568 bytes

Fixed Size                   282576 bytes
Variable Size              83886080 bytes
Database Buffers           33554432 bytes
Redo Buffers                 532480 bytes

Database mounted.
ORA-00402: database changes by release 9.0.0.0.0 cannot be used by release 8.1.7.0.0
ORA-00405: compatibility type "PDML ITL invariant"

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************


"Todd M. Helfter" <tmh_at_jumpgate.cc.purdue.edu> wrote in message
news:a9jk9h$66b$1_at_mozo.cc.purdue.edu...


>

> Can anyone think of an init.ora parameter to disable all users from having

access


> to the security hole?  Something like "TURN_OFF_SQL92_BLAH_BLAH" or would

setting


> compatibility to 8.1.7 have the same effect?

>

> --

> Todd M. Helfter

> Database Analyst/Programmer

> Purdue University

> tmh_at_purdue.edu

Received on Wed Apr 17 2002 - 09:19:47 CDT