Need next line as a space delimiter in awk

Shell Programming and Scripting
1

Hi,Below is the output for p3fi_dev services

1/app/oracle> . ./oraprofile_p3fi_dev
[dev-oragrid-ux01]p3fi_dev_01 (P):/devoragridcn_01/app/oracle> srvctl config service -d p3fi_dev
p3fi_p3fi_dev.world PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
pplnet_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
nexus_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
applog_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02

I need distinct values fro PREF and AVAIL out of the above output

Below is the code I am using:

case $ORACLE_HOME in
  */product/10*)
# i# *)              echo "something else" ;;
#esac
Instance_value=`srvctl config service -d $database | awk -F: '
/PREF/ {
                P[$NF]
        }
        /AVAIL/ {
                A[$NF]
        }
        END {
                printf ( "%s:", "Preferred instances" )
                for ( k in P )
                        printf ( "%s ", k )

                printf ( "\n%s:", "Available instances" )
                for ( k in A )
                        printf ( "%s ", k )

                printf "\n"
        }
'`;;

However this is giving blank values for Preferred and Available instances.

Please suggest.

Best regards,
Vishal

2

show expected output also for your input.

3

Below is the expected output:

Checking services for database p3fi_dev
p3fi_p3fi_dev.world
pplnet_p3fidev
nexus_p3fidev
applog_p3fidev
Preferred instances: p3fi_dev_01 Available instances: p3fi_dev_02

Best regards,
Vishal

4

I assumed this is input

$ cat file
p3fi_p3fi_dev.world PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
pplnet_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
nexus_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02
applog_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02

database=p3fi_dev
awk -v data=$database '
BEGIN{
        print "Checking services for database ", data
     }
     {
        P[$3]
        A[$5]
        print $1
     }
  END{
        printf ( "%s : ", "Preferred instances" )
        for(i in P)printf i
        printf("\t%s : ", "Available instances" )
        for(i in A)printf i
        printf RS
     }' file

Resulting

Checking services for database  p3fi_dev
p3fi_p3fi_dev.world
pplnet_p3fidev
nexus_p3fidev
applog_p3fidev
Preferred instances : p3fi_dev_01    Available instances : p3fi_dev_02

----edit-------

create variable like this

Instance_value=$(srvctl config service -d $database  | \
awk -v data=$database '
BEGIN{
        print "Checking services for database ", data
     }
     {
       P[$3]
       A[$5]
       print $1
     }
  END{
        printf ( "%s : ", "Preferred instances" )
        for(i in P)printf i
        printf("\t%s : ", "Available instances" )
        for(i in A)printf i
        printf RS
     }' )


printf  "$Instance_value\n"