+

Search Tips   |   Advanced Search

Create an Oracle database for the UDDI registry


Perform this task to use Oracle as the database store for the UDDI registry data.

This task creates three new schemas: ibmuddi, ibmudi30 and ibmuds30. We cannot complete this task if schemas with these names exist already.

The following steps use a number of variables. Before you start, decide appropriate values to use for these variables. The variables, and suggested values, are:

OracleUserID

The Oracle user ID to use to create the database.

OraclePassword

The password for the Oracle user ID.

The Oracle database can be either local or remote. To create a remote database, refer first to the database product documentation about the relevant capabilities of WAS ND.

You perform this task only once for each UDDI registry, as part of setting up and deploying a UDDI registry. The supported versions of Oracle are V9i and V10g. Each version has the following restrictions:


Table 1. UDDI restrictions and Oracle versions

  Version 9i restrictions Version 10g restrictions
discoveryURL (Business) maximum 4000 bytes UDDI spec 4096 characters maximum 4000 bytes UDDI spec 4096 characters
accessPoint (bindingTemplate) maximum 4000 bytes UDDI spec 4096 characters maximum 4000 bytes UDDI spec 4096 characters
instanceParms (tModelInstanceInfo) maximum 4000 bytes UDDI spec 8192 characters    
overviewURL (tModelInstanceInfo) maximum 4000 bytes UDDI spec 4096 characters    
Digital Signature maximum 4000 bytes      

 

  1. Run the following commands: 

    1. sqlplus OracleUserID/OraclePassword @ uddi30crt_10_prereq_oracle.sql


    2. sqlplus OracleUserID/OraclePassword @ uddi30crt_20_tables_generic.sql

  2. Run one of the following commands, depending on the version of Oracle.

    • For Oracle V9i: 

      sqlplus OracleUserID/OraclePassword @ uddi30crt_25_tables_oracle_pre10g.sql

    • For Oracle V10g and later: 

      sqlplus OracleUserID/OraclePassword @ uddi30crt_25_tables_oracle.sql

  3. Run the following commands: 

    1. sqlplus OracleUserID/OraclePassword @ uddi30crt_30_constraints_generic.sql


    2. sqlplus OracleUserID/OraclePassword @ uddi30crt_35_constraints_oracle.sql


    3. sqlplus OracleUserID/OraclePassword @ uddi30crt_40_views_generic.sql


    4. sqlplus OracleUserID/OraclePassword @ uddi30crt_45_views_oracle.sql


    5. sqlplus OracleUserID/OraclePassword @ uddi30crt_50_triggers_oracle.sql


    6. sqlplus OracleUserID/OraclePassword @ uddi30crt_60_insert_initial_static_data.sql

  4. To use the database as a default UDDI node, run the following command: 

    sqlplus OracleUserID/OraclePassword @ uddi30crt_70_insert_default_database_indicator.sql

 

Next steps

Continue with setting up and deploying the UDDI registry node.

 

Related tasks


Set up a default UDDI node
Set up a customized UDDI node