ORA-12154 error: TNS couldn't resolve the service name

[silvia23]

Hello!
I'm installed Oracle 8.1.7 Enterprise Edition on my pc with Windows NT. I can declare services and when I connect with sql*plus using username/pwd@servicename all works ok. But when I declare an ODBC alias to access Oracle database the ORA-12154 appears.
My tnsnames.ora,sql.net and listener.ora files are as follow:


# TNSNAMES.ORA Network Configuration File: D:\ORANT\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ACCESOBDORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = spi63197)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BDOracle.Eadscasa)
)
)

BDORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 155.1.100.181)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BDOracle.Eadscasa)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = spi63197)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = BDOracle.Eadscasa)
(PRESENTATION =

http://admin)

)
)

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

# SQLNET.ORA Network Configuration File: D:\ORANT\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

NAME.DEFAULT_ZONE = world

NAMES.DEFAULT_DOMAIN = Eadscasa

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME, CDS, NDS, NIS)

SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf

NAMES.PREFERRED_SERVERS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=spi63197)(port=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=spi63197)(PORT=1521)))

# LISTENER.ORA Network Configuration File: D:\ORANT\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = spi63197)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\ORANT)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = BDOracle.Eadscasa)
(ORACLE_HOME = D:\ORANT)
(SID_NAME = BDOracle)
)
)

Any idea about what is wrong ? Thanks a lot,
Silvia

 

[phtoulouse]

hi Silvia

Oracle Error Code = 12154 ORA-12154: TNS:could not resolve service name
If you verify that your Oracle client can connect via SQLPlus you will need to change your TNSNAMES.ORA file to point to the IP address of the Oracle server rather than the Domain Name. Try this.