Sponsored Content
Top Forums Shell Programming and Scripting Edit .profile to connect to Oracle- Linux 2.6.9-89 Post 302402983 by dips_ag on Thursday 11th of March 2010 04:14:12 AM
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?
 

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. 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
MHPARAM(1)							     [nmh-1.5]								MHPARAM(1)

NAME
mhparam - print nmh profile and context components SYNOPSIS
mhparam [components] [-all] [-component | -nocomponent] [-version] [-help] DESCRIPTION
mhparam writes the value of the specified profile component to the standard output separated by newlines. If the profile component is not present, the default value (or nothing if there is no default) is printed. If the switch -component is given, then the component name is displayed along with the profile components value. This can be disabled with the switch -nocomponent. If more than one component is specified in the components list, then the switch -component is on by default. If only one component is specified, then the switch -nocomponent is on by default. If -all is specified, then all components in the nmh profile are displayed and other arguments are ignored. Examples: % mhparam path Mail % mhparam mhlproc /usr/lib/mh/mhl % mhparam -component Path Path: Mail % mhparam AliasFile rmmproc AliasFile: aliases rmmproc: rmmproc % mhparam -nocomponent AliasFile rmmproc aliases rmmproc % mhparam path nonexistent context Path: Mail context: context mhparam is also useful in back-quoted operations: % fgrep cornell.edu `mhpath +`/`mhparam aliasfile` EXIT STATUS
mhparam returns the number of components that were not found. FILES
$HOME/.mh_profile The user profile or $MH Rather than the standard profile <mh-dir>/context The user context or $MHCONTEXT Rather than the standard context PROFILE COMPONENTS
context: To determine the context file SEE ALSO
mh-profile(5) DEFAULTS
`-nocomponent' if only one component is specified `-component' if more than one component is specified `components' defaults to none CONTEXT
None MH.6.8 11 June 2012 MHPARAM(1)
All times are GMT -4. The time now is 06:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy