Re: Oracle 9i Installation / Configuration :: ORA_NLS33 Error

Tim Schaefer wrote:

> Hi!
>
> I'm new to Oracle.... <gawd here we go right>
>
> OS: SuSE Linux 7.2 2.4 Kernel
> uname -a
> Linux linux 2.4.4-4GB #1 Fri May 18 14:11:12 GMT 2001 i686 unknown
>
> Machine: Pentium III 500 Mhz, 768 MB RAM, TWO (2) 40 GB IDE HD
>
> Lots of room to play on this machine--well it's Oracle so mebbe not....
>
> I've tried to set up everything by the book. Engine actually started after
> install,
> sucking the life out of the system, and even started the Apache web server!
> Woo Hoo!
> I built the system fresh, following all the Oracle docs to the letter.
> Obviously
> I'm missing something.
>
> Upon rebooting the system of course, I needed to figure out how to restart
> the engine,
> which simply won't happen. I cannot for the life of me figure out why,
> continuing to
> get the following output from my /etc/init.d/dbora start :
>
> My dbora command src:
>
> --begin
>
> #!/bin/sh
> ############################################################################
> ####
> . ~oracle/.profile
>
> ORA_HOME=$ORACLE_HOME
> export ORA_HOME
>
> ORA_OWNER=oracle
> export ORA_OWNER
>
> if [ ! -f $ORA_HOME/bin/dbstart ]
> then
> echo "Oracle startup: cannot start"
> exit
> fi
>
> case "$1" in
> 'start')
>
> # Start the Oracle databases:
> # The following command assumes that the oracle login
> # will not prompt the user for any values
>
> echo "Starting Oracle"
> /opt/oracle/shared_memory.cmd.sh
> su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
> ;;
>
> 'stop')
>
> # Stop the Oracle databases:
> # The following command assumes that the oracle login
> # will not prompt the user for any values
>
> su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
> ;;
>
> esac
>
> --end src
>
> And the resulting output:
>
> --begin
>
> linux:/etc/init.d # ./dbora start
> Starting Oracle
> 100 256 100 100
> 100 256 100 100
> 2147483648
> 2147483648
> linux:/etc/init.d #
> SQL*Plus: Release 9.0.1.0.0 - Production on Wed Sep 26 20:45:37 2001
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> SQL> ERROR:
> ORA-12705: invalid or unknown NLS parameter value specified
>
> SQL> ORA-01031: insufficient privileges
> SQL>
> Database "mutt01" warm started.
>
> linux:/etc/init.d #
>
> --end
>
> EVEN IF I SET ORA_NLS33 like the docs show, it still errors-out!!!! And the
> docs
> tell you not to set ORA_NLS33 unless NLS stuff is somewhere else other than
> the
> default! So it's now unset, and still giving me fits. I put this in and it
> ignored
> the settings completely:
>
> ORA_NLS33=/opt/oracle/product/9.0.1/ocommon/nls/admin/data
> export ORA_NLS33
>
> Check this out:
>
> oracle_at_linux:~ > oerr ORA 12705
> 12705, 00000, "invalid or unknown NLS parameter value specified"
> // *Cause: The NLS parameter value specified in an alter session statement
> // is not valid or not implemented.
> // *Action:
> oracle_at_linux:~ >
>
> DUH!
>
> I also set the shared_memory before starting which is the display of numbers
> you see before dbora really gets started:
>
> --begin
> linux:/opt/oracle # cat shared_memory.cmd.sh
> cd /proc/sys/kernel
> cat sem
> #
> #
> # echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value > sem
> # 100 256 100 100
> #
> echo 100 256 100 100 > sem
> cat sem
> cat shmmax
> echo 2147483648 > shmmax
> cat shmmax
>
> --end
>
> My oracle .profile :
>
> --begin
>
> ORACLE_HOME=/opt/oracle/product/9.0.1; export ORACLE_HOME
> ORACLE_TERM=xterm; export ORACLE_TERM
> TNS_ADMIN=/export/home/oracle/config/9.0.1; export TNS_ADMIN
> NLS_LANG=AMERICAN-AMERICA.UTF8; export NLS_LANG
>
> LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
> LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/td/lib:/usr/ucblib:/usr/local/lib
> export LD_LIBRARY_PATH
>
> ORACLE_SID=mutt01; export ORACLE_SID
>
> #
> # ORACLE_DOC=
> #
>
> # Set shell search paths:
>
> PATH=/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/openwin/bin:/op
> t/local/GNU/bin
> PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/bin
> PATH=$PATH:/usr/local/samba/bin:/usr/ucb:
> export PATH
>
> #CLASSPATH must include the following JRE locations:
>
> CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
> CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
> export CLASSPATH
>
> --end

Tim,

There is an error in this line:

NLS_LANG=AMERICAN-AMERICA.UTF8; export NLS_LANG

The correct one is:

NLS_LANG=AMERICAN_AMERICA.UTF8; export NLS_LANG

I hope it is just typo. Instead of " _ " you are using " - ".

Hope that helps,

Trifon Anguelov
Senior Oracle DBA Received on Wed Sep 26 2001 - 14:07:08 CDT