Oracle – RAC cluvfy
cluvfy stage -post crsinst -n nserver-rac1,server-rac2
Oracle – Display Contextual Information in sqlplus session (using sys_context)
Find username, db_name etc. from sqlplus session select sys_context (‘USERENV’, ‘SESSION_USER’) from dual; select sys_context (‘USERENV’, ‘DB_NAME’) from dual;
Oracle 12.2 – Security Change for sqlplus
See article by Mike Dietrich: Security change in Oracle Database 12.2 with login.sql
Linux – sort output of dh -h command
df -h | grep -v ^none | ( read header ; echo “$header” ; sort -rn -k 5)
Oracle – 12cR2
PDB Local Undo Flashback PDB Character Set (CDB must be AL32UTF8)
Oracle – sql – escape characters
select username from dba_users where username like '%\_J' escape '\';
Linux – Install rlwrap from epel (Extra Packages for Enterprise Linux )
What is rlwrap? rlwrap (readline wrapper) is a utility that provides command history and editing of commands for programs such as sqlplus, rman. Red Hat Linux 7 and OEL 7 Execute the commands as…
SQL Server – Decrease size of Out-of-Control Transaction Log File
https://www.brentozar.com/archive/2009/08/backup-log-with-truncate-only-in-sql-server-2008/