OraFAQ Forum: General » connection with 10g

Home » Other » General » connection with 10g

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

connection with 10g [message #210133]

Tue, 19 December 2006 09:26

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

Report message to a moderator

Re: connection with 10g [message #210143 is a reply to message #210133]

Tue, 19 December 2006 10:26

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

Report message to a moderator

Re: connection with 10g [message #210148 is a reply to message #210133]

Tue, 19 December 2006 11:02

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

Report message to a moderator

Re: connection with 10g [message #210177 is a reply to message #210148]

Tue, 19 December 2006 15:53

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: connection with 10g [message #327074 is a reply to message #210177]

Fri, 13 June 2008 11:48

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.

Report message to a moderator

Re: connection with 10g [message #331556 is a reply to message #327074]

Fri, 04 July 2008 00:21

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Previous Topic:	Generating Load with Swingbench
Next Topic:	REAL TIME PROJECT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:55:03 CDT 2024