I have not installed 9i as yet. But you should only set ORA_NLS33 before
creating a database if you are using a character set other than US7ASCII. It
sounds as ORA_NLS33 was inadvertrntly set to some illegal value before your
database was created. Perhaps you can quey your environment to see if it is
set. Or recrreate database making sure it is not set.
hth
Lawrence
"Tim Schaefer" <tim_at_datad.com> wrote in message
news:P3vs7.63543$%72.1406909_at_sjcpnn01.usenetserver.com...
> 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
>
>
>
>
>
Received on Wed Sep 26 2001 - 21:19:15 CDT
