It seems there was a security feature builtin to the Chrome/Edge which prevents local links (file:///c:/test.xls) to open.

This seems to be pretty awful for Intranet sites where this was used for ages, so you end up with an endless amount of local links around.

I really also don't understand why you can't define an exception for e.g. local files/Intranet. But however there are some solutions/workarounds I found.

Use Firefox

To be honest, even if the new Edge is a very cool browser, they did a lot with Firefox and I think this is a also a decent choice you should consider even for a company.

Change the Group Policy to handle a list of exceptions as "Internet Explorer"

This applies to Edge and reading through the articles this means a lot of configuration and fiddling with Group Policys.

Rewrite the links and use Office URI schemes

This is the solution I went for, of course you need to be able to change the links (which is possible at my side), and it is all about office documents here, so this fits my needs.

So the links changed from:

<a href="/ file:///x:/localintranetfiles/mytest.csv ">Download</a>

to:

<a href="/ file:///x:/localintranetfiles/mytest.csv ">Download</a>

to

<a href="ms-excel:ofv|u|file:///x:/localintranetfiles/mytest.csv">Download</a>

I hope this helps to find a proper solution for you!

 

After a upgrade to buster I was not able to get the bridge interface online, I created a public bridge as described here 5 years ago and never touched it again.

After completely reinstalling the system (after that was my intention for some time for other reasons), I had the same issue.

I could solve the issue by simply installing the package bridge-utils. I have no idea why this dependency is missing, probably just a bug.

apt install bridge-utils

I did a fresh installation of one of my server, including upgrade of all disks.

When rebooting in a fresh Debian installation I got stuck with the message "Scanning for devices. Please wait, this may take several minutes".

After 5 hours of trial and error, reading manuals and posts I found the solution.

In the PERC Raid Controller I had to create two new virtual disks and the boot order of the virtual disks which you can assign in the RAID Controller configuration was set to the wrong virtual disk...

yell

 

When starting the glassfish server via IntelliJ I always got a Null-Pointer exception with JDK 8 (it was for sure not 9).

I had to set the environment variable AS_JAVA in <<glassfish_home>>\glassfish\config\asenv.bat to the full path of my JDK in order to get rid of it.

set AS_JAVA=C:\Program Files (x86)\Java\jdk1.8.0_144

I can just guess, that this is probably a problem when starting IntelliJ 64bit and glassfish? is probably 32bit?

 

 

When registering an XSD to oracle with dbms_xmlschema.registerSchema I got the strange error

LPX-00209: PI names starting with XML are reserved

This error occured because I had a leading CR in front (from copy/paste importing). Just removed it and everything was fine.

Easier than I thought. After fiddling with command line I found out that you can simple use CTRL+ALT+END.

!!END!! not DELETE!!!

Troubles with Oracle Report fonts

A while ago I was noticing strange symbol characters in Oracle Reports PDF output after a major version upgrade of the Middleware. They looked kind of greek and I could not find a solution. Turned out you should really search for "Greek" characters Oracle Reports, which brings you to the Oracle Bug 2906401 - FONT ALIASING NOT WORKING FOR ALL FIELDS WITH WE8ISO8859P15 CHARACTERSET.
Don't be confused, that is also a problem with any other character set. If you go to the solution you have a lot of different ways to bypass that. Below you find the way it worked on our system. The solution with creating backup directories and script was too complicated for me, so there is a one-liner which is doing the same.

sed -i 's/EncodingScheme AdobeStandardEncoding/EncodingScheme FontSpecific/' $ORACLE_HOME/guicommon/tk/admin/AFM/*

To make it short there are AFM files (Adobe Font Metrics) which Oracle Reports is using to generate the PDF files. These need to be changed in order to generate correct PDF output.

Recently I needed a good PLSQL tool also on Linux, after the whole Oracle stuff has massive flaws I decided to use the best tool on the market (PL/SQL Developer from Allround Automations) with Wine.
After I really like how Codeweavers are supporting the open source project wine, I decided to purchase the commercial version Crossover (very close to wine).
I tried a bit around and what I found out is that on my Linux system (Debian Stretch with Gnome, 3 sreens) PL/SQL Developer 12 ist not working (windows flipping endless).
I decided to go to version 11, and also take the 32bit version (had a headache with 64 bit version on wine), I also took Windows 7 (why not its stable...) and the R11 instant client (because I know this version is working).

The results are fantastic, until now I could not find any bugs, all looks good, below you find the steps it took me.

Download
    PL/SQL Developer 11 32bit (PL/SQL Developer downloads)
    Oracle Instant Client 11.2 32bit (instantclient-basic-win32-11.1.0.7.0.zip) (Instant Client Download)

Create Bottle
Create a new Windows 7 32bit bottle (I did it via the cxsetup GUI, but of course you can also do it by script)

Open the c: drive of your bottle (wherever it is located on your system) and install the instant client

cd ~/.cxoffice/PLSQLDEV/dosdevices/c:/
mkdir -p oracle/network/admin
unzip ~/Downloads/instantclient-basic-win32-11.1.0.7.0
mv instantclient_11_1 oracle/bin

Set some environment variables
Run regedit in the bottle (I did it via the bottle manager).

Create a Key Oracle in HKEY_LOCAL_MACHINE\Software.
Add String NLS_LANG HKEY_LOCAL_MACHINE\Software\Oracle with value AMERICAN_AMERICA.AL32UTF8.

Add bin directory to path and set TNS_ADMIN (so the client finds our tnsnames.ora files for sure).
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment
Edit PATH and add c:\oracle;c:\oracle\bin;

Add String TNS_ADMIN and set it to c:\oracle (yes I place my tnsnames file always in c:\oracle because I usually have multiple installations and want to just maintain one file).
Close regedit.

Create tnsnames.ora file.

cat > ~/.cxoffice/PLSQLDEV/dosdevices/c:/oracle/tnsnames.ora <<- EOF
MYDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )
EOF

Install PL/SQL Developer 11
After everything is prepared just install the software into the bottle (did it again via GUI).

I just wanted to copy some stuff from a PDF which did not work because of some strange formatting, so I gave it a try with a PDF editor. Surprisingly everything is contained in LibreOffice.

On my Debian system I just had to install the pdfimporter (not installed by default).

apt install libreoffice-pdfimport

Then just open the file withing Draw, that's it.

I had lately the problem that my crossover (wine) bottle did not have any audio driver.

/opt/cxoffice/bin/cxdiag

revealed that a audio driver was missing.

apt install libpulse0:i386

solved the problem.

I was having fun with Oracle Spatial lately, and stumbled over a fantastic bug (which should have been already fix what he not is...). I got the following:

ORA-29902: error in executing ODCIindexStart()routine ORA-13207: incorrect use of ... ORA-06512: at "MYSYS.SDO_INDEX_METHOD_10I...

which was caused by

AND SDO_ANYINTERACT(XSP.GEOM,XCG.GEOM) = 'FALSE'

what I really like here is the solution, which really works

AND SDO_ANYINTERACT(XSP.GEOM,XCG.GEOM) != 'TRUE'

This bug (18718478) should be solved (at least for SDO_RELATE) with 12.1.0.2 which I am currently working on...

As explained previously, you can easily get a history for sqlplus and rman on lnux.

apt-get install rlwrap

I forgot to mention that the easiest way to automatically use it is to set up an alias in your shell

alias sqlplus='rlwrap sqlplus'