directory-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Karasulu <akaras...@gmail.com>
Subject Re: Oracle partition
Date Mon, 06 Apr 2009 13:03:44 GMT
Thanks for this Andrea.

Alex

On Mon, Apr 6, 2009 at 5:51 AM, Andrea Gariboldi <andrea.gariboldi@gmail.com
> wrote:

> Alex,
>   i have a readme in it but it does not cover oracle installation so i'll
> of course update it but for now who wants to try this can:
>
> 1) Download Oracle Express Edition (Oracle XE) here:
> http://www.oracle.com/technology/software/products/database/xe/index.html
>     it come as .deb or a .rpm !! It is really simple to install just follow
> the instructions. Remember also that Oracle XE came from the same
>     code base as of Standard and Enterprise Edition as opposite to Oracle
> Light that is a slightly different product. So once you use it
>     you can then upgrade to the Standard Edition One, then Standard
> Edition, then Enterprise Edition on an as needed basis.
>
> 2) Once installed it asks to launch /etc/init.d/oracle-xe configure (This
> will create an oracle instance for you - localhost:1521:xe)
>
> 3) su - oracle
>
> oracle:~$ export
> ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
> oracle:~$ export ORACLE_SID=xe
> oracle:~$ export PATH=$ORACLE_HOME/bin:$PATH
> oracle:~$ cd /path/to/apacheds-oracle/oracle
> oracle:/path/to/apacheds-oracle/oracle$ sqlplus / as sysdba
> sql> alter system set db_create_file_dest='/usr/lib/oracle/xe/oradata'
> scope=both;
> sql> @createuser.sql
> .... this will create tablespaces and the dsorapart database user...
> oracle:/path/to/apacheds-oracle/oracle$ sqlplus dsorapart/dsorapart
> @schema.sql
> .... this will create tables, pl/sql packages and a default index on the
> objectclass attribute....
> oracle:/path/to/apacheds-oracle/oracle$ cd ..
> download the ojdbc14.jar from
> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
> oracle:/path/to/apacheds-oracle$  mvn install:install-file
> -DgroupId=com.oracle -DartifactId=ojdbc14 -Dversion=10.2.0.3.0
> -Dpackaging=jar -Dfile=/tmp/ojdbc14.jar
> ... intall it in your maven repo ...
> oracle:/path/to/apacheds-oracle$  mvn compile
> oracle:/path/to/apacheds-oracle$  mvn package
> ... this will create a apache target/apacheds-oracle-1.5.5-SNAPSHOT.jar to
> include in your apacheds classpath ..
>
> then you can use the provided /path/to/apacheds-oracle/oracle/server.xml to
> start apacheds, just change the datasource:
>
> from:
>  <s:bean id="Db10gDataSource" class="oracle.jdbc.pool.OracleDataSource">
>     <!-- configure oracle -->
>     <s:property name="user"><s:value>dsorapart2</s:value></s:property>
>     <s:property name="password"><s:value>dsorapart2</s:value></s:property>
>     <s:property name="driverType"><s:value>thin</s:value></s:property>
>     <s:property name="portNumber"><s:value>1521</s:value></s:property>
>     <s:property name="serverName"><s:value>localhost</s:value></s:property>
>     <s:property name="databaseName"><s:value>db10g</s:value></s:property>
>   </s:bean>
>
> to:
>  <s:bean id="Db10gDataSource" class="oracle.jdbc.pool.OracleDataSource">
>     <!-- configure oracle -->
>     <s:property name="user"><s:value>dsorapart</s:value></s:property>
>     <s:property name="password"><s:value>dsorapart</s:value></s:property>
>     <s:property name="driverType"><s:value>thin</s:value></s:property>
>     <s:property name="portNumber"><s:value>1521</s:value></s:property>
>     <s:property name="serverName"><s:value>localhost</s:value></s:property>
>     <s:property name="databaseName"><s:value>xe</s:value></s:property>
>   </s:bean>
>
>
> this server.xml has 2 oracle partitions:
>
> ou=system
> dc=example,dc=com (where you have to create the context entry with an
> ldapadd)
>
>
> I'll post a new README on jira.
>
> Andrea
>
>
>
>
> 2009/4/6, Alex Karasulu <akarasulu@gmail.com>:
>
>> Hi Andrea,
>>
>> This is great.  Perhaps you attach this to a JIRA instead? Also make sure
>> denote this as an ASL licensed contribution on JIRA. I'll try to get to this
>> soon.  I'm going to have to figure out what you need to do to setup.  Like
>> you had some free edition of Oracle u used for this.  Please ignore this if
>> you have a readme inside.
>>
>> Thanks,
>> Alex
>>
>> On Sun, Apr 5, 2009 at 6:39 PM, Andrea Gariboldi <
>> andrea.gariboldi@gmail.com> wrote:
>>
>>> I finally finished to clean up dependencies, setup maven, and use the
>>> lastest interfaces (basically reimplented the partition).
>>> I think there are a lot of things that can be improved i hope also by
>>> others, but this should be a solid proof of concept.
>>> The partition actually does not cache entries in ApacheDS waiting for a
>>> cross partition cache at an higher level.
>>> I hope Stefan can test it someday with his automated tests, probably
>>> there is the need to fix some use case.
>>>
>>> Andrea
>>>
>>>
>>
>

Mime
View raw message