ORA-12535 & ORA-12514

From: Franky Thiel <franky.thiel_at_infohos.be>
Date: Tue, 2 Jul 2002 16:32:55 +0200
Message-ID: <3d21b997$0$8135$ba620e4c@news.skynet.be>

I want to connect to a Oracle 8i database (8.1.7.3) (Windows 2000) from my client.

The database is not installed in my domain. I want to connect to that database using Sqlplus.

Connecting to another Oracle database in our domain is not a problem, connecting to the other one gives me the error ORA-12535 - time out.

The connect_timeout_listener_name in the listener.ora is set to 0.

tnsnames.ora :

DB1.WORLD =
(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = db1.WORLD)

)

Listener.ora

LISTENER =
(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521)(connect_timeout_listener=0))

)

Any idea what's wrong?

Thanks,

Franky Received on Tue Jul 02 2002 - 09:32:55 CDT