Hi,
I may be asking something silly but I don't see any sql*plus or any GUI kind of interface to connect my Oracle server remotely. I tried SQL Plus but it's a command line interface, don't know what to do with that.
Thanks RC, then how to use 11 g ?
Rishi
2010-09-03 05:37:54
Euh? click the icon "SQL Developer" over "SQL PLus" in your screenshot
RC
2010-09-03 05:56:30
RC, I didn't get any option to set-up id/password. So, I thought scott/tiger should work. But getting "Protocol adapter error".
Rishi
2010-09-03 06:01:39
See oracle FAQ and read the manual in order to know how to setup.
RC
2010-09-03 06:12:16
Thanks RC. I'll check the documentation.
Rishi
2010-09-03 06:53:40
Protocol Adapter error suggests your client or TNS_NAMEs may not be configured correctly. I always start with SQL*Plus - if you can logon and get SELECT 'x' FROM DUAL working then you know that your desktop can at least see the database.
JulesLt
2010-09-03 10:32:19
A:
pl/sql developer and toad are both decent, but nonfree, Oracle gui clients. If you're going to do a lot of work on packages or stored procs/funcs, one of these will be worth every bit of money you spend.
squirrel sql is an opensource client. There's a squirrel-derived plugin for eclipse called SQL Explorer; it's really good for looking at your data to help get your programs right.
Ollie Jones
2010-09-04 13:12:27