WebSphere Application Server Version 6.1 Feature Pack for Web Services
             Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows

             Personalize the table of contents and search results

Creating 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. You need to this only once for each UDDI registry, as part of setting up and deploying a UDDI registry.

Before you begin

This task creates three new schemas: ibmuddi, ibmudi30 and ibmuds30. You cannot complete this task if you already have existing schemas with these names.

The following steps use a number of variables. Before you start, ensure that you have appropriate values for these variables.
<OracleUserID>
The Oracle user ID to use to create the database.
<OraclePassword>
The password for the Oracle user ID.

[AIX HP-UX Linux Solaris Windows] [z/OS] 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.

[i5/OS] You can create a remote database using Oracle, but not a local database. Because the database is remote, refer first to the database product documentation about the relevant capabilities of the product.

About this task

The supported versions of Oracle are Version 9i and Version 10g. Each version has the following restrictions:
Version 9i
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.
Version 10g
discoveryURL (Business) maximum 4000 bytes, UDDI specification 4096 characters; accessPoint (bindingTemplate) maximum 4000 bytes, UDDI Specification 4096 characters.

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. Run one of the following commands, depending on your 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

    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. [Optional] Enter the following command 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.




In this information ...


IBM Redbooks, demos, education, and more


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

This feature requires Internet access.

IBM Suggests
Task topic    

Terms of Use | Feedback

Last updated: Nov 25, 2008 2:35:59 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.wsfep.multiplatform.doc/info/ae/ae/twsu_create_oracle.html