Home > dbd error > dbd error ocistmtexecute/describe

Dbd Error Ocistmtexecute/describe

Q&A Tutorials Poetry RecentThreads NewestNodes Donate What'sNew on Jun 10, 2008 at 19:37UTC ( #691318=perlquestion: print w/replies, xml ) Need Help?? eugemz has asked for the wisdom of the Perl Monks concerning the following question: I need help! I can not even count the number of hours that I use to find a solution for this problem! I�m just giving up. I have a perl program (#1) that process text files and insert the data in a DB. In this case is running in linux ubuntu and Oracle 10.g DB. I use DBD::Oracle Version 1.21 and DBI Version 1.604. Oracle Instant Client Version 10.2.0.4 As there could be thousand of text files, I have a perl program (#2) that allocate the text files based on the size in X folders and call X times perl program (#1) to process the files that where distributed in the folders. The perl program (#2) runs well until any of the perl program instances (#1) finish. When the instance finish and get back to the program that called it, I loose the connection with the DB and I get the error DBD::Oracle::db prepare failed: Error while trying to retrieve text for error ORA-03113 (DBD ERROR: OCIStmtExecute/Describe) I trace the DBI connection and I get this message, <- DESTROY(DBI::st=HASH(84d52b4))= undef <- disconnect_all= (not implemented) at DBI.pm line 716 ! <- DESTROY(DBI::db=HASH(84e2148))= undef during global destruction ! <- DESTROY(DBI::dr=HASH(84d5590))= undef during global destruction !! ERROR: '3113' 'Error while trying to retrieve text for error OR +A-03113 (DBD ERROR: OCIStmtExecute/Describe)' (err#0) <- prepare('Select rows_added,start_datetime,stop_datetime FROM kc +rei_batch_job_history WHERE master_job_no = 123 AND master_job_sub_no + = 0')= undef at kc_tlog_monitor.pl line 1151 ERROR: '3113' 'Error while trying to retrieve text for error OR +A-03113 (DBD ERROR: OCIStmtExecute/Describe)' (err#0) <- errstr= 'Error while trying to retrieve text for error ORA-0311 +3 (DBD ERROR: OCIStmtExecute/Describe)' at kc_tlog_monitor.pl line 11 +51 ERROR: '3113' 'Error while trying to retrieve text for error O

Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and http://www.perlmonks.org/?node_id=691318 thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Perl Forum at Tek-Tips HomeForumsProgrammersLanguagesPerl Forum http://www.tek-tips.com/viewthread.cfm?qid=106239 ORA-00936: missing expression (DBD ERROR: OCIStmtExecute/Describe thread219-106239 Forum Search FAQs Links MVPs ORA-00936: missing expression (DBD ERROR: OCIStmtExecute/Describe ORA-00936: missing expression (DBD ERROR: OCIStmtExecute/Describe SridharSrini (MIS) (OP) 13 Jul 01 16:21 Hi,Can anyone tell me why I am getting this error.ORA-00936: missing expression (DBD ERROR: OCIStmtExecute/DescribeI am running a perl script on HP11.00 and DBD-Oracle-1.06.The same script runs fine on our other box which runs on HP 10.20 and DBD-Oracle-1.06.Thanks in advanceSridhar RE: ORA-00936: missing expression (DBD ERROR: OCIStmtExecute/Describe hmerrill (Programmer) 13 Jul 01 16:32 How about giving us some code - include your connect statement, and the SQL statements that are giving you problems - with the DBI commands.Also, what versions of Perl and DBI do you have?One tool you can use to help find out what the problem might be is the DBI "trace" method.Read the DBI perldocs by doing "perldoc DBI", and search for(using the slash "/") "trace". Hardy MerrillMission Critical L

V.2.18.1 To V.2.18 Next message: (RADIATOR) ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute/Describe) Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] Hello everybody, I've got the same error for ages. It http://www.open.com.au/pipermail/radiator/2001-May/000025.html happens when Radiator is (re)started and tries to query BD for the first-second time. For example: Thu May 3 19:46:50 2001: INFO: Server started: Radiator 2.17.1 on elektra.jazzlab.com Thu May 3 19:47:49 2001: http://radiator.open.com.narkive.com/Xmvp0Doq/radiator-ora-03113-end-of-file-on-communication-channel-dbd-error-ocistmtexecute-describe DEBUG: Reclaiming expired leases Thu May 3 19:47:49 2001: DEBUG: do query is: update RADPOOL set STATE=0 where state!=0 and EXPIRY < 988912069 Thu May 3 19:47:49 2001: ERR: do failed for dbd error 'update RADPOOL set STATE=0 where state!=0 and EXPIRY < 988912069': ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute) Thu May 3 19:48:49 2001: DEBUG: Reclaiming expired leases Thu May 3 19:48:49 2001: DEBUG: do query is: update RADPOOL set STATE=0 where state!=0 and EXPIRY < 988912129 Thu May 3 19:49:49 2001: DEBUG: Reclaiming expired leases Thu May 3 19:49:49 2001: DEBUG: do query is: update RADPOOL dbd error ocistmtexecute/describe set STATE=0 where state!=0 and EXPIRY < 988912189 Thu May 3 19:50:11 2001: DEBUG: Packet dump: *** Received from 10.9.10.200 port 49152 .... Code: Access-Request Identifier: 9 Authentic: <233><174>&H<10><153><3>%<167>]<5>C<136><236>#3 Attributes: User-Name = "usuario1isp at clienteisp" CHAP-Password = "<1><241><237>ow<189><248>KO<127>G5<194>mB<244><200>" Acct-Session-Id = "42000058" NAS-IP-Address = x.x.x.x Shasta-SGROUP = "Shasta 5000: iSOS (tm), 2.1(14)" Service-Type = Framed-User Framed-Protocol = PPP Calling-Station-Id = "9xxxxxxxx" Called-Station-Id = "9xxxxxxxx" Thu May 3 19:50:11 2001: DEBUG: Rewrote user name to usuario1isp at clienteisp Thu May 3 19:50:11 2001: DEBUG: Handling request with Handler 'Realm=DEFAULT' Thu May 3 19:50:11 2001: DEBUG: SDB1 Deleting session for usuario1isp at clienteisp, x.x.x.x, Thu May 3 19:50:11 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='x.x.x.x' and ACCTSESSIONID='42000058' Thu May 3 19:50:11 2001: ERR: do failed for 'delete from RADONLINE where NASIDENTIFIER='x.x.x.x' and ACCTSESSIONID='42000058'': ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute) ----------------------------...-------------------------- My scenario: Radiator 2.17.1 in Linux (2.2.14 or 2.4.1) and Oracle 8.1.6 in Linux 2.4.1(PC) or Solaris 2.6 (Ultra-60). I think it's a problem related with SQL Oracle Libraries but it only happens at the beginning (not after) and it seems not to be serious. Bye, Daniel. === Archive at http://www.open.com.au/archives/radiator/ An

following error:ORA-03113: end-of-file on communication channel (DBD ERROR:OCIStmtExecute/Describe)and now that I see it, is the same after the kill -HUP I sent you 'boutan hour ago...So maybe the problem isn't with kill -HUP but with Oracle DBD or, mostprobably, my way of using it.Let's start over again, full scenario:Sun Netra T1 AC200, 1CPU 360MHz, 512Mb RAM, 2x18Gb HD, Solaris 8, Perlv5.6.1, Radiator 2.18.1, Oracle8i Release 8.1.6.0.0 - Production.I run two instances of Radiator, one for authentication and one foraccounting.I'm using a bunch of config files:radius-auth.cfg (for authentication only settings)radius-acct.cfg (for accounting only settings)radius-common.cfg (for everything in common, included from both above)DBGlobalData.cfg (data base global data, included from radius-common.cfg)DBUseData.cfg (for including everytime I have to put DBSource/DBUsername/DBAuth)clients.cfg (the clients section, a , included fromradius-common.cfg)I'm attaching all of the config files to this message.Now, apparently, what's happening is the following:the first "oracle thing" that ought to be done is to get theClientListSQL by doing the corresponding SELECT.That is apparently working since the host where the radpwtst is being runand the NAS_Identifier that it provides are accepted (it rejected thembefore I inserted the records in the tables).Next time an oracle query is executed, it fails with the error:ORA-03113: end-of-file on communication channel (DBD ERROR:OCIStmtExecute/Describe)It's the same error, whether I kill -HUP the server (and theClientListSQL statement is executed again) or if I try to execute thestatement to authenticate a user... After failing the first time, then itworks OK, or so it seems... but I don't know what's going on.I'm still not doing SQL accounting so I can't verify the same behavior inthe other instance (but the kill -HUP behavior is the same).Here there is a trace 4:Tue May 8 18:30:22 2001: INFO: Server started: Radiator 2.18.1 on dummy-serverTue May 8 18:30:27 2001: DEBUG: Packet dump:*** Received from 127.0.0.1 port 39823 ....Code: Access-RequestIdentifier: 12Authentic: 1234567890123456Attributes:User-Name = "a-user at some-realm"Service-Type = Framed-UserNAS-IP-Address = 200.59.130.83NAS-Port = 1234Called-Station-Id = "123456789"Calling-Station-Id = "987654321"NAS-Port-Type = AsyncUser-Password ="Z/<237>h%<251><233>:<238><192><220>`<176><12>\<146>"Tue May 8 18:30:27 2001: DEBUG: Rewrote user name to a-user at some-realmTue May 8 18:30:27 2001: DEBUG: Rewrote

Related content

dbd error ocistmtfetch

Dbd Error Ocistmtfetch p representation of strings Message ID D easysoft com E R wrote Alright so here's another mystery use DBI relatedl ENV NLS LANG AMERICAN AMERICA WE ISO P dbh DBI- connect c chr print result select scalar SELECT FROM DUAL WHERE ' c' chr n The select scalar subroutine merely returns the first column of the first row of the query The above code emits result However if I change NLS LANG to AMERICAN AMERICA US ASCII it emits result Is there another NLS LANG setting I should use or should I check my versions of OCI

dbd error code 20

Dbd Error Code table id toc tbody tr td div id toctitle Contents div ul li a href Dbd Error Ocistmtexecute a li li a href Sqlite Error Messages a li li a href How To Fix Error Code a li ul td tr tbody table p their respective owners in the US and other countries Privacy Policy Legal Steam relatedl Subscriber Agreement Refunds STORE Featured Explore Curators dbd error error possibly near indicator Wishlist News Stats COMMUNITY Home Discussions Workshop Greenlight Market Broadcasts ABOUT p h id Dbd Error Ocistmtexecute p SUPPORT Install Steam login language Bulgarian e tina

dbd error ociserver

Dbd Error Ociserver table id toc tbody tr td div id toctitle Contents div ul li a href Tns No Listener Dbd Error Ociserverattach a li li a href Ociserverattach Failed Ora Tns No Listener a li li a href Ora Dbd Error Ociserverattach a li ul td tr tbody table p listener DBD ERROR OCIServerAttach message Tue September babble Messages Registered July Location new york Junior Member Hi Gurus relatedl OS Red Hat Enterprise Linux Oracle dbd error ociserverattach ora I Installed OEM And when I'm trying to connect to DB through p h id Tns No Listener Dbd

dbd error ocisessionbegin

Dbd Error Ocisessionbegin table id toc tbody tr td div id toctitle Contents div ul li a href Ora Insufficient Privileges Dbd Error Ocisessionbegin a li li a href Error Ora The Account Is Locked a li li a href Ora- The Account Is Locked Oracle g a li ul td tr tbody table p friend Failed to connect to database instance DBD ERROR OCISessionBegin message Fri October masoodnt Messages Registered October Junior relatedl Member I'm trying to connect to remote database from oracle exception ocisessionbegin enterprise manager the connection is going fine but when i try ora invalid username

dbd error ocisessionend during global destruction

Dbd Error Ocisessionend During Global Destruction p Q A Tutorials Poetry RecentThreads NewestNodes Donate What'sNew on Mar at UTC perlquestion print w replies xml Need Help guice has asked for the wisdom of the relatedl Perl Monks concerning the following question Anybody have any problems with Parallel ForkManager or maybe even DBI eating up resources I currently run a script that forks upto children using ForkManager with upto a total children by the time it's done When I run a big load my CPU load slowly climbs from to over by the time it finishes Once the whole script is

dbd error ociserverattach ora-12541

Dbd Error Ociserverattach Ora- p for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get relatedl Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange Questions ORA- TNS no listener DBD ERROR OCIServerAttach Want to Advertise Here Solved ORA- TNS no listener DBD ERROR OCIServerAttach Posted on - - Oracle Database Verified Solution Comments Views

dbd error ocisessionbegin at t/10general.t line 22

Dbd Error Ocisessionbegin At T general t Line p View Threaded Feb PM Post of views Permalink make relatedl fixdeps unable to fix DBD Oracle MISSING Fails with ORA- Hi all As a background I'm quite familiar with Oracle and mostly know my way with Linux too but I've no experience on PERL nor RT before What I'm trying to do is install RT on Oracle Linux and configure it to use an existing remote Oracle g database I've used this installation document http requesttracker wikia com wiki CentOS InstallPlusSome as my guideline with minor differences in versions etc and

dbd error

Dbd Error table id toc tbody tr td div id toctitle Contents div ul li a href Dbd Error Ociserverattach a li li a href Dbd Error Ocisessionbegin a li li a href Perl Dbi Connect a li ul td tr tbody table p PerlNews Q A Tutorials Poetry RecentThreads NewestNodes Donate What'sNew on Mar at UTC relatedl perlquestion print w replies xml Need Help dbd error error possibly near indicator suhailck has asked for the wisdom of the Perl Monks dbd error ocistmtexecute concerning the following question Hi Im new to perl and i wrote a script for oracle

dbd error log

Dbd Error Log table id toc tbody tr td div id toctitle Contents div ul li a href Dbd Error Ocistmtexecute a li li a href Dbd Error Ocisessionbegin a li li a href Perl Dbi Trace a li li a href Dbi trace a li ul td tr tbody table p the answer generally runs along the lines of Why aren't you performing error checking Sure enough nine out of ten relatedl times when error checking is added the exact error message dbd error error possibly near indicator appears and the cause for error is obvious Automatic Versus Manual

dbd error ociserverattach ora 12154

Dbd Error Ociserverattach Ora p here for a quick overview of the site Help Center Detailed answers to any questions relatedl you might have Meta Discuss the workings and failed to connect to database instance ora- tns no listener dbd error ociserverattach policies of this site About Us Learn more about Stack Overflow the company ora- tns could not resolve the connect identifier specified Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of million programmers

dbd error ociserverattach windows

Dbd Error Ociserverattach Windows p Perl Lists Python Lists PHP Lists relatedl Ruby Lists Tcl Lists ActiveState Lists Lists raquo perl-dbi-users Re ORA- DBD ERROR OCIServerAttach From Charles Seelig csee penrose com Wed Sep - - TNS ADMIN is not set in either the registry or environment - Not run by web server only from the command line CS Jeff Urlwin wrote Chances are something is wrong in the registry or environment Is there a TNS ADMIN set anywhere Are you running under a web server when it's not working Jeff Greetings Context Windows XP client Perl This is perl

dbd error ociserverattach agent

Dbd Error Ociserverattach Agent table id toc tbody tr td div id toctitle Contents div ul li a href Environment Variable Oracle unqname Not Defined Please Set Oracle unqname To Database Unique Name a li li a href Ora- Tns protocol Adapter Error a li ul td tr tbody table p here relatedl for a quick overview of the site agent connection to instance failed ora Help Center Detailed answers to any questions you might enterprise manager is not able to connect to the database instance have Meta Discuss the workings and policies of this site About Us Learn more

dbd error ocistmtprepare

Dbd Error Ocistmtprepare table id toc tbody tr td div id toctitle Contents div ul li a href Database Error Ora- Invalid Length Specified For Statement a li ul td tr tbody table p Rejected bugs Report a new bug Preferred bug tracker Please visit the preferred bug tracker to report your relatedl issue This queue is for tickets about the DBD-Oracle ora- CPAN distribution Report information The Basics Id Status stalled Priority p h id Database Error Ora- Invalid Length Specified For Statement p Queue DBD-Oracle People Owner Nobody in particular Requestors dflewelling epsilon com Cc AdminCc Bug Information

dbd error ocienvinit

Dbd Error Ocienvinit p DBD ERROR OCIEnvInit Message ID c ae- b - a - fc - eacba bbee n g prg googlegroups com Hello List I have seen several such messages and tried to gather as much wisdom as I could from those but I still can not get it to work Would appreciate someone helping with this Here is the scenario Running following perl script on Microsoft Windows XP Professional Version Service Pack Build C Nishi Perl perl tst pl DBI connect 'host myHost SID sid ' 'myUser' failed DBD ERROR OCIEnvInit at tst pl line DBD ERROR

dbd error ociserverattach 11g

Dbd Error Ociserverattach g table id toc tbody tr td div id toctitle Contents div ul li a href Failed To Connect To Database Instance Ora- Tns no Listener dbd Error Ociserverattach a li li a href Ns Main Err Code a li ul td tr tbody table p CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError You don't have JavaScript enabled This tool uses JavaScript and much of it will not work correctly relatedl without it enabled Please turn JavaScript back on ora- tns connection closed error and reload this page Please enter a title You can not p

dbd error ociserverattach

Dbd Error Ociserverattach table id toc tbody tr td div id toctitle Contents div ul li a href Tns No Listener Dbd Error Ociserverattach a li li a href Dbd Error Ociserverattach Perl a li li a href Dbd Error Ocisessionbegin a li ul td tr tbody table p listener DBD ERROR OCIServerAttach message Tue September babble Messages Registered July Location new york Junior Member Hi Gurus OS Red relatedl Hat Enterprise Linux Oracle I Installed dbd error ociserverattach ora OEM And when I'm trying to connect to DB through URL I get p h id Tns No Listener Dbd

dbd error ora-01406

Dbd Error Ora- p Blog Extensions Documentation Community Development Tasks Download Support You are here Foswiki Support Web SupportQuestions Question Jan relatedl MichaelDaum Edit AttachThis question about This website Task filed Oracle Long Column Type I got this oracle error while using the SqlPlugin ERROR DBD Oracle st fetchrow hashref failed ORA- A Truncation or null fetch error occurred DBD ERROR ORA- error on field of ora type LongReadLen too small and or LongTruncOk not set for Statement select view name text from all views As a workaround I patched lib Foswiki Plugins SqlPlugin Connection pm by adding the following

dbd error ocisessionbegin perl

Dbd Error Ocisessionbegin Perl table id toc tbody tr td div id toctitle Contents div ul li a href Ora- Invalid Username password Logon Denied dbd Error Ocisessionbegin a li li a href Perl Dbd Oracle a li ul td tr tbody table p Q A Tutorials Poetry RecentThreads NewestNodes Donate What'sNew on Aug at UTC perlquestion print w replies xml Need Help laminee has relatedl asked for the wisdom of the Perl Monks perl dbi connect oracle service name concerning the following question Hi Monks I am trying to replicate p h id Ora- Invalid Username password Logon Denied

dbd error ociserverattach em

Dbd Error Ociserverattach Em p listener DBD ERROR OCIServerAttach message Tue September babble Messages Registered relatedl July Location new york Junior Member Hi Gurus OS Red Hat Enterprise Linux Oracle I Installed OEM And when I'm trying to connect to DB through URL I get error message ORA- TNS no listener DBD ERROR OCIServerAttach My listener is also up Can somebody help me to troubleshoot this problem Regards Report message to a moderator Re ORA- TNS no listener DBD ERROR OCIServerAttach message is a reply to message Tue September Arju Messages Registered June Location Dhaka Bangladesh Mobile Senior Member This

ocisessionbegin error

Ocisessionbegin Error table id toc tbody tr td div id toctitle Contents div ul li a href Ora- The Account Is Locked dbd Error Ocisessionbegin a li li a href Ociserverattach a li li a href Ora- a li li a href Dbsnmp a li ul td tr tbody table p relatedl Thu October dba failed to connect to database instance ora the password has expired dbd error ocisessionbegin Messages Registered August Location Delhi Senior p h id Ora- The Account Is Locked dbd Error Ocisessionbegin p Member Hi I'm new to OEM When login i'm getting error ora- the

ora-12154 dbd error ociserverattach

Ora- Dbd Error Ociserverattach table id toc tbody tr td div id toctitle Contents div ul li a href Failed To Connect To Database Instance Ora- Tns no Listener dbd Error Ociserverattach a li li a href Ora- Tns could Not Resolve The Connect Identifier Specified a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any relatedl questions you might have Meta Discuss the workings p h id Failed To Connect To Database Instance Ora- Tns no Listener dbd Error Ociserverattach p and policies of this site About

ora-12541 dbd error ociserverattach

Ora- Dbd Error Ociserverattach p listener DBD ERROR OCIServerAttach message Tue September babble Messages Registered July Location relatedl new york Junior Member Hi Gurus OS Red ora tns no listener but listener is running Hat Enterprise Linux Oracle I Installed OEM And failed to connect to database instance ora- tns no listener dbd error ociserverattach when I'm trying to connect to DB through URL I get error message ORA- TNS no listener DBD lsnrctl command not found ERROR OCIServerAttach My listener is also up Can somebody help me to troubleshoot this problem Regards Report message to a moderator Re ORA-

oracle dbd error ociserverattach

Oracle Dbd Error Ociserverattach table id toc tbody tr td div id toctitle Contents div ul li a href Failed To Connect To Database Instance Ora- Tns no Listener dbd Error Ociserverattach a li li a href Ora- Tns could Not Resolve The Connect Identifier Specified a li ul td tr tbody table p Q A Tutorials Poetry RecentThreads NewestNodes Donate What'sNew on Apr at UTC perlquestion print w replies xml Need Help Anonymous Monk has asked for the relatedl wisdom of the Perl Monks concerning the following ora dbd error ociserverattach question I am having problems connecting to Oracle

oracle dbd error ocisessionbegin

Oracle Dbd Error Ocisessionbegin table id toc tbody tr td div id toctitle Contents div ul li a href Perl Oracle Connection Example a li li a href Perl Connect To Oracle Database Example a li ul td tr tbody table p friend Failed to connect to database instance DBD ERROR OCISessionBegin message Fri October masoodnt Messages Registered October Junior Member I'm trying to connect to remote relatedl database from oracle enterprise manager the connection is going fine perl dbi oracle service name but when i try to connect to a database xyz it's giving error like ora- invalid username