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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT HPUX
rpccp_remove_profile
remove profile(1m) remove profile(1m)
NAME
remove profile - Removes all profile elements and the profile from the specified name service entry
SYNOPSIS
rpccp remove profile profile-entry-name [-s syntax]
OPTIONS
Indicates the name syntax of the entry name (optional). The only value for this option is the dce name syntax, which is the default name
syntax. Until an alternative name syntax becomes available, specifying the -s option is unnecessary.
ARGUMENTS
Indicates the name of the target profile. For an entry in the local cell, you can omit the cell name and specify only the cell-relative
name.
DESCRIPTION
The remove profile command removes a profile (and all of its elements) from the name service database. The entry name of the profile is
required.
Privilege Required
You need write permission to the CDS object entry (the target profile entry).
NOTE
This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.
EXAMPLES
The following commands run RPCCP and remove the profile named /.:/LandS/anthro/molly_o_profile: $ rpccp rpccp> remove profile
/.:/LandS/anthro/molly_o_profile
RELATED INFORMATION
Commands: add element(1m), remove element(1m), show profile(1m)
remove profile(1m)