Re: listener.ora not found.

On Jan 4, 12:26 pm, "clement rajappa" <clement.raja..._at_gmail.com> wrote:
> Hi
> I have oracle 9i database installed on windows xp OS. The issue is i do
> not find
> listener.ora file in the /network/admin dir. Nor is the listener
> service registered
> under OS services. But i am able to work perfectly well with sqlplus. I
> also have
> forms 6i installed on a separate home in the same m/c.
> When i connect to the database from forms 6i without connect string it
> connects
> perfectly fine.
> My question is how does the connection take place without listener.ora
> and
> listener service under OS.
> Appreciate your help
> regards
> clement.

Apparently ORACLE_SID in the registry is is set to the SID of the database. (The SID is the part after OracleService in the O/S service name).

However, if you are using the default port (1521) you wouldn't need a listener.ora and you can just start the listener service. The database would also register it's service_name parameter automagically with the listener.
Obviously this are documented features.

-- 
Sybrand Bakker
Senior Oracle DBA