|
From: Juan C. P. <bi...@ge...> - 2005-11-07 16:12:40
|
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
|