RE: [Openinteract-help] Oracle DB setup problems --sorted!

[Ben A. <be...@th...>]

On Mon, 2002-03-18 at 13:27, Ben Avery wrote:
> does anyone have experience of setting up OI on Oracle?
> 
> I am still working through the 'fruit' test package, but cannot manage to
> build a database table.
> this is the output from the test_db stage:
> 
> /export/home/oi_dev/fruit $ oi_manage --package fruit test_db
> 
> [oi_manage]: Using (/export/home/openinteract) for 'base_dir'.
> [oi_manage]: Using (/export/home/cares/test) for 'website_dir'.
> Running test_db...
> =========================
> 
> DBD::Oracle::db do failed: ORA-00900: invalid SQL statement (DBD ERROR:
> OCIStmtExecute) at
/usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/DBI.pm
> line 47.
> Status of the database test:
> 
> FAILED!: 
>            Status of connection <<main>> (default
>            connection) 
>            =========================
>            -- Basic connect: ok
>            -- Use database: failed -- ORA-00900: invalid
>            SQL statement (DBD ERROR: OCIStmtExecute)
>            -- Create table: not attempted
> 
> =========================

Unfortunately you're going to be a bit of a guinea pig here, since I've
never installed OI on Oracle before.

However, you can probably get around this error by leaving the
'db_info.main.db_name' key empty in the server configuration. IIRC,
Oracle generally specifies this in the DSN or an environment variable,
so you don't need to do so.

Chris

___________

Chris, 

yep, spot on! (it actually took me longer to find out what IIRC meant :-)


Oracle has no 'use' command, and OpenInteract::DBI will die() if the db_name
key is set in conf/server.ini.

making a connection to Oracle requires 3 parameters: username/password@host
So, for example, if I connected to Oracle with: oi_test/PaSsWoRd@TEST1
then the db_info section of my conf/server.ini file would look like this:

[db_info main]
db_owner      =
username      =oi_test
password      =PaSsWoRd
dsn           =TEST1
db_name       =
driver_name   =Oracle


cheers,

Ben