Just to be clear, this one is so fucking stupid.
lsnrctl status
TNS-12541 no listening program
TNS-12560 protocol adapter error
TNS-00511 no listener program
According to the online solution I have various reconfiguration listening, but none of them work.
Finally, I saw a post where he accidentally found that the listening log had reached 4G. I looked at mine and sure enough it was the same. I didn’t hesitate to delete it and restart the service. Solve the problem.
Log position app/administrator/diag/TNSLSNR/XXXXXX/listener/trace/listener. The log
lsnrctl status
TNS-12541 no listening program
TNS-12560 protocol adapter error
TNS-00511 no listener program
According to the online solution I have various reconfiguration listening, but none of them work.
Finally, I saw a post where he accidentally found that the listening log had reached 4G. I looked at mine and sure enough it was the same. I didn’t hesitate to delete it and restart the service. Solve the problem.
Log position app/administrator/diag/TNSLSNR/XXXXXX/listener/trace/listener. The log
Read More:
- Navicate premium Connecting to a remote Oracle，ORA-12514: TNS:listener does not currently know of service requested in c
- Deployment project error: Oracle 11g ora-12505, TNS:listener does not currently know of SID given in connect descriptor
- [Solved] SpringBoot Integrating Oracle reports errors: ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
- Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently
- Oracle error – ora-12519, TNS:no appropriate service handler found
- Oracle 11gR2 RAC ohasd failed to start solution
- Oracle database file is damaged, Error:ORA-01033 :ORACLE initialization or shutdown in progress
- An error is reported when kettle connects Oracle database and MySQL database
- A series of errors encountered in connecting to the database using Oracle SQL developer
- JDBC connection to Oracle: listener used the connection with the following error: ora-12505
- Oracle database error: fatal Ni connect error 12170
- Solve the error of ora-12514 when Navicat connects to Oracle Database
- Oracle database missing init.ora Solutions
- Failed to create Oracle Oracle home user solution appears in oracle12c installation
- The problem of [connection lost contact] after C # code connecting Oracle database for a period of time
- Solution of invalid username / password; login denied error in Oracle Database Foundation
- Oracle can’t start the database due to deleting DBF file by mistake
- reason 442 failed to enable virtual adapter
- How to Solve mybatis returns null when querying Oracle database with char type field
- Android ADB command adb devices error: protocol fault (no status)