Oracle 9iAS Portal on 9i Database? 
Author Message
 Oracle 9iAS Portal on 9i Database?
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



Sat, 01 May 2004 03:37:04 GMT
 Oracle 9iAS Portal on 9i Database?

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


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



Sun, 02 May 2004 11:05:47 GMT
 Oracle 9iAS Portal on 9i Database?
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
===============================


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



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



Sun, 02 May 2004 16:12:01 GMT
 Oracle 9iAS Portal on 9i Database?
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



Quote:
>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
>===============================



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



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


www.pentest-limited.com



Mon, 03 May 2004 00:12:55 GMT
 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
===============================


Quote:
> 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 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
> >===============================



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



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


> www.pentest-limited.com



Mon, 03 May 2004 02:41:55 GMT
 Oracle 9iAS Portal on 9i Database?

Quote:
> 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!

I had to foward this to the Oracle Portal developers, since they
provide these install scripts :-/

regards
Holger



Thu, 06 May 2004 01:40:01 GMT
 Oracle 9iAS Portal on 9i Database?

Quote:
> 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.

Hi Pete,

you also tried to install Portal into 9i?

I've found some further incompatiblitys:
- sqlnet clients < 9.0.0.1 can't connect to a 9i DB ("wrong date
format")
  (e.g. the one shipped with 9iAS :-(
- 8.1.7 JDBC Drivers can't connect
  (e.g. the one shipped with 9iAS :-(

I've fixed both, but I've still problems with starting the iAS:
I can start the one installed with the 9i, but the one installed with
portal fails :-(
(Sorry right now I havn't got the exact errortext, but it's an issue
with loading some modules into iAS)

If anyone has got more experince with that I would be glad for any
suggestions/pointers.

best regards
holger



Thu, 06 May 2004 01:50:35 GMT
 Oracle 9iAS Portal on 9i Database?
Hi Holger

I have only installed 9iAS against an 8.1.7 database and also against an
8.1.6 database. On one occasion I needed webcache for a customer and the
apache web server and on the other occasion portal. The database cache
failed on both occasions, for two different reasons. I have not been
impressed so far with the 9iAS. I will keep note of the issues you found
as i will be installing 9iAS against 9i in the next few weeks for a
client.

cheers

Pete Finnigan
www.pentest-limited.com



Quote:
>> 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.

>Hi Pete,

>you also tried to install Portal into 9i?

>I've found some further incompatiblitys:
>- sqlnet clients < 9.0.0.1 can't connect to a 9i DB ("wrong date
>format")
>  (e.g. the one shipped with 9iAS :-(
>- 8.1.7 JDBC Drivers can't connect
>  (e.g. the one shipped with 9iAS :-(

>I've fixed both, but I've still problems with starting the iAS:
>I can start the one installed with the 9i, but the one installed with
>portal fails :-(
>(Sorry right now I havn't got the exact errortext, but it's an issue
>with loading some modules into iAS)

>If anyone has got more experince with that I would be glad for any
>suggestions/pointers.

>best regards
>holger

--
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885


www.pentest-limited.com



Fri, 07 May 2004 19:51:12 GMT
 Oracle 9iAS Portal on 9i Database?
Hi Pete (and anyone else that drives crazy installing 9i and Portal ;)

finally i gave up installing, but here is how far i got:

Problem: Installing Portal 3.0.9 into 9i DB

Facts:
-I red Note 160254.1 (How to Install Portal into an Oracle 9i
Database) and followed the instructions.
-Due to the fact that ORA-1821 DATE FORMAT NOT RECOGNIZED occured
executing launch.sh I followed the intructions in Note Note:163268.1
and updated sqlnet clients.
-trying to acces /pls/portal30/portal30.home leeds to HTTP-503
(Service Temporarily Unavailable)
Apache error_log:
-----------------
[Tue Nov 20 13:27:07 2001] [error] mod_plsql:
/pls/portal30/portal30.home HTTP-503 ORA-604 <B>Client Logon Failed
with error : 604</B><BR>

9i database log/trace:
woody_ora_17708.trc:
--------------------
/www/oracle/app/oracle/admin/woody/udump/woody_ora_17708.trc:
Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production
With the Partitioning option
JServer Release 9.0.1.1.0 - Production
ORACLE_HOME = /www/oracle/app/oracle/product/9.0.1
System name:    SunOS
Node name:      bello
Release:        5.8
Version:        Generic_108528-08
Machine:        sun4u
Instance name: WOODY
Redo thread mounted by this instance: 1
Oracle process number: 14

*** SESSION ID:(20.26) 2001-11-20 13:27:07.698
Skipped error 604 during the execution of SYSTEM.PORTAL_LOGIN_TRIG
*** 2001-11-20 13:27:07.700
ksedmp: internal or fatal error
ORA-00604: Fehler auf rekursiver SQL-Ebene 1
ORA-01031: Unzureichende Berechtigungen
ORA-06512: in "SYS.DBMS_SESSION", Zeile 78
ORA-06512: in "SYSTEM.OWA_VPD_CTX", Zeile 5
ORA-06512: in "SYSTEM.PORTAL_LOGIN", Zeile 3
ORA-06512: in Zeile 2
KSTDUMP: In-memory trace dump

SYS.DBMS_SESSION, SYSTEM.OWA_VPD_CTX, SYSTEM.PORTAL_LOGIN all have
grant execute to portal30 and i even gave them to public!

So I disabled the SYSTEM.PORTAL_LOGIN_TRIG and login was possible!

Then I got WWC-4149, I tried to run ssodatan but that failed, look
into details and recognized that a Object Type is missing and this
causes ERRORS

--> droped the users and reinstalled according to Note:135182.1
(Metalink)
a.  PORTAL30
b.  PORTAL30_DEMO
c.  PORTAL30_PUBLIC
d.  PORTAL30_SSO
e.  PORTAL30_SSO_PUBLIC

i tried to reinstall but falied since laun.sh raised a new error:
Class not found: oracle.webdb.config.PortalConfigAssistant
even if the opca.jar is in the classpath and all other component did
load successfull

Finaly at this Point I gave up installing Portal against 9i DB, please
let me know if anyone else suceeds...

thx
Holger



Sun, 09 May 2004 00:34:23 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. Oracle 9i Database Server and 9i Database 9i Developer Suite Forms Access Problem

2. US-MA-ORACLE 9IAS PORTAL RELEASE 2

3. Oracle 9iAS portals

4. Recommended RAM for Oracle 9i + 9iAS

5. Oracle 9iAS Portal

6. Oracle 9i,9iAS,9iDevServer

7. Problem in configuring Oracle 9iAS Portal on Oracle9i.

8. installing oracle 9i/9ias on suse 7.3

9. oracle's portal-to-go (oracle 9i) issues

10. Installation problem Oracle 9i AS Portal on SuSe 7.0

11. Oracle 9i Portal 3.0 Configuration Assistant

12. 9ias: Migrating a Portal


 
Powered by phpBB® Forum Software