How to Set oracle11g remote Logon (using plsqldev or sqlplus remote logon)

Oracle 11g remote Logon Setting (using plsqldev or sqlplus remote logon) using plsqldev or sqlplus remote logon to oracle configuration: these three configuration files are under your oracle installation directory: 1. sqlnet. ora configuration information SQLNET. AUTHENTICATION_SERVICES = (ETS) NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT) // The TNSNAMES information is directed to tnsnames. ora, do not need to change, if there is no such file, you can create a new, and then write the content 2, tnsnames. ora configuration information ORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.103) (PORT = 1521 )) // 192.168.0.103 is the IP address of the remote host you want to connect to, and the port number is 1521.) (CONNECT_DATA = (SERVICE_NAME = orcl ))) ###================================================= ==================================== ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521) // instance configuration information on the local machine, used to connect to the local machine or when someone else connects to this machine) (CONNECT_DATA = (SERVICE_NAME = orcl) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) // This place seems to be a euro, not zero) 3. listener. ora configuration information SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = ORACLE_HOME) // ORACLE_HOME is your oracle installation directory, change it to your installation directory (PROGRAM = extproc) (SID_DESC = (GLOBAL_DBNAME = Oracle8) // Oracle8 your Global Database Name (SID_NAME = ORCL) // ORCL for your Global Database Service name) LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = PC_NAME) (PORT = 1521 )) // PC_NAME is the name of your computer) 4. After the three files are configured, the key point is to shut down the firewall of your computer system ), or add the port number or something to the Trust List. 5. Start the listening service, either in windows or linux. Otherwise, the listening service will not be connected: (service command) lsnrctl start6, and then you can establish a remote connection. The following connection can help you achieve remote connection. http://www.bkjia.com/database/201206/137903.html Oracle remote Logon: method 1. In cmd or on the terminal: sqlplus scott/tiger @ oracle // there is no space between tiger and @ (and no space is allowed ), oracle runs tnsnames for you. method 2 for the remote connection service added in ora, in cmd or at Terminal: sqlplus/nologSQL> conn scott/tiger@192.168.0.101/orcl // orcl for the service name on the remote server