NYCPHP Meetup

[nycphp-talk] Oracle NLS_LANG problem: ADD

Jeremy Hise jhise at linuxforbusiness.org
Wed Jun 19 13:18:25 EDT 2002


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
> 
> 
> 






More information about the talk mailing list