X registry 6.6 with Oracle

[jimmy_antony]

I am looking some answers, please see the questions given below

1. Do we have to execute the commands create-portal-schema and create-registry-schema if dba create the schemas manually?

2. Do we have to execute the command create-tablespace if dba create the tablespace manually?

3. How do we create the portal tables and registry tables? Do we need to execute any sql's?
4. Is it possible to use X registry without X broker?

5. Do we need to Instal X registry console data base if we are not using X broker?

[brapacki]

Hi,

1. Do we have to execute the commands create-portal-schema and create-registry-schema if dba create the schemas manually? - each of these (and create-console-schema) commands has it respective section in db-oracle.xml file.

For example like this below:
<target
name="create-registry-schema"
if="registry-uses-oracle"
depends="decrypt-registry-password">
<sql onerror="continue"
driver="${infravio.registry.db.driver}"
url="${registry.db.connection-url}"
userid="${infravio.registry.db.username}"
password="${infravio.registry.db.decrypt.password}"
autocommit="true" >
<transaction src="${registry.db.dir}/create-registry-schema.sql"/>
<transaction src="${registry.db.dir}/create-registry-data.sql"/>
<classpath>
<fileset dir="${db.classpath}">
<include name="oracle/*.jar"/>
</fileset>
</classpath>
</sql>
</target>

So each command runs the scripts put in transaction section. If you are sure that you ran all the scripts for given command you can skip the command. however I would strongly recommend using product-config instead of manual db creation.

2. Do we have to execute the command create-tablespace if dba create the tablespace manually? - check 1

3. How do we create the portal tables and registry tables? Do we need to execute any sql's? - product-config create-portal-schema (or registry), later when you start X=Registry, run product-config setup command.

4. Is it possible to use X registry without X broker? - sure, however you need to have another mediator if you want to enforce runtime policies (in such case you need to create appropriate transformation scripts for that given type of mediator). if you just want to use design/change time policies and X-Registry as storage only, then you do not require XBroker nor any other mediator.


5. Do we need to Instal X registry console data base if we are not using X broker? - yes, for some XRegistry's errors are logged into console.

For details of each step, please refer to documentation or check whitepapers on www.soamasterclass.com/ (http://www.soamasterclass.com/)

hope this helps,

Bart