LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-29-2010, 12:06 AM   #1
sushil_sk
LQ Newbie
 
Registered: Jul 2008
Posts: 11

Rep: Reputation: 0
sqlplus connection help is required


Hi Friends I am newbie to Linux . I am working as oracle DBA on 10g . Till last day I had worked on windows platform. Now my company want me to work on Linux platform . I am first time using Linux dont know A,B,C of Linux . I want to connect sqlplus through linux command prompt. I have exported enviornment variable of oracle but I am getting permission denied Below mention steps I ahd followed . Please help me to solve it

[oracle@bhel1 mj]$ ORACLE_SID=V7;export ORACLE_SID
[oracle@bhel1 mj]$ ORACLE_HOME=/usr/lib/oracle/v7/app/oracle/prod
ver;export ORACLE_HOME
[oracle@bhel1 mj]$ PATH=$ORACLE_HOME/bin:$PATH;export PATH
[oracle@bhel1 mj]$ NLS_LANG=AMERICAN_AMERICA.AL32UTF8;export NLS_
[oracle@bhel1 mj]$ LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_P
LIBRARY_PATH
[oracle@bhel1 mj]$ sqlplus/nolog
bash: sqlplus/nolog: Permission denied
[oracle@bhel1 mj]$
 
Old 11-29-2010, 12:17 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,355

Rep: Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751
Try

which sqlplus

to find the sqlplus binary and it's ownerships/permissions. It looks like you don't have the right access perms, could also be its not in your cmd path. Try

echo $PATH

to check.
Also, for Linux generally, here's a great tutorial http://rute.2038bug.com/index.html.gz.

To examine the ownership & perms in Linux

ls -l filename

(that's a lowercase L btw)
 
  


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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
sqlplus problem kshkid Programming 8 05-09-2007 07:20 PM
remote sqlplus connection to an oracle server saavik Linux - Networking 0 01-20-2006 03:16 AM
Strange Connection refused error. Maybe kernel guru required? shy Programming 3 10-27-2004 11:35 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 - Newbie

All times are GMT -5. The time now is 09:36 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