Connect to sqlplus with another linux user than oracle

Question

I installed Oracle with sqlplus with user oracle (linux - CentOS). If I try to connect to database being oracle everything goes as expected (sqlplus / as sysdba for example), but I need to do the same thing (maybe not as sysdba, but as a user from database) being another linux user. I added this second user to group "dba", but still nothing. If, being secondUser, I enter "sqlplus username/password" I get this:

ERROR ORA-12547 TNS: lost contact

Can someone (please) guide me? Thank you in advance.

See How to resolve ORA-12547: TNS :lost contact when try to connect to Oracle — Lalit Kumar B
– Lalit Kumar B, Commented Nov 3, 2015 at 11:11

Lalit Kumar B · Accepted Answer · 2015-11-03 11:12:27Z

2

Most likely it is due to incorrect privileges at OS level. The Oracle file in the $ORACLE_HOME/bin directory should have following privileges:

-rwsr-s--x

You could check it like:

cd $ORACLE_HOME/bin
ls -lrt oracle

If you see any difference, then do:

chmod 6751 oracle
ls -lrt oracle

For more details, see How to resolve ORA-12547: TNS :lost contact when try to connect to Oracle

edited Nov 3, 2015 at 11:12

answered Jun 8, 2015 at 10:42

Lalit Kumar B

49.5k13 gold badges104 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to sqlplus with another linux user than oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related