REM Installation Guide for IPDK (iDesk Portal Development Kit)

REM DO ** NOT ** RUN THIS FILE AS A SCRIPT!!!
REM IT IS ONLY INTENDED AS A GUIDE TO THE INSTALLATION STEPS.

REM This guide assumes that you're installing IPDK
REM in the IDESK schema. If you're not, then you must
REM create a few objects first:

CONNECT SYS@ORCL AS SYSDBA

GRANT EXECUTE ON DBMS_LOCK TO STARTER;

CONNECT STARTER@ORCL

CREATE SYNONYM DBMS_LOCK FOR SYS.DBMS_LOCK;

CREATE TABLE IPDK_CONFIG (
	ID                   NUMBER NOT NULL
,	LDAP_HOST            VARCHAR2(100)
,	LDAP_PORT            NUMBER NOT NULL
,	LDAP_SU_DN           VARCHAR2(100) NOT NULL
,	LDAP_SU_PWD          VARCHAR2(100) NOT NULL
,	LDAP_BASE            VARCHAR2(100) NOT NULL
,	LDAP_PORTAL_GROUP    VARCHAR2(100)
,	LANGUAGE             VARCHAR2(30)
,	OIDDAS_HOST          VARCHAR2(100)
,	SCHEDULE_SLEEP_TIME  NUMBER
 ) STORAGE (
	INITIAL 10K
	NEXT 10K
	PCTINCREASE 0
	MAXEXTENTS UNLIMITED
)
/

ALTER TABLE IPDK_CONFIG
 ADD CONSTRAINT IPDK_CONFIG_PK PRIMARY KEY
  (ID)
/

INSERT INTO IPDK_CONFIG (
	ID
,	LDAP_HOST
,	LDAP_PORT
,	LDAP_SU_DN
,	LDAP_SU_PWD
,	LDAP_BASE
,	LDAP_PORTAL_GROUP
,	LANGUAGE
,	OIDDAS_HOST
,	SCHEDULE_SLEEP_TIME
) VALUES (
	1
,	NULL
,	4032 -- 9iAS 9.0.2 W2K: 4032, AS10g (9.0.4) W2K: 389, AS10g (9.0.4) Red Hat Linux: 3060
,	'cn=orcladmin'
,	'welcome1'
,	'dc=acme,dc=com'
,	'PORTAL_GROUPS' -- 9iAS 9.0.2: "PORTAL_GROUPS", AS10g (9.0.4): "portal.yymmdd.nnnn"
,	'us'
,	NULL
,	3
);

COMMIT;

CREATE TABLE IPDK_TEXT_ELEMENTS (
	TEXT_KEY    VARCHAR2(100) NOT NULL
,	LANGUAGE    VARCHAR2(30) NOT NULL
,	TEXT        VARCHAR2(2000)
 ) STORAGE (
	INITIAL 10K
	NEXT 10K
	PCTINCREASE 0
	MAXEXTENTS UNLIMITED
)
/

ALTER TABLE IPDK_TEXT_ELEMENTS
 ADD CONSTRAINT IPDK_TEXT_ELEMENTS_PK PRIMARY KEY
  (TEXT_KEY, LANGUAGE)
/

CREATE TABLE IXS_SYSTEM_LOG (
	SYSTEM_LOG_ID   NUMBER NOT NULL
,	LOG_TYPE        VARCHAR2(10) DEFAULT 'ERROR' NOT NULL
,	LOG_STEP        VARCHAR2(100)
,	LOG_CODE        NUMBER
,	LOG_MESSAGE     VARCHAR2(4000)
,	LOG_DATE        DATE DEFAULT SYSDATE
,	LOG_SCHEMA      VARCHAR2(30)
,	LOG_PORTAL_USER VARCHAR2(256)
) STORAGE (
	INITIAL 100K
	NEXT 100K
	PCTINCREASE 0
	MAXEXTENTS UNLIMITED
)
/

ALTER TABLE IXS_SYSTEM_LOG
 ADD CONSTRAINT SYLO_PK PRIMARY KEY
  (SYSTEM_LOG_ID)
/

CREATE SEQUENCE IXS_PRIMARY_KEYS
/

Alternatively, you could create synonyms that
point to the iDesk objects:

create synonym ixs_system_log for idesk.ide_system_log;
create synonym ixs_primary_keys for idesk.ixs_primary_keys;


1. Go to directory <ORACLE_HOME>\portal(30)\admin\plsql\wwc

2. Start the command line version of SQL*Plus and log in as PORTAL(30)

3. Run the following command:

   @provsyns.sql IDESK

4. Exit SQL*Plus

5. Go to directory <ORACLE_HOME>\portal(30)\admin\plsql\wws

6. Start the command line version of SQL*Plus and log in as PORTAL(30)

7. Run the following command:

   @sbrapi.sql IDESK

8. Grant access to the WWSBR_CONTENT_AREA_ITEM_TYPES (this
   view is missing from the sbrapi.sql script) and
   WWDOC_DOCUMENT views by running the grants.sql script
   found in the modules\IPDK\source\db directory:

   @\modules\IPDK\source\db\grants IDESK

9. Alter view WWSBR_ITEM_ATTRIBUTES
   (ref bug 1873418 on MetaLink:
   http://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=1873418):

create or replace view wwsbr_item_attributes as 
select
	ta.siteid			item_caid
,	ta.masterthingid		item_masterid
,	ta.attributeid			attribute_id
,	ta.attribute_siteid		attribute_caid
,	ta.language
,	ta.valuetype
,	nvl(nvl(ta.value, ta.datevalue), ta.numbervalue)	value
from
	wwv_thingattributes ta
where
	exists (
		select	1
		from	wwsbr_all_items i
		where	i.id = ta.masterthingid
		and	i.caid = ta.siteid
	)
/



10. Connect as IDESK and create synonyms for the SBR
    views and the Document Repository view in Portal
    by running the synonyms.sql script
    found in the modules\IPDK\source\db directory.

11. Exit SQL*Plus

12. Go to directory modules\IPDK\source\pkg

13. Start SQL*Plus and log in as IDESK (or your schema)

14. Run the following command:

    @p_all.sql

15. Popuplate the IPDK_TEXT_ELEMENTS table
    by running the IPDK_TextElements.sql script
    found in the modules\IPDK\source\db directory.