Dear All, I believe the oracle server version is 8.1.7 and I don't have access to that server.
I guess the reason was, I was putting SID=test.abcd.com which was wrong. I think Catalyst model provides "SID INSTANCE_NAME SERVER SERVICE_NAME " as options that can be mentioned as parameters. These are all name=value pairs that *Can* (?) be put for model creation. Today , I tried with perl script/testapp_create.pl model DB DBIC::Schema DB::Schema create=static 'dbi:Oracle:*SERVICE_NAME=test.abcd.com*;host=192.168.100.107; port=1521' 'user' 'pass' And I think this connects (?) but since the database has many many tables so the script kind of stays still. Can we just create one table dynamically in order to test everything works fine? I mean, provide single table name to the above command and test. Thanks for the help.. Regards, ROhan On Fri, Mar 11, 2011 at 1:29 PM, Jorge Gonzalez <[email protected]>wrote: > 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 <%28%2B34%29%2091%20188%2008%2028> >> Fax: (+34) 91 632 65 42 <%28%2B34%29%2091%20632%2065%2042> >> *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/ >> >> > > > -- > रोहन मल्लेल्रवार > > > > _______________________________________________ > 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>>
<<image/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/
