[suse-oracle] Installed 9i on 8.0 Not quite useable... yet please advise

From: rob (dizzy74@attbi.com)
Date: Sun Oct 06 2002 - 18:06:38 CEST

  • Next message: Bennett Leve: "Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet please advise" 
    Message-ID: <3DA05F8E.9020805@attbi.com>
Date: Sun, 06 Oct 2002 11:06:38 -0500
From: rob <dizzy74@attbi.com>
Subject: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet please advise

    All
        I installed Oracle 9i on SuSE 8.0 professional, using this document
    http://www.suse.com/en/business/certifications/certified_software/oracle/docs/901_sles7_install.pdf

    I followed the document to the letter and the installion was
    suprisingliy smooth (excellent doc!)

    everything went fine... except

    When the install was creating the test database, it got to 46% then hung
    with the following error
    "Database creation failed because of shared pool memory ORA-27123 unable
    to attach shared memory segment"

    For the record I have 512RAM and 1G swap file

    So I figgured no problem, I have scripts that will manually build the
    database, but now It dosnt seem like any of the executables are in my path

    sqlplus
    oradim
    all fail with "command not found"
    ##################################################################################
    Here are the pertinant portions of the command env
    Nicole:~# env

    CLASSPATH=/opt/oracle/product/oracle/JRE:/opt/oracle/product/oracle/jlib:/opt/oracle/product/oracle/rdbms/jlib:/opt/oracle/product/oracle/network/jlib
    USER=oracle
    OLDPWD=/home/oracle
    JAVA_HOME=/usr/lib/java
    ORACLE_BASE=/opt/oracle
    ORACLE_HOME=/opt/oracle/product/oracle
    ORA_NLS33=/opt/oracle/product/oracle/ocommon/nls/admin/data
    JDK_HOME=/usr/lib/java
    JRE_HOME=/usr/lib/java
    PATH=/usr/sbin:/bin:/usr/bin:/sbin:/usr/X11R6/bin
    TNS_ADMIN=/opt/oracle/product/oracle/network/admin
    _=/usr/bin/env
    #######################################################################

    My oracle executables and installion are in
    /work/9ihome/bin

    Ive added the following to my .profile and .bashrc

    #. oraenv
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

    but still cant access the executables

    even if I change to the bin dir I get this smessage

    Nicole:/work/9ihome/bin # ./sqlplus
    Error 6 initializing SQL*Plus
    Message file sp1<lang>.msb not found
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

    so the questions... If I may

    1 So how do I do that? "set ORACLE_HOME to your Oracle software directory"
    2 How do I get the starter database installed?
    and
    3 How can I get the menu bar of programs availabe on kde??
    or in the very least get a list of executables.
     I've worked with Oracle on Windows for 3+ years so I know most of the
    commands but Id guess for a 2Gigabyte install at least I can get a menu
    of commands?? <grin>

    please advise
    Thanks

    rob 

    -- 
  My arthritic pinkies are already starting to ache just thinking about ||||=.
             -- Larry Wall in <199809251659.JAA06689@wall.org>

    ---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting

    This archive was generated by hypermail 2.1.4 : Sun Oct 06 2002 - 17:06:41 CEST