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

From: Bennett Leve (bennett.leve@oracle.com)
Date: Sun Oct 06 2002 - 22:16:13 CEST

  • Next message: rob: "Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet please advise" 
    Message-ID: <3DA09A0C.DD207979@oracle.com>
Date: Sun, 06 Oct 2002 13:16:13 -0700
From: Bennett Leve <bennett.leve@oracle.com>
Subject: Re: [suse-oracle] Installed 9i on 8.0 Not quite useable... yet please  advise

    Rob,

    Two issues here. The ORA-27123 problably also flagged an ORA-1034. This is likely because the database never started in a nomount state. Check the
    alert log to see why it failed to start. You need to do this before you exit out of DBCA as DBCA cleans up the files after the failure.

    As far as not being able to find the binaries you can see in your environment why this is:

    ORACLE_HOME=/opt/oracle/product/oracle
    PATH=/usr/sbin:/bin:/usr/bin:/sbin:/usr/X11R6/bin

    Do the following in your ".bashrc_profile".

      export ORACLE_HOME=/opt/oracle/product/oracle
      export PATH=$ORACLE_HOME/bin:$PATH

    This assumes that your ORACLE_HOME is truely /opt/oracle/product/oracle. You get the message file not found messages when either you have ORACLE_HOME set
    improperly, ORACLE_HOME is not exported or the permissions for the ORACLE_HOME/rdbms/mesg directory and files do not allow the user access to the files.

    Also keep in mind 9.2.0.1 is not supported on Suse 8.0 and it has never been tested at Oracle. This not your issue though.

    -Bennett

    rob wrote:

    > 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

    ---------------------------------------------------------------------
    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 - 19:22:38 CEST