Oracle 9i Installation / Configuration

From: Tim Schaefer <tim_at_datad.com>
Date: Wed, 26 Sep 2001 21:10:06 -0400
Message-ID: <P3vs7.63543$%72.1406909@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

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

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 - 20:10:06 CDT

Oracle 9i Installation / Configuration :: ORA_NLS33 Error