Remotely connect to oracle10 through sqlpuls

1. Configure the name of the remote connection service 

Open E: oracleproduct10.2.0db _ 1NETWORKADMINnsnames. ora and add the service name. 

Service name = 
(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.232.2) (PORT = 1521 )) 
) 
(CONNECT_DATA = 
(SERVICE_NAME = Global Database Name) -- Also available SID = database SID 
) 
) 

2. Remote Logon 
Sqlplus username/password @ service name 


Note: 

By default, tnsnames. ora has the following content: 
EXTPROC_CONNECTION_DATA = 
(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0 )) 
) 
(CONNECT_DATA = 
(SID = PLSExtProc) 
(PRESENTATION = RO) 
) 
) 
This is mainly used to call external processes. For example, you need to set EXTPROC_CONNECTION_DATA when using full-text search. 
(Extproc_connection_data is a special service name that is used for external procedures) 
Correspondingly, listener. ora has similar content. 

During remote connection configuration, the above default configuration in tnsnames. ora I tested should be removed. Otherwise, the database that is next to the above default configuration will not be connected. The specific reason is not found