problems connecting to a remote db on my network

[sweetleaf]

Hi

the dba at a remote office has emailed me the tns entry to use to connect to his remote db (instead of providing an ip for host i'm using an alias).

I've copied the entry into my tnsnames file, am using the username and pwd he has created for me but am still having problems.

When i try to connect i get "invalid username/pwd; logon denied". Are we missing a step - does something else need to be done here for me to be able to connect to the remote db (we're on the same network)?

Thanks!

 

[Turkbear]

Hi,
The message indicates that you are reaching an Oracle database instance, so either the username and/or password are wrong, or the tnsnames entry is connecting to the wrong instance..use the IP address, not an alias to test.
Or run tnsping ...

 

[sweetleaf]

thanks for that Turkbear!

maybe a real elementary question but how do i run tnsping?

thanks

 

[SantaMufasa]

Sweetleaf,

"tnsping" is a program that comes with the rest of your Oracle installation. It should reside in your %ORACLE_HOME%\bin (example: "c:\Oracle\Ora81\bin"). From your OS prompt, you can then say:

tnsping <tns_alias_name>

Here is an example of my running tnsping on my client, checking for an Oracle instance with tns alias, "FOS":

D:\oracle\ora92\bin>tnsping fos

TNS Ping Utility for 32-bit Windows: Version 9.2.0.4.0 - Production on 23-JUN-20
04 10:51:41

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
D:\Oracle\Ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 4256) (ADDRESS = (PROTOCOL = TCP)(Host = foster)(Port = 1521)) (CONNECT_DATA = (SERVICE_NAME = FOS9204)))
OK (1060 msec)

In addition to tnsping's confirming the connection information to the target, the result at the bottom is "OK (1060 msec)", which tells you that it successfully connected to "FOS" in just over 1 second.

Mufasa
(aka Dave of Sandy, Utah, USA @ 17:57 (23Jun04) UTC (aka "GMT" and "Zulu"), 10:57 (23Jun04) Mountain Time)

 

[sweetleaf]

my apologies,

the dba at the remote site had sent the incorrect user/pwd afterall.

but another interesting issue has presented itself:

using sql plus I get in no problems. but when i try to connect using SQL Navigator v4 (by Quest Software) i get the following oracle error:

"Session Manager: Oracle Version not supported
..Make sure connection parameters are correct and try again"

I don't see why not but does anyone know if sql-nav v4 cannot be used with the oracle 9.1.2 client?

Thanks

 

[Turkbear]

Hi,
Not sure..check Quest's site for help

http://www.quests.com/sql_navigator/

But it appears the v4.4 does support Oracle v9

 

[sem]

Is it possible that the tool uses Oracle libraries of older version installed in another home?

Regards, Dima

http://seminihin.narod.ru