I only have SQL Developer installed. What other programs do I need to install to create a local database. Please provide links.
3
-
2You'd need to download and install the Oracle database. There are multiple versions and editions that you could download from the OTN site (the same place that you, presumably, downloaded SQL Developer from). You could, for example, grab the express edition of 11.2. Or the enterprise edition of 12.1.Justin Cave– Justin Cave2015-04-30 16:11:35 +00:00Commented Apr 30, 2015 at 16:11
-
1I talk about this here thatjeffsmith.com/archive/2012/12/…thatjeffsmith– thatjeffsmith2015-04-30 16:56:01 +00:00Commented Apr 30, 2015 at 16:56
-
I have installed XE 11.2. I set up a workspace with a workspace name and username and password. I don't know what to enter for the Connection Name in SQL Developer.Pie– Pie2015-04-30 17:15:56 +00:00Commented Apr 30, 2015 at 17:15
Add a comment
|
2 Answers
SQL Developer is a client that access to a database server to extract data.
You need a database server.
If you operate with SQLDeveloper probably you like to install Oracle. There is a simplified version of Oracle that is called Oracle-XE. Search it over google and download the right version for your operating system.
answered Apr 30, 2015 at 16:12
Davide Lorenzo MARINO
27k4 gold badges44 silver badges58 bronze badges
5 Comments
Pie
Ya I have Oracle XE 11-g version 2. Creat local database still isnt showing up.
Davide Lorenzo MARINO
Is your database running? Check it. You have to manually start it if it is not a service that starts automatically when your pc is switched on. You can test it with a telnet call on the database port something like: telnet 127.0.0.1 1521 or similar
Davide Lorenzo MARINO
So it is not present in your pc.
Pie
can you provide a link to what I need to download please oracle.com/technetwork/database/database-technologies/…
Pie
I'm able to access 127.0.0.1:8080/apex/f?p=4500:1000:2405754666672024::::: which is the Oracle database web application. I made a workspace and user and such.
Give the username and password of the user you created. You can specify localhost in Host name. If you haven't modified the port on which Oracle works then give 1521. If you haven't changed SID as well then give XE. You might be able to connect with DB.
