can not connect to database: TNS-12538: TNS:no such protocol adapter

Hello,

I'm trying to connect to my database service name : orcl in command line, but I got an error:

Q1
=====================================================
C:\>sqlplus system/dba123@orcl

Message 133 not found; product=SQLPlus; facility=SP2
: Release 9.0.1.4.0 - Production on Thu Mar 16 16:02:49 2006

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-12538: TNS:no such protocol adapter
======================================================

If I do tnsping orcl:
the error is:

Q2
======================================================
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =mypcname.mydomanname)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = o
rcl)))
TNS-12538: TNS:no such protocol adapter
======================================================

My tnsnames.ora file is :
================================================
# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =mypcanme.mydomainname)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
==============================================

So there is a service name called : orcl

My listener.ora file is :

================================================
# listener.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mypcanme.mydomainname)(PORT = 1521))
)
)
)
=======================================================

Q3
Before set up oracle_home variable, I can log into sqlplus by using in command line.

user name: sys as sysdba ; password : dba123, But after I set oracle_home variable: I got an error when I tried log into sqlplus:(I still can log into the sqlplus from sqlplus interface though)


==========================================
ERROR:
ORA-12538: TNS:no such protocol adapter
=========================================

My pc os is windows xp and has oracl10g and htmldb2.0 installed.

Thanks so much for replying my above three questions,
Emily
Start Free Trial