LDAP Install

Starting from SCT® Banner® General 6.1, the database must have both JVM and LDAP packages installed to be able to support LDAP logins.

The following procedures show how to manually install these packages into the database.
These packages must be in place PRIOR to the General 6.1 upgrade.

Note that all scripts must be run as SYS or from an account with SYSDBA Privileges.

1. run $ORACLE_HOME/rdbms/admin/initdbj.sql - This will create the base java packages in the database.

2. run $ORACLE_HOME/javavm/install/initjvm.sql - This will create the required VM packages in the database.

3. run $ORACLE_HOME/xdk/admin/initxml.sql - This initializes the xml components into the JServer.

4. run $ORACLE_HOME/xdk/admin/xmlja.sql - This loads the XML Parser.

5. run $ORACLE_HOME/rdbms/admin/catjava.sql - This loads the java classes into RDBMS.

6. run $ORACLE_HOME/rdbms/admin/catldap.sql - This will initialize the packages needed to start LDAP.

7. Create a tablespace XDB to hold the XML DB repository.
Then run $ORACLE_HOME/rdbms/admin/catqm.sql with the following args:

catqm <xdb_password> <xdb_tablespace_name> <db_temp_tablesapce_name>

Then run $ORACLE_HOME/rdbms/admin/catxdbj.sql as sys to initialize the XMLDB objects.

Add the following dispatcher entry to the init.ora file:

 dispatchers="(PROTOCOL=TCP) (SERVICE=XDB)"
Restart database and listener to enable Oracle XML DB protocol access.

8. create public synonym dbms_ldap for sys.dbms_ldap;

9. grant execute on dbms_ldap to wtailor,baninst1;

Querying sys.dba_objects should return a count of about 9400 for objects with an OBJECT_TYPE of '%JAVA%'

At this point, you are set to proceed with the General 6.1 Upgrade.