Create an Oracle database for the UDDI registry

 

Perform this task if you want to use Oracle as the database store for your UDDI registry data. We need only do this once for each UDDI registry, as part of setting up and deploying a UDDI registry.

 

Overview

The supported versions of Oracle are V9i¹ and V10g²

The Oracle database can be either local or remote. For remote databases, use the database product documentation to familiarize yourself with the relevant capabilities of the product before proceeding with this task.

Before you begin

This task creates three new schemas: ibmuddi, ibmudi30 and ibmuds30. You will be unable to complete this task if you already have existing schemas with these names. The steps below use a number of variables for which enter appropriate values. You should decide the values that you will use before you start. The variables used are:

<OracleUserID>

is the Oracle userid to be used to create the database.

<OraclePassword>

is the password for the Oracle userid.

 

Procedure

1. Run the following commands:

   1. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_10_prereq_oracle.sql

   2. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_20_tables_generic.sql

   3. Complete one of the following actions depending on your level of Oracle:

      • For Oracle 9i:

        sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_25_tables_oracle_pre10g.sql
        

      • For V10g and later:

        sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_25_tables_oracle.sql
        

   4. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_30_constraints_generic.sql

   5. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_35_constraints_oracle.sql

   6. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_40_views_generic.sql

   7. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_45_views_oracle.sql

   8. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_50_triggers_oracle.sql

   9. sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_60_insert_initial_static_data.sql

2. This last command should only be run if you want the database to be used as a default UDDI node.

   sqlplus <OracleUserID>/<OraclePassword> @ uddi30crt_70_insert_default_database_indicator.sql
   

 

What to do next

Continue with setting up and deploying your UDDI registry node.

---

 

Related tasks

Setting up a default UDDI node
Setting up a customized UDDI node

¹

Restrictions:

discoveryURL (Business) maximum 4000 bytes, UDDI specification 4096 characters; accessPoint (bindingTemplate) maximum 4000 bytes, UDDI Specification 4096 characters; instanceParms (tModelInstanceInfo) maximum 4000 bytes, UDDI specification 8192 characters; overviewURL (tModelInstanceInfo) maximum 4000 bytes, UDDI specification 4096 characters; Digital Signature maximum 4000 bytes.

²

Restrictions:

discoveryURL (Business) maximum 4000 bytes, UDDI specification 4096 characters; accessPoint (bindingTemplate) maximum 4000 bytes, UDDI Specification 4096 characters.