ORA-12546: TNS:permission denied after restarting the system
- Oracle Linux 7
- Oracle XE 18c
- 2 vhosts Everything is local, so this should be simple.
Yesterday I finished setting up the vhosts, which need to connect to the database. I had to install php-oci8 (and some other missig php packages). After that, everything worked fine, and I even saved some data on the DB.
Then I shut down the system - not for the first time since I installed all the oracle DB stuff, but for the first time since I installed php-oci8. This morning I wanted to continue testing what's on the vhosts and I get the ORA-12546: TNS:permission denied error. I googled for a solution, followed some examples on how to change the permission, but to no avail.
I'm a QA person, not a developer or system administrator, so please keep answers simple for me. Also, tell me what else you need to know and I will provide the info.
Writing this question I got an idea, and further investigation showed that this is indeed a oci problem. The required PHP version can't be started correctly, and that's why my pages can't connect to the DB, whereas sqlplus, sqldeveloper etc have no problem.
I had to "downgrade" the version of InstantClient (to 18.3) in order to work with Oracle 18c, and apparently that's when something got mixed up as I still have this: