Import: Release 11.2.0.1.0 - Production on Thu May 28 06:46:52 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available connect […]
oracle : ALTER DATABASE CHARACTER SET INTERNAL_USE
[oracle@owl110]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Thu May 28 06:38:32 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> SQL> SQL> conn /as sysdba Connected. SQL> SHUTDOWN IMMEDIATE; Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT; ORACLE instance started. Total System Global Area 6.3068E+10 bytes Fixed Size 2219392 bytes […]
CentOS7 : oracle 11g install brief
xrdp 설치 후 원격데스탑으로 서버에 접속하여 oracle을 설치할 수 있다. 오라클설치 패키지가 한글이 올바로 지원하지 않을 경우가 있으므로 X윈도우를 영문으로 세팅하여 설치하는 것이 권장할만하다. X윈도우 언어설정 X윈도우의 언어 설정을 다듬과 같은 명령으로 설정할 수 있다. # localectl status # localectl list-keymaps | grep kr # localectl set-keymap kr # localectl set-x11-keymap kr […]
CentOS7 : Remote Desktop by Window Desktop Tool (rdp)
## yum -y install tigervnc-server ## yum -y install http://dl.fedoraproject.org/pub/epel/6/x86_64/xrdp-0.6.1-2.el6.x86_64.rpm # yum grouplist # yum groupinstall "KDE Plasma Workspaces" # yum install xrdp # systemctl start xrdp # systemctl start xrdp.service # netstat -antup | grep xrdp # systemctl enable xrdp.service # firewall-cmd --permanent --zone=public --add-port=3389/tcp # firewall-cmd --reload # localectl status […]
Centos : yum add epel repos
Centos 6 wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -ivh epel-release-6-8.noarch.rpm yum install php-pecl-mailparse Centos 7 wget http://dl.fedoraproject.org/pub/epel/beta/7/x86_64/epel-release-7-0.2.noarch.rpm wget http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm rpm -ivh epel-release-7-0.2.noarch.rpm yum install php-pecl-mailparse Other examples: yum --enablerepo=epel install php-pecl-mailparse yum --enablerepo=remi install php-mailparse -y yum --enablerepo=remi install php-imap -y
CentOS7 : firewall-cmd command hint
systemctl unmask firewalld systemctl start firewalld systemctl enable firewalld firewall-cmd --get-default-zone firewall-cmd --get-active-zones firewall-cmd --get-zones firewall-cmd --permanent --zone=public --add-service=ssh firewall-cmd --permanent --zone=public --add-service=dns firewall-cmd --permanent --zone=public --add-service=ftp firewall-cmd --permanent --zone=public --add-service=http firewall-cmd --permanent --zone=public --add-service=https firewall-cmd --permanent --zone=public --add-service=imaps firewall-cmd --permanent --zone=public --add-service=mysql firewall-cmd --permanent --zone=public --add-service=pop3s firewall-cmd --permanent --zone=public --add-service=smtp firewall-cmd --permanent --zone=public --add-service=tftp […]
CentOS7 : systemctl command hint
# systemctl -t service # systemctl start mariadb # systemctl enable mariadb
CentOS7 : network command hint
hostnamectl set-hostname owl25 nmcli d show ip addr show nmtui systemctl restart NetworkManager systemctl restart network
httpd cpu 100% full : [debug] mod_headers.c(743): headers: ap_headers_output_filter()
/etc/httpd/conf/httpd.conf #Loglevel debug Loglevel warm
httpd upgrade : mod_url must be recomplied
#wget http://caos.kldp.net/frs/download.php/6015/mod_url-apache2-1.6.2.6.tar.bz2 # bzip2 -d mod_url-apache2-1.6.2.6.tar.bz2 # tar -xvf mod_url-apache2-1.6.2.6.tar #cd mod_url-apache2 # apxs -i -a -c mod_url.c