How to connect oracle from unix


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to connect oracle from unix
# 1  
Old 03-24-2008
Question How to connect oracle from unix

Hi All,

I am trying to connect oracle from unix mechine but i am getting an error like

Ksh: sqlplus: not found

Any one please tell me how to connect oracle from unix mechine.
I would appreciate if any one send the query.

Regards,
Ravi kumar.Gongati
# 2  
Old 03-24-2008
$ . oraenv
ORACLE_SID = [oracle] ? demo1
$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 24 18:03:58 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name:

hope this help Smilie
# 3  
Old 03-24-2008
The sqlplus executable isn't in your PATH specification. Make sure that in your environment the following variables are correctly set:

Code:
ORACLE_HOME
ORACLE_SID
PATH (must include $ORACLE_HOME/bin)

Then you can connect with sqlplus.

Sourcing the oraenv like invinzin21 said could be a starting point, but I think that oraenv doesn't set the PATH variable for you.

Otherwise, you must provide the full path to the sqlplus executable:

Code:
$ORACLE_HOME/bin/sqlplus user/pass

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

2. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

3. Shell Programming and Scripting

Switching user to oracle to connect Oracle 11g DB with 'sysdba'

I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'. I've tried the following with no success. su - oracle -c "<< EOF1 sqlplus -s "/ as sysdba" << EOF2 whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies

4. UNIX for Dummies Questions & Answers

Not able to connect Oracle

In unix i login as root but when i am conneting to SQL as sqlplus "/ as sysdba" then its telling "sh: sqlplus: not found".. (6 Replies)
Discussion started by: ripudaman.singh
6 Replies

5. Shell Programming and Scripting

Unix - Oracle DB Connect

Hello, Returing to Unix scripts after a long while, This might be a simple question for most of you , I need to connect from a .sh script to oracle, select XYZ.nextval from dual , , meaning either get the Current Val or Next Val for a sequence. How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies

6. Shell Programming and Scripting

How to connect with oracle database using unix...

Hi all I am working in datawarehouse project and use DB2 database . shell scripting is written to connect with DB2 database in my application but i dont know how to connect with oracle databse or other databases.Is there any command in unix to connect any of these datbases? (6 Replies)
Discussion started by: vijays3
6 Replies

7. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

I want to use Perl to connect to a remote Oracle DB I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server. Is this possible? I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies

8. Shell Programming and Scripting

How to COnnect to Oracle database from UNIX Box

I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message. $ sqlplus sqlplus: not found I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Discussion started by: angelarosh
12 Replies

9. Shell Programming and Scripting

By default connect to the oracle at the time login to Unix

Hi, How to set or what I have to do, so that at the time of login into unix, it will connect by default to Oracle server. Thanks Rajesh (3 Replies)
Discussion started by: rajesh08
3 Replies

10. Shell Programming and Scripting

How to connect to oracle ??

Hi, I am a new user, who wants to connect to oracle through shell scripting. Can anybody help me? Regards, Divyesh (2 Replies)
Discussion started by: divyesh shah
2 Replies
Login or Register to Ask a Question