Cannot Start sqlplus after installing oracle10g-10.1.0 on fedoracore
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Cannot Start sqlplus after installing oracle10g-10.1.0 on fedoracore

  1. #1
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    27

    Cannot Start sqlplus after installing oracle10g-10.1.0 on fedoracore

    Hi All,
    I tried installing oracle10g-10.1.0 on Fedora Core 2.My installation was successful.But i'm not able to start sqlplus after my installation.I have made the necessary changes in the .bash_profile.Please do find the contents of the file and let me know what i need to do further for me to start both my sqlplus and isqlplus.when i go to the bin directory and execute sqlplus as oracle user i get the following error messages.
    Error 6 initializing SQL*Plus
    Message file sp1.msb not found
    SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory.
    How can i solve this error.Your suggestions are greatly appreciated.The contents of my .bash_profile are as follows.Pls advice on the same.Thanks in advance.
    # .bash_profile

    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
    . ~/.bashrc
    fi

    # User specific environment and startup programs
    umask 022

    PATH=$PATH:$HOME/bin

    unset USERNAME
    export ORACLE_BASE=/u01/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/Db_1
    export ORACLE_SID=orcl
    export PATH=$PATH:$ORACLE_HOME/bin
    export PATH
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib

    #/u01/app/oracle/product/10.1.0/db_1/bin

    #NLS_LANG=american_america.US7ASCII
    #export NLS_LANG

    #ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
    #export ORA_NLS33

    Thanks,
    Rama

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you oracle_home is wrong, its normally db_1 not Db_1

  3. #3
    Join Date
    Dec 2002
    Location
    Singapore
    Posts
    27
    Hi Davey,
    I think it's only Db_1 when i checked the directory stucture for Oracle_home.
    Pls see the cmd below which i have typed pwd.
    /home/oracle/product/10.1.0/Db_1/bin
    Thanks for ur suggestion.pls let me know where i have done the mistake when setting the .bash_profile or any other setting is missed out.Thanks once again.

    Thanks,
    Rama

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width