Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

where can we download oracle database along with its GUI tools?

 
Rajiv KumarRai
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Where can we download oracle database along with its GUI tools?

Thanks
 
K. Tsang
Bartender
Posts: 3583
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Download for Oracle DB surely at the Oracle download site here

For GUI tools, JDeveloper (full Java IDE) here or SQL Developer (for DB/SQL only) here
 
Rajiv KumarRai
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Is Oracle and SQL developer download available at the links given by you
free? Are they full or trial versions?

 
K. Tsang
Bartender
Posts: 3583
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The tools are free. The DB to my understanding, if your purpose is for development then it's free, otherwise a license should be be in order so that support is available.
 
Rajiv KumarRai
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have downloaded the oracle DB 12c version as well as SQL Developer.

But I am not able to understand how to create my own database and create tables
and other database objects

I created a connection through SQL Developer but when I try to use it to connect its
giving the following error

Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID
given in connect descriptor

Vendor code 12505

So please let me know the steps to follow to create a database and execute queries
on it.

Thanks
 
K. Tsang
Bartender
Posts: 3583
16
Android Java
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A database should be created when you install the database software. If your database is remote, ask your sys/db admin for the info.

If you haven't created a database, just installed the software, the Oracle software should have a item to let you create databases.

During the db creation, a SID, user/password (for the db, not the db admin) is created.

Link here tells how to create/ configure 12c db.

 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you're new to Oracle, you might find it easier to start with Oracle Express Edition (XE). This is aimed at developers and gives you the core features of Oracle - the RDBMS, PL/SQL, etc - without a lot of the enterprise stuff that you may not need.
Oracle wrote:
Oracle Database 11g Express Edition (Oracle Database XE) is a free version of the world's most capable relational database. Oracle Database XE is easy to install, easy to manage, and easy to develop with. With Oracle Database XE, you use an intuitive, browser-based interface to administer the database, create tables, views, and other database objects, import, export, and view table data, run queries and SQL scripts, and generate reports.

Oracle XE installs a single database, with a SID of "XE", and it pretty much runs itself, so you don't need to worry about all the DBA stuff unless you really want to. There are plenty of Oracle tutorials on how to get started with Oracle XE. I think Oracle XE plus SQL Developer is a pretty powerful combination for anybody who wants to learn how build applications on top of Oracle.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic