This is the 7th day of my participation in the Gwen Challenge in November. Check out the details: The last Gwen Challenge in 2021.”
directory
1. Check whether the Oracle12c listening service is started
2. Ping whether the local ID can be pinged
3. Check whether there is an error in configuration listening:
4. Reconfigure the listener Net Configuration Assistant
5. Restart the OracleServiceORCL service
1. Check whether the Oracle12c listening service is started
2. Ping whether the local ID can be pinged
3. Check whether there is an error in configuration listening:
Find the Oracle Listening configuration file (listener.ora) and the TNS configuration file (tnsnames.ora)
My installation path is E:\oracle\ Product \11.2.0\dbhome_1\NETWORK\ADMIN
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.139)(PORT = 1521))
)
)
4. Reconfigure the listener Net Configuration Assistant
For details, see Oracle Listener configuration/orA-12541: TNS: No Listener – yxtic – Blog park
5. Restart the OracleServiceORCL service
