Link to home
Start Free TrialLog in
Avatar of stavrama
stavramaFlag for Greece

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.
SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Have you set your environment?
Try $ORACLE_HOME/bin/sqlplus
Avatar of stavrama

ASKER

There is no such file or directory...
Can you change to $ORACLE_HOME/bin?
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/product/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/oracle
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.