본문 바로가기
책/DB

시작

by 파이어볼러 2015. 6. 21.

부트로더란?

http://121202.tistory.com/60

http://littlemadoros.tistory.com/86


코어 개수

http://blog.naver.com/naraebali/220355685607

코어 덤프

https://ko.wikipedia.org/wiki/%EC%BD%94%EC%96%B4_%EB%8D%A4%ED%94%84


오라클 리눅스 설치

http://blog.naver.com/xesines/120129325527

http://cafe.naver.com/ocmkorea/book1618740/8694


DISPLAY문제

http://blog.naver.com/shipgo/220308495451

http://blog.naver.com/cooroom/100153021823

root계정에서 xhost +

oracle계정에서 export DISPLAY="자신의IP":0.0


혹시 안될경우

ln -s /usr/bin/xdpyinfo /usr/X11R6/bin/xdpyinfo


[root@localhost ~]# vi /etc/security/limits.conf

Oracle soft nproc 2047
Oracle hard nproc 16384
Oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240

[root@localhost ~]# vi /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

[root@localhost ~]# sysctl - p

vi /etc/pam.d/login

session required pam_limits.so

[root@localhost ~]# vi /home/oracle/.bash_profile

export EDITOR=vi
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11g
export ORACLE_SID=orcl
export LANG=ko_KR.eucKR
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export PATH=$PATH:$ORACLE_HOME/bin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

emctl langauge 문제

vi /etc/profile
LC_ALL=C;
export LC_ALL

/app/oracle/product/11g/network/admin/samples/tnsnames.ora
/app/oracle/product/11g/network/admin/tnsnames.ora
[root@localhost ~]# find / -name 'sqlnet.ora'
/app/oracle/product/11g/network/admin/samples/sqlnet.ora
[root@localhost ~]# find / -name 'listener.ora'
/app/oracle/product/11g/network/admin/samples/listener.ora
/app/oracle/product/11g/network/admin/listener.ora


전체 사용자 설정

find $ORACLE_HOME -name glogin.sql

/u01/app/oracle/product/11g/db_1/sqlplus/admin/glogin.sql

 

set sqlprompt "_user'@'_privilege>"

 

특정사용자 설정

 

vi login.sql

set sqlprompt "_date'#'_user'#'_CONNECT_IDENTIFIER>"

set time on


find / -name '*.apk'

' > DB' 카테고리의 다른 글

Sol  (0) 2015.05.17
Part 7 라우터?  (0) 2015.03.07
Part 6 스위치를 켜라!  (0) 2015.03.07
Part 5 IP 주소로의 여행  (0) 2015.03.07
Part 3 4 TCP/IP와의 만남 네트워크 장비들  (0) 2015.03.07