LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 08-18-2003, 11:22 PM   #1
cyrilbritto
LQ Newbie
 
Registered: Jul 2003
Posts: 12

Rep: Reputation: 0
SQLPLUS and TNS Listner PROBLEM


Hello,

I successfully installed oracle9i on Redhat Linux8.0 and worked with oracle.When i restart the machine i'm unable to start the database.Then how can i open sqlplus in linux machine.i entered sqlplus command in the terminal.It shows error "Bash:command not found".


Thanks,
Cyril
 
Old 08-18-2003, 11:34 PM   #2
megaspaz
Senior Member
 
Registered: Nov 2002
Location: Silly Con Valley
Distribution: Red Hat 7.3, Red Hat 9.0
Posts: 2,054

Rep: Reputation: 46
Re: SQLPLUS and TNS Listner PROBLEM

Quote:
Originally posted by cyrilbritto
Hello,

I successfully installed oracle9i on Redhat Linux8.0 and worked with oracle.When i restart the machine i'm unable to start the database.Then how can i open sqlplus in linux machine.i entered sqlplus command in the terminal.It shows error "Bash:command not found".


Thanks,
Cyril
well a lot of software when installed don't set the path to the executable which would explain why typing in sqlplus in the command shows that error. provided that sqlplus is the command that starts up oracle, you can try the command:

whereis sqlplus

which will give a directory path to executables. then just use the path listed to start up oracle. if you want to start it up on boot, add that path to /etc/rc.d/rc.local

i don't know how oracle works since i don't use it, but the above is a valid way of starting programs on boot up for red hat.
 
Old 08-19-2003, 02:50 AM   #3
jonas_larson
Member
 
Registered: Jul 2003
Location: Stockholm, Sweden
Distribution: RH9
Posts: 37

Rep: Reputation: 15
Hi Cyril,

In order to run sqlplus (it is located in $ORACLE_HOME) you normally run this as the oracle user...

To be able to connect to the database you need to start the database and the listener... To start the database login to sqlplus and run "startup", to start the listner run "lsnrctl start". (Both as the oracle user)

Good luck

Jonas
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
tnsping : TNS-12541: TNS: no listener hpmface Linux - Networking 4 05-31-2004 12:38 PM
TNS: lost contact jerrymei Linux - Software 0 05-26-2004 03:58 AM
How to run sqlplus? sikandar Linux - Software 5 09-01-2003 12:42 AM
SQLPLUS Help with 5 Questions kb2010 Programming 3 09-03-2002 08:14 AM
Sqlplus mikeshn Programming 1 07-16-2002 10:13 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 01:24 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration