Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Edit .profile to connect to Oracle- Linux 2.6.9-89

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Edit .profile to connect to Oracle- Linux 2.6.9-89
# 1  
Old 03-11-2010
Edit .profile to connect to Oracle- Linux 2.6.9-89
Hi,

I want to connect to sqlplus through unix. I got the command to do it. But I was getting error:
./executeSQL.ksh[20]: sqlplus: not found

Then when I googled I found that we have to include Oracle Client path in .profile file. I don't know how to do it. Also I don't have permissions to edit /etc/profile file. And there are plenty of profile files available with the below names.

profile
zprofile
profile.d
profile.rpmnew
profile.20090213

And on none I have permissions. I also have tnsnames.ora under the same path (/etc) but that too is read-only.

Can you give me the steps to be done which I can send to LINUX ADMIN team of my project?
# 2  
Old 03-11-2010
first checkyour path

echo $PATH

If the clinet path is not there in PATH ,
Then add oracle client path in the .profile file in your home directory.

PATH=$PATH:/xx/yyy/oracle/bin
Last edited by amitranjansahu; 03-11-2010 at 05:24 AM.. Reason: typo
# 3  
Old 03-12-2010
Edit .profile to connect to Oracle- Linux 2.6.9-89
The Oracle client resides in C:\Oracle\Oracle10\BIN. Can I give this path in my .profile file Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Edit profile

Hello, just want to know how can i edit profile to show " user@hostname" when i login to aix ? now when i login it show " hostname:/dir#" i want to show as " username@hostname:#" :) Thanks. CP (1 Reply)
Discussion started by: tcp01315
1 Replies

2. 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

3. Cybersecurity

When i start CSF i cant connect VPS or download any data into it It appears i cant connect Linux VP?

It appears i cant connect linux VPS server via SSH or i cant SCP any file to it and i cant wget any file TO it (from inside it) while CSF (Config Server Firewall, LFD is running. Just after isntall in default configuration and after changing TESTING mode to LIVE mode. Trying to wget & install... (1 Reply)
Discussion started by: postcd
1 Replies

4. Red Hat

Connect Direct - XSMG242I -Create user profile - sdsc_create failed

HI, I have two Linux servers on which IBM Sterling ConnectDirect is installed. I want to transfer a file from server(abc20) to abc19. I have edited userfile.cfg & netmap.cfg on both the server still file transfer is not happening. Also the file is getting transferred from abc20 to abc20 itself... (5 Replies)
Discussion started by: ABM_CD
5 Replies

5. 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

6. Emergency UNIX and Linux Support

Unable to connect to oracle in red hat linux

Hi Gurus, I have installed the oracle xpress 10g edition in my red hat linux and saw the message that it has been installed successfully ,but after that I started the database by going through application->database->start database and after that i open the sql prumt but when i tried to connect... (18 Replies)
Discussion started by: sanjay.login
18 Replies

7. Shell Programming and Scripting

Connect to Oracle in Windows XP from Linux HOST

Hi everyone, I have oracle 9i installed in Windows XP and i have ubuntu in VM WARE. I would like to know how to connect to Oracle in windows xp from Linux through shel scripting...... (3 Replies)
Discussion started by: Zimbu
3 Replies

8. Solaris

Oracle Profile

So my oracle DBA emails me a profile.txt and tells me I need to install it for my oracle user account. what do I do with it? (4 Replies)
Discussion started by: Kjons76
4 Replies

9. 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

10. UNIX Desktop Questions & Answers

Edit .profile

I just started to use Solaris and am looking to see if anyone has any good documents for begginers on using Solaris, specifically, how to edit .profile. I know this question may be a little vague... I have done numerous searches on google with no results! Thanks for your time. Dasnutz (1 Reply)
Discussion started by: dasnutz
1 Replies
Login or Register to Ask a Question