Re: Oracle Portal installation

From: Jacek Dobosz <nospam_at_nospam.com>
Date: Mon, 30 Apr 2001 20:43:19 +0200
Message-ID: <9sbretol5qpe54qugm931utqkd315p1qf5_at_4ax.com>


On Mon, 30 Apr 2001 16:18:25 +0200, Rafal Jank <yankee_at_wp-sa.pl> wrote:

>I have a problem with installing Oracle Portal 3.0 on linux.
>Installation seems to go OK, but when it finishes, I get the following error
>messages:
>-The SSOHash class has not been loaded into the database
>-The enabler configuration table
>(WWSEC_ENABLER_CONFIG_INFO$) does not have any entries
>Any ideas?
>TIA
>Rafal

to get rid of this problem follow instructions I have found in the metalink article. Directories and file names are form NT installation but this works on linux.

-----Metalink Article -------------------------------------
.....

WWC-41439 at login to Portal - ssodatan script fails


  1. loadjava -resolve -user portal30/portal30_at_connect_string SSOHash.class
  2. loadjava -resolve -user portal30_sso/portal30_sso_at_connect_string SSOHash.class

Then, go to src/sso directory. Type the following command:

  1. sqlplus portal30_sso/portal30_sso_at_connect_string to get to SQL*PLUS.
  2. run ssoinsd.sql by typing _at_ssoinsd in SQL*PLUS.
  3. when asked to put in values for argument 4,3,1,2, type in NULL(uppercase), N(uppercase), portal, portal_sso

after that run ssodatan script from admin directory:

3) Portal security depends directly on what URL you use for the Portal. It
 must be exactly correct. Run ssodatan.cmd with -w, -l, and -s parameters as
 below to tell portal security what URL you would use for the portal (case-sensitivity and the trailing slash for -w and -l options are mandatory):

Usage: ssodatan.cmd [-w webdb_url] [-l login_server_url] [-s webdb_schema]
[-p webdb_password] [-o sso_schema] [-d sso_password] [-c webdb_connect_string]

    -w webdb_url             URL that points to the WebDB product host
                             and DAD.  The URL must end with a forward
                             slash.
    -l login_server_url      URL that points to the Login Server host
                             and DAD.  The URL must end with a forward
                             slash.
    -s webdb_schema          Oracle Database schema for WebDB database
                             objects.
                             Default = WEBDB
    -p webdb_password        Oracle Database password for WebDB
schema.
                             Default = [webdb_schema]
    -o sso_schema            Oracle Database schema for Login Server
                             objects.
                             Default = [webdb_schema]_SSO
    -d sso_password          Oracle Database password for Login Server
                             schema.
                             Default = [sso_schema]
    -c webdb_connect_string Optional connect string to connect to WebDB
                             on a remote database.
                             Default = null

description: This shell script installs the appropriate seed data to set up a connection between the WebDB product and a newly installed Login Server. It uses sqlplus.

example:
C:\portal30\webdb30\admin\plsql\ssodatan.cmd  -w http://companyname.nl.com:8000/pls/portal30/ -l  http://companyname.nl.com:8000/pls/portal30_sso/ -s portal30  -p portal30 -o portal30_sso -d portal30_sso -c orcl

4) Stop and Start your database to clear the cache. 5) Stop and Start your HTTP listener


Jacek



jdob (at) eunet (dot) at

share what you know
learn what you don't
Received on Mon Apr 30 2001 - 20:43:19 CEST

Original text of this message