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 <[email protected]> >> >> 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/ > > -- रोहन मल्लेल्रवार
<<logo-daikon-email.png>>
_______________________________________________ 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/
