Running Repository Creation Unit to create repositories related to SOA
Running Repository Creation Unit to create repositories related to
SOA
SOA Version: 11.1.1.5
Database Version: 11.2.0
Operating System: Red Hat Linux (Fedora 16)
Prerequisites:
1. Already
the database should be installed, configured and should be running.
2. Listener
should be configured and should be running.
RCU will create all the repositories
related to SOA. In terms of SOA, RCU will create dehydration data store in the
database.
This section will explain how to create and
drop the repositories or schemas related to SOA.
Steps to create or drop SOA schemas:
1. Download
the RCU from Oracle site and unzip it.
2. By
default the files will be unzipped to a folder named rcuHome.
3. Now
open terminal and go to bin folder
under rcuHome (or unzipped folder)
and type the command ./rcu to create
repositories.
4. Now
Repository Creation Utility will open.
5. Creating
schemas related to SOA
·
Now select Create from the displayed options to
start creating repositories/ schemas related to SOA.
Now click Next Button to continue.
·
Now provide the database details and credentials
for creating the repository in the fields provided.
Note: Since RCU will create new objects
(like tablespaces related to SOA) in the database, provide administrative
privileges (like sys or system or any SYSDBA granted users) in the Username and
Password. Otherwise RCU will fail to create components in the database.
·
Now the utility will check for system
requirements to create repositories.
·
A warning will be displayed as part of checking prerequisites
for character set. Click Ignore to continue else the database character set
should be changed by altering the settings or create the database using the
character set.
Right now we can ignore this warning.
·
Once all the Prerequisites are checked Click Ok to continue.
·
Now select the components to be created in the
database and provide the prefix for the components to be created by RCU.
·
Select SOA
and BPM Infrastructure from the options displayed.
We can see the prefix in all the components
to be created.
·
Now the utility will check for prerequisites
before creating the components.
·
Now provide the password for all the schemas to
be created.
Choose the options based on your need.
·
Use same passwords for all schemas (Take care of
security issues)
·
Use main schema passwords for auxiliary schemas
·
Specify different passwords for all schemas (Don’t
forget the passwords)
·
Now the default tablespaces to be created will
be shown. If required new tablespaces also can be created or already existing
tablespaces can be modified by clicking Manage tablespaces.
·
A popup will be displayed if new tablespaces are
to be created.
Since we are creating the SOA related
tablespaces click Ok to continue.
·
Now the Utility wizard will be creating the
tablespaces for SOA.
We can stop creation of the components by
clicking Stop button.
Now, Click Ok to continue.
·
Now in the summary if all the options provided
are satisfied, Click Create button
to create objects or if something has to be changed Click Back button to modify the options.
·
Repository Creation in progress.
·
After creation of repositories we will get
summary of successfully created tablespaces.
6. Dropping
schemas related to SOA
·
Select Drop from the options displayed
·
Provide the database details from which the
schemas should be dropped.
Note: Since RCU will create new objects (like
tablespaces related to SOA) in the database, provide administrative privileges
(like sys or system or any SYSDBA granted users) in the Username and Password.
Otherwise RCU will fail to create components in the database.
·
Now the utility will check prerequisites to drop
repositories.
·
Now choose the Prefix of the schema to be
dropped.
·
Check the schema to be dropped once again.
·
Be sure you are not dropping the wrong schema.
A warning popup will be shown now. Click OK
if the right schema is selected otherwise click Cancel.
·
Checking prerequisites before dropping schemas.
·
Check in the summary once again for the schema
to be dropped. If right schema is selected then Click Drop else click Cancel or
Back to change already selected options.
·
Dropping schemas in progress.
·
After dropping the required schemas we will get
a status or summary page.
7. After
creating or dropping schemas open sqldeveloper or any sql tools , create connection to the
database and connect as SYSTEM user and use the following sql to check the
created or dropped tablespaces.
Select * from user_tablespaces;
Comments
Post a Comment