Oracle LAN connection Database

Xiao Zhong is connecting to the local database today, and there are various problems. So I am going to share it with you here. This is the first time I used the Oracle database, so it is quite 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.

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 IP address of the server.

SERVICE_NAME is the database name (name of the database on the server)

Orcl = this header is defined as needed. You can select it during logon.

(I hope that you should back up your configuration in advance, so that you can reply to the original form if the file is modified or incorrect)

 

If a ORA--12514 error occurs, modify it under listener. ora. My modified configuration is as follows (Note: I am from Oracle 11g)

 

# 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 = clrextproc)
(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 \ lrlr11.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

 

If you imitate such an operation, there should be no major problems. I hope to share my learning and work experiences with you in the future!