Listener.ora

[vandclem]

Environment information:
* Oracle version:
* Operating system:

What does this line mean in Listener.ora?

Select all

SID_LIST_SAAM = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = C:\oracle\ora92) 
      (PROGRAM = extproc) 
    ) 
  )

It is because type I put two instances in the Oracle
and I added the listeners but it only connects in instance 1 and in the two no, there is something else Do addition to creating the instance and listener one on port 1521 the other placed in 1522.

Valewsss.

[gilbertoca]

Show us the part that you set the doors.

Gilberto

[vandclem]

Select all

# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora 
# Generated by Oracle configuration tools. 
 
SAAM = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521)) 
      ) 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) 
      ) 
    ) 
  ) 
 
SID_LIST_SAAM = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = C:\oracle\ora92) 
      (PROGRAM = extproc) 
    ) 
  )

[gilbertoca]

Before a question: Have a door per instance will serve you in some proposition?

Gilberto

[vandclem]

Oops, in fact, I did not only think I could give conflict: P
are you talking about the right listener instance?


Valews ..

[vandclem]

I did a test now but I had already done, Oracle conventionally does not let two listener in the same right door?

[gilbertoca]

Think of the following:

Can you use two phone numbers at the same time?

The relationship is as follows:

• * A Listener (service) by port, authenticating and passing those right (one or more instances). [/ list]
  You can also have a listener per instance. That way you will have to choose another door because it is another service.
  
  Gilberto

[vandclem]

I did not understand anything, could it be less theoretics?

[vandclem]

I understand, yes when I'm in the company I'll post my tsname and listener and talk about the problem right so I think we could solve!


Valw