Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Parsing Listener.ora

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parsing Listener.ora
# 1  
Old 09-29-2015
Parsing Listener.ora
Anymore have any code to easily parse the listener.ora to update the ORACLE_HOME for a specific sid?

thanks.
# 2  
Old 09-29-2015
Wouldn't you be better off to get what you need from /usr/local/bin/oraenv (or wherever you put it.)? /opt/var/oracle/oratab (or wherever you put it like /etc/ for Linux) also tells you what instances are supposed to be running locally.

oraenv is all about setting correct environment variables.

Usually you need both ORACLE_SID and ORACLE_HOME defined and possibly TWO_TASK define as well for remote instances.

The interdependence of those two files:
Linux oraenv Tips
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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... (2 Replies)
Discussion started by: Maddy123
2 Replies

2. Shell Programming and Scripting

Script multi listener

hello can help to script to find the listener is up or down for diferent db i have 2 listener ps -fea |grep tns root 17333 17559 0 12:26:38 pts/3 0:00 grep tns oracle 3800 1 1 Jul 23 ? 400:42 /u01/app/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit ... (1 Reply)
Discussion started by: ceciaide
1 Replies

3. Shell Programming and Scripting

Modifying listener file

Hi Pros, I'm writing a script to modify listener.ora file on multiple hosts. When I ssh to any server from a central server in our environment we are presented with menu to select the instance. I need to set my environment to listener which could be different number on every instance. How can I... (5 Replies)
Discussion started by: humble_learner
5 Replies

4. Shell Programming and Scripting

Removing sections from listener.ora

Hi, I am trying to write a script or command to add/remove a section from listener.ora file in the following example I would like: 1. to remove sid_alias2 sections 2. to add a new alias sections called sid_alias4, it can be placed after sid_alias3 sections $ cat listener.ora ... (18 Replies)
Discussion started by: ynixon
18 Replies

5. 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 ... (7 Replies)
Discussion started by: Mansoor8810
7 Replies

6. Shell Programming and Scripting

sed: parsing tnsnames.ora

All: Can sombodoy help me out with a sed command? Assume I have the following: PRI = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.3.7)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pri) ... (3 Replies)
Discussion started by: BeefStu
3 Replies

7. 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:... (1 Reply)
Discussion started by: newbie_01
1 Replies

8. 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 (2 Replies)
Discussion started by: gwrm
2 Replies

9. 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 Replies)
Discussion started by: fif14344
4 Replies

10. IP Networking

ftp port listener

Hi, Anyone have any pointers on how I would go about creating some sort of listener (preferably, but not exclusively in Java) that would monitor an ftp port and react to arrival of a new file? Thanks in advance. Selma (2 Replies)
Discussion started by: Selma
2 Replies
Login or Register to Ask a Question