|
SQLDeveloper 2.1 IDE font size |
|
|
|
|
Written by Martin
|
|
Tuesday, 09 February 2010 |
|
This is a quick post for anyone out there wanting to change the font size of the SQLDeveloper 2.1 IDE I downloaded SQLDeveloper 2.1 (really cool!) for Linux and installed it under /opt/sqldeveloper. All that remained to be done was to make /opt/sqldeveloper/sqldeveloper.sh executable and off I went! Sun's website is now Oracle-branded so it took me a while to get a Sun JDK 1.6 but java.sun.com still works, albeit it's read! So back to my initial problem, changing the IDE font size. Sue Harper had the correct idea by changing ide.properties but that file wasn't to be found under /opt/sqldeveloper where I installed it. It is however, unix conform, in ~/.sqldeveloper - the exact path depends on your build so it's easiest to simply do a find ~/.sqldeveloper -iname "ide.properties" and then edit it. All I literally did was to to add a line "Ide.FontSize=10", saved the file and restarted SQL Developer. Done! Read the comments in ide.properties, there are many more options available.
|
|
Last Updated ( Tuesday, 09 February 2010 )
|
|
|
Format large ext HDD with FAT32 |
|
|
|
|
Written by Martin
|
|
Wednesday, 02 December 2009 |
|
The XP "format" utility can't format partitions larger than 32G with FAT32. If you absolutely need to, you can use the H2format tool to overcome this limit. I just successfully created a 100G partition for data exchange! If you don't mind the output is in German, you can see this: C:\temp>h2format.exe n:
H2format -- by Harald Bögeholz / c't Magazin für Computertechnik
Version 1.6, Copyright (C) 2003 Heise Zeitschriften Verlag GmbH & Co. KG
Partitionsgröße: 209712447 Sektoren = 100.0 GByte
Standard-Clustergröße: 64 Sektoren.
Anzahl der Cluster: 3275956
51284 Sektoren vom Dateisystem belegt (25.0 MByte).
Setze Partitionstyp auf 0xc.
Ok.
I got the binary here: http://www.heise.de/ct/c-t-Systeminfo-473388.html, but this link may break at some later time.
|
|
|
Copying a sequence of archived logs to the standby db |
|
|
|
|
Written by Martin
|
|
Monday, 02 November 2009 |
|
This is becoming a recurring pattern: the standby database has lost network connectivity due to network maintenance and now needs a bunch of archived logs to be copied. The easiest way is to use the FAL process by Oracle, but sometimes that's not possible. A different scenario is the use of SE oracle and the "home grown managed recovery" where you constantly recover a copy of the production database with archived logs from the actual production. So, how do you copy, say archived logs from sequence 45438 to 45714, thread# 2? The log_archive_format is %t_%s_%r.dbf by the way, and the production database stores them in /u03/oradata/prod/arch/ The solution is to use the seq bash built-in as in the following example: for i in `seq 45438 45714`; do
scp sourceHost:/u03/oradata/arch/2_${i}_548600535.dbf /u03/oradata/arch/
done
I came across this by chance and really loved it. Will see if I can add it to other scripts as well.
|
|
|
Written by Martin
|
|
Wednesday, 28 October 2009 |
|
Quick note to self. I created an amazon Centos 5.2 image-during the creation of the latter I was prompted to generate a key pair for the machine which is fair enough, have done that in the past. The interesting part though is that you get a file with the extension "*.pem". Putty doesn't like it so what to do? The solution is to fire up puttygen and import the key. You can then generate the public/private keys off it and connect to the public DNS name. On to figuring out how the storage bit works...
|
|
|
Use Thunderbird to group emails by subject |
|
|
|
|
Written by Martin
|
|
Monday, 26 October 2009 |
|
Quick note to self: how to group emails from the oracle-l mailing list.
Open Thunderbird and select the account. Then select view->sort by-Subject.
Next select view->sort by-grouped by sort G
done!
|
|
|
|
<< Start < Prev 1 2 3 4 Next > End >>
|
| Results 1 - 9 of 28 |
FAQs