Re: [Catalyst] Catalyst and oracle database.

Jorge Gonzalez Fri, 11 Mar 2011 00:00:41 -0800

Have you tried to troubleshoot the connection at the "other" side, i.e. the Oracle server? What does the listener log say about the failed connection, and about the successful ones from the same machine (your Catalyst host)? How do they differ?

j.

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 11/03/11 06:28, Rohan M escribió:

Dear all,

Thanks for the reply. I'm trying to connect the Catalyst application hosted on 192.168.100.10 to the Oracle server on 192.168.100.107.

I tested the oracle connection from 192.168.100.10 with sql plus and perl-DBI combination.

Anything that I'm missing?

Regards,
Rohan M
On Thu, Mar 10, 2011 at 6:00 PM, Jorge Gonzalez <[email protected]> wrote:
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/
--
रोहन मल्लेल्रवार
_______________________________________________
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/

Re: [Catalyst] Catalyst and oracle database.

Reply via email to