Re: Problem with tnsnames on multiple version box

Why did you put the entry in the listener.ora on the same box that you updated the tnsnames.ora file on? Or did I mis-read?

You should have updated the listener.ora file on the computer that has the database you want to log into. Start up that listener. Telnet to the other computer, update it's tnsnames.ora, then sqlplus username/password_at_dbalias

HTH
Lyall Barbour

At 06:13 AM 8/23/00 -0800, you wrote:
>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:10:36 CDT