[oracle@hellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 04-Nov-2021 15:30:14
Copyright © 1991, 2014, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
– The ps command did not find the listening process
[root@sh ~]# ps -ef | grep -i tns
root 36 2 0 Jan26 ?00:00:00 [netns]
root 14995 14824 0 15:30 pts/1 00:00:00 grep -i tns
– Check the listening status, error reported; TNS-01189
[oracle@sh ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 4-NOV-2021 15:57:39
Copyright © 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hello)(PORT=1521)))
TNS-01189: The listener could not authenticate the user
– There are basically 2 reasons for this problem,
1, the ip and hostname in /etc/hosts file are not the same
2, the listener.ora listener host is not the current host.
After checking, the listener.ora listener host is incorrectly filled in
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hellow)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
After changing to the current host name, restart the listener to resume normal.
Read More:
- [Solved] eggjs Error: Warning: Current Server Discovery and Monitoring engine is deprecated, and will be rem…
- [Solved] lightdb oracle_fdw Error: ERROR: error connecting to Oracle: OCIEnvCreate failed to create environment handle
- Oracle Start as DBA Error [How to Solve]
- Oracle 12.2.0.1 opatch lsinventory Error: LsInventorySession failed: RawInventory gets null OracleHomeInfo
- Oracle Database Cannot Open mount Mode Error: ORA-01102
- ORA-12505 error when java connects to oracle database
- [Solved] Oracle Delete the Archive Error: RMAN-08137
- [Solved] Navicat Connect Error: Oracle library is not loaded.
- [Solved] ora 01033 linux,ORA-01033: ORACLE initialization or shutdown in progres
- Oracle VM VirtualBox open replication virtual machine Error
- Oracle prompt text does not match format string
- PLSQL even oracle11g problem on 64-bit machine: SQL*Net not properly installed and ORA-12154:TNS: cannot handle service name
- Oracle18c Error: ORA-12012: error on auto execute of job
- [Solved] Oracle 18C RAC Install Error: Error in invoking target ‘irman ioracle idrdactl idrdalsnr idrdaproc‘ of makefile
- How to Fix TNS 12560 Error
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- [Solved] Mycat Startup Error: ERROR Startup failed: Timed out waiting for a signal from the JVM
- [Solved] Pre requisite check “checksystemcommandavailable” failed
- Weblogic Start Error: weblogic.management.DeploymentException: weblogic.management.DeploymentException:
- [Solved] MinIO Start Error: “WARNING: Console endpoint is listening on a dynamic port…”