OraFAQ Forum: Networking and Gateways » Oracle9.2 listener does not need listener.ora ??

Home » RDBMS Server » Networking and Gateways » Oracle9.2 listener does not need listener.ora ??

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

Oracle9.2 listener does not need listener.ora ?? [message #146227]

Wed, 09 November 2005 08:28

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

OK here is a strange thing I found out while moving our databases to a new server.

Apparently the Oracle 9.2 listner does not need a "listener.ora" file to work... at least that's what it looks like.

There are 5 databases in this dev server.
Oracle 9.2.0.4.0
AIX 5L
Default port 1521

1. Renamed the ?/network/admin/listener.ora file.
2. Stop and start the listner
3. after a couple of seconds, the listner had handlers for ALL the databases in the server.
4. connected from my local PC and another server to the database in this server.

5. Further testing ... I shut down 2 of the database
6. check listener status, there were 3 hadlers (for the databases that were up)

sweet.... Smile

has the Oracle 9.2 listener become smart enough ??

Anyone had anything like this before ?
--
Sanjay

Report message to a moderator

Re: Oracle9.2 listener does not need listener.ora ?? [message #146634 is a reply to message #146227]

Fri, 11 November 2005 12:30

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Yes, this is one of the cool features introduced with 9i.

PMON registers service information with the local listener on port 1521.

Best regards.

Frank

Report message to a moderator

Re: Oracle9.2 listener does not need listener.ora ?? [message #147453 is a reply to message #146634]

Thu, 17 November 2005 11:48

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

Thanks for the update ...

One question though ....

Let's say I DO NOT have a listner.ora file and the listener is started up..... it takes some time for the lsitener to establish the handlers for the existing databases.....I guess the PMON takes some time to figure this up.

Are there any command to force the PMON to set the handlers ?

In my testing, with no "listener.ora" I started the listener. Then immediately tried to connect to the db, it errored out. After a while though, I could connect to the db's. I guess the PMON created handlers for the listener by then (with a delay).

Later.
--
Sanjay

Report message to a moderator