Home » RDBMS Server » Networking and Gateways » Could Oracle be the worst RDBMS ever - ORA-12154?
Could Oracle be the worst RDBMS ever - ORA-12154? [message #67041] Wed, 25 June 2003 04:45 Go to next message
DP
Messages: 15
Registered: February 2002
Junior Member
It's official, Oracle is rubbish !

Have just got my tnsnames.ora sorted and can connect from java apps, TOAD and tnsping, yet when I go to connect from SQL Plus or some of my many VB apps that use Oracle, I get a ORA-12154 error.

Grrrrrrrrrr
Re: Could Oracle be the worst RDBMS ever - ORA-12154? [message #67042 is a reply to message #67041] Wed, 25 June 2003 09:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
can't really say that.
we have personally administered around 180 different oracle databases distributed worldwide, serving around 300 + websites and apps and data is cross-driven ( extracted from / loaded into) 
across every other major database vendor.
We never had any major issue with sql*net.

ora-12154 is a very generic issue.
It needs some understanding about oracle.
The issue may be anything from syntax error to sqlnet internals.
MOST frequent one is MISCONFIGURATION of service_name,sid and host.
Note that, oracle 8 uses sid, 8i and 9i service_name.

please post the exact message, we can give a try

Re: Could Oracle be the worst RDBMS ever - ORA-12154? [message #67483 is a reply to message #67042] Thu, 19 August 2004 09:03 Go to previous message
suryakant
Messages: 1
Registered: August 2004
Junior Member
hi
i have some problams in vb6 and oracle91
when i conect ot oracle and vb then
err
-2147467259
ORA-12154:TNS:could not resolve service name

pls help me
Previous Topic: sqlnet
Next Topic: Logging the remote connection Information
Goto Forum:
  


Current Time: Wed May 01 03:06:13 CDT 2024