Re: Oracle 9iAS Portal on 9i Database?

Could well be a bug... wouldn't surprise me (9iAS was initially released *not* working with 9i database, of course!).

I was just trying to say that the fix lies in the scripts, not some (perfectly reasonable, it is true) workaround with the init.ora. Jump up and down on Oracle if needs be, by all means.

(And of course change the init.ora if time is of the essence).

Cheers,
HJR

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


"Pete Finnigan" <pete_at_peterfinnigan.demon.co.uk> wrote in message
news:7uYf9qAHgp87Ewhp_at_peterfinnigan.demon.co.uk...


> Hi Howard,

>

> I thought he was actually referring to a script provided by the portal

> install??, so its a bug??

>

> I also found a problem installing 9iAS, i set the size of the SGA to 50M

> as recommended and the install failed because it tried to verify the SGA

> size to be greater than 32M, but it checked the absolute figure in bytes

> and couldn't handle it sized as 50M.

>

> cheers

> Pete

>

> In article <3bf2276b$0$5064$afc38c87_at_news.optusnet.com.au>, Howard J.

> Rogers <dba_at_hjrdba.com> writes

> >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

> >>

> >>

> >

> >

>

> --

> Pete Finnigan

> IT Security Consultant

> PenTest Limited

>

> Office  01565 830 990

> Fax     01565 830 889

> Mobile  07974 087 885

>

> pete.finnigan_at_pentest-limited.com

>

> www.pentest-limited.com