Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·Nov 7, 2024Resolving ORA-12506: TNS:listener rejected connection based on service ACL filteringI encountered this error when I moved the ADB to a Private End Point and tried to connect to it on a Compute Instance which was on a VCN that had access to the ADB. Weird huh? If its contactable and on a Private End Point then why is it being blocked...100 readsorclapex
Ulf Hellströmdbengineer.hashnode.dev·Aug 28, 2023Secure your Oracle accounts using a wallet.Do you have Oracle schemas that are frequently shared among multiple users or contain sensitive information in your database, and want to prevent passwords for these schemas from being distributed among your developers and end users? Do you utilize s...49 readsOracle
Boyd Timmermanbtimmerman.hashnode.dev·Dec 7, 2022Finding hidden characters in SQL filesOracle DBAs love to use SQL*Plus when installing database objects. As a developer, I make SQL install scripts. Which then are executed by these DBAs. These scripts contain references to other files with the actual SQL statements. Below is an example ...2.6K readssqlplus