In the past two days, the Oracle client is configured. The Server OS is Windows XP 64, the client OS is Windows 7 64, and the Oracle version is 11.2.
Let's talk about your doubts on the server. As you are a newbie, many of them do not understand what is going on.
1) about server listeningProgramSid setting during configuration
When I create a database, I set the SID Name of the database to "ahgridgis" and the global database name to ahgridgis. However, when I configure a listener through net manager, when "Database Service" is added to the listener, I enter "ahgridgis" as the Sid, and a prompt saying "a valid Sid is required". Why?
Finally, I can only set this Sid to the default orcl. Then, by changing the listening file listener. ora's
(Sid_desc =
(Global_dbname = ahgridgis)
(Sid_name= Ahgridgis)
The sid_name is ahgridgis to complete the listener.
What is the reason? Who can tell me?
2) After configuring the listener on the server end, restart the listener by using the following methods:
A: Control Panel-management tools-component services
Locate oracleoradb11g_home1tnslistener and restart
B: execute the following command in sqlplus
SQL> host LSNRCTL start;
3) configure the client.
Use Oracle Net configuration assistant on the client to configure the local network service name ".
Enter the service name ahgridgis and select the TCP protocol,The host name is the IP address of the server.Finally, perform a connection test.
The system prompts "connection timeout", changes user logon, or prompts connection timeout. Finally, after confirming that the server listener is enabled and the ping connection is enabled, the solution is "Disable the server firewall ", test the connection again. The connection is successful.
4) Solve "No listener"
When configuring the client network service name, the host name entered for the first time is the host name of the server, instead of the IP address. During the connection test, the system prompts "no listening program ". I checked the server listening program file and found that the host of the address parameter is the server's Host IP address.
So I tried to set the host name of the client to the IP address and connect again.
Does it mean that the "host name" setting must be consistent with the "host" parameter in the listening position of the server when configuring the client network service name?
Therefore, the following tests were conducted to set the server listening location to the host name, for example, student-PC. The client's IP address is still the host's IP address, and the connection test was conducted again on the client, the connection is successful.
In the futureTry to use IP addresses to configure the network service name of the client.
Summarize the connection configuration errors.
1) connection timeout
Solution: Disable the server firewall.
The premise is to ensure that the server listening program is normal.
2) No listener
Solution: when the client configures the network service name, the "host" uses the Server IP address instead of the server host name.