Home » RDBMS Server » Enterprise Manager » client for 10g database
icon5.gif  client for 10g database [message #120583] Fri, 20 May 2005 09:59 Go to next message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
Member
Our developers used the 9i client to access the database. Now that we have upgraded to a 10g database, what would be the recommended tool for developers to access the database? I cannot find a client for 10g. We may go with the web interface but it is quite a bit different than the client the developers are used to.

Thanks
Re: client for 10g database [message #120584 is a reply to message #120583] Fri, 20 May 2005 10:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
is this a development tool you are looking into?
TOAD is widely used.
There is a list of recomendations in http://orafaq.com/tools/index.htm

Anything that the folks are comfortable with.
Oracle has it own set tools , which require a little configuration.
HTMLDB is good.
But i dont think it supports the features developers would like to have.


Re: client for 10g database [message #120585 is a reply to message #120584] Fri, 20 May 2005 10:11 Go to previous messageGo to next message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
Member
Thanks for the response.

They mainly used the tool to browse the schemas and look at data. The 9i client was good for them and was included with our existing license. I am hoping there may be a similar tool with the Oracle toolset. They are used to using the DBA studio and the 9iOEM but not sure there is a similar tool for the 10g database.
Re: client for 10g database [message #120587 is a reply to message #120585] Fri, 20 May 2005 10:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> DBA studio and the 9iOEM
Sure they are supported.
I am a bigtime (and strongly biased) fan of OEM.
The Only GUI tool i ever use is OEM.
To make use of all new features, may be u need to switch to OEM website concept (in 10g). I have not really played around with OEM 10g.

Re: client for 10g database [message #120588 is a reply to message #120587] Fri, 20 May 2005 10:23 Go to previous messageGo to next message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
Member
9ioem is all we need but i cannot get connected to the 10g database with it.
Comes back with the error
' Application requires SELECT ANY DICTIONARY privilege'
I do have this so not sure what else it is looking for.

Re: client for 10g database [message #120591 is a reply to message #120588] Fri, 20 May 2005 10:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Bug.
patchset for 10.1.0.4 should be fixing it.
or
Did you try OEM standalone console / DBA studio standalone
Re: client for 10g database [message #126352 is a reply to message #120588] Mon, 04 July 2005 00:43 Go to previous message
Achchan
Messages: 86
Registered: June 2005
Member
Try OEM Client 10g! It is not on the same CD with Database(As was in 9i) but you can get it seperately.
DB control (web based version) is NOT recommended at all.
PLSQL Developer is another tool that is very amazing for me atleast! http://www.allroundautomations.com/
Just a try about your error when trying to connect using 9i Client to 10g Database: Grant "SELECT ANY DICTIONARY" to public and let me know if it works please!
-Best wishes
Previous Topic: SQL*SCRIPT Jobs in OEM "no output"
Next Topic: Problem with Database Control?
Goto Forum:
  


Current Time: Mon May 23 00:58:38 CDT 2022