Home » Developer & Programmer » Forms » disappear XE database
disappear XE database [message #634294] Sat, 07 March 2015 02:03 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
hi all,
I installed first oracle database Express 11g and then installed plsql developer 9.
when run plsql developer in login page section database have 'XE'
but after install developer suite 10g,in login page of plsql developer,database section not have 'XE'.
why?

Sorry I do not know English well!
Re: disappear XE database [message #634299 is a reply to message #634294] Sat, 07 March 2015 02:34 Go to previous messageGo to next message
John Watson
Messages: 8309
Registered: January 2010
Location: Global Village
Senior Member
PL/SQL Developer is not an Oracle product. Some people here may know how to configure it with a database connection, but you might get faster response if you go to the product's support site.

[Updated on: Sat, 07 March 2015 02:35]

Report message to a moderator

Re: disappear XE database [message #634304 is a reply to message #634294] Sat, 07 March 2015 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think you have to search in the former installation a file name tnsnames.ora and copy it in the new installation directory.

Re: disappear XE database [message #634308 is a reply to message #634304] Sat, 07 March 2015 03:29 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
thanks ok,solved.
plsql developer connected but form builder not connect.
In connect page(form builder) i enter User Name:sys,password:....,Database:XE but when click connect button show error :
ORA-12154:TNS:could not resolve the connect identifier specified.
why?
Re: disappear XE database [message #634312 is a reply to message #634308] Sat, 07 March 2015 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Tell us how you solved your problem.

See my previous post, same thing.

Re: disappear XE database [message #634314 is a reply to message #634312] Sat, 07 March 2015 04:18 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
I first install oracle express 11g and copy tnsnames.ora file.then install developer suite and paste tnsnames.ora!
your previous post,where is it?
Please help me.
What form builder 10g connect to the database XE?
Re: disappear XE database [message #634317 is a reply to message #634314] Sat, 07 March 2015 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 67283
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It also must have a tnsnames.ora in its home.

Re: disappear XE database [message #634318 is a reply to message #634317] Sat, 07 March 2015 04:43 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
yes,in home oracle developer suite have a tnsnames.ora that no diffrent contents....
What can I do?
Re: disappear XE database [message #634322 is a reply to message #634318] Sat, 07 March 2015 10:54 Go to previous messageGo to next message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I prefer using TNS_ADMIN environment variable which points to a single TNSNAMES.ORA file, and maintain all databases I connect to within that TNSNAMES.ORA. See this message in "TNS admin method" topic.
Re: disappear XE database [message #634323 is a reply to message #634322] Sat, 07 March 2015 12:12 Go to previous message
hahaie
Messages: 194
Registered: May 2014
Senior Member
thanks
Previous Topic: How to disable menu item in default forms menu
Next Topic: Form with Multiple canvases
Goto Forum:
  


Current Time: Mon Aug 03 06:28:12 CDT 2020