Re: Service names vs. Oracle SIDs

On 31 Jan 2004 03:45:23 -0800, newtophp2000_at_yahoo.com (php newbie) wrote:

>I installed Oracle9i (v9.2) on Mandrake Linux9.2. At the moment the
>configuration is not complete, but I am reading the manuals and will
>fix it soon. (One thing is that only the Oracle user can log in to
>the database; no other users can; although I have made sure all their
>environment variables are exactly the same.)

Usually a result from incorrect file protection.

>
>My question is that on Windows (again with Oracle 9i), I can log in to
>the database using the Oracle SID. But on Linux, it only accepts the
>service name (Global DB Name) for a connection. Is this some new
>behavior that is going to be standard from now on? Should I stop
>using the SIDs in my apps?

In 8i, several new features were introduced in net8. Transparent Application Failover, Connection manager, the option to have your listener running on a different server, to have different listeners for your database on different nodes etc, etc. They all won't work using a SID.
Consequently the net8 manual tells you the SID mechanism is deprecated and you only *must* use it for Oracle Enterprise Manager.

--
Sybrand Bakker, Senior Oracle DBA