Removing sections from listener.ora Post: 302959057

Sponsored Content

Top Forums Shell Programming and Scripting Removing sections from listener.ora Post 302959057 by ynixon on Wednesday 28th of October 2015 10:55:30 AM

10-28-2015

Registered User

When there is only 1 alias, the replacement is not working Smilie

Code:

$ cat INSERT.TXT
                (SID_DESC=
                        (SID_NAME=alias3)
                        (ORACLE_HOME=/oracle/product/12.1.0.2/dbhome_1)
                        (GLOBAL_DBNAME=alias3)
                )
                (SID_DESC=
                        (SID_NAME=alias3)
                        (ORACLE_HOME=/oracle/product/12.1.0.2/dbhome_1)
                        (GLOBAL_DBNAME=alias3_DGMGRL)
                )
                (SID_DESC=
                        (SID_NAME=alias3)
                        (ORACLE_HOME=/oracle/product/12.1.0.2/dbhome_1)
                        (GLOBAL_DBNAME=alias3_DGB)
                )

$ cat listener.ora
# listener.ora Network Configuration File: 
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = l )(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER=
        (SID_LIST=
                (SID_DESC=
                        (SID_NAME=alias2)
                        (ORACLE_HOME=/oracle/product/12.1.0.2/dbhome_1)
                        (GLOBAL_DBNAME=alias2)
                )
                (SID_DESC=
                        (SID_NAME=alias2)
                        (ORACLE_HOME=/oracle/product/12.1.0.2/dbhome_1)
                        (GLOBAL_DBNAME=alias2_DGMGRL)
                )
                (SID_DESC=
                        (SID_NAME=alias2)
                        (ORACLE_HOME=/oracle/product/12.1.0.2/dbhome_1)
                        (GLOBAL_DBNAME=alias2_DGB)
                )
        )


ADR_BASE_LISTENER = /oracle

$ sed -e '/(SID_D/ {:L;N;/\n *)/bK;bL; :K;/alias2/d;/'$(sed -n '/GLOBAL_DBNAME/h; $ {g; s/^[^=]*=//; s/)//;p}' listener.ora)'/rINSERT.TXT' -e ' }' listener.ora
# listener.ora Network Configuration File: 
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = l )(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER=
        (SID_LIST=
        )


ADR_BASE_LISTENER = /oracle

$

ynixon

View Public Profile for ynixon

Find all posts by ynixon

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing sections and leaving separators intact

I have an awk script like below function abs(val) { return val > 0 ? val : -val } # 1. Main input loop, executed for each line of input BEGIN { RS = ORS = ">" } { if ( NF > 2 ) { if ( abs( $1 - $(NF-2) ) < 40 ) { print } } } The input file is something like...

2. Shell Programming and Scripting

Removing sections

I have a file like this %( PHASES P %) %( SOURCES (10,0.0) (13,0.0) (16,0.0) (19,0.0) (22,0.0) (25,0.0) (28,0.0) (31,0.0) (34,0.0) (37,0.0) (40,0.0)

3. Shell Programming and Scripting

How to know the location of the listener?

Hi, I have an unknown listener of of one of my port. How would I know the location of that specific listener?

4. UNIX for Dummies Questions & Answers

Listener port

Hi All, I'm installation a server we have client -server architecture I need to configure a port for client to communicate with the server and server to communicate with the clients Pls let me know how to configure in linux

5. Shell Programming and Scripting

awk removing sections of a file

I have a file that looks liek this (see below). can somebody provide me with and awk or sed command that can take a piece of the file starting from the time to the blank line and put in into another file. For example: How would I get the data from 10:56:11 to the blank line. Two things: ...

6. Solaris

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

Hi all, Am intermittently getting the following errors on one of my databases. Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302:...

7. UNIX for Advanced & Expert Users

grep all ORA errors except one ORA error

Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command? In following "grep" command I want to exclude "ORA-01653" error grep -i ORA alert.log >>/tmp/ora_errors.txt ...

8. Shell Programming and Scripting

Parsing Listener.ora

Anymore have any code to easily parse the listener.ora to update the ORACLE_HOME for a specific sid? thanks.

9. Shell Programming and Scripting

Removing section from tnsnames.ora

Hi, I am trying to write a script or command to remove a section from tnsnames.ora file in the following example I would like to remove tns_alias2 section $ cat tnsnames.ora tns_alias1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host1 )(PORT = 1521)) ...

10. Red Hat

Ora-27603:ora-27626:

Hi, User claim that job is running slow from their end. I DBA found in database the below errors in alert log file. ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576 ORA-27626: Exadata error: 2201 (IO...

LEARN ABOUT DEBIAN

ocf_heartbeat_oralsnr

OCF_HEARTBEAT_ORALSN(7) 					OCF resource agents					   OCF_HEARTBEAT_ORALSN(7)

NAME

       ocf_heartbeat_oralsnr - Manages an Oracle TNS listener

SYNOPSIS

       oralsnr [start | stop | status | monitor | meta-data | validate-all]

DESCRIPTION

       Resource script for Oracle Listener. It manages an Oracle Listener instance as an HA resource.

SUPPORTED PARAMETERS

       sid
	   The Oracle SID (aka ORACLE_SID). Necessary for the monitor op, i.e. to do tnsping SID.  (unique, required, string, no default)

       home
	   The Oracle home directory (aka ORACLE_HOME). If not specified, then the SID should be listed in /etc/oratab.  (optional, string, no
	   default)

       user
	   Run the listener as this user.  (optional, string, no default)

       listener
	   Listener instance to be started (as defined in listener.ora). Defaults to LISTENER.	(unique, optional, string, no default)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 120.

       stop
	   Stops the resource. Suggested minimum timeout: 120.

       status
	   Performs a status check. Suggested minimum timeout: 60.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 10.

       validate-all
	   Performs a validation of the resource configuration. Suggested minimum timeout: 5.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.

       methods
	   Suggested minimum timeout: 5.

EXAMPLE

       The following is an example configuration for a oralsnr resource using the crm(8) shell:

	   primitive p_oralsnr ocf:heartbeat:oralsnr 
	     params 
	       sid=string 
	     op monitor depth="0" timeout="30" interval="10"

SEE ALSO

       http://www.linux-ha.org/wiki/oralsnr_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

resource-agents UNKNOWN 					    03/09/2014						   OCF_HEARTBEAT_ORALSN(7)