The Oracle installed the day before yesterday suddenly became unusable yesterdayOracleJudging from the error prompt, it is said that TNS: no listener, it is estimated that some kind of service is not starting, open the windows management tool - > service, at a glance, there is oneOracleServices like OraHome90TNSListener are consistent with the error message problem, and it is almost certain that the problem caused by this service is the same. Looking at it again, the service did not start, so I started it manually, and after refreshing, the service was automatically closed immediately. Tried N times, the result is the same. I went to Google to search, but I didn't expect this to be a common problem, and someone proposed to open listener.ora in the installation directory and take a look. For example: d:\oracle\ora90\network\admin\listener.ora。 After opening the configuration file, the following configuration information is found: LISTENER = (DESCRipTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IBMThinkPad) (PORT = 1521)) ) ) ) ) ) When I saw the line HOST=IBMThinkPad, the problem was solved. It turned out that it was due to a few days of installationOracleAfter that, the computer name of Windows was changed, and the listening host name recorded in this configuration file was still the original name, which is no wonder.OracleThe OraHome90TNSListener service cannot be started, so immediately change it to the current computer name and start againOracleOraHome90TNSListener service is successful, PL/SQL Developer connectionOracleThe database succeeds, but the login cannot be logged in for troubleshooting.
|
Posted on 11/26/2014 3:54:56 PM
|
|
|
