http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
Virtualbox 5.2.8 or above
for performance use 3GB RAM 2 CPU
New ish:
rest enabled sql
rest enabled jdbc sql username/password@http://...(to ORDS)
+18.1 ORDS SQLDeveloper SQLCL modeller APEX
Oracle Linux 7 update5 (yum updated from 7u3 iso)
executables now under applications->other
(only .txt and .html can be easily clicked on desktop with no popups)
readme.txt and readmeCopy.txt - the same - one sometimes gets half hidden in icon layout.
errata
Same as last release + more recent software
any requests/what does not work let me know in the comments.
Virtualbox 5.2.8 or above
for performance use 3GB RAM 2 CPU
New ish:
rest enabled sql
rest enabled jdbc sql username/password@http://...(to ORDS)
+18.1 ORDS SQLDeveloper SQLCL modeller APEX
Oracle Linux 7 update5 (yum updated from 7u3 iso)
executables now under applications->other
(only .txt and .html can be easily clicked on desktop with no popups)
readme.txt and readmeCopy.txt - the same - one sometimes gets half hidden in icon layout.
errata
Same as last release + more recent software
any requests/what does not work let me know in the comments.
11 comments:
Problem with java 8u161 with sqldeveloper on Linux. 8u152 being tried. Reports suggested javaFX related, and turn off splash/welcome screen helps. Turn off splash/welcome screen checkbox sometimes hidden but still works.
Try in the VM as oracle user
(Watch newlines and quotes, one line starting cd next line starting cp next line starting cat quotes are both simple single quotes (some editors/email/OS change them to prettier useless quotes). (The setting (to my limited knowledge) unsets a graphical optimization - i.e. no change to sqldeveloper java code))
#!/bin/bash
cd ~
cp /home/oracle/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf /home/oracle/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf.SAV
cat /home/oracle/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf.SAV | sed 'sZsun.java2d.ddoffscreen=falseZsun.java2d.ddoffscreen=false\nAddVMOption -Dsun.java2d.xrender=falseZg' > /home/oracle/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
About the icons - something like :
You need to cp the .desktop files to ~/Desktop
cp /home/oracle/.local/share/applications/*.desktop ~/Desktop
run the commands below
cd ~/Desktop
dbus-launch gio set "Rest Client.desktop" "metadata::trusted" yes
dbus-launch gio set "SQL Developer.desktop" "metadata::trusted" yes
dbus-launch gio set "Oracle-datamodeler.desktop" "metadata::trusted" yes
dbus-launch gio set "Click here to Start.desktop" "metadata::trusted" yes
dbus-launch gio set "sql.desktop" "metadata::trusted" yes
restart the VM sudo shutdown -r now
Could do this (to stop yum and packagekitd being in conflict (and reboot))
[need confirmation for this]
sudo /bin/systemctl disable packagekitd
sudo /sbin/shutdown -r now
Seems pretty persistent one site suggested:
sudo systemctl mask packagekit.service
Hi Michael & rakotomandimby ,
Dbca and the assistants are removed for space reasons.
With updated (open) source the builder can chose not to make those space saving measures i.e. rm ... .
(Released open source has a bug affecting graphical resize of the VM main window you can still use xrandr / command line resize)
If you want a new pdb
-You can create a new pdb graphically through the SQLDeveloper tool, and very easily graphically or script their destruction.
-There is a 'createnewpdb ' script provided.
[It is technically possible to script new instance creation ( too much trouble )].
Not sure why you want dbca.
You can do things like change the SGA/PGA memory targets for the existing setup easily enough
through sqlplus to suit RAM given/available to the VM.
-Turloch
SQLDeveloper Team
createnewpdb YOUR_PDB_NAME
Hi,
For sqldeveloper:
menu applications->other (sqlcl modeller sqldeveloper and the intro web page are there)
or
type sqldeveloper at the terminal (text window) (or sql or datamodeller)
This menu item is a temporary workaround.
-Turloch
SQLDeveloper Team
If you get a 18.3 version to get dbca working unzip the database zip, zip up the assistants directory and unzip it in the ORACLE_HOME in the VM -> dbca works (12.2 version complicated by software install stage is not just an unzip).
Post a Comment