NYCPHP Meetup

[nycphp-talk] Oracle NLS_LANG problem: ADD

Hans Zaunere zaunere at yahoo.com
Wed Jun 19 13:48:01 EDT 2002


And oh, here's that link:
http://www.oracle-error.com

Sorry about that, and alas it doesn't seem to have your particular
error message, but hopefully it'll be useful at somepoint to someone.

That's great you got it working.  I know Oracle can be a real beast, I
can only imagine the cross-platform issues that would arise.

HZ


--- Jeremy Hise <jhise at linuxforbusiness.org> wrote:
> Ok. I figured out the problem.
> 
> For some reason, the Oracle on NT (where the database actually was)
> had:
> 	ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
> 
> But on the RH box, the oracle install script had set it to:
> 	ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/oracle
> 
> So, I went and simple changed the /oracle to /data
> 
> And my day just got a hell of a lot better.
> 
> As the great Homer says:
> 	WHOOOOOOOOOOO HOOOOOOOOOOOO
> 
> I do have the following in my apachectl script:
> 
> export ORACLE_BASE=/ora8/m01/app/oracle
> export ORACLE_HOME=$ORACLE_BASE/product/8.1.6
> export PATH=$PATH:$ORACLE_HOME/bin
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr
> export ORACLE_SID=ora8
> export ORACLE_TERM=vt100
> export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
> export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
> 
> 
> I really hope this helps others.
> 
> Thanks!
> 
> Jeremy
> 
> 
> On Fri, 2002-06-14 at 22:27, Hans Zaunere wrote:
> > 
> > I might be able to help on this one.
> > 
> > If you don't know already, consider http://orafaq.com and
> > http://oradoc.photo.net invaluable.  On orafaq.com somewhere, there
> is
> > a directory of every ORA-* error message, in addition to the search
> > ability.  I have the URL at work and will post Monday.
> > 
> > Anyway, although you say you're using the Oracle client, I'm
> assuming
> > this is running from Apache/PHP (as opposed to the actual Oracle
> > client).
> > 
> > If running Apache, you need to make sure that the proper Oracle
> > environment is actually available via Apache and permissions for
> the
> > Apache user.  I generally setup the environment in the apachectl
> script
> > in some way.  This ensures that Apache itself actually has the
> proper
> > environment, and cane be confirmed with a phpinfo() call.  Also, be
> > sure Apache has access to the Oracle client resource, which are
> > generally installed as a different user.
> > 
> > Let me know if this helps, and if not, any more details on the
> > situation (I use 8i client libs on RH 6.2 to connect to a NT
> server).
> > 
> > HZ
> > 
> > 
> > 
> > 
> > --- Jeremy Hise <jhise at linuxforbusiness.org> wrote:
> > > On line 178 I'm also calling a stored procedure that generates a
> > > value,
> > > which is bound to a PHP variable for use.
> > > 
> > > On Fri, 2002-06-14 at 18:21, Jeremy Hise wrote:
> > > > Hi All:
> > > > 
> > > > I'm running oracle on NT and connecting via the oracle client
> on RH
> > > 6.2
> > > > Kernel version 2.2.14-5.0 ... Oracle 8.1.6
> > > > 
> > > > The PHP error I'm getting is:
> > > > 
> > > > Warning: OCIStmtExecute: ORA-06550: line 1, column 30:
> PLS-00553:
> > > > character set name is not recognized ORA-06550: line 0, column
> 0:
> > > > PL/SQL: Compilation unit analysis terminated in
> > > > /development/jhise/dbmerge_src/class/login.pclass on line 178
> > > > 
> > > > I've been looking all over the place and all the pages I've
> found
> > > say to
> > > > correctly set up the NLS_LANG env variable...which I do. I've
> > > stopped
> > > > and started apache...even rebooted the whole machine...doesn't
> seem
> > > as
> > > > though any of it makes any difference.
> > > > 
> > > > Anyway have any insight?
> > > > 
> > > > Thanks!
> > > > 
> > > > jhise
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > 
> > > 
> > > 
> > > 
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> > 
> > 
> > 
> 
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com



More information about the talk mailing list