Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Thu Jan 04 2007 - 05:32:19 CST