Re: COMPATIBLE parameter not being read...why?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 11 Aug 1999 15:53:42 GMT
Message-ID: <37c09bd2.15464126@newshost.us.oracle.com>

A copy of this was sent to Connor McDonald <connor_mcdonald_at_yahoo.com> (if that email address didn't require changing) On Wed, 11 Aug 1999 16:50:50 +0800, you wrote:

>Thomas Kyte wrote:
>>

[snip]

>Could it be init.ora more than 2k...?
>
>Thomas - could confirm the 'rumour' that (Oracle 7.x) all entries in
>init.ora past the 2kbyte mark are silently ignored ?

No, i cannot confirm that rumor.

my init.ora file is:

$ ls -l $ORACLE_HOME/dbs/init$ORACLE_SID.ora lrwxrwxrwx 1 oracle73 53 Jul 1 1997 /user2/oracle73/dbs/initoracle73.ora -> /user2/oracle73/admin/oracle73/pfile/initoracle73.ora

$ ls -l /user2/oracle73/admin/oracle73/pfile/initoracle73.ora -rw-r--r-- 1 oracle73 4962 Aug 11 11:24 /user2/oracle73/admin/oracle73/pfile/initoracle73.ora

so, it is >4k in size.... and:

$ tail $ORACLE_HOME/dbs/init$ORACLE_SID.ora

open_cursors = 20

resource_limit = true

max_enabled_roles = 148

log_checkpoints_to_alert = TRUE

compatible = 7.3.4.0.1

compatible is the last entry and:

$ grep compatible $ORACLE_HOME/dbs/init$ORACLE_SID.ora compatible = 7.3.4.0.1

it is only in there once and ....

$ svrmgrl

Oracle Server Manager Release 2.3.4.0.0 - Production

Oracle7 Server Release 7.3.4.0.1 - Production With the distributed, replication, parallel query and Spatial Data options PL/SQL Release 2.3.4.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> show parameter compat

NAME                                TYPE    VALUE
----------------------------------- ------- ------------------------------
compatible                          string  7.3.4.0.1                     
compatible_no_recovery              string

SVRMGR> it is being set...

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Aug 11 1999 - 10:53:42 CDT