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* […]
Category: Unix
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 […]
SQL Informations
The Oracle database administrator knows the pid of an Oracle resource-intensive process. Now we want to gather some informations on the SQL Statement (SQL_ID, username, program, terminal…) before running an explain plan. SELECT ‘USERNAME : ‘ || s.username || CHR (10) || ‘SCHEMA : ‘ || s.schemaname || CHR (10) || ‘OSUSER : ‘ || […]