Home » SQL & PL/SQL » Client Tools » How to create complete setup
How to create complete setup [message #549020] Tue, 27 March 2012 09:33 Go to next message
sridb
Messages: 2
Registered: March 2011
Junior Member
Hi Everyone,

I would like to pursue pl/sql developer as my carrier.So I would like to create a setup in the following manner in my windows7(64 bit) laptop.

Since I heard that,In real time the setup will be look like as follows

Windows7 as front end
Toad --> to practice Pl/Sql(Preferred use in windows7)
Solaris OS (To install Oracle 10g in Solaris & practice scripting)
Virtual Box (Open source tool to run both windows and solaris)

Now please let me know How I can create setup so that I can accomplish following things(To gain knowledge in programming/scripting).

1.Both OS has to be run simultaneously with Virtual Box So that
Oracle will be running in backend(Solaris)
2.Practicing Oracle Pl/sql in Toad (Windows7)
3.Practicing shell scripting in Solaris.

Is it possible to create the setup as i mentioned above. If not please give your feedback/comments/suggestions.

Regards,
Srikanth
Re: How to create complete setup [message #549021 is a reply to message #549020] Tue, 27 March 2012 09:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Toad is just a gui tool.
If you know you database concepts, any GUI tool will suffice.
Oracle SQL Developer is free.

Oracle behaves the same in any OS (In a generalized way).
So does Oracle pl/sql.
To learn pl/sql, what you are trying to do is overkill. It would be nice though. But you will
be spending a lot of time worrying about things
that are not immediately pertinent.

I would just install Oracle on windows and use a local GUI tool.
To get a little fancy,
install a linux distribution , Oracle on linux and sql-developer on linux.

[Updated on: Tue, 27 March 2012 09:45]

Report message to a moderator

Re: How to create complete setup [message #549035 is a reply to message #549021] Tue, 27 March 2012 11:19 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
and sql-developer on linux


and sqlplus in Linux. Wink

Regards
Michel
Re: How to create complete setup [message #549068 is a reply to message #549035] Tue, 27 March 2012 23:36 Go to previous messageGo to next message
sridb
Messages: 2
Registered: March 2011
Junior Member
Hi Mahesh,Michel,

Thanks for your reply.

So I am going to install Oracle10g db, Toad/Sql developer(GUI tool) in Solaris OS.

So that I can practice Sql & Pl/Sql concepts as well as scripting.

Please comment.

Regards,
Sri

Re: How to create complete setup [message #549069 is a reply to message #549068] Wed, 28 March 2012 00:17 Go to previous message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I were you: as you use MS Windows 7 (shouldn't be HOME edition!), I'd install Oracle 11g XE database. Nothing else.

Then, bookmark 11g documentation page (Master Book list!) and read:
- Concepts
- 2 day DBA
- SQL*Plus User's Guide and Reference
- SQL Language Reference
- PL/SQL Language Reference

As a tool, use SQL*Plus only. After you finish all those books, you'll understand what Oracle is and how it works. Then, if you wish, install some GUI tool.

As of different operating systems, virtual machines you mention and similar stuff, I'd say that - for a beginner - these would be unnecessary overhead.

Master Book List is comprehensive; it contains everything you need to know. Certainly, there are forums, blogs as well. Welcome to Oracle world!
Previous Topic: Unicode conversion
Next Topic: create database on server
Goto Forum:
  


Current Time: Sun Apr 20 16:28:11 CDT 2014

Total time taken to generate the page: 0.07270 seconds