ora_setup failed with "ORA-12546: TNS:permission denied" (4296524)

When running ora_setup, you encounter the following error:

validating user name and password. . . This may take a few seconds.
Error! Unable to login using the user name and password just entered.
ORA-12546: TNS:permission denied

Could be any one of a number of issues ranging from permission on Oracle binary to the way sql*net is configured.

You can check for the following and resolve the issue if any:

1. The oratab file has SID set correctly.

2. Verify the permissions on $ORACLE_HOME/bin/oracle is set to (-rwsr-s--x 1 oracle dba)

ls -l $ORACLE_HOME/bin/oracle

3. The user that launches Shareplex should be a part of spadmin group

If the above do not apply, re-run the ora_setup using tns alias (sql*net) as follows:

Run ora_setup using tns alias after splex_passwd and see if this helps. So instead of supplying the password when prompted for one during the running of ora_setup, you can supply <password>@<connect string>

The downside to this would be that you will need to ensure that the listener is up at all times if you want Shareplex to connect to the database since Shareplex will now connect to the database through sql*net and would not use Bequeath.