oracle : change charset test => csscan

$ sqlplus /nolog SQL> conn /as sysdba SQL> @/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/csminst.sql $ csscan $ csscan Character Set Scanner v2.2 : Release 11.2.0.1.0 - Production on 일 9월 13 23:11:54 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: derp Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With […]

Read More

centos 7 : systemctl oracle Hint

make oracle daemon file vi /etc/rc.d/init.d/oracle cd /etc/rc.d/init.d ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc4.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc5.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle systemctl daemon-reload or reboot systemctl status oracle

Read More

oracle : set language and charset Hint SQLs

SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER in ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET','NLS_LANGUAGE'); select distinct(nls_charset_name(charsetid)) CHARACTERSET, decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKOWN'), 9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKOWN'), 96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKOWN'), 112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKOWN')) TYPES_USED_IN from sys.col$ where charsetform in (1,2) and type# in (1, 9, 96, 112); SELECT […]

Read More

centos7 : chrome install

# vi /etc/yum.repos.d/google-chrome.repo -------------------------------------------------- [google-chrome] name=google-chrome baseurl=http://dl.google.com/linux/chrome/rpm/stable/x86_64 enabled=1 gpgcheck=1 gpgkey=https://dl.google.com/linux/linux_signing_key.pub -------------------------------------------------- # yum install google-chrome-stable

Read More

CentOS 6 : chrome install

#vi /etc/yum.repos.d/google-chrome.repo [google-chrome] name=google-chrome baseurl=http://dl.google.com/linux/chrome/rpm/stable/$basearch enabled=1 gpgcheck=1 gpgkey=https://dl-ssl.google.com/linux/linux_signing_key.pub #yum install google-chrome-stable # wget http://chrome.richardlloyd.org.uk/install_chrome.sh # chmod 755 install_chrome.sh # ./install_chrome.sh ... need os update.... # google-chrome &

Read More

Mac OS X ftpd

Mac Siera  Siera remove ftp serivice must use sftp (ssh)   Using sftp by Finder mounting $ sshfs -p22 -o allow_other,defer_permissions userid@ipaddr:/path1 /Users/me/mnt/path1   1. Max OS Default FTP Server   default package : tnftpd   ftp service On/Off               ftp user add   ftp user directory   by Terminal   […]

Read More

mod_bw.c : error remote_addr

# apxs -i -a -c mod_bw.c /usr/lib64/apr-1/build/libtool --silent --mode=compile gcc -std=gnu99 -prefer-pic -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -DLINUX -D_REENTRANT -D_GNU_SOURCE -pthread -I/usr/include/httpd -I/usr/include/apr-1 -I/usr/include/apr-1 -c -o mod_bw.lo mod_bw.c && touch mod_bw.slo mod_bw.c: In function 'get_bw_rate': mod_bw.c:567:59: error: 'conn_rec' has no member named 'remote_addr' if (apr_ipsubnet_test(e[i].x.ip, r->connection->remote_addr)) { ^ mod_bw.c: […]

Read More