After the server-side installation is complete,
D:\app\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN under
1. The red part of the Listener.ora is added. ORCL177 is the instance name. host:172.30.70.177 here is the server IP
# Listener.ora Network Configuration File:d:\app\oracle\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:\app\Oracle\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:d:\app\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(Sid_desc =
(Global_dbname = orcl177)
(Oracle_home = D:\app\Oracle\product\11.2.0\dbhome_1)
(Sid_name = orcl177)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.30.70.177) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)
Adr_base_listener = D:\app\Oracle
2.tnsnames.ora under HOST changed to IP 172.30.70.177
# Tnsnames.ora Network Configuration File:d:\app\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL177 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.30.70.177) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = orcl177)
)
)
Oraclr_connection_data =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(Connect_data =
(SID = Clrextproc)
(PRESENTATION = RO)
)
)
Client: New Under Tnsnames.ora
orcl_177 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.30.70.177) (PORT = 1521))
)
(Connect_data =
(service_name = orcl177)
)
)
After the change, PL/SQL Develop can be connected
ORA-12514 The TNS listener does not currently recognize the workaround for requesting a service in the connection descriptor