🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: pl.comp.os.linux.debian
Article #42221

Re: connection debian client to external rh:oracle

#42221
From: washide
Date: Tue, 07 Feb 2012 10:54
290 lines
15953 bytes
On 7 Lut, 10:57, washide <yoaw...@gmail.com> wrote:
> W oparciu o:
>     * oracle-instantclient11.1-basic-xx.x.x.x.x-x.i386.rpm
>     * oracle-instantclient11.1-sqlplus-xx.x.x.x.x-x.i386.rpm
>     * oracle-instantclient11.1-devel-xx.x.x.x.x-x.i386.rpm
> zbudowa³em paki deb.Nastêpnie w oparciu o instrukcje:http://
> usestrict.net/2009/07/perl-installing-dbdoracle-on-ubuntu-904-and-
> oracle-instant-client/.
>
> - na etapie :make test :
>
> ~/.cpan/build/DBD-Oracle-1.38-szAWvo# make test
> cp Oracle.pm blib/lib/DBD/Oracle.pm
> cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm
> Skip blib/lib/DBD/mkta.pl (unchanged)
> Skip blib/lib/DBD/Oraperl.pm (unchanged)
> Skip blib/lib/DBD/Oracle/Troubleshooting.pm (unchanged)
> Skip blib/lib/DBD/Oracle/Object.pm (unchanged)
> Skip blib/lib/DBD/mk.pm (unchanged)
> Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged)
> cc -c  -I/usr/local/lib/perl/5.10.1/auto/DBI -I/usr/include/oracle/
> 10.2.0.3/client -O2 -g   -DVERSION=\"1.0\" -DXS_VERSION=\"1.0\" -fPIC
> "-I/usr/lib/perl/5.10/CORE"  -Wall -Wcast-align -Wpointer-arith -
> DORA_OCI_VERSION=\"10.2.0.3\" Oracle.c
> In file included from /usr/lib/perl/5.10/CORE/perl.h:4829,
>                  from /usr/local/lib/perl/5.10.1/auto/DBI/DBIXS.h:23,
>                  from Oracle.h:50,
>                  from Oracle.xs:1:
> /usr/lib/perl/5.10/CORE/proto.h:690: error: expected declaration
> specifiers or '...' before 'off64_t'
> /usr/lib/perl/5.10/CORE/proto.h:697: error: expected '=', ',', ';',
> 'asm' or '__attribute__' before 'Perl_do_sysseek'
> /usr/lib/perl/5.10/CORE/proto.h:702: error: expected '=', ',', ';',
> 'asm' or '__attribute__' before 'Perl_do_tell'
> /usr/lib/perl/5.10/CORE/proto.h:6019: error: expected '=', ',', ';',
> 'asm' or '__attribute__' before 'Perl_PerlIO_tell'
> /usr/lib/perl/5.10/CORE/proto.h:6020: error: expected declaration
> specifiers or '...' before 'off64_t'
> In file included from Oracle.c:170:
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h: In function
> 'dbixst_bounce_method':
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h:27: warning:
> dereferencing type-punned pointer will break strict-aliasing rules
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h:46: warning:
> dereferencing type-punned pointer will break strict-aliasing rules
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h: In function
> 'dbdxst_bind_params':
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h:72: warning: passing
> argument 2 of 'imp_sth->com.std.dbistate->set_err_char' from
> incompatible pointer type
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h:72: note: expected
> 'struct imp_xxh_t *' but argument is of type 'struct imp_sth_t *'
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h: In function
> 'dbdxst_fetchall_arrayref':
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h:93: warning:
> dereferencing type-punned pointer will break strict-aliasing rules
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h:98: warning: passing
> argument 2 of 'imp_sth->com.std.dbistate->set_err_char' from
> incompatible pointer type
> /usr/local/lib/perl/5.10.1/auto/DBI/Driver_xst.h:98: note: expected
> 'struct imp_xxh_t *' but argument is of type 'struct imp_sth_t *'
> Oracle.xsi: In function 'XS_DBD__Oracle__db__login':
> Oracle.xsi:93: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_selectall_arrayref':
> Oracle.xsi:146: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_selectrow_arrayref':
> Oracle.xsi:190: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_commit':
> Oracle.xsi:276: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_rollback':
> Oracle.xsi:286: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_disconnect':
> Oracle.xsi:296: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_STORE':
> Oracle.xsi:319: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_FETCH':
> Oracle.xsi:333: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__db_DESTROY':
> Oracle.xsi:345: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st__prepare':
> Oracle.xsi:451: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_rows':
> Oracle.xsi:467: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_bind_col':
> Oracle.xsi:484: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_bind_param':
> Oracle.xsi:522: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_bind_param_inout':
> Oracle.xsi:552: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_execute':
> Oracle.xsi:581: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_fetchrow_arrayref':
> Oracle.xsi:624: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_fetchrow_array':
> Oracle.xsi:637: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_finish':
> Oracle.xsi:671: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_blob_read':
> Oracle.xsi:700: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_STORE':
> Oracle.xsi:715: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_FETCH_attrib':
> Oracle.xsi:732: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'XS_DBD__Oracle__st_DESTROY':
> Oracle.xsi:746: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__st_ora_stmt_type':
> Oracle.xs:122: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__st_ora_stmt_type_name':
> Oracle.xs:132: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__st_ora_scroll_position':
> Oracle.xs:144: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__st_ora_fetch_scroll':
> Oracle.xs:156: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function
> 'XS_DBD__Oracle__st_ora_bind_param_inout_array':
> Oracle.xs:176: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__st_ora_fetch':
> Oracle.xs:207: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:210: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:211: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:221: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:231: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:235: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:238: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:239: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:239: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__st_ora_execute_array':
> Oracle.xs:250: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__st_cancel':
> Oracle.xs:273: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_db_startup':
> Oracle.xs:286: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:287: warning: unused variable 'status'
> Oracle.xs:286: warning: unused variable 'imp_dbh'
> Oracle.c:1702: warning: unused variable 'attribs'
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_db_shutdown':
> Oracle.xs:329: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:330: warning: unused variable 'status'
> Oracle.xs:329: warning: unused variable 'imp_dbh'
> Oracle.c:1759: warning: unused variable 'attribs'
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_can_taf':
> Oracle.xs:357: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:361: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:361: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_ping':
> Oracle.xs:375: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:390: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:390: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_reauthenticate':
> Oracle.xs:414: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_write':
> Oracle.xs:424: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:440: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:440: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:448: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:448: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:458: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:458: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_append':
> Oracle.xs:477: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:496: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:496: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:504: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:504: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:513: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:513: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_read':
> Oracle.xs:535: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:553: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:553: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:559: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:559: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_trim':
> Oracle.xs:584: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:587: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:587: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_is_init':
> Oracle.xs:601: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:605: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:605: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_length':
> Oracle.xs:619: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:623: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:623: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__db_ora_lob_chunk_size':
> Oracle.xs:638: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:642: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:642: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs: In function 'XS_DBD__Oracle__dr_init_oci':
> Oracle.xs:658: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xs:659: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi: In function 'boot_DBD__Oracle':
> Oracle.xsi:19: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi:19: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi:19: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> Oracle.xsi:24: warning: dereferencing type-punned pointer will break
> strict-aliasing rules
> make: *** [Oracle.o] B³±d 1
>
> Rozjecha³o siê.Czy da siê to ogarn±æ ?
>
> Czy ma kto¶ sposób na pod³±czanie siê via perl z debiana  do zdalnej
> bazy oracle 10g.

instantclient10 użyłem a nie 11.
--
zażółć gęsią szyję.Test kodowania .what is the f...
Technical Details
Message-ID: <577c38fa-0fcc-4c14-984a-c7fa28e2f155@bs8g2000vbb.googlegroups.com>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!fu-berlin.de!postnews.google.com!bs8g2000vbb.googlegroups.com!not-for-mail
References: <8d9c5986-69eb-4315-bd17-1d0448ecc558@15g2000vbq.googlegroups.com>

Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!fu-berlin.de!postnews.google.com!bs8g2000vbb.googlegroups.com!not-for-mail
From: washide <yoawaoy@gmail.com>
Newsgroups: pl.comp.os.linux.debian
Subject: Re: connection debian client to external rh:oracle
Date: Tue, 7 Feb 2012 02:54:14 -0800 (PST)
Organization: http://groups.google.com
Lines: 296
Message-ID: <577c38fa-0fcc-4c14-984a-c7fa28e2f155@bs8g2000vbb.googlegroups.com>
References: <8d9c5986-69eb-4315-bd17-1d0448ecc558@15g2000vbq.googlegroups.com>
NNTP-Posting-Host: 213.227.101.55
Mime-Version: 1.0
X-Trace: posting.google.com 1328612054 22576 127.0.0.1 (7 Feb 2012 10:54:14 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 7 Feb 2012 10:54:14 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: bs8g2000vbb.googlegroups.com; posting-host=213.227.101.55; posting-account=SBycvgkAAADamTvCZmAlf2k1il34U7-j
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-Header-Order: HUALESNKRC
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; pl-PL; rv:1.9.1.16) Gecko/20110929 Iceweasel/3.5.16 (like Firefox/3.5.16),gzip(gfe)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit