Upgraded JDK to 1.7.0_45
Updated Centos from 6.4 to 6.5
Tried with plain new configuration; deleted everything from ~/.sqldeveloper prior starting up SQL Developer. Verified integrity of downloaded installation rpm file. Still no snippets. See atached picture.
When disabling features using Tools -> Features -> Database, note that Snippets says Data Miner, OLAP, and Spatial depend on it. While disabling / enabling combinations of those 3 in conjunction with Snippets, I noticed that enabling Snippets did not make it reappear in the View menu unless OLAP is also re-enabled -- a probable bug.
Is OLAP disabled in your Centos environment?
SQL Developer Team
In Tools -> Features -> Database I have only Snippets and Spatial nodes. I do not have Data Miner and OLAP nodes, see attached screenshot of enabled/available features:
The situation does not improve even if I start with new profile (delete ~/.sqldeveloper)
I really don't know what you mean by "Is OLAP enabled in your Centos environment" since CentOS is a binary compatible clone of RHEL. All the databases I connect to with SQLDev have OLAP and Data Mining options enabled.
Thanx for looking into this. SQLDev 4 is a huge step forward and so much better than 3.2 but I really miss my snippets.
In Tools -> Features -> Database I have only Snippets and Spatial nodes. I do not have Data Miner and OLAP node
In my Windows 7 install of 4.0 EA3, Data Miner and Oracle OLAP nodes appear above the Change Management node. Perhaps something went wrong during the actual install process. In your ...\sqldeveloper\sqldeveloper\extensions directory do you have folders and jars for oracle.dmt.dataminer and oracle.olap? If you start SQL Developer from the command line (...\sqldeveloper\sqldeveloper\bin\sqldeveloper), do any interesting messages appear in the console?
I really don't know what you mean by "Is OLAP enabled in your Centos environment"
Enabled in Tools -> Features -> Database. But if you don't see a node for it there, that's a moot point.
Verified integrity of downloaded installation rpm file.
In releases prior to 4.0, if I had any install issues with the rpm I would just unzip the generic download zip under my scratch directory, but that is no longer provided and I haven't tried using the Windows zip on Oracle Linux. But perhaps that is something to try out.
Summary first: I've got my snippets back! It was a bad extract from the rpm installation file. Here are the gory details for those who like to be entertained.....
You've got me thinking, that something may be different between windows and linux versions. Since both are java, the windows version should run on linux, too - right? Here's what I did:
- downloaded the windows version
- unzipped it in an empty directory
- made sqldeveloper executable (chmod u+x sqldeveloper.sh)
- added AddVMOption -Duser.home=/home/alex/tmp/sqldevwin to sqldeveloper.conf to force it to use a new profile
- run sqldeveloper.sh (it started up just fine!)
- created a connection to make it open a new worksheet
- check the view menu - and snippets entry is there - and it displays the default snippets correctly
- exited sqldeveloper
- copied UserSnippets.xml from my linux profile to the new windows profile
- started sqldeveloper again, checked the snippets, and my snippets are there, too!! Yay!
As far as I can see, there are two files missing in my linux install when I compare with what is found in extensions directory in my windows install:
Then I disabled the following features and restarted SQL Developer, just to check the Gary's suspicious about a possible bug:
- change management
- restfull services
- times ten
- unit test
- xml schema
- all database migrations
- version control
After the restart, snippets are still correctly displayed!
So I checked if those files are missing in the downloaded linux rpm. When I opened the file with Archive Manager (File Roller 2.28.2), those 2 files were in there! I extracted the archive in an empty folder - the files are missing! Obviously, File Roller is messing things up (no shortage of space, no errors reported). Since I usually install this way, now I see why my installation got hosed. I extracted the installation files from the rpm with:
- rpm2cpio /home/alex/down/sqldeveloper-220.127.116.11.30-1.noarch.rpm | cpio -i -d
Check the files, they are where they're supposed to be. I guess I'll have to talk to developers of File Roller why this is happening.
Gary, thanx for your help and guidance!
Various issues with un-archiver utilities have been reported in the past: