OraFAQ Forum: Networking and Gateways » Static Service registration for Listener

Home » RDBMS Server » Networking and Gateways » Static Service registration for Listener (Oracle 9i R2 on RHEL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Static Service registration for Listener [message #306557]

Fri, 14 March 2008 12:29

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

Report message to a moderator

Re: Static Service registration for Listener [message #306567 is a reply to message #306557]

Fri, 14 March 2008 12:56

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As far I know you never need it.

Regards
Michel

Report message to a moderator

Re: Static Service registration for Listener [message #306575 is a reply to message #306557]

Fri, 14 March 2008 14:18

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.

Report message to a moderator

Re: Static Service registration for Listener [message #307976 is a reply to message #306557]

Thu, 20 March 2008 11:27

OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom

Senior Member

Hi,

Do we need it for connecting through OEM?

Thanks and Regards,
OraKaran

Report message to a moderator

Re: Static Service registration for Listener [message #308169 is a reply to message #307976]

Fri, 21 March 2008 13:12

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.

Report message to a moderator

Previous Topic:	ORA-27101: shared memory realm does not exist (connect from unix to window db)
Next Topic:	listener connection_timeout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 02:18:16 CDT 2024