SQLPLUS not accessible [message #244662] |
Wed, 13 June 2007 12:30 |
yoonus.it@gmail.com
Messages: 109 Registered: June 2007 Location: kuwait
|
Senior Member |
|
|
Hi Dears,
I have been working with Oracle in windows for a long time but in i dont have much idea. No i have installed oracle on Red Hat Linux ES 4. After installation i gave the option not to start oracle at boot up.
Now when i use sqlplus in terminal it says bad command.What i have to do to start oracle services if this is the problem..Can any one help me to start with my oracle journey in Linux..
Thankz inadvance..
unus
|
|
|
Re: SQLPLUS not accessible [message #244674 is a reply to message #244662] |
Wed, 13 June 2007 13:37 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
You have to log onto linux as the oracle user or a dba privileged account to startup the database. But that is not what your problem is. You have to set many environment variables to be able to start sqlplus, such as ORACLE_HOME, ORACLE_BASE, LD_LIBRARY_PATH, PATH, ORACLE_SID (not all required, but best to have all of them).
The linux installation guide will have all of that information.
|
|
|
Re: SQLPLUS not accessible [message #244675 is a reply to message #244662] |
Wed, 13 June 2007 13:38 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
before that su to user you made for running oracle then import ORACLE_SID like
export ORACLE_SID=mydb =====> if you working in bash
if you working in Korn shell then
$ . .profile_mydb
|
|
|