[Bioperl-l] Trying to install bioPerl-db on Windows XP
Hilmar Lapp
hlapp at gmx.net
Thu Dec 11 14:55:12 UTC 2008
For Oracle, the dbname parameter should be what you would otherwise
use as SID (usually that's also the ORACLE_SID environment variable,
and depending on the Oracle version TWO_TASK needs to be set too if
the database is on a remote host).
Note that if you have a tnsnames.ora file that has the SID defined
then you shouldn't need to duplicate the respective parameters here.
For example, in your case you shouldn't need to have port and host set
(you could just comment them out).
There is much more documentation for the individual parameters in
DBHarness.conf.example. Looking at which, I realize that it says host
is mandatory, which is wrong. (In fact, for MySQL and PostgreSQL,
leaving host undef versus setting it to localhost is not the same.)
Let me know if that will solve the problem.
-hilmar
On Dec 10, 2008, at 3:06 PM, Lori G. Wilson wrote:
> Hello,
>
> I solved my previous problem (the driver was "Oracle" not "oracle"),
> but I hit another snag (see attached). How do these parameters:
>
> {
> 'port' => '1521',
> 'schema_sql' => ['../biosql-schema/sql/biosqldb-mysql.sql'],
> 'dbname' => 'biolori',
> 'host' => 'Shanie',
> 'database' => 'biosql',
> 'password' => 'password',
> 'user' => 'biolori at pennant',
> 'driver' => 'Oracle',
> }
>
> relate to the following excerpt from my TNSNames.ora file?
>
> PENNANT =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = Shanie)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = pennant.Shanie)
> )
> )
>
> Thanks again,
>
> Lori
>
>
> Lori G. Wilson wrote:
>
>> I believe I have run all the prerequistes and am now attempting:
>>
>> build test
>>
>> I have attached a screen shot of the errors I'm getting. The only
>> error seems to be:
>>
>> Can't locate object method "new" via package
>> "Bio::DB::DBI::Oracle" (perhaps you forgot to load
>> "Bio::DB::DBI::oracle"?) at ...\blib\lib/Bio/DB/SimpleDBContext.pm
>> line 368.
>> My SimpleDBContext.pm is attached. Line 368 is:
>>
>> $self->{'dbi'} = $dbimod->new(-dbcontext => $self);
>>
>> What do you suggest?
>>
>> Thank you,
>>
>> Lori
>> 510-685-6571
>
>
>
>
> <bioperl-dbError2.jpg>_______________________________________________
> Bioperl-l mailing list
> Bioperl-l at lists.open-bio.org
> http://lists.open-bio.org/mailman/listinfo/bioperl-l
--
===========================================================
: Hilmar Lapp -:- Durham, NC -:- hlapp at gmx dot net :
===========================================================
More information about the Bioperl-l
mailing list