Home » RDBMS Server » Networking and Gateways » Static Service registration for Listener (Oracle 9i R2 on RHEL)
Static Service registration for Listener [message #306557] Fri, 14 March 2008 12:29 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi,

In which case we need to do Static Service registration for Listener?

I assume initially the Listener file looks like following


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/rdb01)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db01_host.hsa.co.uk)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )


Which after Static Service Registration looks like

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/rdb01)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = DB01)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/rdb01)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db01_host.hsa.co.uk)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )



Please Suggest

Thanks and Regards,
OraKaran
Re: Static Service registration for Listener [message #306567 is a reply to message #306557] Fri, 14 March 2008 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As far I know you never need it.

Regards
Michel
Re: Static Service registration for Listener [message #306575 is a reply to message #306557] Fri, 14 March 2008 14:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
As Michel said, for the most part you'll probably find you'll never need it. However, one reason for wanting a static entry would be for when you try to make a connection utilizing the listener when the database itself isn't in at lteast MOUNT mode.
Re: Static Service registration for Listener [message #307976 is a reply to message #306557] Thu, 20 March 2008 11:27 Go to previous messageGo to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi,

Do we need it for connecting through OEM?

Thanks and Regards,
OraKaran
Re: Static Service registration for Listener [message #308169 is a reply to message #307976] Fri, 21 March 2008 13:12 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You'll still be able to connect thru OEM without a static entry. However, without a static entry in the listener, you'll still receive errors with OEM when the database isn't at least mounted.

Listener refused the connection with the following error: ORA-12514

You can still start the listener and database using OEM without the static entry.
Previous Topic: ORA-27101: shared memory realm does not exist (connect from unix to window db)
Next Topic: listener connection_timeout
Goto Forum:
  


Current Time: Tue Sep 16 17:06:49 CDT 2014

Total time taken to generate the page: 0.08747 seconds