Showing posts with label Shell scripting. Show all posts
Showing posts with label Shell scripting. Show all posts
Monday, April 22, 2024

grep for all database names in /etc/oratab

›
The file /etc/oratab contains: # mydb01:/orainst/product/19c:Y cdb:/orainst/product/19c:N To extract the database names: grep "^[^#]...
Thursday, April 18, 2024

Solution to script warning: here-document at line < num > delimited by end-of-file (wanted `!')

›
In a script, I had formatted my code as follows: for l in $(cat file.txt|grep 'Status'| awk -F' ' '{print $2}')...
Wednesday, April 17, 2024

A scriptlet that will look for a file and when found, start displaying it using tail

›
A short script that will look for the existence of a file, and when found, start tailing it to std out: while true; do if [ -f /u01/crea...
Friday, April 12, 2024

How to process a variable consisting of values separated by blank spaces using a for-loop construct in shell scripting

›
If you have a variable with to or more values, separated by space, it's very simple to loop through them and process them individually...
Tuesday, April 9, 2024

How to extract the the first of two identical sentences in a log file using awk

›
I have a log file which repeats the same message twice. I would like to save this message in a variable to use later in the script. The f...

How to trim away all extra output from a result using sqlplus

›
The following code can be put in a shell script and executed by root. Note the sqlplus directives which will remove all unwanted output fr...
Friday, February 9, 2024

Script snipplet to test for subdirectories

›
echo "Test: are there subdirectories in /orainst/oracle/cfgtoollogs/dbca/cdb ?" ls $(pwd)/*/ > /dev/null 2>&1 if [ $?...
Thursday, February 8, 2024

Script snipplet to scan the dbca logs for errors

›
Here is a way to scan the logs in the directory where dbca creates its logfiles, by default under your $ORACLE_BASE/cfgtoollogs/dbca/$ORACL...

Script to check for the number of control files in a database and create minimum two if only one is found

›
A script that checks for the number of controlfiles and creates two new ones if only one is found. # 080224: Created # Check if there i...
Friday, December 8, 2023

Script sniplet to differentiate between cdb and pdb environment settings in a shell script

›
This little sniplet could be used if you find yourself in a situation where you need to differentiate between the cdb environment and the p...
Friday, August 25, 2023

How to exchange a line in a text file with a different one, when using double quotation marks in the text itself?

›
The following sed command will exchange the string initParams= with initParams=undo_tablespace=UNDOTBS1,sga_target=9GB,db_block_size=327...
Saturday, February 18, 2023

How to prevent sed to destroy your symlinks

›
Because of EBS, we have a subdirectory in our $TNS_ADMIN which has the following name PDB1_test1.oric.no In other words, the files listen...
Tuesday, February 14, 2023

Error fetching the value from a shell script executed by root, when doing "su - oracle"

›
Problem: Inside a new bash shell session, executed as user "oracle", like this: su - oracle <<! instructions here ! I ...
Friday, January 6, 2023

How to solve script error $'\r': command not found syntax error: unexpected end of file

›
when trying to execute a script from root, like the following: su - oracle -c "/tmp/set_params.sh" You may see errors like the...
Wednesday, November 16, 2022

How to log entire output from a shell script

›
I have recently used exec to send all output from a bash script to a designated logfile. For example, if you have a complex script which...
Tuesday, August 23, 2022

How to extract hostname withouth FQDN in a shell variable

›
Taken from https://stackoverflow.com/questions/36151206/hostname-variable-in-shell-script-not-fqdn and really useful: export HOST=${HOSTNA...
Thursday, July 7, 2022

How to check for existence of multiple files in a shell script

›
# check for installation files existence if [ ! -f /tmp/file1 -a -f /tmp/file2 -a -f /tmp/file3 ] then echo "Some of the files file1...
Thursday, October 15, 2020

How to select a specific line number using awk

›
The file clonetext.txt contains: Clone Volume: true Clone Parent server Name: myserver1-cluster49 ...
Monday, June 4, 2018

one-liner for debugging script parameter output

›
To view the output of your script parameters, put this line in the beginning of your script: printf "Parameters passed are : $*\n...
Tuesday, May 29, 2018

Shell script snipplet for resetting a password

›
This little code snipplet to use a Linux/Unix escape character to send a line shift into a string of mulitple commands: #!/bin/bash . /ho...