I think you are doing it right from the Catalyst side, I connect to Oracle routinely in exactly the same form as you show, with no issues.

If you omit the "create=static", it's probably creating a dynamic schema, and so it's created OK but you run into problems at runtime, since the creation of schema classes is being deferred until then, as well as the connection to the database.

Maybe you have tried connecting to the database with other methods (sqlplus, DBI) from the same host, and so it works, but for the Catalyst app you are doing it remotely? If so, your tests are not conclusive.

My bet would be that although you have correctly configured the Oracle database locally, the listener is not, and does not accept connections from the network for that SID.

But of course, I might be wrong. :-)
Cheers
Jorge

Jorge González Villalonga
Director Técnico


DAIKON Integración y Desarrollo S.L.
Telf: (+34) 91 188 08 28
Fax: (+34) 91 632 65 42
www.daikon.es

El 10/03/11 13:16, Rohan M escribió:


On Thu, Mar 10, 2011 at 4:32 PM, Octavian Rasnita <[email protected]> wrote:
From: Rohan M
Dear All,

 I'm trying to use Oracle database as a back-end database for Catalyst application. (I tried MySQL and its working properly for me ).

 At first, I tried the following command  - 

 perl script/testapp_create.pl model DB DBIC::Schema DB::Schema create=static 'dbi:Oracle:sid=TEST1;host=192.168.100.107; port=1521' 'user' 'pass'
 Have you tried with sid=test.abcd.com?
Yes. I tried this also.  
 
perl script/testapp_create.pl model DB DBIC::Schema DB::Schema create=static dbi:Oracle:sid=test.abcd.com;host=192.168.100.107;port=1521 user pass
 
Octavian
 

_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/


The complete error is 
"DBI Connection failed: DBI connect('sid=test.abcd.com;host=192.168.100.107;port=1521','user',...) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) at /usr/local/share/perl/5.10.1/DBIx/Class/Storage/DBI.pm line 1262 "

--
Rohan M

_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/


_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/

Reply via email to