869949 wrote:The alias name being different is exactly the point. The alias name is what ora-12154 is all about.
You are a star!! That worked.
I would've thought that this was doing the same thing (albeit the alias name is different).
Can I ask what I did wrong please? I'm eager to learn :)
(CONNECT_DATA = (SERVICE_NAME = XE)
(HS = OK))
BrianGee wrote:so "XE" is valid & working tnsalias that should be used in your connection string; no more ORA-12154 error
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 4 19:02:11 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
scott/tiger@XE is not a valid username/password. I dont have this user on my database so I logged in as system.