Re: Oracle 9iAS Portal on 9i Database?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 14 Nov 2001 19:12:01 +1100
Message-ID: <3bf2276b$0$5064$afc38c87@news.optusnet.com.au>

In 9i, the default for that parameter is false. In 8i and 8.0 it was true.

I hate to say it: but the real fix is to stop logging on as SYS as a normal user. The clear recommendation is that connections as SYS should now always be "as sysdba".

And when Oracle decides that compatibility with Oracle 7 is no longer a major requirement (and I'd probably hold my breath on that one, since the rate of releases is going through the roof... hold on for 9i Release 2!!), then that parameter is likely to be obsoleted... and your scripts will all start failing again.

So, time to sort those scripts out!

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Stevie" <steviep9_at_hotmail.com> wrote in message
news:fclI7.161616$5h5.68023594_at_news3.rdc2.on.home.com...


> Yup, thats rights.

> You need to enable 07_dictionary_accessible=true in the init.ora.

> You should double-check if it's true or false.

> It's real late and I can remember.  Do a searh for that parm on

> metalink or technet forums

>

>

> "Holger" <h.lausen_at_gmx.de> wrote in message

> news:7b61a29b.0111121137.2d7eea7d_at_posting.google.com...

> > Hi,

> >

> > I've setup a 9i Database on solaris 8 - everything seems ok.

> >

> > I tried to install 9iAS Portal, but there is a problem since the 9i DB

> > no more allows to logon sys/change_on_install... and so some scripts

> > e.g. "onetime" fails (are their more scripts that rely on the "old

> > fashioned logon"?)

> >

> > I've red in 9iAS Portal Installation requirements said it has to a

> > 8.1.7DB (or higher), I thought 9i would be also OK, am I wrong?

> >

> > Anyone experienced the same problem?

> >

> > beste regards

> > holger

>

>

Received on Wed Nov 14 2001 - 02:12:01 CST