SQL*Plus (MOSC)

MOSC Banner

How do i permit non-oracle Unix accounts to run sqlplus and tnsping

in SQL*Plus (MOSC) 2 commentsAnswered ✓

I have on a Unix server and oracle client 12.1.0.2 version installation done under oracle account. On this same server, i have another Unix account called weblogic. I need to have weblogic have the ability to run sqlplus or even tnsping while logged in as weblogic.

I have included in weblogic .bash_profile account the $ORACLE_HOME/bin as well as $ORACLE_HOME/bin/sqlplus, and when i attempted to run it, i got the following error message

-bash: /u01/app/oracle/product/12.1.0/client_1/bin/sqlplus: Permission denied

I checked the permission level of sqlplus under oracle account, and below is the permission

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center