In the first configuration Oracle At that time, I always fail because I still don't know much about oracle. I just follow the steps in the book. As for why, I don't know why, and finally have free time. Research .
OracleDataLibrary isNetworkDatabaseAn Oracle database isServiceA database is identified by a service name (srver name), which is a logical representation of the database and a link that the database presents to the client.
When installing the database, you will be asked to enter the SID and global database name. The Global Database Name of a database is composed of the database name and the database Domain Name: Database Name. database domain name. The global database name is the service name, which is composed of initialization parameters.FileThe db_name and db_domain parameters are both expressed together, while the listener is obtained on the server side. SERVER_NAME in the ora file.
The Network Service name is the name of the database word client, and the logical name represents the database alias. It is used to help the client accurately link to the specified service (database), which is stored in the client's tnsname.org file (Transparent Network Substrate ). Oracle uses the network descriptor as the path for the client to access the database. As long as network access is involved, this descriptor should containAddress, Indicating the server address on the network? Access protocol? Host Name? Port Number? Access Method (Oracle servers are divided into dedicated processes and shared processes)
GIS =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = zuiyirenjian) (Port = 1521) (note that my host is the name of my computer and can be written as an IP address)
)
(CONNECT_DATA =
(Server = dedicated) (dedicated connection mode)
(SERVICE_NAME = zuiyirenjian.com) (Global Database Name)
)
)
It should be because the connection descriptor here is too long. If we write so long during the connection, it will inevitably lead to errors. So we can simply replace this link descriptor. I use GIS, so this GIS replaces my link descriptor. We call this network service name. Is there a problem? I can read from the above. As long as the connection descriptor remains unchanged, I can configure several network service names. Is there a problem?
We know that network sessions are listenedProgramIt is a process running on the server, In the listener. Relevant information is displayed in the ora file.
The content in the listener. ora file is as follows:
Listener =
(Description_list =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = zuiyirenjian) (Port = 1521 ))
)
(Address_list =
(Address = (Protocol = IPC) (Key = EXTPROC ))
)
)
)
Since it is a listener, it is necessary to listen to information on a port and a server, so the host name and port number above should be the same as that in tnsname. If it is wrong, the latter should be the same as the previous one, we must first Configure the server and then the client.
The IP address can help us find computers on the network, but can we find specific services? We know that a computer can have multiple servers, such as IIS and tomcat. If we compare an IP address to a building, and each service is equivalent to a room in this building, each room can have a different number, similar to the port number, so we can find this service through IP + port. We want to find a room. First, we need to find the address of the building where the room is located, find the room number.