(dist)(iseries)Create an Oracle database for the UDDI registry
Complete 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.
(dist)(zos) 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 the product.
(iseries) The Oracle database must be a remote database; we cannot create a local database. Refer first to the database product documentation about the relevant capabilities of the product.
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 10g and later, and have the following restrictions:
and Oracle versions. The table lists the Version 10g and
Version 10g and later restrictions discoveryURL (Business) maximum 4000 bytes UDDI specification 4096 characters accessPoint (bindingTemplate) maximum 4000 bytes UDDI specification 4096 characters instanceParms (tModelInstanceInfo)
overviewURL (tModelInstanceInfo)
Digital Signature
- Run the following commands:
sqlplus OracleUserID/OraclePassword @ uddi30crt_10_prereq_oracle.sql
sqlplus OracleUserID/OraclePassword @ uddi30crt_20_tables_generic.sql
- Run the following commands:
sqlplus OracleUserID/OraclePassword @ uddi30crt_25_tables_oracle.sql
- Run the following commands:
sqlplus OracleUserID/OraclePassword @ uddi30crt_30_constraints_generic.sql
sqlplus OracleUserID/OraclePassword @ uddi30crt_35_constraints_oracle.sql
sqlplus OracleUserID/OraclePassword @ uddi30crt_40_views_generic.sql
sqlplus OracleUserID/OraclePassword @ uddi30crt_45_views_oracle.sql
sqlplus OracleUserID/OraclePassword @ uddi30crt_50_triggers_oracle.sql
sqlplus OracleUserID/OraclePassword @ uddi30crt_60_insert_initial_static_data.sql
- 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 the UDDI registry node.
Related tasks
Set up a default UDDI node