-
10g & 11g clients acting differently
I have a local 10g database server.
For clients I have both 10g and 11g, which are both needed for application testing.
If I enter username/password to log in from the 10g SQL Plus client it is smart enough to know that I mean the only Oracle server running on my machine and connects.
If I enter username/password to log in from the 11g SQL Plus client it fails to connect w an ORA-12560 error. I need to enter the service name specified in TNSNAMES to access the db.
How can I get my 11g client to connect to the server without having to specify the service name?
Thanks
-mcslain
-
you need to specify the service name
-
is there an explanation as to why if i can not do this? i would like to understand the limitation...
-
You can also try setting ORACLE_SID and possibly TWO_TASK.
Somewhere in Morgantown, WV there is a couch burning!!!
Go ears!!!
-
-
looks like adding the ORACLE_SID as a windows system var is doing the trick. thanks for all the helpful suggestions... especially to gandolf who nailed it, and who also thinks burning couches is funny. (cause it is)
-
Originally Posted by mcslain
looks like adding the ORACLE_SID as a windows system var is doing the trick. thanks for all the helpful suggestions... especially to gandolf who nailed it, and who also thinks burning couches is funny. (cause it is)
I only mention it because my bother in law went to WVU.
Glad to see you resolved your issue.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|