Home » Other » General » connection with 10g
connection with 10g [message #210133] Tue, 19 December 2006 09:26 Go to next message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

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
Re: connection with 10g [message #210143 is a reply to message #210133] Tue, 19 December 2006 10:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

during connection your getting any error.

if yes plz. post here.

regards
Taj
Re: connection with 10g [message #210148 is a reply to message #210133] Tue, 19 December 2006 11:02 Go to previous messageGo to next message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

Hi,
As specified earlier there is no error message shown up.
The Sqlplus is getting closed while trying to login
and same screen shot has been attached. pls find the attachment

Thanks & regards,
Manju
Re: connection with 10g [message #210177 is a reply to message #210148] Tue, 19 December 2006 15:53 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no attachment in your message.

Are you trying to run SQL*Plus by selecting its icon? If so, and in order to help us help you, try to enter SQL*Plus from the command prompt of your operating system.

It *should* not close and vanish without a trace. So, when (if) you get it, post the whole output here.
Re: connection with 10g [message #327074 is a reply to message #210177] Fri, 13 June 2008 11:48 Go to previous messageGo to next message
sameh_riad
Messages: 4
Registered: June 2008
Junior Member
Actually I am facing the same problem.

But if you connect from the forms rather than the pl/sql you might get one of the following errors, either two way fatal communication error, or connect failed because target host or object does not exist.

From what I found on metalink if you search for 6i and XE that the most probable reason is that XE default character set is AL32UTF8 and Developer 6i does not support that.

I tried changing the XE database character set but with no Use, it always gives me the error, the character set must be a subset of the original character set.

Someone suggested downloading the European version of XE that I believe will have the Character set that Developer 6i will support but unfortunately i want to be able to store arabic in my database.

So if someone finds a solution to changing the XE character set to AR8MSWIN1256 please let me know.

Regards,

Sameh.
Re: connection with 10g [message #331556 is a reply to message #327074] Fri, 04 July 2008 00:21 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search for this problem in the Forms forum by looking for 'tnsnames.ora'.

It is probably due to having two or more copies of 'tnsnames.ora' on your PC and they contain different information.

David
Previous Topic: Generating Load with Swingbench
Next Topic: REAL TIME PROJECT
Goto Forum:
  


Current Time: Thu Dec 08 02:00:25 CST 2016

Total time taken to generate the page: 0.05148 seconds