Thanks Mr.Bakker for yr reply.
My doubt about connectivity was because the listener service itself has
not been created during installation and listener.ora was also not
there. I am new to db admin and i was going through the manual were it
was talking about static and dynamic registration. I was wondering how
either of this could take place without the above mentioned
requirements.
rgds
clement
On Jan 4, 2:32 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
> 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- Hide quoted text -- Show quoted text -
Received on Thu Jan 04 2007 - 07:12:44 CST
