The error when connected was the famous ORA 12514 can not resolve service name.

I have checked few more things and :


- In init file for the DB I have the pb, there is a line with :

service_names = [service].[server's name]
This is the raison why I can not connect if I specify only "service" in my tnsnames.ora.

I guess this is new to 8I.


- by the way, if I change my tnsnames.ora to following, then it works ( with SID instead of SERVICE_NAME).
DB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
)
(CONNECT_DATA =
(SID =DB2.server2)
)
)

- Still, I do not know why my server's name is not indicated by itself when using the assistant. I will leave it like this as I can not check everything ( rights on the servers and so on...)

Thanks.