Oracle Vs SQL Doubt ...
Q: One of the user in BDotNet had
asked if he can have same named Instance for Oracle and SQL Server.
"If I have my machine named as Anil. And I install SQL Server 2k on my machine
with a instance name called ANIL\ANILSQL for SQL2k,and same for Oracle 9i
ORAHOME\ANILSQL. Will there be a conflict when accessing both the
databases?"
My Answer:
Well, NO Not atall ... They are not the same ...
Understand the basic ports and the calls are specific to the datastore ... For
example, SQL uses the 1433 and 1434 for connection and the Oracle provider uses
the 1521 and other ports ... Like in SQL you can also change the ports in
Oracle ... But DONOT point to the same port ... Neither of the applications
might work ...
Hence please donot confuse on with named instances
... Oracle has implemented the same concept of named instances as different
Oracle Homes ... Look and feel are the same what SQL Server is to offer ... Net
net you can have the same name of the instance for Oracle and SQL and the
Client tools / datastore connection provider takes care of connection to the
appropriate datastore ...
|