Re: [GUSDEV] DBD connect error

[Elisabetta M. <man...@pc...>]

Hi Juan,
the gus.propertios file is no longer used. See email from Mike in this 
regard on Oct 28.
Elisabetta

---

On Mon, 7 Nov 2005, Juan Carlos Perin wrote:

> Hello,
>
> I'm having DBD connection problems.  I assume this is because of DBIdsn not
> set properly in my gus.properties file.  Should I be trying a more specific
> name?  The error is:
>
> ##GUS::ObjRelP::DbiDbHandle connect('orcl','gususer',...) failed: ORA-12514:
> ##TNS:listener does not currently know of service requested in connect
> ##descriptor (DBD ERROR: OCIServerAttach) at
> ##/home/oracle/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiDatabase.pm line 165
> ##Can't bless non-reference value at
> ##/home/oracle/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiDbHandle.pm line 21.
>
>
>
> The latter half of my gus.properties looks like this:
>
>
>
> ##coreSchemaName=CORE
> ##userName=dba
> ##group=dba
> ##project=Database administration
> ##dbiDsn=dbi:Oracle:orcl
>
>
>
>
> The listener is running fine, the output of the start looks like this:
>
>
>
>
> #########################################################################
> LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-NOV-2005 12:18:21
>
> Copyright (c) 1991, 2005, Oracle.  All rights reserved.
>
> Starting /u01/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please
> wait...
>
> TNSLSNR for Linux: Version 10.2.0.1.0 - Production
> System parameter file is
> /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
> Log messages written to
> /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bioinformatics-server.res.chop.edu
> )(PORT=1521)))
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
> STATUS of the LISTENER
> ------------------------
> Alias                     LISTENER
> Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
> Start Date                07-NOV-2005 12:18:21
> Uptime                    0 days 0 hr. 0 min. 0 sec
> Trace Level               off
> Security                  ON: Local OS Authentication
> SNMP                      OFF
> Listener Parameter File
> /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
> Listener Log File
> /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
> Listening Endpoints Summary...
>  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bioinformatics-server.res.chop.edu
> )(PORT=1521)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
>  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> The command completed successfully
>
>
>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Download
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>