This was the best result so far that reflected czech characters and IMHO correct sorting. select * from test6 order by NLSSORT( (NAME),’NLS_SORT=Xczech‘) 46 46 d 47 47 D 134 134 dra 136 136 Dra 139 139 dráb 138…
Our R&D did struggle with Oracle setting for Czech specific search. Following might be the solution. ALTER SESSION SET NLS_COMP=ANSI;ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;– this should be XCZECH we discussed previously First 3 screenshots are from setting up the DB where…
The iptables firewall will need to be modified to allow connections to the Apache web server that will be installed. Edit your /etc/sysconfig/iptables file with your favorite text editor. Modify the file as outlined below by adding the black line…
find . -type f -exec file ‚{}‘ ; Runs `file‘ on every file in or below the current directory. Notice that the braces are enclosed in single quote marks to protect them from interpretation as shell script punctuation. The semicolon…
Check what directory is most fulldu -b | sort -n -r | more List of available discsfdisk -l Show mounted discs/directoriesmount Configuration of mounted pointsmore /etc/fstab List available vxdiscsvxdg listvxdisk list Volume Group displayvgdisplay Physivcal volume displaypvdisplay Mount disc to…
I’ve used following documentation Few commands is incorrect like mysql -u <username> -p <dbname> Configuration is at /usr/share/cacti/include or /var/www/html/cacti/ Some parts from following link helped as well Cacti-Installation-on-Fedora-101.pdf
Apache Error Log File All apache errors / diagnostic information other errors found during serving requests are logged to this file. Location of error log is set using ErrorLog directive. If there is any problem, you should first take a look at…
Got this bike from my brother, not sure why he didn’t like it as its got all superb components. Love to ride with adjustable front fork that actually works not like other so called suspensions on cheaper versions of mountain…
One of the best monitoring tools for Linux PDF Cacti installation
1. SAR Using sar utility you can do two things: 1) Monitor system real time performance (CPU, Memory, I/O, etc) 2) Collect performance data in the background on an on-going basis and do analysis on the historical data to…