First you need to explain the version and type of Oracle used for this document: 12c, Desktop Edition (desktop class, relative to server Class)
We know that Oracle local access host is localhost, and as with other relational databases Mysql,sql server, Oracle remote Access also needs to modify parameters such as host.
Therefore, before you deploy Oracle, there is only one thing to verify: Ensure that the machine that installs Oracle has a static IP (static IP on the LAN is also OK)
Here's the start:
1. Shut down Windows Firewall, shut down Linux firewall in Linux environment
2. Modify Oracle's NET Manager configuration
Open Oracle's net Manager, configured as follows (primarily to modify the connection type to a shared server ):
3. Configure the number of connections
Open Database Configuration Assistant
Next is all you have to do.
4. Modify the listening IP to find the installation of Oracle Admin directory, the author's directory is:
D:\app\orcl\product\12.1.0\dbhome_1\NETWORK\ADMIN
Folder to open the following file:
Modify the following (mainly to modify the value of the host):
Tnsnames.ora
<pre name= "code" class= "SQL" ># Tnsnames.ora network Configuration File:
# D:\app\orcl\product\12.1.0\dbhome _1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
Oraclr_connection_data =
(DESCRIPTION = (
address_list =
(address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(Connect_data =
(SID = clrextproc)
(presentation = RO)
)
LISTENER_ORCL =
(address = (PROTOCOL = TCP) (HOST = 10.60.38.154) (PORT = 1521))
ORCL =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521
)) (Connect_data =
(SERVER = SHARED)
(service_name = ORCL)
)
Listener.ora
# Listener.ora Network Configuration File:
# D:\app\orcl\product\12.1.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:\app\orcl\ Product\12.1.0\dbhome_1)
(program = extproc)
(Envs = "extproc_dlls=only:d:\app\orcl\product\12.1.0\dbhome_ 1\bin\oraclr12.dll ")
)
LISTENER =
(description_list = (
DESCRIPTION =
(address = ( PROTOCOL = TCP) (HOST = 10.60.38.154) (PORT = 1521))
(address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
The code for the above two files is bold and needs to be modified. As can be seen, the main is to modify the host from localhost to the static IP of this machine.
5. Restart All services after modification (this is very important), and then through the SQL Developer test successfully