Oracle 9iAS Portal on 9i Database?
Holger
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
Stevie
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.la...@gmx.de> wrote in message
news:7b61a29b.01111...@posting.google.com...
Howard J. Rogers
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" <stev...@hotmail.com> wrote in message
news:fclI7.161616$5h5.68...@news3.rdc2.on.home.com...
Pete Finnigan
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$afc3...@news.optusnet.com.au>, Howard J.
Rogers <d...@hjrdba.com> writes
--
Pete Finnigan
IT Security Consultant
PenTest Limited
Office 01565 830 990
Fax 01565 830 889
Mobile 07974 087 885
Howard J. Rogers
*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" <pe...@peterfinnigan.demon.co.uk> wrote in message
news:7uYf9qAH...@peterfinnigan.demon.co.uk...
Holger
> 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
Holger
> 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
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
In article <7b61a29b.01111...@posting.google.com>, Holger
<h.la...@gmx.de> writes
--
Holger
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
Unix process pid: 17708, image: oracle@bello (TNS V1-V3)
*** 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