Running SQL scripts against several Pluggable Databases with SQL*Plus is tedious, because the DBA have to login into every Pluggable Database and run the required script or SQL Statement . In this article, I’ll show you how to run SQL Statements easily across all Pluggable Databases. In a container database (CDB) Environment, the Oracle catcon.pl […]
Catégorie : Unix
Find and replace a string in several text files
Maybe you are looking for a particular phrase in log files or maybe you are a programmer and need to find some string that is inside many different code files? Here is how you can find and replace a string in several text files. For this example, the Oracle DBA wants to replace strings NSR* […]
Lock, expire and delete Linux account
Sometimes the Oracle DBA has to I delete a Unix user account under Linux operating systems including the home directory. How do I expire, delete or remove a user’s access from my server? Deleting user account in Linux is an administrative task to remove user login credentials from system configuration files such as /etc/passwd, /etc/shadow […]
Unable to create audit trail file or Read-only file system
This morning, the Cloud Control and other applications are down. Hard for the customer :( but as an Oracle DBA I love problems in production so it’s a great day today! First, I tried to edit a file with vi but a swap error raised: « E297: Write error in swap file« Another read-only error with […]
ZFS snapshots (Overview)
A snapshot is a read-only copy of a file system or volume. Snapshots can be created almost instantly, and they initially consume no additional disk space within the pool. It’s important for the Oracle DBA in Montreal to have a list of these commands. How can I create a new ZFS snapshot? $sudo zfs snapshot […]