tag:blogger.com,1999:blog-2442647981995819981.post3175272255293161531..comments2023-05-31T02:58:45.329-07:00Comments on SQLDeveloper Senior Member of Tech Staff blog: Developer day VM Updated: 4/25/2016 ErrataTurloch O'Tierneyhttp://www.blogger.com/profile/08870427718022428504noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-2442647981995819981.post-67358983124694089092017-07-07T09:12:18.874-07:002017-07-07T09:12:18.874-07:00There is also:
in newpdbords
if test -f /home/ora...There is also:<br />in newpdbords<br /><br />if test -f /home/oracle/Desktop/Database_Track/coffeeshop<br /><br />instead of<br /><br />if test -d /home/oracle/Desktop/Database_Track/coffeeshop<br /><br />which is likely to also cause a second run of newpdbords to hang.<br /><br />-TurlochTurloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-81998980444077695072017-07-03T12:13:48.612-07:002017-07-03T12:13:48.612-07:00Hi Paolo,
Thanks for the information.
It slipped ...Hi Paolo,<br /><br />Thanks for the information.<br />It slipped by us in testing.<br /><br />Works altering newpdbords in my VM .<br /><br />Will confirm next build (not sure when it will be externalized).<br /><br />Any other issue please send it in.<br /><br />The best workaround for the workshop team is:<br />[Either alter the newpdbords ]<br />or before newpdbords is reused:<br /><br />cd ~/storm<br />rm import_sys.sql storm.log storm.dmp storm_vm_log<br /><br /><br />Thanks,<br />Turloch<br /><br />--SQLDeveloper Team<br /><br />Before<br /><br />if test -f storm.zip<br />then<br /> if test -f storm.dmp<br /> then<br /> echo storm.zip already unzipped<br /> fi<br /> echo unzipping storm.zip<br /> unzip storm.zip >> storm_vm_log 2>&1<br /> echo importing storm.dmp<br /> imp storm/oracle@ORDS FILE=storm.dmp FULL=Y >> storm_vm_log 2>&1<br />fi<br /><br />After<br /><br />if test -f storm.zip<br />then<br /> if test -f storm.dmp<br /> then<br /> echo storm.zip already unzipped<br /> else<br /> echo unzipping storm.zip<br /> unzip storm.zip >> storm_vm_log 2>&1<br /> fi<br /> echo importing storm.dmp<br /> imp storm/oracle@ORDS FILE=storm.dmp FULL=Y >> storm_vm_log 2>&1<br />fi<br /><br /><br />We have open sourced the scripts:<br />https://github.com/oracle/db-appdev-vm/<br /><br />I welcome any additional feedback.<br /><br />Why not just use the ova shipped (instead of building it yourself)?<br /><br />-You can change the virtual disk size<br />-You can skip the delete of some things that were deleted for space reasons eg dbca (database creation wizard)<br />-You can add your own application 'on top' as part of your build.<br />-You can change the database properties bigger/smaller SGA<br />-You can update the newpdbords<br /><br />There are other helper scripts:<br />uploaddemos - install lots of demos not just hr (ie OE AV etc)<br />and<br />createnewpdb which creates a new pdb with 'hr' - it does not do the storm import though.Turloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-49897444463569488522017-07-03T08:42:45.311-07:002017-07-03T08:42:45.311-07:00Hello Turloch,
today I noticed that the new script...Hello Turloch,<br />today I noticed that the new script newpdbords works fine when run once, but if you then drop the PDB it created and try to run it again, it will seemingly hang at:<br /><br /><i>storm.zip already unzipped<br />unzipping storm.zip</i><br /><br />By looking at the storm_vm_log the script is waiting for input by the user as follows:<br /><br /><i>Archive: storm.zip<br />replace storm.dmp? [y]es, [n]o, [A]ll, [N]one, [r]ename:</i><br /><br />but none of this is visible to the user. If I blindly type A in the console that started the script, it will then proceed further to the end.<br /><br />I believe it's probably better for the script either to clean up the unzipped archives or to force overwriting the zip contents if they already exist in the destination directory.<br /><br />Hope it helps,<br />Paolo MarzuccoAnonymoushttps://www.blogger.com/profile/08512126194271837879noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-9581580025666352662017-06-15T07:55:08.287-07:002017-06-15T07:55:08.287-07:00Latest release - a few setup fixes new labs and so...Latest release - a few setup fixes new labs and some minor version bumps.<br /><br />Updated: 6/14/2017<br />http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.htmlTurloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-7910937703490995612017-04-13T01:00:51.170-07:002017-04-13T01:00:51.170-07:00Firewall probably still up in the vm (cannot sqlne...Firewall probably still up in the vm (cannot sqlnet/sqlcl/sqldeveloper/firefox in from guest)<br /><br />http://dba.stackexchange.com/questions/60536/im-trying-to-run-an-oracle-database-in-virtual-box-under-oracle-linux<br /><br />ie <br />chkconfig iptables off<br />service iptables stop<br />service ip6tables stop<br /><br /><br />stays off on reboot<br /><br />Turloch<br />-SQLDeveloper teamTurloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-69268175797136742072017-03-21T14:08:18.850-07:002017-03-21T14:08:18.850-07:00http://stackoverflow.com/questions/41550929/cannot...http://stackoverflow.com/questions/41550929/cannot-load-system-cursor-copydrop-32x32-exception-in-java-on-centos-7<br />I am getting : failed to load system cursor: DnD.Cursor.CopyDrop : cannot load system cursor: CopyDrop.32x32<br /><br />On launching sqldeveloper - went away on reboot - worrying - got it once before - just got it again.<br /><br />Not reproducible enough to try the nomodeset grub setting suggested workaroundTurloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-24112032731801800712017-03-13T03:00:32.498-07:002017-03-13T03:00:32.498-07:00Updated had open upgrade at the end and forgot utl...Updated had open upgrade at the end and forgot utlrp<br /><br />Do not just press enter when eventually asked for the sys password!!!<br />For use on test 12.2 VM with 32kvarchar not set yet.<br /><br />#!/bin/bash<br />export DONOTSETTWO_TASK=true<br />export TWO_TASK=<br />export LD_LIBRARY_PATH=$ORACLE_HOME/lib<br />echo using /home/oracle/utl32k_cdb_pdbs_output for output dir<br />echo XXXX presss enter if database is up XXXX<br />ps -ef| grep pmon<br />read line<br />sqlplus sys/oracle as sysdba <<EOF<br />ALTER SESSION SET CONTAINER=CDB\$ROOT;<br />ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;<br />shutdown immediate<br />startup upgrade<br />ALTER PLUGGABLE DATABASE ALL OPEN UPGRADE;<br />EXIT;<br />EOF<br />cd $ORACLE_HOME/rdbms/admin<br />mkdir /home/oracle/utl32k_cdb_pdbs_output<br />echo XXXXXX enter sys password when prompted XXXXXXXXX<br />$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl \<br />-u SYS -d $ORACLE_HOME/rdbms/admin -l \<br />'/home/oracle/utl32k_cdb_pdbs_output' -b \<br />utl32k_cdb_pdbs_output utl32k.sql<br />echo XXXXXXX if successful press enter to continue XXXXX<br />read line<br />sqlplus sys/oracle as sysdba <<EOF<br />shutdown immediate<br />startup<br />ALTER PLUGGABLE DATABASE ALL OPEN READ WRITE;<br />EXIT;<br />EOF<br /><br /><br />cd $ORACLE_HOME/rdbms/admin<br />mkdir /home/oracle/utlrp_cdb_pdbs_output<br />echo XXXXXXXXXXXXXXXXXXXXX type sys password at prompt XXXXXXXXXXXXXXXXXXXXXX<br />$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl \<br />-u SYS -d $ORACLE_HOME/rdbms/admin -l \<br />'/home/oracle/utlrp_cdb_pdbs_output' -b \<br />utlrp_cdb_pdbs_output utlrp.sql<br />Turloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-24891505254067321552017-03-10T12:52:04.776-08:002017-03-10T12:52:04.776-08:00Please post if you used that 32k varchar2 script s...Please post if you used that 32k varchar2 script successfully.<br />Differences from a different install include:<br />export DONOTSETTWO_TASK=true [VM workaround]<br />export LD_LIBRARY_PATH=$ORACLE_HOME/lib [should be set by . oraenv]<br />/home/oracle/ path may vary<br />On a production system you probably want two double check each stage runs successfully.<br />I tried to keep the lines short by backslash at line continuation so over long lines may not be mangled in blog post cut and past.Turloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-7588488612523384092017-03-10T12:46:03.835-08:002017-03-10T12:46:03.835-08:00This comment has been removed by the author.Turloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-32862440950377733462017-03-10T10:36:31.097-08:002017-03-10T10:36:31.097-08:00http://docs.oracle.com/database/122/REFRN/MAX_STRI...http://docs.oracle.com/database/122/REFRN/MAX_STRING_SIZE.htm#REFRN10321<br />32k varchar2 not set in 12.2VM (I thought it was by default already)Turloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-16258362297153767312017-03-10T08:25:06.146-08:002017-03-10T08:25:06.146-08:00Versions for 12.2 VM:
export DEMOSURL= (internal l...Versions for 12.2 VM:<br />export DEMOSURL= (internal labs) demos.zip as of March 1st<br />export JAVAURL= jdk-8u121-linux-x64.tar.gz<br />export SQLDEVURL= sqldeveloper-4.1.5.21.78-no-jre.zip<br />export SQLCLURL= sqlcl-4.2.0.16.355.0402-no-jre.zip<br />export APEXURL= apex_5.1.zip 5.1.0 as of March 1st<br />export ORDSURL= ords.3.0.9.348.07.16.zip<br />export MODELLER= datamodeler-4.1.5-907-no-jre.zip<br /><br />Built with packer 0.10.2 and Oracle Linux 7.3 as of mid February<br />If anyone want to know the minor issues worked around in the automated build - drop me an email with VM in the subject: turloch.otierney@oracle.comTurloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-35136985198008766642017-03-10T08:00:35.436-08:002017-03-10T08:00:35.436-08:00(also rm ~/LDLIB/oraenv ~/LDLIB/coraenv )
(also rm ~/LDLIB/oraenv ~/LDLIB/coraenv )<br />Turloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.comtag:blogger.com,1999:blog-2442647981995819981.post-72254563302732348362017-03-10T07:57:40.840-08:002017-03-10T07:57:40.840-08:002017 12.2 release:
#1/sqlcl
#2/master.zip (demos)...2017 12.2 release: <br />#1/sqlcl<br />#2/master.zip (demos) for createnewpdb<br />#3/Reported issues: issue when install o windows d:<br />#4/Report any issues to: turloch.otierney@oracle.com have VM in the subject<br />#5/Any requests?<br />#6/Any usecases?<br /><br />#1/sqlcl:to use sqlcl: rm ~/LDLIB/sql $ORACLE_HOME/bin/sql<br />and start a new terminal (or use ~/bin/sql (no rm required)) <br />#2/master.zip (demos) for createnewpdb<br />- demos missed get from https://github.com/oracle/db-sample-schemas save download zip as ~/master.zip<br />note createnewpdbminhr works only for ORDS (hr schema is loaded master.zip) could be easily modified.<br />#3/install on d: gave problems might have been: Virtualbox->preferences->General->Default_Machine_Folder or snapshot setting: machine->settings->advanced->snapshot folder.<br />#4/Report any issues to: turloch.otierney@oracle.com have VM in the subject<br />[possible source of issues: <br />-use virtualbox 5.1.14 or later<br />-let it auto login do not click on Oracle user. <br />-12.1 prerequisites used ulimit (copy stack) might need to be more<br />-really should stop that firefox warning.<br />-We removed lots of stuff for space reasons dbca ~/apex/builder (for German Chinese .. language support - it should be the same as the current apex 5.1.0 download.) <br />]<br />#5/Any requests (I guess just update when other oracle software gets a version update)<br />Meant to have a load all demos script (not just HR) but it was too late for release.<br />If download master.zip and look at createnewpdb:<br />1/Remove PATH_PREFUX setting on pdb creation<br />2/It goes out of its way to only load HR - do not have the exit added to the .sql file and all the demos should build - I think I also made the directory a hard link (no soft links) in the version in development - might not have been necessary.<br />#6/Any usecases:<br />-source control based new pdb database for each continuous integration run ?<br />-note there is an oracle docker script: https://blogs.oracle.com/developer/entry/creating_and_oracle_database_docker (12.1.0.2 no latest other software (APEX/ORDS)).Turloch O'Tierneyhttps://www.blogger.com/profile/08870427718022428504noreply@blogger.com