I have Oracle SQL Developer Installed, Now What?

thatjeffsmith SQL Developer 159 Comments

Tell Others About This Story:

If you’re here because you downloaded a copy of Oracle SQL Developer and now you need help connecting to a database, then you’re in the right place.

I’ll show you what you need to get up and going so you can finish your homework, teach yourself Oracle database, or get ready for that job interview. You’ll need about 30 minutes to set everything up…and about 5 years to become proficient with Oracle πŸ˜‰

Oracle Database come with SQL Developer but SQL Developer doesn’t include a database

If you install Oracle database, it includes a copy of SQL Developer. If you’re running that copy of SQL Developer, please take a second to upgrade now, as it is WAY out of date.

But I’m here to talk to the folks that have downloaded SQL Developer and want to know what to do next.

You’ve got it running. You see this ‘Connection’ dialog, and…

Where am I connecting to, and who as?

You NEED a database

Installing SQL Developer does not give you a database. So you’re going to need to install Oracle and create a database, or connect to a database that is already up and running somewhere. Basically you need to know the following: where is this database, what’s it called, and what port is the listener running on?

The Default Connection properties in SQL Developer

These default settings CAN work, but ONLY if you have installed Oracle Database Express Edition (XE).

Localhost is a network alias for 127.0.0.1 which is an IP address that maps to the ‘local’ machine, or the machine you are reading this blog post on.

The listener is a service that runs on the server and handles connections for the databases on that machine. You can run a database without a listener and you can run a listener without a database, but you can’t connect to a database on a different server unless both that database and listener are up and running. Each listener ‘listens’ on one or more ports, you need to know the port number for each connection. The default port is 1521, but 1522 is often pretty common.

I know all of this sounds very complicated

Oracle is a very sophisticated piece of software. It’s not analogous to downloading a mobile phone app and and using it 10 seconds later. It’s not like installing Office/Access either – it requires services, environment setup, kernel tweaks, etc.

However.

Normally an administrator will setup and install Oracle, create the database, and configure the listener for everyone else to use. They’ll often also setup the connection details for everyone via a ‘TNSNAMES.ORA’ file. This file contains a list of database connection details for folks to browse – kind of like an Oracle database phoneboook.

If someone has given you a TNSNAMES.ORA file, or setup your machine to have access to a TNSNAMES file, then you can just switch to the ‘TNS’ connection type, and use the dropdown to select the database you want to connect to. Then you don’t have to worry about the server names, database names, and the port numbers.

ORCL – that sounds promising! ORCL is the default SID when creating a new database with the Database Creation Assistant (DBCA).

It’s just me, and I need help!

No administrator, no database, no nothing. What do you do?

You have a few options:

  • Buy a copy of Oracle and download, install, and create a database
  • Download and install XE (FREE!)
  • Download, import, and run our Developer Days Hands-on-Lab (FREE!)

If you’re a student (or anyone else) with little to no experience with Oracle, then I recommend the third option.

Oracle Technology Network Developer Day: Hands-on Database Application Development Lab

The OTN lab runs on a A Virtual Box image which contains:

  • 11gR2 Enterprise Edition copy of Oracle
  • a database and listener running for you to connect to
  • lots of demo data for you to play with
  • SQL Developer installed and ready to connect
  • Some browser based labs you can step through to learn Oracle

You download the image, you download and install Virtual Box (also FREE!), then you IMPORT the image you previously downloaded.

You then ‘Start’ the image. It will boot a copy of Oracle Linux, start your database, and all that jazz. You can then start up and run SQL Developer inside the image OR you can connect to the database running on the image using the copy of SQL Developer you installed on your host machine.

Setup Port Forwarding to Make It Easy to Connect From Your Host

When you start the image, it will be assigned an IP address. Depending on what network adapter you select in the image preferences, you may get something that can get out to the internet from your image, something your host machine can see and connect to, or something that kind of just lives out there in a vacuum. You want to avoid the ‘vacuum’ option – unless you’re OK with running SQL Developer inside the Linux image.

Open the Virtual Box image properties and go to the Networking options. We’re going to setup port forwarding. This will tell your machine that anything that happens on port 1521 (the default Oracle Listener port), should just go to the image’s port 1521. So I can connect to ‘localhost’ and it will magically get transferred to the image that is running.

Oracle Virtual Box Port Forwarding 1521 listener database

Now You Just Need a Username and Password

The default passwords on this image are all ‘oracle’ – so you can connect as SYS, HR, or whatever – just use ‘oracle’ as the password. The Linux passowrds are all ‘oracle’ too, so you can login as ‘root’ or as ‘oracle’ in the Linux desktop.

Connect!

Connect as HR to your Oracle database running on the OTN Developer Days Virtual Box image

If you’re connecting to someone else’s database, you need to ask the person that manages that environment to create for you an account. Don’t try to ‘guess’ or ‘figure out’ what the username and password is. Introduce yourself, explain your situation, and ask kindly for access.

This is your first test – can you connect?

I know it’s hard to get started with Oracle. There are however many things we offer to make this easier. You’ll need to do a bit of RTM first though. Once you know what’s required, you will be much more likely to succeed. Of course, if you need help, you know where to find me πŸ™‚

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 159

    1. thatjeffsmith Post
      Author

      Start SQLDev. Create a connection. Enter the connection properties. You’ll need to know where you put the database, what it’s called (XE), the listener port (1521), and your username and password.

      You should prob connect with user SYSTEM which will have the pwd you assigned in the setup.

    1. thatjeffsmith Post
      Author
      1. i dont know ,,what is connection name , and user name and password,
        and its giving error as network adaptor could not connect. please help me

        1. thatjeffsmith Post
          Author
    1. thatjeffsmith Post
      Author
  1. Hi Smith,
    I have successfully imported an xml file into sqldeveloper which contains various databases. Now if i click to open any database it throws back me an error. i.e Vendor error (017176).
    I have not installed any Oracle versions.
    Kindly suggest way to proceed.

    1. thatjeffsmith Post
      Author
  2. How do I solve this problem with my Oracle VM an SQL developer: Status : Failure -Test failed: Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    ?

    1. thatjeffsmith Post
      Author
  3. Jeff,

    I followed the instructions as stated as was still unable to connect to the Developer Days Database. I downloaded SQL Developer to get me experience with Oracle as well as learning SQL.

    I have been trying for several days but have not been able to successfully connect to a database to this point. I have a Mac, I am unsure if this would cause me any trouble. Part of the difficulty has come from finding resources that will instruct me on how to access the sample databases, whether they need to be downloaded or I need to enter a password for them.

    Could you please provide me with any additional information that you feel may be more descriptive in downloading and connecting to a sample database?

    Thank you.

    1. thatjeffsmith Post
      Author
  4. Jeff
    I’ve used SQL Developer before sometime ago.
    Now, I’ve a Windows 10 client and I’m trying to connect after installing and I get this error below:
    An error was encountered performing the requested operation:

    IO Error: The Network Adapter could not establish the connection

    Vendor code 17002
    Apparently, it looks like there is a connection issue with my laptop.

    I looked up the Windows 10 services, to see if I need to bring up the services by going to Control Panel > Admin Tools > Services.
    Here I dont see any services related to Oracle such as Oracle.

    Can you let me knwo what I need to do to be able to connect?

    1. thatjeffsmith Post
      Author

      Did you see the part in this story where I said that SQL Developer doesn’t include a database, and that you’ll need to provide your own? I also included a few options for making that happen with varying degrees of effort…

  5. Hi Jeff,

    I downloaded sql developer on my mac. I downloaded virtual box as well and installed windows server 2012. I downloaded the databases from oracle website and installed them on the virtual box on windows server 2012. When i open sql developer and put in all the required information, i use the ip of the virtual box but i am still receiving the error “the network adapter cannot establish a connection” I NEED HELP PLEASE!! ive been at it for about 2 hours, went through so many videos still no luck.

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author

          I’m suggesting you read the post you commented on, in particular this bit:

          It’s just me, and I need help!

          No administrator, no database, no nothing. What do you do?

          You have a few options:

          + Buy a copy of Oracle and download, install, and create a database
          + Download and install XE (FREE!)
          + Download, import, and run our Developer Days Hands-on-Lab (FREE!)
          If you’re a student (or anyone else) with little to no experience with Oracle, then I recommend the third option.

          It’s a VM that already has linux and Oracle 12c going on it. You just download it, import it to VirtualBox, and hit ‘start’ – then you’re up and running.

          Here’s the link to go get it.

          1. You’re a life saver. Will try it out and give you feedback. I appreciate your time.

          2. thatjeffsmith Post
            Author
  6. Hi
    I have OralceSqlDeveloper 4.0.3 version, and I am not able to create a connection due to I/O adapter network error. and I am not able to find out the tnsname.ora file
    please help me out

    1. thatjeffsmith Post
      Author

      You don’t have a tnsnames.ora file unless you make one or unless someone gave you one? Are either of these true? If so, point to the directory where that file is in your preferences, on the database page.

      Otherwise I/O adapter network errors generally indicate we can’t reach the server/port you have defined in your db connection.

  7. Hi

    I get the following error:

    VT-x/AMD-V hardware acceleration is not available on your system. Your 64-bit guest will fail to detect a 64-bit CPU and will not be able to boot.

    What have I done wrong?

    Thanks

    Tash

    1. thatjeffsmith Post
      Author
      1. Thanks Jeff.

        That did it. I managed to install and run virtual box and I’ve now connected to the database and run some queries from sql developer.

  8. Hi,

    I installed SQL developer recently. when i click on create new connection, it shows the gallery and doesnt give me the actual new connection popup.Whats the problem?

  9. I tried connecting my Oracle 11.2.0.1.0 database instance using sys as sysdba role selected but failed on sqldeveloper with ORA-01017 However i was able to connect to sys user using sqlplus terminal using same password.

    Using command client console using sys user, I tried to create another user with granted CONNECT role on the same database and this user is able to connect successfully using sqldeveloper.

    Earlier, I had been using Oracle XE instance on SQLDeveloper and was successful to connect to XE instance using sys user

    I would like to know what could be a reason for such a behavior on SQLDeveloper.

  10. i had install the sql developer but when i try to click on button’test’to create connexion,a msg appears:Error I/O:the network adapter could not establish the connection.I try to start oracle listener on windows tasks,but i didn’t find any service refers to oracle.

    1. thatjeffsmith Post
      Author

      There’s no database with SQL Developer. You have to have your own database. If you didn’t install the server component and then create a database, you don’t have a database. Hence this post.

  11. Jeff, I’ve installed Oracle Database in a virtual box Windows Server 2012.
    I’ve installed the SqlDeveloper there too.

    I can connect with SqlDeveloper using localhost as hostname. But I wanted to put the name or IP of the windows server. How could i do that?

    I’ve changed the tnsnames.ora and listener.ora. I’ve changed the localhost to the IP of the Win server. But still can use this on SqlDev.

    Any idea?

  12. I installed an SQL developer, but I don’t have a database to connect to. I really only want to practice my skills. Is there any databases out there I can connect to in order to just practice query writing?

    1. thatjeffsmith Post
      Author
  13. I downloaded the SQL developer for my MAC, and i followed through with the instructions for the connections etc but when i tested it out it did not work. Help!!

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author

          So that’s your error message. Now I need to know your connection properties and I need to know about your database. Is this a db you installed, is it from a free vm, is it a work thing?

          1. After downloading SQL developer and running it on my MAC, i clicked for new connection
            Connection name: hr
            Username: hr
            Password: oracle

            SID: orcl

            clicked on test connection and i got the error i told you about.

          2. thatjeffsmith Post
            Author
  14. Hi jeff,
    I have downloaded sql developer and oracle 12c edition, but to unlock HR schema i can’t find my TNSNAME.ORA file. In home directory i searched in Oracle folder, but it is not having much files.
    Please help me to solve this issue, I’m finding it very difficult.

    Thank you.

    1. thatjeffsmith Post
      Author

      you don’t need a tnsnames.ora file to connect to oracle 12c with sql developer

      just define a connection, and give the server address (probably localhost if it’s running on your machine), the port and the Service name for your database (probably ORCL)

      1. Thank you, i connected using system as username,
        i wanted to unlock HR schema from oracle 12c., so i needed TNSNAMES.ora file so that i can have some sample tables installed with it already.
        And is it possible to install both oracle 12c and 11g in my laptop, so that i can try to get connection from 11g.

        1. thatjeffsmith Post
          Author
  15. How is the user id and password passed on from SQL Developer to Oracle Database. Does it use any encryption mechanism or is it sending in plain text?

    1. thatjeffsmith Post
      Author
  16. I want to practice SQL queries but there is no dummy Connection..pLease help me…Please send solution to my mail to [email protected]

    1. thatjeffsmith Post
      Author
  17. Hello Jeff,

    I was able to follow your notes till the second paragraph where you are saying that the default connections work only when we have database installed on our system, and you have provided the link to download the Oracle Database express edition (XE). I couldn’t find the mac version of the oracle database express edition. Could you please help me from here to install a database software and set up connection.
    Thank you,
    Have a good night.

    1. thatjeffsmith Post
      Author

      XE isn’t available for OS X. You’ll need to run a linux or windows VM on your Mac. That’s why I talk about our VirtualBox appliance, which is what i’m running right now on my mac as I type this…

    1. thatjeffsmith Post
      Author
  18. Kadence Buchanan writes articles for – In addition,
    Kadence also writes articles for and. When purchasing a baby parrot, take a look at the size of its parents to know how big the bird will grow
    so that you can know what size the cage needs to be when the bird is completely grown. This can become aggravated to
    result to brain tumor, kidney failure and liver ailment.

  19. Hello Jeff, I know this post is year old.. but I had been trying to connect SQL Developer to oracle on VM (centOS7) for 3 days now.. Tried everything until I tried this link How to properly set up 2 network interfaces in CentOS (running in VirtualBox)?
    After changing one thing here and there it finally worked .. but what so I turned off the NAT configured adapter (with port forwarding as suggested here) and SQL Developer was still able to connecting. However my connection would only work with the host name set to the ip address set for the VM (with the host-only ip set as default gateway)..
    I was wondering if I missed anything as I was hoping localhost would work.
    N.B. localhost is set in listener.ora and tnsnames.ora though

    Thanks

  20. Hey Mr. Jeff i’m back πŸ™‚ please i realy need help, i’m using SQL developer on my mac with the virtual box image and everything works correctly, but now i want to create and manage my own database, does the otn oracle developer comes with a tool like DBCA, if not how can create our database in this case ?

    1. thatjeffsmith Post
      Author

      Why not create a new pluggable db inside the 12c Multitenant database already running in your image?

      If you mean you want to create your own database on your Mac, you cannot as we don’t have Oracle Database for Mac available today. You’ll have to create a Windows or *NIX virtual environment and proceed as normal.

  21. jeff please i need just a clarification i’m a newbie, if i use the virtual box image, and SQL developer on my host machine ( using the forwarding of course ), i will be able to manipulate any database on the SQL DEV. that is on my host machine without any modification on the vm ? , and the SQL queries written on the SQL DEV. ( that is on my host ) will be interpreted by the oracle database of the virtual machine ?

    1. thatjeffsmith Post
      Author
      1. thank u jeff i really appreciate it :), i’ve installed SQL developer on my macbook pro (yosemite os) but it won’t launch, i use jdk 7, does upgrading the JDK will solve the problem ?

        1. nevermind, i was right, when i returned to check the download page of sql developer i found that the version that i’ve downloaded is only compatible with java 8 and above, so upgrading the jdk has solved the problem and sql devloper is now starting correctly, thank u again jeff your article is a life savior.

          1. thatjeffsmith Post
            Author
  22. Hi Jeff,
    I installed virtualbox with SQL Developer installed. My system password was expired and instead of using oracle as password I tried everything else and it locked me out. Using terminal when I log in as sysdba, I get invalid username / password at logon display.

    1. thatjeffsmith Post
      Author
      1. Thank you for your swift response. I had to re-install everything using dimitrisli’s instructions. Here’s the link:
        https://dimitrisli.wordpress.com/2012/08/08/how-to-install-oracle-database-on-mac-os-any-version/
        when I finally logged in to my reinstalled Oracle Day Developer’s SQL Developer; I got a pop up stating that my system password is good for 7 days only. I tried changing it by going to properties and clicking on resetting option but it didn’t work.
        I tried connecting via terminal and entering the following commands
        * SQLPLUS /nolog
        * SQL> conn as sysoper
        * Enter user-name: sys
        * Enter password: oracle
        Connected.
        SQL> alter user system identified by *******
        2
        System responded with 2 after alter statement. I tested my connection and found out that system password didn’t change at all and it is still oracle.
        Kindly accept apologies for my lack of knowledge. Still learning πŸ™‚
        Really appreciate you.
        Regards,
        Shawn —

        1. thatjeffsmith Post
          Author

          once you’re connected, just run this

          alter user hr identified by oracle – that will reset the password to ‘oracle’ and restart your password lifetime countdown

          not sure why you had to re-install ‘everything’ though – the point of the virtualbox image is that we have everything installed and configured for you

          1. Jeff,
            I will try running it this evening and will report back. I think first time when I installed; I was not paying too much attention to details and I guess the password must have expired. On my follow up attempts; I may have locked myself out. Anyhow, trial and error is the name of the game. I appreciate your swift responses and will post upon my progress.

          2. Jeff,
            I ran alter statement and got 2 on the next line. Not sure if that was expected. Is there a way I can verify the timeline of password for a specific table?

    1. thatjeffsmith Post
      Author
  23. hi, i have been trying to connect my Sql developer but i keep getting error 12505, what am i suppose to use as my username and password? is it the same as the one i use for sqlplus?

  24. Hi,

    I have a machine provided by my workplace which already had a sql developer installed when i got it. I want to use it at home for practice but i am unable to create a local connection. Everytime i try to create it using the method you have explained here, i get error which says “Network editor could not establish the connection”. What should i do?

  25. hi ,
    i have some doubt like SID,service name .what are major differ of both . why to use service name only preference by oracle .why not SID . when there are going to stop if the support of SID.i want to know the work flow also..
    thank you..

    1. thatjeffsmith Post
      Author

      SID is the name of your database, SERVICE is the name of the service the listener is using to serve connections to that SID

      in a 12c multitenant world, you have to use SERVICE to connect to a PDB

    1. thatjeffsmith Post
      Author
  26. Hi there, this is a helpful post but HOW in the world do I get Oracle Database Express 11g on a Mac (OSX, Yosemite)? I am trying to learn SQL and I literally have no idea what I’m doing. I just downloaded SQLDeveloper through Oracle and am trying to just understand the very basics, but I can’t since I can’t connect to a database! Help?

    1. thatjeffsmith Post
      Author
  27. I just installed Oracle VM VirtualBox and loaded the image. But when i try to start the DB i am getting this error:

    Failed to open a session for the virtual machine Oracle DB Developer VM.

    VT-x is disabled in the BIOS. (VERR_VMX_MSR_VMXON_DISABLED).

    Result Code: E_FAIL (0x80004005)
    Component: Console
    Interface: IConsole {8ab7c520-2442-4b66-8d74-4ff1e195d2b6}

    how do i fix that?

    1. thatjeffsmith Post
      Author
  28. Hello,
    I have previously installed XE 11g v2 and then I got SQL Developer as well. The problem is that when I try to create a connection my listener doesn’t recognize the SID for XE(I used all default settings: localhost on port 1521 with SID xe). I also tried many other combinations but it’s just not working. I googled my issue and found lots of posts that recquired me to modify some files.ora. My problem is that I don’t know how to make the mods so that it would work in the end.
    Could you please help me out?
    P.S.: Checked if my listener is running at it is.

  29. Hi, i followed the above procedure and installed everything.
    When i am running sql developer and starting the data base its shows warning telling to change password, the present one will expire in 6 days.
    How do i change the password.
    I am not able to create new data bases in sql.

    Thank you.

  30. Hi Jeff

    I am using oracle 12c and I have downloaded virtual box and set up port forwarding whenever trying to connect, it hangs then error message ‘Connection Reset’

    1. thatjeffsmith Post
      Author
  31. Hi,

    I have a question.

    I need to connect my VBA code to Oracle SQL Developer. However I am getting the error as “Provider could not be found”. Can someone let me know how I can find the provider details from the SQL Developer. ?”

    I used the Provider as “ORAOLEDB”. Still I face the same issue

    TIA

  32. Thanks for the awesome steps Jeff! It worked for me
    but i had to use settings as hostname: 127.0.0.1 instead of localhost
    and orcl as “Service Name” instead of SID

    Then it worked perfectly πŸ™‚

  33. Hi!

    When I’m trying to connect with the given parameters, it says that the account is locked. What should I do about it?

    Thanks in advance!:)

    1. thatjeffsmith Post
      Author
    1. thatjeffsmith Post
      Author
  34. Still ridiculous in 2014 to connect from SQL Developer tool to Oracle 11g XE. Maybe that’s why I’m a Senior MS SQL Server DBA and UNIX guy and not an Oracle DBA.

    Saying Oracle is a sophisticated piece of software is an euphemism for confusing and clumsy tools … get real – this the XXI century.

    1. thatjeffsmith Post
      Author
      1. The question was “I have Oracle SQL Developer Installed, Now What?” which coincidentally is the subject of this article of yours.

        However my post was more an outpouring because I do not understand at all (and I suspect I’m not alone here…) that Oracle does a big effort to NOT to simplify things for the ones who just want to try the technology. This is considered to be on purpose.

        Thanks for your reply / kind attention.

        1. thatjeffsmith Post
          Author

          This is considered to be on purpose

          I sure hope not! Our team spends a lot of time, and it’s one of our core missions, to lower the cost of entry to the database – both monetarily and technology/effort-wise.

          I think the best thing for a new person to try is our VirtualBox appliance. It’s basically, download and go.

          Otherwise, installing the database software, creating a database, and configuring connectivity is indeed something that requires a bit of experience to be able to do w/o effort or lots of reading the docs.

  35. I installed oracle database 11g express edition, and also sql developer, and now I can’t make a connection in sql, even though I tried a lot of things I saq on the internet. The test just won’t success. Can you tell me how to make that possible? Thank You

    1. thatjeffsmith Post
      Author
  36. Hi, i’m a student and want to practice sql….. I have downloaded a file from oracle site ‘sql developer’ of nearly 220 mb. but given the options on this very page cannot help me to have a new connection. I would appreciate it if you give me some more options or in very detail explain how to establish a new connection. i cannot find ‘TNSNAMES.ORA’ file in the folder and don’t know where else to find it. Please do help. Thanks in advance.

    1. thatjeffsmith Post
      Author

      You don’t need a TNSNAMES.ORA to connect. Just use the direct connect.

      If you want a TNSNAMES.ORA file, you’ll need to create one using the Network Configuration Assistant – which is part of the full Oracle Client.

    2. But what would be the user name and password…..

      connection : dev
      username: hr
      password: oracle
      connection: basic as opposed to tns

      I get following error while testing with above credentials:

      IO Error: The network adapter could not make establish the connection….

      Any help here…. Please…….:)

      1. thatjeffsmith Post
        Author
  37. I am new to Oracle and keep having error INS-20802…. Oracle Net Configuration Assistant failed.

    I am using Windows 8.1 , Oracle 12c

    Does anyone know what is causing this?
    Thanks

    1. thatjeffsmith Post
      Author
  38. Hi,
    I’m just trying to add a new connection using “HR” as username and “oracle” as password but I’m getting an error:
    Status: Failure -Test failed: ORA-01017: invalid username/password; logon denied

    Could you help me please?

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
  39. Hi – great post πŸ™‚ It might be worth noting though for more recent OTN VMs it appears OEL (at least 6.5) has a firewall inbuilt & blocking the DB port. I was pulling what little hair I have left out trying to get my host SQLDEV to connect to the VM DB. I finally found /system/administration/firewall > Disable that sucker. Cheers

  40. i installed oracle linux 11g on virtual box. i also installed SQL developer, but when i try to create a new connection with credential:
    usrnm:hr
    pass:oracle

    it says: io exception:the network adapter could not establish the connection.
    could you please help me with this?

    thank you in advance

    1. thatjeffsmith Post
      Author
        1. thatjeffsmith Post
          Author
          1. i have installed: Oracle Database 11g Release 2 (11.2.0.1) Software (64-bit) – For unsupported installation.

            how to check the listener on port 1521?

            sorry , i’m new at oracle….: (

          2. thatjeffsmith Post
            Author

            after you install oracle, you have to create a database. you can use ‘dbca’ – database creation assistant to walk you through this.

            However, if you’re new to Oracle, I’d advise you to just use our developer day virtualbox appliance – everything is already setup and you can just concentrate on learning the database basics instead of starting with installation/creation/configuration – which is normally left to seasoned DBAs

  41. This is on Amazon, an RDS database instance, so I don’t have access to the file system. I can’t use the ‘hr’ user, nor the ‘SYS’ user. I think I’m pretty much limited to the one master account user.

    It’s a really easy way to bring up an Oracle instance and works fine connecting via Squirrel or SQL Developer. It’s just limited in some ways, one being that there don’t seem to be any sample tables.

  42. As a followup to my previous post, I was able to work through the SQL developer tutorial without the HR database, but it would still be nice to have some sample data. The HR dataset would be good. I’ll also try loading the other data you’ve suggested.
    thanks

    1. thatjeffsmith Post
      Author
  43. I’m learning PL/SQL using SQL Developer and the Oracle tutorial. It assumes you have the HR database but I’m using an Oracle 11g instance on AWS so I don’t have the HR database. Where can I download it?

    thanks

  44. Jeff,

    I had to download the virtual box. But, still, when I try to connect I get an error: “status: failure – test failed: ORA -28000: The account is locked” with SID: XE, that is the error I get, and tried it with orcl and got a different error, but still can not connect the developer. I have an pc running windows 8.1, connecting through WIFI.
    What next?
    Thanks,
    Mike

    1. thatjeffsmith Post
      Author
      1. I think I might have not set up the virtual box correctly.
        Is there directions anywhere on the Oracle site where it walks you through the process step-by-step?
        Thanks.

        1. thatjeffsmith Post
          Author
  45. A bit of a long shot but maybe you can help with your knowledge of Virtualbox and tns. When I create two virtual machines in on my Macbook pro I can’t tnsping between them it just keeps coming up with ORA-12154: TNS: could not resolve… no matter which adapter I use. I can ssh, scp and ping between them but no tnsping. I know it is not my tnsnames.ora or listener.ora as I can copy them and place them into two VM’s created in WMWare Fusion and load the databases from a data pump export and it works fine in Fusion. The reason however that I want to use Virtualbox is that for RAC labs Virtualbox makes it so much easier with the ability to create shared drives. Anyway just wondered if you had any ideas regarding the internal etc interfaces. Mac laptops do have an issue with bridged adapters on Mac laptops also and it’s been found you need to use NAT.

    Great article by the way!

    1. thatjeffsmith Post
      Author

      >>I can ssh, scp and ping
      Ok, well that tells me you seem to have gotten over the largest hurdle. If the two VM’s can ‘see each other’, then I’m thinking there’s an issue with the listener or sqlnet setups? Are you using IP addresses or machine names?

      The real RAC Attack ninjas out there are Yury and Bjorn. I’d ask one of them for insight.

      1. Hi Jeff, well I thought it could be the listener.ora or tnsnames.ora but I’m 100% sure it isn’t and I’ve added them at the bottom for you to see. As a confirmation as it was driving me crazy I took a data pump export of both databases and literally copied the listener.ora and tnsnames.ora files and pasted them into a vmware fusion setup I had configured and lsnrctl status was totally happy and I could tnsping no problem. Normally I configure the /etc/hosts file or if I am setting up a RAC lab I use dnsmasq, a great little dns server as the scan addresses don’t seem to work with hosts file entries. I am an Oracle fanatic and love the way virtualbox makes shared storage so easy for OCR and the voting disk. On a Macpower book etc using wireless card however there seems to be a bit of an adaptor issue. Firstly a well blogged issue is having to use NAT instead of Bridged as it wont accept bridged. So as it doesn’t like that I used an internal adaptor that it loves for everything, ping, ssh, scp and grid infrastructure for scan, private and priv. The only thing it won’t play with is tns. As I mentioned to I even verified my settings were right by doing a data pump export of both DB’s and copied my tnsnames.ora and listener.ora files and it worked perfectly in VMWare Fusion. So in summary:

        Virutalbox: Love to use and is miles ahead of VMWare Fusion for shared disk allocation for RAC. Can’t use for Bridged connections or for internal adaptors (tns only).

        WMWare Fusion: All adaptors work great for all protocols but heck is it a nightmare for creating shared disks and even when you do you get an annoying message stating Fusion doesn’t support clustering every time you restart VM.

        Any help really appreciated as I love Virtualbox and would love to be able to practice RAC labs more using internal redundancy etc for my grid infrastructure configurations etc.

        db1 host listener

        SID_LIST_LISTENER =
        (SID_LIST =
        (SID_DESC =
        (GLOBAL_DBNAME = fully1)
        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
        (SID_NAME = fully1)
        )
        )

        LISTENER =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
        )

        ADR_BASE_LISTENER = /u01/app/oracle

        db1 tnsnames

        FULLY2 =
        (DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521))
        )
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = fully2)
        )
        )

        FULLY1 =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = fully1)
        )
        )

        db2 host listener

        SID_LIST_LISTENER =
        (SID_LIST =
        (SID_DESC =
        (GLOBAL_DBNAME = fully2)
        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
        (SID_NAME = fully2)
        )
        )

        LISTENER =
        (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521))
        )

        ADR_BASE_LISTENER = /u01/app/oracle

        db2 tnsnames

        FULLY2 =
        (DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521))
        )
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = fully2)
        )
        )

        FULLY1 =
        (DESCRIPTION =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
        )
        (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = fully1)
        )
        )

        1. thatjeffsmith Post
          Author
          1. Hi Jeff, yes I did it’s one of those things with linux I always go straight into /etc/selinux/config and set it to disabled then use chkconfig just encase to keep it off. Also I set up labs a lot and I installed from scratch three times trying it with Virtualbox and the same each time. Repetition is the key I find to learning and I’m on my fifth data guard configuration from scratch on VMWare Fusion and I haven’t had a problem once. Also tried it a couple of times on Solaris in Virtualbox and the same thing happened. It’s a real puzzler and I’d love to get it fixed so I can practice RAC with Virtualbox’s easy to setup external sharable virtual drives. It’s a real puzzler.

          2. David,
            can you please try some things?
            – I assume your SAN DNS-name is “SCAN” (if it is not, please tell us)
            * on all nodes of interest
            1) nslookup db1
            2) nslookup db2
            3) nslookup SCAN
            4) telnet db1 1521
            5) telnet db2 1521
            6) telnet SCAN 1521
            – by these tests you sould know if you can resolve the names (either DNS or /etc/hosts) [test 1-3] and connect (on a network layer) to those [test 4-6].
            With those results we can hunt the problem better.
            Martin

          3. Hi Jeff, Martin, thanks for all your effort. After many many tests I have found that like myself others have experienced the same problem using Virtualbox on a mac. No matter what even with completely disabling the firewall all protocols work, scp, ssh, telnet, ping, tcp, dns etc but tnsping simply wont connect. At the end of the day if you get it to work everytime by scp-ing over tnsnames.ora and listener.ora to another setup and everything else is enabled then it severely limits what it can do. Anyway bit the bullet and bought a great little N54L HP server and now do all my RAC, Data Guard etc labs on that using vsphere to manage it all.

            Thanks again.

            Dave

  46. Hi Jeff, I found your site after I had a good friend at Oracle download the Mac OS X version and send it to me – why ? Because I couldn’t successfully register on the site to download it myself πŸ™

    I really want to use SQL Developer, but I’m on a MacBook Pro (running Mavericks) and designing databases in MS SQL Server (but we don’t have direct access to the server).

    I’m hoping I can create the data model offline, generate the DDL then ship it off to be executed on the server – is this possible ?

    Anyway, awesome tool from what I’ve seen so far.

    Cheers πŸ™‚

    1. thatjeffsmith Post
      Author
      1. The main problem is that I’ve never received an email from Oracle. I tried registering, I tried “forgot password”, both say “an email will be sent” but nothing arrives.

        1. thatjeffsmith Post
          Author

          Is it possible it’s getting trapped in a corporate spam system like Postini? If not, let me know if you used the same email address as I see here for your blog comments so I can see what is happening on our side.

  47. Hey Jeff !

    I installed the VN on my computer and succesfully create my first Database connection by following the steps you explain in this post (Thanks for that !). The Database “HR at 11gR2” already contain some tables like “Countries”, “Departments” and so on. I could train a little bit and create my first tables, but yet i want to create a new Database. What did i have to do ? Create a new Database connection ? I tried it already, but i don t know anything about what connection name, username, password i have to use and which hostname, port and SID i have to enter… I’m really new and a little bit lost in this stuff…

    1. thatjeffsmith Post
      Author

      Creating a new database – the easiest way would be to run DBCA – database creation assistant – from the VM. It will ask you some questions, and when it’s done, you’ll have your 2nd database on the image.

      If you’re just getting started, I would recommend waiting a bit to go and create your own database. Use the one on the image provided to do all of your experimentation πŸ™‚

  48. Hi Jeff,

    I have been trying to connect my SQLdevelper from HOST OS (win 8) connect my Oracle Linux VM (in VirtualBox) where Oracle 11g is installed, but everything fails :'( . I can connect to the oracle db in the guest OS.

    My VM has two adapters, one configured as NAT and the other as HOST-Only.

    Can you please guide me how can I connect my Oracle DB in the VM with SQLDeveloper?

    1. thatjeffsmith Post
      Author

      If your host can see the IP address of the vm, then you’re golden. Getting this to work reliably on Virtual Box used to be a big PITA for me – until I learned a trick: port forwarding. I’ve setup port 1521 on my host to auto-forward to port 1521 on the image via Virtual Box.

      So my connections are to localhost:1521 and Virtual Box auto-forwards those to the listener port on the REL image running.

  49. Help, please. I want to install the latest version of Oracle XE under some version of Linux running in VirtualBox on a Mac (OS X 10.8.5). I’ve spent the last several days trying to do this with Ubuntu, and I’ve been tearing my hair out. I don’t know much about Linux, and I don’t want to know much about it. I just want to get the latest Oracle XE running on my Mac with the ability to interact with it using the Mac version of SQLDeveloper. (I do want to have the Linux desktop occupy the entire screen of my iMac, and I want Oracle to start automatically when I start the Linux OS.) Which available Linux VirtualBox VM do you recommend? If you don’t recommend any, which version of Linux should I install in a VM which will result in the easiest installation of Oracle XE? I will really, really appreciate any advice you can provide.

  50. I have the virtual machine running. When I start SQLDeveloper and try to connect with the parameters shown above, I get a message saying that the TNS listener doesn’t know of the SID “ord”. Help, please.

    1. thatjeffsmith Post
      Author
  51. Hey..I installed Oracle VM Virtual box manager and opened the Oracle developer days image. The image started running and asked me username and password for Enterprise Linux 5. I don’t know this combination of username and password. I tried using my windows credentials. It didn’t work. May I know what should I use?

    Thanks πŸ™‚

    1. thatjeffsmith Post
      Author
  52. I was about to be really happy, you answered my main question with relative ease. Then I realized that Oracle Express does not work on a 64bit version of windows 7. πŸ™

    1. thatjeffsmith Post
      Author

      You can go the Virtual Machine route, otherwise, yes, no can do. The next version will probably be based off 12c and will be x64 only. But I can’t tell you how far away that is from happening.

  53. i owe a macbook pro and i have sql developer installed on it.
    you know i have no database to connect to ..i read some of your articles but i guess i’m failed i getting any connection to any database nor i can connect.!

    one more thing can we connect to a database which is on the other system in my case (its desktop) and a macbook . both are in same network . is this somehow possible?

    1. thatjeffsmith Post
      Author

      You can connect to any system for which you have database/network access to.

      If you want to build your own, I suggest using our Developer Days Hands On Lab. It’s a VirtualBox image you can run on your MBP.

  54. When running Oracle VM VirtualBox Manager and Oracle Developer Days my machine is almost frozen. Every other second hitting 100%. I have lots of diskspace and am running on a Intel Celeron C900
    Is there any point trying to open SQL Developer 3.2 with no performance?

    1. thatjeffsmith Post
      Author

      John, how much physical memory do you have on your machine? I have 8GB of RAM on my machine and I can comfortably run that VM and 3-4 instances of SQL Developer.

      Are you running SQL Developer inside the VM, or from your host OS?

Leave a Reply

Your email address will not be published. Required fields are marked *