-
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
-
you oracle_home is wrong, its normally db_1 not Db_1
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|