Oracle PL/SQL HTTP File Upload With Post Request

More and more services these days are following a cloud-based hosting model. A cloud-hosted application is one where you pay a subscription fee and the vendor hosts the product for you. This way you don’t have to worry about buying/managing your own servers or paying IT staff to take care of them. This makes integrations more difficult in a sense. You can no longer simply connect in to the database. Instead, vendors usually provide you with API endpoints to use where you can send normal HTTP GET or POST requests.

Oracle Data Guard “Physical Standby Database (Disabled)”

This past week, I was working on a task nobody anywhere ever wants to do: routinely changing passwords. It’s easy enough to do. In Toad for Oracle, right-click the user, Alter, paste new password. That works well until you realize you forgot everywhere you used and need to update that password. In our case, I neglected to stop Data Guard prior to changing the passwords, which caused our production server to be marked as “disabled”.