[Catalyst] Catalyst and oracle database.

Rohan M rohan7799 at gmail.com
Thu Mar 10 12:16:01 GMT 2011


On Thu, Mar 10, 2011 at 4:32 PM, Octavian Rasnita <orasnita at gmail.com>wrote:

>  *From:* Rohan M <rohan7799 at gmail.com>
>
> 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=3Dstatic* 'dbi:Oracle:sid=3DTEST1;host=3D192.168.100.107; port=3D1=
521'
> 'user' 'pass'
>  Have you tried with sid=3Dtest.abcd.com?
>
> Yes. I tried this also.

>
> perl script/testapp_create.pl model DB DBIC::Schema DB::Schema
> create=3Dstatic dbi:Oracle:sid=3Dtest.abcd.com;host=3D192.168.100.107;por=
t=3D1521
> user pass
>
> Octavian
>
>
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
>
>
The complete error is
"DBI Connection failed: DBI
connect('sid=3Dtest.abcd.com;host=3D192.168.100.107;port=3D1521','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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20110310/d2177=
4cb/attachment.htm


More information about the Catalyst mailing list