![]() ![]() That’s because on the VirtualBox Linux appliance, we’ve setup a local port forwarding rule – anything you say to port 1521 on YOUR machine, will go to port 1521 on the Linux VM. Unless you already have Oracle Database installed and listening to port 1521 on your computer, all of your database connections can simply talk to 127.0.0.1:1521 or localhost:1521. ![]() Connecting to the database from SQL Developer/SQLcl on your host machine Using the DBA panel, open your CDB connection to see and manage your pluggable databases. If you want to clone a PDB, then you’ll need to create a SYS-level connection to the CDB and access the DBA – Container Database node. To connect to the database with all the sample data, you’ll want to go in as HR or SYS to the orcl ‘service.’ PDBs are accessible via the service, not the SID. The CDB instance is ‘orclcdb’ and the PDB instance is ‘orcl’. This would be faster probably than re-downloading the OVA file, importing it, etc.įor SQL Developer, you can create a connection to the CDB or the PDB. In either case, you MIGHT want to create a snapshot for the VM first – this will give you a backup of your image you can go back to in case you ever screw it up beyond repair. Or, you could fire up SQL Developer and start mucking around. Well, you could click on the big Start button (yes, that is a picture/button/icon) and launch the Hands-on Labs, pick one and follow the instructions. Your desktop should come up, and will look a little something like this – without the annoying arrows and blocky words I added □ You don’t HAVE to know Linux, but it will help. Logon as oracle/oracle – this is the user that owns the install, the labs, and software. There’s a good tutorial on how to do that here. You’ll want to enable the virtualization technology. Your BIOS is going to need to be updated. “This kernel requires an x86-64 CPU, but only detected an i686 CPU.” ![]() Oracle Enterprise Linux 6 is booting up! If you see this error… You’ll know you’re good if you see this screen. Select the vm in the manager and hit the ‘Start’ button. This will take a few minutes – or however fast you can write out those 2 huge files, ~= 12GB. I’ve switched mine over to my D: partition. Make sure that drive is ‘fast’, has contiguous blocks available (defrag first if necessary), and enough space. If you have it, bump the memory up to 4GB.Īlso, the OS ‘disks’ are by default going to be sitting on your C: drive. Remember, we’re running Oracle Database 19c, on a Linux image, plus you’ll be running a browser, and probably SQL Developer, or the Modeler, or APEX, or all of those. ![]() The image requires at least 1 GB of RAM to run. There are two that I want you to take a look at before just saying ‘Yes’ to everything: Have lots of memory? It’s OK to be greedy… Next you’ll be prompted to approve of the VM settings. OVA file you’ve just downloaded – Screenshot from 2014…it’s slightly larger now, but same process. The virtual machine has already been created, you just need to ‘suck it into’ VirtualBox via the Import feature. You’ll get the Oracle VM VirtualBox Manager on your screen, and then you’ll want to IMPORT an appliance. An aside, if you already have VMWare’s VM Player, that should also work, but that’s between you and VMWare.Īre you ready to get started? Awesome. You’ll need to go download and install VirtualBox first. And it runs on any OS, including Windows, Macs, and *NIX. The virtualization software is VirtualBox – that’s free. No need to create anything, just download, import, and run a fully functional Oracle Database, complete with sample data and hands on labs.Įverything you need to get started with Oracle Database. If you’re looking for an already configured Oracle Database 19 c environment with a database already setup and all the software you need to learn database programming, design, and administration concepts, then look no further! Updated February 2021: I’ve updated this post to reflect the newest edition of this VirtualBox Appliance. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |