linux - delete lines based on number of brackets? -

-

i trying find best way replace text in file called listener.ora oracle. looking replace "sid_list_listener_orcl" entry else... have couple of things can go wrong here want avoid...

first can see entry can either entry#1 or entry#2, first 1 has "sdu=" entry, while second 1 dont...do note file either have entry#1 or entry#2 , not both @ same time(at least not in our environment).

second, thinking find of "sid_list_listener_orcl" , delete 6 or 7 lines there, entry varies (sdu= in 1 , not in other) dont think idea...

next thing, no matter can come might find environment might have lets 2 more lines in entry script break or cause other error....so nice have work these 2 entry , else might encounter in future...one important thing can think of is, no matter how many lines have 6, 7, 9 or 9 have exact number start , close brackets{ () }... starting "(sid_list ="

i know want replace , have part worked out struggling how delete existing lines

### entry #1  sid_list_listener_orcl =   (sid_list =     (sid_desc =       (sdu = 32768)       (sid_name = orcl)       (oracle_home = /oracle/orcl/11264)     )   )  ## entry #2  sid_list_listener =   (sid_list =     (sid_desc =       (sid_name = orcl)       (oracle_home = /oracle/orcl/11264)     )   )

the full listener.ora file typically this...

listener_orcl =   (description_list =     (description =       (address_list =         (address =           (protocol = tcp)           (host = hostname)           (port = 1578)       )     )   )  )  startup_wait_time_listener_orcl = 0 connect_timeout_listener_orcl = 10 trace_level_listener_orcl = off sid_list_listener_orcl =   (sid_list =     (sid_desc =       (sdu = 32768)       (sid_name = orcl)       (oracle_home = /oracle/orcl/11204)     )   )

this delete content matching parenthesis on same line. i'm not sure that's problem though.

$ sed '/(.*)/d' file

will print

sid_list_listener_orcl =   (sid_list =     (sid_desc =     )   )  ## entry #2  sid_list_listener =   (sid_list =     (sid_desc =     )   )

update full file.

for it's better switch awk power.

$ awk -v rs= -f"\n" '!/sid_list_listener/{print}                        /sid_list_listener/{for(i=1;i<=nf;i++)                                     if($i!~/\(.*\)/) print $i}' listener.ora

will delete matched parenthesis in required context.

listener_orcl =   (description_list =     (description =       (address_list =         (address =           (protocol = tcp)           (host = hostname)           (port = 1578)       )     )   )  ) startup_wait_time_listener_orcl = 0 connect_timeout_listener_orcl = 10 trace_level_listener_orcl = off sid_list_listener_orcl =   (sid_list =     (sid_desc =     )   )

update 2 delete full record

$ awk -f"\n" -v rs= '/sid_list_listener/{sub("sid_list_listener.*","")}1' listener.ora listener_orcl =   (description_list =     (description =       (address_list =         (address =           (protocol = tcp)           (host = hostname)           (port = 1578)       )     )   )  ) startup_wait_time_listener_orcl = 0 connect_timeout_listener_orcl = 10 trace_level_listener_orcl = off

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more