Wednesday, 6 June 2018

New Developer day VM

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.

Same as last release + more recent software
any requests/what does not work let me know in the comments.


Turloch O'Tierney said...

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.

Turloch O'Tierney said...

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))
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

Turloch O'Tierney said...
This comment has been removed by the author.
Turloch O'Tierney said...

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

Turloch O'Tierney said...
This comment has been removed by the author.
Turloch O'Tierney said...

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

Turloch O'Tierney said...

Seems pretty persistent one site suggested:
sudo systemctl mask packagekit.service

Turloch O'Tierney said...

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.

SQLDeveloper Team

Turloch O'Tierney said...

createnewpdb YOUR_PDB_NAME

Turloch O'Tierney said...


For sqldeveloper:

menu applications->other (sqlcl modeller sqldeveloper and the intro web page are there)
type sqldeveloper at the terminal (text window) (or sql or datamodeller)
This menu item is a temporary workaround.

SQLDeveloper Team

Turloch O'Tierney said...

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).