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

Re: sudo sqlplus -v returns "Error 6 initializing SQL*Plus" [message #665855 is a reply to message #665851]

Tue, 26 September 2017 07:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I know what the problem is.
I am just not sure what needs to be done to correct it.

For debugging purposes change the sudo line to be as below

sudo -u oracle env > /tmp/capture.env

then post content of /tmp/capture.env back here

Report message to a moderator

Re: sudo sqlplus -v returns "Error 6 initializing SQL*Plus" [message #665856 is a reply to message #665851]

Tue, 26 September 2017 07:06

John Watson
Messages: 8880
Registered: January 2010
Location: Global Village

Senior Member

This works for me, but it may be very shell specific:

[ec2-user@ip-172-30-0-72 ~]$
[ec2-user@ip-172-30-0-72 ~]$ sudo -u oracle -- sh -c 'export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1;/u01/app/oracle/product/12.2.0/dbhome_1/bin/sqlplus -v'

SQL*Plus: Release 12.2.0.1.0 Production

[ec2-user@ip-172-30-0-72 ~]$

Report message to a moderator

Re: sudo sqlplus -v returns "Error 6 initializing SQL*Plus" [message #665857 is a reply to message #665856]

Tue, 26 September 2017 07:23

snuggiebear
Messages: 2
Registered: September 2017

Junior Member

John Watson wrote on Tue, 26 September 2017 07:06

This works for me, but it may be very shell specific:

[ec2-user@ip-172-30-0-72 ~]$
[ec2-user@ip-172-30-0-72 ~]$ sudo -u oracle -- sh -c 'export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1;/u01/app/oracle/product/12.2.0/dbhome_1/bin/sqlplus -v'

SQL*Plus: Release 12.2.0.1.0 Production

[ec2-user@ip-172-30-0-72 ~]$

Thanks John. I can get this working with the following in sudoers:

user1 ALL=(oracle) NOPASSWD: ALL

Would you know the discrete sudoers definition to run just the required command ? Appreciate this is diverging from Oracle itself.

Report message to a moderator

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: Sun Oct 01 17:11:44 CDT 2023