TNS-01197 TNS-12532

TNS-01197 TNS-12532 

Oracle Database Connectivity Errors:  TNS-01197: Listener failed to create the end point:  TNS-12532: TNS:invalid argument

Listener startup issue on AIX

Errors:
TNS-01197: Listener failed to create the end point
TNS-12532: TNS:invalid argument
==========
ORAAIX(oracle)>lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 11-SEP-2021 00:09:03


Starting /u00/app/oracle/product/11.2.0.4/db_2/bin/tnslsnr: please wait…

TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production
System parameter file is /u00/app/oracle/product/11.2.0.4/db_2/network/admin/listener.ora
Trace information written to /u00/app/oracle/diag/clients/user_oracle/host_997396372_80/trace/ora_5898328_1.trc
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORAAIX.xyz.com)(PORT=1521)))
TNS-01197: Listener failed to create the end point
TNS-12532: TNS:invalid argument

Listener failed to start. See the error message(s) above…



ORAAIX(oracle)



troubleshooting
ORAAIX(oracle)>echo $LIBPATH
/u00/app/oracle/product/11.2.0.3/db_1/lib:/usr/tivoli/tsm/client/oracle/bin64:/usr/lib:/lib:/u00/app/oracle/product/11.2.0.3/db_1/rdbms/lib:.
ORAAIX(oracle)>echo $LD_LIBRARY_PATH
/u00/app/oracle/product/11.2.0.4/db_2/lib
ORAAIX(oracle)>

Cause:
LIBPATH value is not set to correct Oracle Home

Action:
export LIBPATH=/u00/app/oracle/product/11.2.0.4/db_2/lib:$LIBPATH

How to avoid this error?
Put the correct value of LIBPATH in .profile