It is always good practice to lock down password based logins and SSH using keys. We can use pem files to login to remote server from local machines. Infact if you use AWS, the only way to SSH into the server is using pem files. This procedure can be done on any server cloud based … Continue reading Create pem file for SSH access Linux
Now that I have got your attention with my sales pitch. Let me quote a sales pitch we have heard quite often from Exadata Sales rep "Drop the indexes on Exadata ; It is a magical unicorn and it will guarantee performance even without them" Well, 50 years of computer science begs to differ. This … Continue reading Drop those Indexes and see the Magical Unicorn of Exadata do it’s Magic !
Being a DBA requires us many a times to step outside our role and solve a problem in a smart way. One of the issues we faced recently with one of our application, was the application server hanging and not being able to function properly. The application team did not have any means of getting … Continue reading Send SMS using Shell Script, checking Transaction Count of Table in Oracle
-- Create ACFS filesystem on 12c Linux Exadata -- 1. Create a volume in ASM ASMCMD [+] > volcreate -G datac1 -s 500G ACFS_VOL If you get like below error ORA-15032: not all alterations performed ORA-15479: ASM diskgroup does not support volumes ORA-15221: ASM operation requires compatible.asm of 220.127.116.11.0 or higher (DBD ERROR: OCIStmtExecute Check … Continue reading Create ACFS Filesystem Oracle 12c Linux 18.104.22.168
Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym. -- Create a Public Synonym for a Table -- CREATE OR REPLACE PUBLIC SYNONYM EASYNAME for EASYORADBA.TABLE00001 ; -- Drop a Public Synonym for a Table -- DROP PUBLIC SYNONYM EASYNAME ; -- … Continue reading Create or Drop Public Synonyms in Oracle
Oracle Transparent Data Encryption using Oracle Wallet If you wish to use a wallet specifically for TDE, then you must specify a wallet location in the sqlnet.ora file by using the ENCRYPTION_WALLET_LOCATION parameter. Oracle recommends that you use ENCRYPTION_WALLET_LOCATION parameter to specify a wallet location for TDE. ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY … Continue reading Oracle TDE 11g on RAC with Auto Login for the Wallet
Shell Script to generate a column seperator report in SQL*PLUS using a shell script. It can be opened in Excel and or text editor like NOTEPAD++ #!/bin/ksh . $HOME/.bash_profile NOW=$(date +”%a %b %e %T %Y”) HOST=$(hostname) MON2=$(date +”%b%Y”) cd $HOME/scripts rm -rf Report_$MON2.csv sqlplus -s /NOLOG << EOF > /tmp/log.txt CONNECT abc/***** set colsep … Continue reading Generate Excel | CSV Report from SQL*PLUS