OraFAQ Forum: Server Administration » Cannot start sqlplus

Home » RDBMS Server » Server Administration » Cannot start sqlplus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot start sqlplus [message #377719]

Wed, 24 December 2008 10:45

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?

Report message to a moderator

Re: Cannot start sqlplus [message #377721 is a reply to message #377719]

Wed, 24 December 2008 10:53

Mimas
Messages: 40
Registered: September 2008
Location: Athens

Member

Also I cannot find the .profile under $HOME.

Report message to a moderator

Re: Cannot start sqlplus [message #377722 is a reply to message #377719]

Wed, 24 December 2008 11:08

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!!!

Report message to a moderator

Re: Cannot start sqlplus [message #377730 is a reply to message #377719]

Wed, 24 December 2008 12:18

joy_division
Messages: 4963
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

Report message to a moderator

Re: Cannot start sqlplus [message #377731 is a reply to message #377719]

Wed, 24 December 2008 12:25

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

Report message to a moderator

Re: Cannot start sqlplus [message #377732 is a reply to message #377731]

Wed, 24 December 2008 12:28

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Cannot start sqlplus [message #377733 is a reply to message #377731]

Wed, 24 December 2008 12:29

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Cannot start sqlplus [message #377735 is a reply to message #377719]

Wed, 24 December 2008 12:37

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.

Report message to a moderator

Previous Topic:	undo tablespace
Next Topic:	background process "QMNC" did not start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:37:01 CST 2024