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.
![[AIX Solaris HP-UX Linux Windows]](../images/dist.gif)
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 10g and later, and have the following
restrictions:
Table 1. UDDI restrictions
and Oracle versions. The table lists the Version 10g and
later restrictions for different UDDI parameters. |
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 |
|
|
Procedure
- 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 your UDDI registry
node.