Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

To enable sqlplus for a user in unix

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users To enable sqlplus for a user in unix
# 1  
Old 02-19-2009
To enable sqlplus for a user in unix
Hi

I added a new user using root... now i need to enable sqlplus for that particular user... when i give sqlplus schemaname/pwd it gives

Code:
 
$ sqlplus
-bash: sqlplus: command not found

PFB the OS am using

Code:
$ uname -a
Linux gs-portal-04 2.4.21-57.ELsmp #1 SMP Wed Apr 23 01:38:02 EDT 2008 i686 i686 i386 GNU/Linux

# 2  
Old 02-19-2009
You have to add the path to sqlplus (in the $ORACLE_HOME directory tree) to the user's PATH variable. edit either the /etc/profile file or the user's .bashrc or .profile
# 3  
Old 02-19-2009
Whiteboard,


After setting up the $ORACLE_HOME as Jim advise, you also need to verify if he has access to the sqlplus binaries. Setting up the $ORACLE_HOME and the permission to excute sqlplus will do.

Cheers!
# 4  
Old 02-20-2009
Quote:
Originally Posted by csorhand
Whiteboard,


After setting up the $ORACLE_HOME as Jim advise, you also need to verify if he has access to the sqlplus binaries. Setting up the $ORACLE_HOME and the permission to excute sqlplus will do.

Cheers!
How to give permission to execute sqlplus??? can you shed some light on this????

TIA
# 5  
Old 02-20-2009
sqlplus is executable by all....
You should add in is .profile:
Code:
PATH=$PATH$ORACLE_HOME/bin
export PATH

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Red Hat

Runtime Error Enable user directory apache

Hi I am exactly according to this link CentOS 6 - Apache httpd - Enable Userdir : Server World I Enabled userDirectory Server version: Apache/2.2.15 CentOS release 6.8 (Final) But Iget this Error Forbidden You don't have permission to access /~mn/index.html on this server Goal... (2 Replies)
Discussion started by: mnnn
2 Replies

2. Solaris

Enable FTP for root user in Solaris 10

I am not able to get ftp working for Solaris 10 for root user. I am getting login failed error. 331 Password required for root. Password: 530 Login incorrect. Login failed. Tried following things already. 1. SFTP works ok, still would like to know why FTP is not working (curious). 2.... (5 Replies)
Discussion started by: webkid
5 Replies

3. Ubuntu

How to enable guest user in ubuntu 10.04

Hi, do you know how to enable guest user in ubuntu lucid 10.04 ? Regards (1 Reply)
Discussion started by: dagigg
1 Replies

4. UNIX for Dummies Questions & Answers

Enable hpet support in unix

Hi, I am new to this forum. I have a machine, the BIOS doesn't offer a choice to enable/disable HPET, I know in Linux, the hpet.c file can be modified to turn on and off the hpet, I am looking for a way to do this in UNIX as well. Is there already code existed for the modification? If not can... (0 Replies)
Discussion started by: KAKAMOMO
0 Replies

5. UNIX for Dummies Questions & Answers

Enable user quota

hi! i would like to enable user quota on my system (FreeBSD 6.2) i've check on enabling user quota here but i still confuse with fstab it shows there: /dev/da1s2g /home ufs rw,userquota 1 2 but my current /etc/fstab : # Device Mountpoint FStype Options ... (1 Reply)
Discussion started by: rdns
1 Replies

6. UNIX for Dummies Questions & Answers

regular user - enable printer - aix unix

how can I let a regular user enable a printer? (0 Replies)
Discussion started by: naes
0 Replies

7. Linux

How to Enable TELNET for root user

How to Enable TELNET for root user in Linux. (3 Replies)
Discussion started by: sakthi_13
3 Replies

8. UNIX for Dummies Questions & Answers

enable a user via remsh

hi guys, has anybody a solution to enable a user via remsh (in a script)? i know only this: remsh $i /usr/bin/passwd -r files -d USERNAME but on this option the user must enter a new passwd. is it possible to set the passwd in the string or in a file and set a parameter into the... (1 Reply)
Discussion started by: scottl
1 Replies

9. UNIX for Dummies Questions & Answers

How to enable ifconfig to unprivileged user?

Hello, everyone. I have installed Red Hat 9.0 and Mandrake 9.1 on my computer. I could use a unprivileged user account to run "ifconfig" directly. But when I was using Red Hat, either root or other accounts could run "ifconfig" --- the error messege said: "bash: ifconfig: command not found". I... (5 Replies)
Discussion started by: HOUSCOUS
5 Replies
Login or Register to Ask a Question