[AIX HP-UX Linux Solaris Windows]This topic applies only on the IBM i operating system.

Creating an Oracle database for the UDDI registry

Complete this task if you want to use Oracle as the database store for your UDDI registry data.

Before you begin

This task creates three new schemas: ibmuddi, ibmudi30 and ibmuds30. You 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. If you want to create a remote database, refer first to the database product documentation about the relevant capabilities of the product.

The Oracle database must be a remote database; you cannot create a local database. Refer first to the database product documentation about the relevant capabilities of the product.

About this task

You complete this task only once for each UDDI registry, as part of setting up and deploying a UDDI registry.

The supported versions of Oracle are Version 9i and Version 10g. 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 specification 4096 characters maximum 4000 bytes UDDI specification 4096 characters
accessPoint (bindingTemplate) maximum 4000 bytes UDDI specification 4096 characters 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      

Procedure

  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 Version 9i:
      sqlplus OracleUserID/OraclePassword @ uddi30crt_25_tables_oracle_pre10g.sql
    • For Oracle Version 10g 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. Optional: To use the database as a default UDDI node, run the following command:
    sqlplus OracleUserID/OraclePassword @ uddi30crt_70_insert_default_database_indicator.sql

What to do next

Continue with setting up and deploying your UDDI registry node.




In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Feb 5, 2014 9:49:51 PM CST
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-mp&topic=twsu_create_oracle
File name: twsu_create_oracle.html