Many users put forward monitoring configuration related issues, client terminal (client) can not connect server side (server). This article is now a brief introduction to the monitoring configuration, and put forward some customer terminal can not connect to the server-side solution.
First, the
Listener (LISTENER) The listener is an Oracle server-based network service that listens to client connection requests to the database server side. Since it is based on server-side services, it only exists on the database server side, and the listener settings are also done on the database server side.
Second,
Local Service name (tnsname) The Oracle Client-server connection is a connection request made through the client, a client connection request is legitimately checked by the server-side listener, and the connection is rejected if the connection request is valid. The local service name is one of the Oracle client network configurations, plus the Oracle name server (Oracle Names server). Oracle's Common client configuration is the local service name, and is primarily based on the local service name configuration.
Third,
Oracle
Network Connection Configuration method Configuring the Oracle Server side and client can be done in their own graphical Oracle Network Manager (Oracle Net Manager) (it is highly recommended to complete the configuration of the Oracle service side or client under this graphical tool). Under Windows, click "Start/program/oracle-orahome92/configuration and Migration Tools/net Manager" to launch the Oracle Network Manager tool, under Linux/unix, Use the Netmgr command to start the graphical Oracle network manager, such as: $ netmgrthe Windows Startup Net Manager graphics window looks like this: figure (i)
1. Oracle Listener Configuration (LISTENER)As shown in figure (a), select the Listener in the tree directory, and then click on the upper left "+" button to add listeners, click the Listener directory, the default new listener name is listener (the name can also be named by any legal characters). Select the name, select "Listening Location" in the drop-down option in the right column of the window, and click the Add Address button. Select "TCP/IP" in the Protocol drop-down option in the network address bar that appears, enter the host name or the address in the Host text box (if the host is used as the server as the client, one of the two entries is valid; If the host is a server and requires a network connection, the IP address is recommended), Enter a digital port in the Port text box, which is 1521 by default, or you can customize any valid digital port. The configured listener locations are as follows: figure (ii) Select "Database Service" in the drop-down option in the right column of the window and click the Add Database button. Enter the global database name in the database column that appears, such as MyOracle. Note that the global database name differs from the database SID, and the global database name actually controls the uniqueness of the global naming of the database within the same network segment, such as the domain controller under Windows, where you can enter myoracle.192.168.1.5. The Oracle home directory can be entered without filling in the SID, such as MyOracle. The complete database service configuration is as follows:
Figure (iii) Save the above configuration, the default is to find the listening profile under the ORACLE installation directory (under Windows such as D:oracleora92networkadminlistener.ora,linux/unix $ oracle_home/network /admin/listerer.ora). At this point, the Oracle server-side listener configuration is complete.
2. Local Service name configuration (tnsnames)The Local Service name is based on the Oracle client-side network configuration, so if the client needs to connect to the database server for operation, it needs to configure the client to be attached to any pc that wants to connect to the database server. It can also be the database server itself. As described earlier, the Oracle client configuration can be completed using the graphical management tools Net Manager that comes with Oracle. Select the service name in (a), then click the "+" button on the top left to pop up the dialog box as shown: Figure (iv) Enter the net service name, such as MyOracle, and click Next to enter the Display dialog box: Figure (v) Select TCP/IP (Internet Protocol) and click Next, as shown in:
Figure (VI) Enter the host name and port number. Note that the hostname and port number must be the same as the host name and port number configured by the database server-side listener. Click Next, as shown in: Figure (vii) Select the (oracle8i or later) service name and enter the service name. The service name here is actually the global database name in the database server-side listener configuration, which must be the same as the former. Connection types usually choose a dedicated server, depending on the configuration of the database server, if the configuration of the shared database server, the connection type here is the choice of a shared server, otherwise it is recommended to select a dedicated server (for the introduction of a dedicated server see related documents). Once configured, click Next, as shown in: Figure (Eight) if the database server-side related services are started, you can click the Test button to test the connection. Oracle defaults to a test connection through the Scott/tiger user, and since the Scott user is a sample user with Oracle, the user may not be configured for a formal business database or a professional test database, so changing to a valid user login is likely to test successfully. If the test connection here is unsuccessful, it does not matter, first click Finish button to end the configuration. Go back to the Oracle Network Manager (Oracle Net Manager) main window and save the configuration by default to locate the local Service name profile under the Oracle installation directory (Windows D:o Racleora92networkadmintnsnames.ora,linux/unix under $ oracle_home/network/admin/tnsnames.ora). Configure the completed local service name as shown:
Figure (ix) Service naming under the tree directory can be changed to a service name consisting of any legal character by renaming the menu in the Edit menu, note that the service name must not have a space character before it may not connect to the database server.
3. Connect to the database server
(1) Start server-side Listener and database serviceLinux/unix, start the listener:$ lsnrctl Start shutdown Listener: $ lsnrctl Stop View listening status: $ lsnrctl Status Start database: $ sqlplus/nologsql>conn[email protected]As SYSDBA-the myoracle here is the client-side local service name or Sql>conn/as that was previously configured Sysdbasql>startupunder Windows, start the listener:C:lsnrctl Start Oracle Instance service: C:oradim a href= "Http://game.pchome.net/pcgame" class= "None" title= "cs" rel= "external" >CSTARTUP–SID MyOracle shut down Oracle Instance service: C:oradim–shutdown–sid myoracle The above services must be started at the same time for the client to connect to the database. Because the default configured listener name is listener, the above command starts the listener normally, and if the listener name is a different name, such as Alistener, it needs to be started in the following ways:Linux/unix under:$ lsnrctl Start Alistenerunder Windows:C:lsnrctl Start Alistener
(2) Test Connection database ServerThere are a variety of testing methods, which can be tested with local service names configured above, or third-party client tools such as PL/SQL Developer, most conveniently with Oracle's own Sqlplus tool, which is tested using Sqlplus: C:sqlplus/ Nologsql>conn [email protected] is connected.
iv.
Client Connection server-side FAQ Troubleshooting method To troubleshoot client-to-server connectivity issues, first check that the client configuration is correct (the client configuration must be consistent with the database server-side listener configuration), and then resolve it based on the error. Several common connectivity issues are listed below:
1, Ora-12541:tns: No listenerIt is obvious that the server-side listener does not start, and check that the client IP address or port is filled in correctly. Start Listener: $ lsnrctl start or C:lsnrctl start
2. Ora-12500:tns: The listener cannot start the private server processFor Windows, the Oracle instance service is not started. Start Instance service: C:oradim–startup-sid myoracle
3, Ora-12535:tns: Operation timeoutThere are many reasons for this problem, but it is mainly related to the network. To solve this problem, first check whether the network of client and server is unblocked, if the network is connected, check whether the firewall on both sides is blocking the connection.
4. Ora-12154:tns: Unable to process service nameCheck that the service name entered is consistent with the configured service name. Also note that the generated local service name file (under Windows such as D:oracleora92networkadmin Tnsnames.ora,linux/unix under/network/admin/tnsnames.ora) is the first of each service Cannot have spaces before the line service name.
5. Ora-12514:tns: The listening process cannot parse the service_name given in the connection descriptorOpen Net Manager, check the service name and verify that the service name entered in the Service tab is correct. The service name must be the same as the global database name configured by the server-side listener.
6, Windows startup monitoring service prompt cannot find the pathYou cannot find a path by using a command or starting a listener in the Services window, or listen for a service startup exception. Open the registry, enter the Hkey_local_machine/system/current Controlset/services/oracleorahome92tnslistener entry, and see if the ImagePath string entry exists. If not, the setting value is D:oracleora92bintnslsnr, and the different installation path setting values are changed accordingly. The same approach applies to Oracle instance services, as above, to find servicemyoracle items like Hkey_local_machine/system/current controlset/services/oracle, See if the ImagePath string entry exists, and if not, create a new set value of D:oracleora92 BinORACLE.EXE myoracle. Reprinted from Http://blog.sina.com.cn/s/blog_683a8f650100v600.html
How Oracle Configures Monitoring
