• Home
  • Tätigkeitsbereiche
    • IT-Personal
    • Softwareentwicklung
    • Projektmanagement
    • Reseller
  • IT-Blog
  • Kontakt

Troubles with powerLAN network

Details
03 November 2021

At home I have a pretty difficult networking situation. In the evenings especially if a lot of people around are at home the WLAN is not working at all, over the day I have full speed (using AI-Mesh) but in the evening it tends to be horrible slow.
So I looked for a power-line network to get at least a good connection to the most important points. So the use-case is simple I have to bridge two points. After I know that the speed depends on the power-line I was calculating to get about 50% of my 300/50Mbit line speed. Here are the notes which I took after struggling and testing different producer. The Upload/Download tests were all done with speedtest.net.

Devolo

devolo Magic 1 LAN Starter Kit, LAN Powerline Adapter -bis zu 1.200 Mbit/s, ideal für Home Office und Gaming, 1x Gigabit LAN Anschluss, dLAN 2.0, weiß

My first PowerLAN adapter were from devolo and I was pretty happy with them so these were my first choice. The administration console is fine, the configuration with the "power save mode" is tricky. I have on the other side a router connected and even if the adapter should not (because the router is always online), the adapters go to sleep, so I needed to turn the power save mode off. The tests were ok but the download rate was with 86,5 disappointing the upload with 48 was at max. I paid 76€ for them.

AVMFritz

AVM FRITZ!Powerline 510E Set (500 Mbit/s, Fast-Ethernet-LAN) deutschsprachige Version

After I was disappointed from the Devolo I ordered two other systems.

The AVMFritz are pretty small and cheap, they don't have a socket built, so you will loose a socket in your home but they are pretty cheap with 42€. With a download of 79,7MBit they are about the same as the Devolo stuff, an upload of 30,7 is pretty low.

D-Link

D-Link DHP-P601AV PowerLine Gigabit Passthrough Kit (AV2, enthält zwei Adapter, Datenübertragunsraten von bis zu 1000 Mbit/s)

With 52€ they the price is ok. There is a power save mode which you can't turn off as it seems, but until now I never had the "devolo looses suddenly connection" problem, probably the implementation is better. The Download with 130MBit and Upload of 50Mbit is much higher as the ones from Devolo. After they are also about 25 bucks cheaper I will give them a try. In case they turn up to have any flaws I will post an update.

mapviewer with a pluggable database

Details
20 October 2021
  • oracle
  • mapviewer
  • pluggable database
  • multitenant

I need to get MapViewer going to validate my own data imports. I began the installation on a new weblogic and everything worked fine.

One thing what was pretty stupid was that I tried to get to the admin server console by using http://localhost:7001/, but of course the console is an app and therefore needs to be called  via http://localhost:7001/console.

The really annoying part was that I needed to create a datasource and this did not work with a pluggable database (I just have a multitenant installation).

 

  <map_data_source name="test"
                   jdbc_host="myhost"
                   jdbc_sid="mysid"
                   jdbc_port="1521"
                   jdbc_user="test"
                   jdbc_password="!test" 
                   jdbc_mode="thin"
                   number_of_mappers="3"
                   allow_jdbc_theme_based_foi="false"
                   editable="false"
   />

The documented part is the exclamation mark in front of the password, which autoencrypts the password with the next restart.

But it was not possible to get a connection to the database, I always got

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I could not get it going for almost a full day. I found an old installation instruction and the solution is to prefix the SID with double slash.

  <map_data_source name="test"
                   jdbc_host="myhost"
                   jdbc_sid="//mysid"
                   jdbc_port="1521"
                   jdbc_user="test"
                   jdbc_password="test" 
                   jdbc_mode="thin"
                   number_of_mappers="3"
                   allow_jdbc_theme_based_foi="false"
                   editable="false"
   />

I could not find any documentation about that, therefore my note here.

Open local files in Edge/Chrome/Chromium does not work

Details
24 February 2021

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!

 

KVM Networking - buster upgrade

Details
07 January 2020

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

Scanning for devices. Please wait, this may take several minutes

Details
07 January 2020

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

 

Null Pointer when starting glassfish via IntelliJ 8

Details
08 August 2019

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?

 

 

LPX-00209: PI names starting with XML are reserved

Details
05 April 2019

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.

Change password over Remote Desktop (RDP)

Details
02 April 2019

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

!!END!! not DELETE!!!

Strange "Greek" symbol characters in Oracle Reports PDF output

Details
01 November 2018

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.

Run PL/SQL Developer in crossover/wine

Details
29 September 2018

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).

How to edit PDF in Linux

Details
26 August 2018

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.

No audio device in wine (crossover)

Details
22 August 2018

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.

  1. spatial error ORA-29902
  2. history for SQL/PLUS and RMAN II
  3. Oracle 12c Installation on Debian Wheezy
  4. ASM disk already member of diskgroup
  5. Gerrit Permission denied (public key)
  6. Gerrit delete-project plugin for 2.6
  7. Android debug bridge (adb) for Debian
  8. add macro plugin to gedit
  9. Java in Oracle Forms without Beans and Pluggable Java Components
  10. FRM-41214 Unable to run Report with CELLWRAPPER
  11. gnome connection manager - ssh
  12. splitting a comma delimited string in Oracle
  13. Empty calendar in Icedove/Thunderbird
  14. Gnome extension work for Debian Wheezy
  15. Printer problems in Gnome
  16. preseeding in Debian wheezy
  17. build thunderbird 7.x on Debian wheezy
  18. Enable Sound on Debian Wheezy for Dell Latitude 6500
  19. RMAN-06026 and RMAN-06023 when restoring
  20. history for SQL/PLUS and RMAN
  21. UTL_MAIL with SMTP authentication
  22. How to fix ORA-00600/ORA-07445
  23. clockworkmod "an error occured while downloading your recovery."
  24. KVM - bad usb drive performance
  25. KVM Kernel Based Virtual Machine vs. XEN
  26. Oracle 11g Installation on Debian Squeeze
  27. The type R is already defined
  28. HOWTO Sign Amazon Product API Requests
  29. Multiple Desktops in Windows 7
  30. java.security.AccessControlException: access denied
  31. FRM-13008 cannot find java bean
  32. SET_WINDOW_PROPERTY does not trigger WHEN-WINDOW-RESIZED
  33. subversion tortoisesvn with alternate ssh port
  34. developer suite 10g on vista and windows 7
  35. Securing the RBASH?
  36. sending bacula status mails with smtp authentication
  37. svnserve with slikSVN
  38. limit user rights - Jail Shell RBASH (Debian)
  39. limit user rights - Jail Shell RSSH (Debian)
  40. limit user rights - Jail Shell SFTP (Debian)
  41. limit user rights - Jail Shell SSH (Debian)
  42. Bacula "Network error with FD during Backup"
  43. port 9240 already in use
  44. XPlanner+ Permissions for security Manager
  45. XPlanner Plus
  46. Cannot configure CacheManager
  47. Tomcat on Debian
  48. Oracle Developer Patch 10.1.2.3
  49. Oracle Reports font subsetting
  50. Adding Fonts on Unix for Oracle Reports PDF
  51. Harddisk recovery tools free and not so free
  52. REP-1352 Font Issue
  53. Oracle Reports with barcode
  54. Enterprise-Manager + RMAN No RMAN found, Message file not found
  55. ORA-1017: invalid username/password when creating database link
  56. resolv.conf overwritten empty after reboot
  57. AmazonBestseller which products are cheap?
  58. 4gb seg fixup errors after upgrading from etch to lenny
  59. Oracle Bug ORA-07445: exception encountered
  60. C compiler cannot create executables.
  61. Oracle Java File permissions
  62. EM Manager "Compute dynamic property takes too long"
  63. where to download com_migrator
  64. PL/SQL Email-Validation
  65. Power Consumption of Dell Server
  66. Enterprise Manager and ORA-00018
  67. Io exception: The Network Adapter could ...
  68. Centos = Redhat Enterprise Linux
  69. Enterprise Manager notification not working
  70. the magic Oracle WITH-clause
  71. Error in invoking target - Oracle on Debian
  72. Oracle Installation on Debian for dummys II
  73. Oracle Installation on Debian for dummys I
  74. Oracle-Reports Asynchronous calls with SRW-API
  75. on-commit not working on materialized views
  76. using Materialized View
  77. How to determine the character-set in Oracle
  78. how to compile invalid sys-objects
  79. ORA-06553: PLS-320: the declaration of the type...
  80. Access Control with Context/Fine-Grained Access Control
  81. MDA Vario/Qtek 9100 Ersatzstift/Replacement Stylus
  82. Versioning of a table in Oracle
  83. datapump fails with ora-06502
  84. Where to find Opatch
  85. How to create a SPFILE from a PFILE
  86. How to use UTF8 in PDFs created by Oracle-Reports
  87. Oracle Failsafe and SPFILE
  88. phone-number check in constraint
  89. webutil wuc-024 (WUC-24)
  90. Failsafe ORA-00942 "View or Table does not exist" workaround
  91. direct access to the database without TNSNAME.ORA
  92. Failsafe ORA-00942 "View or Table does not exist"
  93. Connection to host failed. Bad SQL_SCRIPT at - line 227.
  94. Is Oracle Failsafe just for Databases?
  95. Do you know Oracle Failsafe???
  96. REP-56055: Exceed max connections allowed
  97. Troubles with OracleDataSource
  98. Enterprise Manager clone Database results in "insufficient disk space"
  99. How to distribute Oracle Reports Part II
  100. How to distribute Oracle Reports Part I
  101. No valid GPS-Signal on Acer N35
  102. How to use a terminal-file in webforms
  103. ORA-00257 ORA-16020 Archiver Stuck
  104. ORA-39002 ORA-39070 ORA-39087 with Datapump
  105. Installation Forms and Reports Service failed
  106. Simple Machine Forum
  107. Don't use timers in webforms - WHY NOT?
  108. The difference between PJC and Java Beans in Forms
  109. Forms and Reports Services Standalone
  110. ORA-00932: inconsistent datatypes
  111. Compare Database Performance
  112. Scott and Tiger
  113. Surprise Surprise Oracle Developer Suite 10gR2
  114. Working with Oracle Express Edition
  115. Oracle Express - an Oracle-Database that's for free

Page 1 of 11

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • Suche
  • Login
  • Impressum