stavrama
asked on
Cant connect to sqlplus on oracle 10g2
Hello,
I have installed oracle 10g2 on Linux Red Hat enterprise 5 but when i try to get to sqlplus i get the following error:
bash: sqlplus: command not found
It looks as if sqlplus aint installed but i did a custom installation and i chose it from the list. For any further info concerning the installation ask me and i ll post it.
Thanx in advance for your help.
I have installed oracle 10g2 on Linux Red Hat enterprise 5 but when i try to get to sqlplus i get the following error:
bash: sqlplus: command not found
It looks as if sqlplus aint installed but i did a custom installation and i chose it from the list. For any further info concerning the installation ask me and i ll post it.
Thanx in advance for your help.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
There is no such file or directory...
Can you change to $ORACLE_HOME/bin?
ASKER
Sorry but i dont understand what you are asking. Under the bin folder i dont have any orcale_home folder. The only sqlplus folder i have is on the directory in which orcale10g2 was installed. The directory is the following:
u01/app/oracle/oracle/prod uct/10.2.0 /db_1
Furthermore i have followed the instructions from meta link about the things i need to do before the installation of 10g2 and one of those, was to set in the home/oracle/.bash.profile the follwoing lines:
export ORACLE_BASE=/u01/app/oracl e
export ORACLE_SID=orcl
unset ORACLE_HOME
Do i need to delete the last line and add there the oracle_home directory? If yes what this will be? The place where sqlplus folder is?
u01/app/oracle/oracle/prod
Furthermore i have followed the instructions from meta link about the things i need to do before the installation of 10g2 and one of those, was to set in the home/oracle/.bash.profile the follwoing lines:
export ORACLE_BASE=/u01/app/oracl
export ORACLE_SID=orcl
unset ORACLE_HOME
Do i need to delete the last line and add there the oracle_home directory? If yes what this will be? The place where sqlplus folder is?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The first line should read as:
You should not unset your ORACLE_HOME in bash.profile
And as instructed in the first post from angelIII:you should include $ORACLE_HOME/bin in your PATH, to have the executable sqlplus in your bin path.
You should not unset your ORACLE_HOME in bash.profile
And as instructed in the first post from angelIII:you should include $ORACLE_HOME/bin in your PATH, to have the executable sqlplus in your bin path.
Try $ORACLE_HOME/bin/sqlplus