O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Client Connections

With all of the tools discussed in this chapter, you need to pass in information about the database. SQL Server has an instance name (or may be local if not named), a server, and a port. The same is true with Oracle. It has the database name (SID), server name, and port. The SID is the instance name, and a service name could be for the database, as in the case of a clustered database.

Just as with SQL Server, the clients and tools need to be able to connect to the database. You can install some sort of client on the client side or use a database driver that can accept the information needed to connect. Table 5-3 compares the connection tools available for SQL Server and Oracle.

TABLE 5-3. Client Connection Tools

Several different ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required