RE: Problem with tnsnames on multiple version box

My guess is that you do not connect to the expected DB ... ;-) So there is still a problem in your config files. I would stop the listener on the local box, keep only one tnsnames.ora file ( rename the other ), leave only one entry in this file, and try to connect to this service.

What happens now ?

> ----------
> From: Cherie_Machler_at_gelco.com[SMTP:Cherie_Machler_at_gelco.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, August 23, 2000 16:13
> To: Multiple recipients of list ORACLE-L
> Subject: Problem with tnsnames on multiple version box
>
> I have three versions of software on each of several boxes. I have three
> separate tnsnames and listener files
> (one for each version). All of the databases for each level use the same
> port.
> So databases use port 1521, 1523,
> or 1525 depending on what software level they're at.
>
> I've got a database on a box where I can log into it with the SYS password
> directly on the box, I can log onto it
> using the SYS password over SQLNET using the sqlplus command sqlplus
> sys_at_DWTST01
> directly on the
> box. So far so good.
>
> Then I went over to one of the other boxes and put the correct entry in
> the
> tnsnames.ora and listener.ora files
> and then try to connect via SQLNET using the same sqlplus command
> sys_at_DWTST01.
> I get an ORA-01017: invalid username/password; logon denied error.
> What's the
> deal with this. I'm used to tns errors and SID not resolved
> errors but I don't know how to fix this.
>
> I've already verified the syntax in the tnsnames.ora and listener.ora
> files, the
> host name, the port number.
>
> Any ideas?
>
> Cherie
>
>
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Aug 23 2000 - 09:24:13 CDT