getting ora error 12154 when trying to login in sqlplus [message #10600] |
Mon, 02 February 2004 20:09 |
sancha
Messages: 31 Registered: October 2003
|
Member |
|
|
Hi all,
I am unable to login into an instance via sqlplus. i get ora 12154 error while trying the same.
But, i am able to work in the same instance using toad without any problems.
I have developer6i installation and oracle workflow installation. so, i have two tnsnames entry one in c:orant.... and the other in c:workflow.....
I have the same entries in both the tnsnames.ora files.
Please let me know how i could solve this problem.
bfn
|
|
|
|
Re: getting ora error 12154 when trying to login in sqlplus [message #10842 is a reply to message #10600] |
Thu, 19 February 2004 23:31 |
Vince
Messages: 11 Registered: December 2000
|
Junior Member |
|
|
hello
i had exactly the same prob, and the prob was that in my TNSNAMES.ORA i had an extension .world
and it's in the sqlnet.ora that it defines the default extension, TOAD doesn't need it.
(you can try sqlplus with the exetension with your domain)
my sqlnet.ora was bad.
if it's can help you this my new sqlnet.ora:
################
# Filename......: sqlnet.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 2147483647
names.default_domain = world
name.default_zone = world
and now it works : )
|
|
|