Oracle Configuration service Side

Oracle configuration server, similar to the way we configure the Java environment

To prevent garbled configuration:

Variable name: Nls_lang

Variable value: Simplified Chinese_china. Zhs16gbk

Select the configuration of the database (important):

Variable Value: tns_admin

Variable name: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN (which is your Oracle installed directory)

Here is my path configuration:

D:\app\administrator\product\11.2.0\dbhome_1\bin;%systemroot%\system32;%systemroot%;%systemroot%\system32\wbem ;%java_home%\bin;%maven_home%\bin;%systemroot%\system32\windowspowershell\v1.0\

Oracle has two files of particular importance listener, and TNSNames, under the D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN folder

Modified file:

Listener

# Listener.ora Network Configuration File:d:\app\administrator\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\Administrator\product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "Extproc_dlls=only:d:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(Sid_desc =
(Global_dbname = ORCL)
(Oracle_home = D:\app\Administrator\product\11.2.0\dbhome_1)
(Sid_name = ORCL)
)
)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST =wangpc) (PORT = 1521))
)
)

Adr_base_listener = D:\app\Administrator
TNSNames:

# Tnsnames.ora Network Configuration File:d:\app\administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
oracle_105 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

oracle_117 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
Oracle_j1 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
oracle_164 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
oracle_130 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
oracle_211 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
oracle_135 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
oracle_136 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = Orclapp)
)
)
orcl_200 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

oracle_j1200 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

oracle_204 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = company database addresses) (PORT = 1515))
)
(Connect_data =
(service_name = j1rep)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = WANGPC) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)
Where HOST=WANGPC, refers to the computer name, modify the computer name can be Baidu, if there is doubt can give me a message

Verify the configuration of the path:

Input Sqlplus

User name: Scott

Password (passphrase): Tiger

Note that as long as you have modified both profiles, be sure to restart the Oracle service, and remember to start ORACLESERVICEORCL before you start Oracleoradb11g_home1tnslistener

The order must not change, otherwise the service can not start normally, will be reported that the listener can not find

Oracle Configuration service Side