Oracle Server Client Configuration

When learning Oracle, you may encounter Oracle Server problems. Here we will introduce the solutions to the Oracle Server problems, and share them with you here. SQL Server exchanges Data with its clients through the application-level TDS communication protocol (Tabular Data Stream. However, TDS also needs to work with underlying network communication protocols, such as TCP/IP or IPX/SPX. Oracle Server and the client exchange data between the TNS (Transparent Network Substrate), Oracle communication protocol transfer interface, and supported Network correspondence library. Net8 uses a communication protocol transfer interface between the TNS and the network library to complete literal translation. If Net8 replaces SQL * Net, the service name is used to search for the server location.

The Net8 network function library supports the following communication protocols: TCP/IP, SPX, Named Pipes, Logical Unit Type 6.2 (LU6.2), and Bequeath. You can use TCP/IP and SPX to connect to the Oracle database from a remote client. Compatible LU6.2 can be used for IBM's APPC (Advanced Program-to-Program Communications) system architecture. If you log on to the Oracle database from the local end, the Net8 online mode uses the Bequeath network communication protocol.

To enable the Net8 client to successfully connect to the Oracle Server, the client must have a service name that can be connected to the Oracle Server. The Oracle client can use the local tnsnames. ora to parse the service name (similar to the HOSTS file in a Windows operating system ). Of course, DNS or Oracle Names Server can also be used. Oracle 9i also provides LDAP (Lightweight Directory Access Protocol) as another method for name resolution. However, Microsoft does not officially support Oracle 9i as a linked server.

The Oracle Universal Installer written in Java will help you install Oracle software on Windows and UNIX systems. In a Windows environment, Oracle Universal Installer is automatically activated as long as the Installer disc is attached to the optical drive.

We recommend that you select the system preset options for installation, because in addition to installing Net8, Net8 Assistant and Net8 Configuration Wizard will also be installed) and SQL * Plus. Add the above items to the Assembly. SQL * Plus is a client tool, similar to SQL Server's osql tool program. The preceding section describes Oracle Server.

1. Quick understanding of Oracle parameter settings
2. Case Analysis Oracle Functions
3. Oracle Sequence
4. Do you know about Oracle triggers?
5. Detailed description of Oracle System privileges