1

How do you start sqlplus in linux? I know this is a service in windows.

1

Ah, it seems its this easy:

isqlplusctl start'

This requires the environment to be setup properly, which is often done in the login scripts of the oracle user:

 isqlplusctl stop
 ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1
 ORACLE_SID=test
 export ORACLE_HOME ORACLE_SID
 isqlplusctl start
1

If you need console version of sqlplus, then:

1) Install appropriate version of Oracle client downloaded from oracle.com
2) Add this strings to your .bashrc (if shell is bash) in home folder

ORACLE_HOME=/opt/oracle/product/11  #Change this if other
export ORACLE_HOME

TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN

ORACLE_BASE=/opt/oracle
export ORACLE_BASE

LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH


3) Run

$ sqlplus /nolog
SQL> connect sys@DBNAME as sysdba

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.