New Developer Day VM 18.3 (18.2 APEX)

https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html

• Oracle Linux 7
• Oracle Database 18.3 Linux x86-64
• Oracle SQL Developer 18.3
• Oracle Application Express 18.2
• Hands-On-Labs (accessed via the Toolbar Menu in Firefox)
  • Oracle REST Data Services 18.3
  • Oracle SQL Developer Data Modeler 18.3
  • Oracle XML DB

For performance up  resources to 2CPU 3GB RAM - default 1CPU 2G ram.

Errata:
1/ Occasional SQLDeveloper startup issue:
2/ DBCA trick
3/ JET lab
4/ reset scripts

1/Occasional SQLDeveloper startup issue:

(java:23682): Gdk-ERROR **: The program 'java' received an X Window System error.

This probably reflects a bug in the program.

The error was 'RenderBadPicture (invalid Picture parameter)'.

  (Details: serial 17547 error_code 143 request_code 139 minor_code 7)

  (Note to programmers: normally, X errors are reported asynchronously;

   that is, you will receive the error a while after causing it.

   To debug your program, run it with the --sync command line

   option to change this behavior. You can then get a meaningful

   backtrace from your debugger if you break on the gdk_x_error() function.)

/u01/userhome/oracle/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: line 1606: 23682 Trace/breakpoint trap   (core dumped) ${JAVA} "${APP_VM_OPTS[@]}" ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} "${APP_APP_OPTS[@]}"

[oracle@localhost ~]$ which java

~/java/jdk1.8.0_152/bin/java

2/ DBCA Trick:
For dbca copy in assistance directory to $ORACLE_HOME from unzip of 18.3 Oracle Database download
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

3/JET lab
Automated set up of seconds ords for use in JET lab (2nd ords also be done through sqldeveloper as described in labs)
2nd pdb 2nd ords
newpdbords        -Sets up 2nd pdb called 'ORDS'
9090init              -Starts up ords on new pdb port 9090
(can start stop with 9090start 9090stop)

 #!/bin/bash
. /home/oracle/.bashrc
newpdbords
9090init
sleep 180
cd /home/oracle/sqldeveloper/ords
echo '#!/usr/bin/expect
exp_internal 1
set timeout 1200
spawn $JAVA_HOME/bin/java -jar ords.war user ords_dev "SQL Developer"
expect -regexp "Enter a password for user ords_dev." { send "oracle\r" }
expect -regexp "Confirm password for user ords_dev." {send "oracle\r"}
expect -regexp "Something that will never happen to force keep searching until process end" {send "neverhappen\r"}
interact'| sed 'sZ$JAVA_HOMEZ'"$JAVA_HOME"'Zg' > ~/bin/xp.sh
chmod 755 ~/bin/xp.sh
~/bin/xp.sh
echo '#!/usr/bin/expect
exp_internal 1
set timeout 1200
spawn $JAVA_HOME/bin/java -jar ords.war user ords_admin "Listener Administrator"
expect -regexp "Enter a password for user ords_admin." { send "oracle\r" }
expect -regexp "Confirm password for user ords_admin." {send "oracle\r"}
expect -regexp "Something that will never happen to force keep searching until process end" {send "neverhappen\r"}
interact'| sed 'sZ$JAVA_HOMEZ'"$JAVA_HOME"'Zg' > ~/bin/xp.sh
chmod 755 ~/bin/xp.sh
~/bin/xp.sh
cd -
9090stop
#on ords 9090 reset we want reinstall not uninstall
touch ~/.ordsreinstall
#note 9090init has a 3 minute wait to ensure ords has started


4/reset scripts
Report any issues - if reset fails reimport VM