I need to read a file line by line, but I am only interest in lines with a specific format.
I have a file that looks like the folowing, but I want to start where my database names start.
I want to start with the "mydb" line. None of my databases have the letters db in the name. This file can change in size since we check it and it gets a revision tagged at the top.
while read LINE
do
DBNAME=`echo $LINE | cut -d ":" -f1`
done < $ORATAB
# Revision 1.1 2005-09-17 13:25:06-04 oracle
# Initial revision
#
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
*:/opt/oracle/product/10120/mrca:N
*:/opt/oracle/product/10.1.0.3:N
*:/opt/oracle/product/10.1.0.3-devo:N
*:/opt/oracle/product/10.1.0.3_test:N
*:/opt/oracle/product/9206/dev/internal:N
*:/opt/oracle/product/9206/dev/id:N
*:/opt/oracle/product/9206/test/infrast:N
*:/opt/oracle/product/9206/test/id:N
*:/opt/oracle/product/9206/uat/id:N
mydb:/opt/oracle/product/10.2.0.4:N