$ 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 […]
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
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 […]
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
centos7 : change user's home base dir
usermod --home /var/www/ username
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 &
file count
find /home/mydir -type f | wc -l
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 […]
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: […]
How to make mod_caucho.o
download resin source file like resin-pro-4.0.44-src.tar.gz # tar xvzf resin-pro-4.0.44-src.tar.gz # cd resin-pro-4.0.44 # chmod 755 ./configure # ./configure --with-apxs=/usr/bin/apxs # make all # cp modules/c/src/apache2/.libs/mod_caucho.so /etc/httpd/modules/