Home » RDBMS Server » Server Administration » Cannot start sqlplus
Cannot start sqlplus [message #377719] Wed, 24 December 2008 10:45 Go to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Hello,

People I am facing probably a stupid error but I am stack and do not know what to do.

I have installed 10g on RHEL4 and everything seemed to go fine BUT when I give from command prompt
sqlplus " / as sysdba" I receive command not found.

When I give echo $ORACLE_HOME I receive
/home/oracle/oracle/product/10.2.0/db_1/
I added using the export command.

I can access iSQL*Plus and EOM through Web.

I try to run the ./sqlplus under /bin but I cannot find anything.

Could someone please help me?
Re: Cannot start sqlplus [message #377721 is a reply to message #377719] Wed, 24 December 2008 10:53 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Also I cannot find the .profile under $HOME.
Re: Cannot start sqlplus [message #377722 is a reply to message #377719] Wed, 24 December 2008 11:08 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
Please note that when I run the ./root script I gave for local bin directory the /usr/local/bin
Did I have to give the /home/oracle/oracle/product/10.2.0/db_1 ?

[root@localhost db_1]# ./root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /home/oracle/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:


I do not know what else to do!!!
Re: Cannot start sqlplus [message #377730 is a reply to message #377719] Wed, 24 December 2008 12:18 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Mimas wrote on Wed, 24 December 2008 11:45

I try to run the ./sqlplus under /bin but I cannot find anything.



$ORACLE_HOME/bin or /bin ???
sqlplus will be in $ORACLE_HOME/bin
You must create your own .profile with all the environment variables, including PATH
Re: Cannot start sqlplus [message #377731 is a reply to message #377719] Wed, 24 December 2008 12:25 Go to previous messageGo to next message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
I tried to run it under $ORACLE_HOME/bin but nothing was there.

My .bash_profile is this:

[oracle@localhost ~]$ more /home/oracle/.bash_profile
# .bash_profile

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

# User specific environment and startup programs
ORACLE_BASE=/home/pracle
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1/
ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin

export PATH


Still nothing!!!
Please help
Re: Cannot start sqlplus [message #377732 is a reply to message #377731] Wed, 24 December 2008 12:28 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
if sqlplus is not in $ORACLE_HOME/bin then the installation was not successful or you did some non standard installation.
Re: Cannot start sqlplus [message #377733 is a reply to message #377731] Wed, 24 December 2008 12:29 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Your ORACLE_BASE is pointing to pracle. You may need to reinstall Oracle into the correct directories.
Re: Cannot start sqlplus [message #377735 is a reply to message #377719] Wed, 24 December 2008 12:37 Go to previous message
Mimas
Messages: 40
Registered: September 2008
Location: Athens
Member
There is an sqlplus undewr $ORACLE_HOME/bin but when I try to give ./sqlplus nothing happens.

Anyway I made the ./bash_profile again and it worked fine.

Thanks for your help.
Previous Topic: undo tablespace
Next Topic: background process "QMNC" did not start
Goto Forum:
  


Current Time: Sat Dec 03 12:03:13 CST 2016

Total time taken to generate the page: 0.23658 seconds