What do you have set for your ORACLE_HOME and any NLS variables? env|grep ORA env|grep NLS
Execute the above commands. -Mark -----Original Message----- From: Vinod Guleria [mailto:vinod.gule...@gmail.com] Sent: Monday, July 26, 2010 12:42 AM To: Alexander Foken Cc: John Scoles; Martin J. Evans; dbi-users@perl.org Subject: Re: DBD Oracle connectivity Hi, I have installed oracle 10g client on my system. But still i am getting error while trying to connect to oracle as follows: DBI connect('host=10.7.85.32;sid=SMDB1;port=1521','wb',...) failed: ERROR OCINls EnvironmentVariableGet(OCI_NLS_CHARSET_ID) Check ORACLE_HOME and NLS settings et c. at test.pl line 19 Pls help me to get rid of this error. Regards, Vinod. On Mon, Jul 19, 2010 at 1:57 PM, Alexander Foken <alexan...@foken.de> wrote: > No, even with DBD::ODBC you need an Oracle client, not for DBD::ODBC > itself, but the ODBC manager needs one. Windows comes out of the box with a > prehistoric Oracle client that causes more trouble than it is worth, so even > there, you want to install a RECENT Oracle client. > > The only way to avoid installing an Oracle client on a specific machine is > to use another machine with an installed Oracle client as a proxy, using > DBD::Proxy or DBD::Gofer, or some other proxying code. > > Alexander > > > John Scoles wrote: > >> I guess you could use DBD::ODBC that does net require an oracle client. >> >> cheers >> John Scoles >> >> On Fri, Jul 16, 2010 at 4:50 AM, Martin J. Evans >> <martin.ev...@easysoft.com>wrote: >> >> >> >>> Vinod Guleria wrote: >>> >>> >>>> Dears, >>>> >>>> >>>> Could you pls let me know that Is there a way to connect to oracle DB(on >>>> remote system) without having oracle client on my system. >>>> >>>> >>>> Thanks & Regards, >>>> Vinod Guleria. >>>> >>>> >>>> >>> If you are absolutely sure you cannot install any Oracle software on >>> your machine you need to search for Oracle Wire Protocol drivers. >>> However, none of these are made by Oracle and if Oracle change the >>> network protocol they will probably stop working until you can get an >>> update from the manufacturer. Also, these WP drivers don't tend to >>> support encryption, XA, failover etc and many other features you get >>> with the Oracle client. >>> >>> A better bet in my opinion is to install Oracle Instant Client. It is a >>> relatively small download and can be installed anywhere - you do not >>> need root permission. >>> >>> Martin >>> -- >>> Martin J. Evans >>> Easysoft Limited >>> http://www.easysoft.com >>> >>> >>> >> >> -- >> New! Learn why & how to love your data with Pythian's new webinar series. >> Topics, details & register: http://www.pythian.com/webinars >> >> >> >> >
