OraFAQ Forum: Linux » sudo sqlplus -v returns "Error 6 initializing SQL*Plus"

Home » Infrastructure » Linux » sudo sqlplus -v returns "Error 6 initializing SQL*Plus" (oracle 11g on centos 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sudo sqlplus -v returns "Error 6 initializing SQL*Plus" [message #665851]

Tue, 26 September 2017 05:15

snuggiebear
Messages: 2
Registered: September 2017

Junior Member

I am needing to run sqlplus -v on Linux where the user I am connecting with does not have execute permission on sqlplus.

I can however set what I need up my users profile as well as sudoers.

I have set in sudoers:

user1 ALL=(oracle) NOPASSWD: /u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus

I then login with user1 and execute:

export ORACLE_SID=wujjii
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_BASE=/u01/app/oracle
export PATH=$PATH:$ORACLE_HOME/bin

And finally:

sudo -u oracle /u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus -v

This does not prompt for password however returns:

Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

I know this is an age old topic but I think I have covered the basics here so any help appreciated.

Report message to a moderator

[Message index]

		sudo sqlplus -v returns "Error 6 initializing SQL*Plus" By: snuggiebear on Tue, 26 September 2017 05:15
		Re: sudo sqlplus -v returns "Error 6 initializing SQL*Plus" By: BlackSwan on Tue, 26 September 2017 07:02
		Re: sudo sqlplus -v returns "Error 6 initializing SQL*Plus" By: John Watson on Tue, 26 September 2017 07:06
		Re: sudo sqlplus -v returns "Error 6 initializing SQL*Plus" By: snuggiebear on Tue, 26 September 2017 07:23

Previous Topic:	df command insert into sqlplus and table databas
Next Topic:	Oracle Client on Virtual System

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 19:55:31 CDT 2024