| ORA-12154 [message #109135] |
Tue, 22 February 2005 08:53 |
swe029
Messages: 1
Registered: February 2005
|
Junior Member |
|
|
I'm trying to use TOAD version 6.3.11.1 g on Windows platform with Oracle 10 g database. However when I try to login to the database from TOAD I get an ORA-12154: TNS: could not resolve connect identifier specified.
Following are the contents of my tnsnames.ora, sqlnet.ora and listener.ora files.
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
MATCH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = arab6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = match.test)
)
)
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# listener.ora Network Configuration File: D:\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 = D:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = arab6)(PORT = 1521))
)
)
)
Could someone help me?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
