Oracle LAN connection Database

Oracle LAN connected to the database today is connected to the local area database, the problem can be said to be a variety of problems, so I want to share with you here, I am the first time to use the oracle database, so it is relatively unfamiliar, the installation process is default, so if you do not know how to use the database, you can configure the lan. In fact, the simplest way is to use tnsnames. modify the ora file, sqlnet. ora does not need to be modified. I have tried to ask a question, and I have also looked for many people's practices. We all copied a piece of tnsnames. paste the items in ora and modify them. However, I do not know how to copy them. I would like to give them to future generations. Www.2cto.com ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl ))) modify the HOST and use localhost on the local machine. The LAN is the server's ipSERVICE_NAME, which is the database name (the database name on the server). ORCL = this header can be customized at will, when logging on, pay attention to the Selection. (I hope you will back up the configuration in advance when you are not familiar with the configuration. If this happens, you can change the file to the original format when an error occurs) if ORA--12514 error occurs, remember in listener. modify the settings under ora. My modified configuration is as follows (Note: I am from oracle 11g) www.2cto.com listener. ora Location C: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN # listener. ora Network Configuration File: D: \ orcl \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ listener. ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = listener) (ORACLE_HOME = D: \ orcl \ product \ 11.2.0 \ dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS = ONLY: d: \ orcl \ product \ 11.2.0 \ dbhome_1 \ bin \ oraclr11.dll ") (SID_DESC = (SID_NAME = ORCL) (ORACLE_HOME = D: \ orcl \ product \ 11.2.0 \ dbhome_1) (PROGRAM = ORCL) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521) (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) ADR_BASE_LISTENER = D: \ orcl