listener.ora in RAC ENV ..

Jhil

Dear RAC Experts ,

/u01/app/oracle/product/11.2.0/db_home  ----> Here i installed DB Software

/u01/product/11.2.0/grid_home          -----> Here i installed GRID Software

>> listener.ora file in RAC env

As we know , listener.ora is running from $GRID_HOME ...

$ORACLE_HOME parameter should point   DB_HOME or GRID_HOME  ??

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = XXXXX )

(ORACLE_HOME = ---------------------------->) Do we need to mention grid_home or oracle_home ?

(GLOBAL_DBNAME = orcl)

)

)

I am getting much confused.

Some people are saying ORACLE_HOME parameter should point $ORACLE_HOME

Some others are saying ORACLE_HOME parameter should point $GRID_HOME

As a beginner, I am getting confused, which one should be there ?

EdStevens

Jhil wrote:Hi Edstevens,My question was simple and straight.

As have the answers you've gotten from multiple people.

I am getting different different answer from everyone's perspective regrading my question.

The only "different" answer I've seen is from Miguel Palacios in msg #9 of this thread.

Still i am in confusion.

Perhaps if you wouldn't try to discuss the same question in 3 different threads:

listener.ora in RAC ENV ..

Need to put DB files in DiskGroup in standard structure

RMAN Cloning Server to Server to setup RAC Database

Personally I'm tired of have to constantly cross-reference 3 different threads to see what was said where.

I am NOT expert like you.

No one expects beginners to be experts.  But eventually we run out of ways to try to explain fundamentals.

Mostly i am doing self study .. self practice.
Just few months back i just started RAC ...I have gone through my office rac setup ( RAC and NON RAC DB's) are running in same machine.

One machine points ORACLE_HOME = (where GRID sw installed) in listener.ora file.

Another one machine points ORACLE_HOME = (where DB sw installed) in listener.ora file.

So that i am getting confused.Experts are suggesting to set DB sw path for ORACLE_HOME in listener.ora (which is runnning from $GRID_HOME)

There is one of your fundamental misunderstandings, which I've tried to explain a couple of times in at least one of the three threads you've got running on this same question.  Machines do not point to environment variables.  Environment variables are set within the memory space of individual processes running on a machine, and can be changed.  This is fundamental to computer operations and has nothing to do with anything specific to Oracle.  That said (again!), the immediate question again seems to be about setting the value for ORACLE_HOME as specified on individual database entries within the SID_LIST section of listener.ora.  Ok, so what is to reconcile?  We've already told you, multiple times, that one of them, the one that specified the GI home, is simply incorrect.  And we've explained, multiple times, WHY it is incorrect?  I'm sorry but at this point I fail to see why there should be any remaining confusion.

JuanM has suggested one thing..>> Is this good approach for RAC and NON RAC databases in same server ...SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = RAC1) (ORACLE_HOME = db home rac) )(SID_DESC = (SID_NAME = DBNORAC) (ORACLE_HOME = dbdno RAC home or dbdrac home if this database has the same oracle home) ))NOTE : i never seen +ASM entries in listener.ora file Now you please provide just simple and plain answer ... 

Again, I fail to see any point of confusion.  Look at it again, with the important bits highlighted:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = RAC1)

(ORACLE_HOME = db home rac)

)

(SID_DESC =

(SID_NAME = DBNORAC)

(ORACLE_HOME = dbdno RAC home or dbdrac home if this database has the same oracle home)

)

)

So you've never seen an entry for +ASM in the SID_LIST section.  So what?  I've already told you multiple times that the SID_LIST section itself is optional.  By extension, that means any particular entry in it may also be considered optional.  At least until such time as a particular operation requires it.  IF you don't need to connect to the ASM instance across the network when the ASM instance is down, then you don't need an entry for it in your listener.ora file.  If you do use the SID_LIST section, then the ORACLE_HOME setting for any particular entry obviously (?) should refer to the ORACLE_HOME of the entity being described.  If the SID_LIST entry is for an 11.2 database, then the ORACLE_HOME would be for the 11.2 db home.  If the SID_LIST entry is for an 12.1 database, then the ORACLE_HOME would be for the 12.1 db home.  And If the SID_LIST entry is for the ASM instance,  then the ORACLE_HOME would be for the ASM home.

Markus Flechtner

Hi,

in a typical setup, you do not need to specify the SID_LIST for a listener in the listener.ora. The instance registers itself at the listener automatically after startup.

But if you specify the SID_LIST, the Oracle Home must be the Oracle Home from which the instance is running (i.e. the RDBMS Home).

This is independent from the ORACLE-Home from which the listener is running.

HTH

Markus

Jhil

Hi,

Pls tell me little more ..

As we know, listener.ora is running from $GRID_HOME in RAC setup.

Suppose  in same server i am running Standalone DB and RAC DB also

in this case,  can i use same listener.ora file for RAC and NON RAC Databases ?

In this case, how listener.ora entries typically to be configured ?

please show me simple example

Thanks

Markus Flechtner

Hi,

typically you do not need to configure anything in listener.ora.

The database instances (RAC and Non-RAC) register at the listener automatically.

And you do not need different listener.ora for RAC and Non-RAC-DBs (because listener are independent on the db instances)

HTH

Markus

Jhil

Hi,

>> How i made rac setup  on my laptop

/u01/app/oracle/product/11.2.0/db_home  ----> Here i installed DB Software

/u01/product/11.2.0/grid_home           ----> Here i installed GRID Software 

Without uddating listener.ora,  i could NOT complete my cloning process NON RAC to RAC.

i updated listener.ora separately.

RMAN Cloning Server to Server to setup RAC Database

I tried to do clone from NON RAC to RAC

I got follwing error

RMAN-06174: not connected to auxiliary database

RMAN-03015: error occurred in stored script Memory Script

RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

and then updated listener.ora following below

SID_LIST_LISTENER =

(SID_LIST =

  (SID_DESC =

  (SID_NAME = orcl)

  (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_home) 

  (GLOBAL_DBNAME = orcl)

  )

)

I added ORACLE_HOME = DB Software Installed path instead of Grid Path

After that i done cloning NON RAC to RAC DB for Standalone DB.

==> in my office .. ORACLE_HOME is pointing $GRID_HOME  only

I am getting confused

When should i use $GRID_HOME and  $ORACLE_HOME ?

Dude!

The listener.ora file exists in the network/admin directories of the grid and database installation, as both installations provide a listener service. It's common practice however to use the listener of the grid installation, since you also need to start the ASM instance before you can start the database.

You do not specify GRID_HOME in the listener.ora file. On UNIX and Linux, setting ORACLE_HOME is actually optional to specify the Oracle home location of the instance.

For more details, please check https://docs.oracle.com/cd/B28359_01/network.111/b28316/listenercfg.htm#i486171

Jhil

Hi Dude,

Getting some thing.

I have checked office rac env

>> From $GRID_HOME  (11.2.0.4)

In one server,  ORACLE_HOME is pointing $GRID_PATH

In another one server, ORACLE_HOME is pointing $ORACLE_PATH

One thing i want to colclude

1) Shall i keep  (ORACLE_HOME=DB Software Installed path)  always in listener.ora from $GRID_HOME ?From GRID_HOME in listener.ora fileexample :...ORACLE_HOME=/u01/........./db_home  ....

Please answer for my question.

Thanks

JuanM

when the connection will be to a database, then put the oracle home for the database binaries where was started.

when the connection will be to an ASM instance, then put the grid home where ASM instance was started.

that's what @EdStevens wrote on reply 12 on Need to put DB files in DiskGroup in standard structure

Dude!

Why do you need to configure ORACLE_HOME in the listener.ora file?

From what I understand it needs to be set to the software installation of the Listener instance. So if you use the listener from Grid, then ORACLE_HOME needs to point to the grid home. All Oracle binaries use libraries, tools and configuration files according to ORACLE_HOME, regardless of Grid or Database. Since the versions of the listener from Grid and Database are identical, it probably doesn't matter which one you choose. However, by bother?

https://docs.oracle.com/cd/E18283_01/network.112/e10836/listenercfg.htm

P.S. you finally changed your name

https://www.urbandictionary.com/define.php?term=jhil

Miguel Palacios

Hi Jhil

Just to let you know that RMAN Duplicate does not work when using GI_HOME listener, you should use a listener running from RDBMS_HOME on the target

Regards

Miguel

EdStevens

Miguel Palacios wrote:Hi JhilJust to let you know that RMAN Duplicate does not work when using GI_HOME listener, you should use a listener running from RDBMS_HOME on the targetRegardsMiguel

Nonsense.  Please cite your source.

I have an ASM based production database that is duplicated (rman duplicate) to a test server every week.  The listener on both servers is always running from the GI home.  Has been for years, from 11.2.0.1 (when I inherited it) through 11.2.0.2, 11.2.0.3, 11.2.04. to 12.1.0.2.  And just to put icing on the cake, at each upgrade, the GI was upgraded several weeks ahead of the db.