OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ora-12535

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-12535 [message #62018]

Fri, 18 June 2004 01:26

Alex
Messages: 190
Registered: August 1999

Senior Member

Hi all!

Situation:

3�Databases:�two 8.1.6�on a w2000-server and one 8.05 on a nt 4.0.-server

One Client 9.2 on a XP.

It's possible for me to connect from the client�to the 8.1. db's, but not to the 8.05. But you can connect from the 8.1. to the 8.05 via dba-studio.

When I connect from the 9.2.-client to the 8.05 I get a ora-12535!

I checked the tnsnames.ora and couldn't find any error!

I can ping all the servers and can also tnsping the 8.05.-db!

How can it be that there is a connect from the 8.1.6 to the 8.05 but not from the client to the 8.05 and why I can make a successful tnsping, but can't connect? And what can I do???

Report message to a moderator

Re: ora-12535 [message #62019 is a reply to message #62018]

Fri, 18 June 2004 03:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. Is there a firewall involved?
2. in the tnsnames.ora file used by 9.2 client

   if
   the entries are like ( to connect 805 Db)
    ..
    ..
     (CONNECT_DATA =
      (SERVICE_NAME = prod805)
    )
    ..
    ..
then
try
     ..
     ..
     )
    (CONNECT_DATA =
      (SID = prod805)
    )
    ..

or vice-versa

Report message to a moderator

Re: ora-12535 [message #62025 is a reply to message #62019]

Sun, 20 June 2004 23:13

Alex
Messages: 190
Registered: August 1999

Senior Member

Thanks for your tip, but we solved the problem.
There IS a firewall, but it was possible to connect over the 8.1.6 db to the 8.0.5 per connection manager!

Report message to a moderator

Previous Topic:	supplied packages,views for a version
Next Topic:	VTADB-10 Error at loggin - Oracle Enterprise Manager Special Privileges!?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:28:58 CDT 2024