TNS-12538: TNS:no such protocol adapter
658586Sep 15 2008 — edited Sep 16 2008hi, i'm a newbie for oracle... now I face some problem while i try to create database.
After i installed Oracle 10g on Solaris 10x86-64, I created listener.ora by using netca.
but I cannot start it. error shown as
$ lsnrctl start
TNSLSNR for Solaris: Version 10.2.0.3.0 - Production
System parameter file is /oracle/ZTDB3/bin/oracle10/product/10.2.0/network/admin/listener.ora
Log messages written to /oracle/ZTDB3/bin/oracle10/product/10.2.0/network/log/listener.log
TNS-01150: The address of the specified listener name is incorrect
TNS-01153: Failed to process string: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.131.92)(PORT=1524)))
Listener failed to start. See the error message(s) above...
$ lsnrctl status
LSNRCTL for Solaris: Version 10.2.0.3.0 - Production on 12-SEP-2008 10:05:30
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.104.131.92)(PORT=1524)))
TNS-12538: TNS:no such protocol adapter
TNS-12560: TNS:protocol adapter error
TNS-00508: No such protocol adapter
how can I fix this problem? also I cannot sqlplus / as sysdba
error shown as
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Fri Sep 12 10:28:56 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12157: TNS:internal network communication error
please help me...thank you.