hi i instaled oracle 10g

Submitted by manns on Tue, 2006-12-19 09:23.

hi
i instaled oracle 10g express & orcale 6i
both are woking fine seperatly but when i try to connect 10g from 6i
the sql prompt is automatically gets closed
in tnsnames.ora of 6i i configerd as below

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

please explain how can i connect 10g from 6i
thanks
Manju

»

you have not mentioned sid in tnsnames code,

Submitted by nabbu on Sun, 2006-12-31 01:27.

Manju ,perhaps, this may solve your problem .

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
(sid=global db sid name )
)

thanks.

»