Loggfilbane:

Forsøk på å kontakte (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOKOLL \u003d TCP) (HOST \u003d hostname1.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database1) (SRVR \u003d dedikert)) )

Forsøk på å kontakte (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOKOLL \u003d TCP) (HOST \u003d hostname2.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database2) (SRVR \u003d dedikert)) )

Forsøk på å kontakte (DESCRIPTION_LIST \u003d (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOKOLL \u003d TCP) (HOST \u003d hostname 3.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database3) (SRVR \u003d dedikert))) (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (AD DRESS_LIST \u003d (ADDRESS \u003d (PROTOKOLL \u003d TCP) (HOST \u003d hostname3.com) (PORT \u003d 1522))) (CONNECT_DATA \u003d (SID \u003d database3) (SRV R \u003d dedikert))))

Forsøk på å kontakte (DESCRIPTION_LIST \u003d (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOKOLL \u003d TCP) (HOST \u003d hostname 4.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database4) (SRVR \u003d dedikert))) (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (AD DRESS_LIST \u003d (ADDRESS \u003d (PROTOKOLL \u003d TCP) (HOST \u003d hostname4.com) (PORT \u003d 1522))) (CONNECT_DATA \u003d (SID \u003d database4) (SRV R \u003d dedikert))))

Jeg trenger utdata som nedenfor: Jeg har prøvd regeluttrykket / awk - ikke klarer å få forventet output (under ett)

Port SID
hostname1.com 1521 database1
hostname2.com 1521 database2
hostname3.com 1522 database3
hostname4.com 1522 database4

Kan noen vennligst hjelpe meg på dette?