[Anthill-pro] Oracle Install

[Steve Boone]

Curtis,

We test nightly with Oracle 10.2 and have had good results.

We specifically execute some Oracle scripts in our nightly test
environment to tear down the database user and recreate it. We have done
this by creating steps that write scripts out (I'm assuming you already
have the scripts). We use a shell builder to invoke Oracle to execute
the scripts and this is our command line setting:

export ORACLE_SID=${ORACLE_SID}
${ORACLE_HOME}/bin/sqlplus $ORACLE_USER/$ORACLE_PWD @drop_anthill3.sql

You can define the ORACLE_SID, ORACLE_HOME environment variables in the
environment or on the shell builder itself. I recommend setting the
ORACLE_USER and ORACLE_PWD as environment properties on the project.

The only problem with this is that sqlplus always seems to return a
successful exit code.

Alternatively, several scripting languages support interfacing with
databases but usually these would already be in place. For example,
people can use Ant tasks or DBUnit for database setup.

I hope this helps.

Cheers,
Steve Boone

On 7/13/07, Curtis Yanko <curt_yanko at uhc.com> wrote:
>
>
> Any one have experience doing an install that uses Oracle for AHP? Any
> lessons learned you'd like to share ; )
>
> - Curtis Yanko
> UnitedHealth Group IT
> Mail Route: CT028-06SA
> Internet email: curt_yanko at uhc.com
> Office 860.702.9059
> Cell 860.729.8171
>
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity to
> which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
>
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.urbancode.com/pipermail/anthill-pro/attachments/20070713/9576e087/attachment-0001.htm