Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-12538: TNS:no such protocol adapter

658586Sep 15 2008 — edited Sep 16 2008
hi, 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2008
Added on Sep 15 2008
5 comments
1,687 views