Problem with connection to Oracle Server Enterprise 11g

Dancko

Hi to all

I have a problem to connect to oracle server enterprise edition 11g 64bit.

On my pc I have installed oracle Oracle Client 10g 32bit.

I want connect to oracle server enterprise edition 11g on remote machine.

1. With SQL Developer I connect to oracle server enterprise edition 11g without any problem.
2. With SQL Plus I do not connect to oracle server enterprise edition 11g and i get this error message: ora-12170 tns connect timeout occurred
3. With TOAD for Oracle I do not connect to oracle server enterprise edition 11g and i get this error message: ora-01017 invalid username/password logon denied-

        TNSNames.ora configuration is ok!

Can any one tell me why I get the errors 2) and 3) and how to resolve them?

Regards.

Unknown

http://www.orafaq.com/forum/t/196549/

Hemant K Chitale

It would seem that sqlplus and toad are using two different oracle clients / tnsnames.ora files   Note that toad can also be used to bypass the tnsnames.ora file and directly specify hostname portnumber service name  (and also sqlplus with ezconnect !).  So check how your connections are configured.

If you are getting an invalid username/password check if the username/password are correct, check if the password is case sensitive, check if the connection request is going to some other database !

Hemant K Chitale

Geert Gruwez

you can see what location is used for sqlplus by running a tnsping command

> tnsping database_alias

this should display the network folder user for the tns

Srinivasan S

From SQL Developer also you can connect using TNS Alias, try it out and check your getting the same error.

12cdb

Hi,

>> With SQL Plus I do not connect to oracle server enterprise edition 11g and i get this error message: ora-12170 tns connect timeout occurred

You are trying to connect 32bit SQL Plus with 64 bits database?

I am not aware but it should work. Did you check any compatibility issue with Oracle support portal ?

HTH,

Pradeep

EdStevens

12cdb wrote:

Hi,
>> With SQL Plus I do not connect to oracle server enterprise edition 11g and i get this error message: ora-12170 tns connect timeout occurred
You are trying to connect 32bit SQL Plus with 64 bits database?
I am not aware but it should work. Did you check any compatibility issue with Oracle support portal ?

HTH,
Pradeep

Why wouldn't it work?  It's a network connection.  bit architecture is not involved.  That only comes into play when you have one process making an inter process call to another process on the same hardware.  I have 32-bit clients calling 64-bit databases all day, every day.

And if that WERE the problem, you'd see different errors - not network timeouts and invalid username/password.

Hemant K Chitale

You are trying to connect 32bit SQL Plus with 64 bits database?

I am not aware but it should work. Did you check any compatibility issue with Oracle support portal ?

64bit servers were introduced many years ago.  Client desktops have been (and many still are) 32bit.  Client-Server applications wouldn't have worked if 32bit clients couldn't talk to 64bit servers.

Hemant K Chitale