http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2896]
PostgreSQL [103]
기타정보 [150]
운영체제 [583]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

Rocky Linux 8.6 Oracle 11.2
최길호 [LIST]   2022-06-03 16:49:02, 조회 : 54

[root@dbsvr ~]# uname -a
Linux dbsvr 4.18.0-372.9.1.el8.x86_64 #1 SMP Tue May 10 14:48:47 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux

[root@dbsvr ~]# cat /etc/redhat-release
Rocky Linux release 8.6 (Green Obsidian)

# ip , hostname 변경
nmtui
ls -al /etc/sysconfig/network-scripts/ifcfg-*

vi /etc/selinux/config
SELINUX=disabled

setenforce 0

firewall-cmd --zone=public --add-port=1024-65535/tcp --permanent
firewall-cmd --zone=public --add-port=1024-65535/udp --permanent
firewall-cmd --reload
systemctl stop firewalld
systemctl disable firewalld


cat >> /etc/sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

/sbin/sysctl -p

cat >> /etc/security/limits.conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

yum grouplist
yum groupinstall "Server with GUI"
yum groupinstall "Development Tools"
yum install libnsl
yum install net-tools
yum install glibc-devel.i686 glibc-devel.x86_64  gmp-devel mpfr-devel libaio.i686
yum install libaio-devel
yum install elfutils-libelf-devel
yum install libgcc
yum install ksh
rpm -Uvh http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

yum install -y binutils.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 \
glibc-devel.i686 glibc-devel.x86_64 ksh libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 \
libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 \
libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64 libXp.i686 libXt.i686

groupadd -g 1521 dba
useradd -u 1521 -g dba oracle
passwd oracle

mkdir -p /oracle
chown oracle:dba /oracle
cd /oracle
tar xf ~/ol711.product.se.tar
/oracle/oraInventory/orainstRoot.sh
/oracle/product/11.2/root.sh

cat >> ~/.bash_profile
export ORACLE_SID=db11
export ORACLE_HOME=/oracle/product/11.2
export PATH=$PATH:$ORACLE_HOME/bin:.
alias sql='sqlplus "/as sysdba"'
alias oh='cd $ORACLE_HOME'
alias df='df -h'

$ORACLE_HOME/OPatch/opatch lsinventory
Patch 28364007 - Oracle Database Security PatchUpdate 11.2.0.4.181016 (CPUOct2018)


cat >> /oracle/product/11.2/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
  (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0 )(PORT = 1521))
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  )
)
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = db11 )
      (ORACLE_HOME = /oracle/product/11.2)
      (SID_NAME = db11 )
    )
  )
ADR_BASE_LISTENER = /oracle
LOGGING_LISTENER = OFF


mkdir /oracle/oradata
dbca -silent \
         -createDatabase \
                 -sid db11 \
                 -gdbName db11 \
                 -totalMemory 8192 \
                 -templateName General_Purpose.dbc \
                 -characterSet KO16MSWIN949 \
                 -datafileDestination /oracle/oradata \
                 -emConfiguration NONE \
                 -sysPassword orapwd \
                 -systemPassword orapwd

alter system set sga_max_size=20g scope=spfile;
alter system set sga_target=0 scope=spfile;
shut immediate
startup
@?/rdbms/admin/catbundle.sql cpu apply

18.207.157.152


  LIST

제목 작성자 작성일 조회
Admin  [ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅    최길호 2008/11/26 113
Admin  [ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 134
Troubleshoot  ORA-12521 listener does not currently know of instance requested in connect descriptor    최길호 2022/08/09 3
Script  ogg save table DML total count to table lv:9   최길호 2022/08/08 4
Admin  UDI-31626: operation generated ORACLE error 31626    최길호 2022/08/02 7
SQL,PL*SQL  제품 코드, 정기 검사, 다음 검사 검색, 재신청 하면 재신청일 기준 다음 검사 검색    최길호 2022/07/28 16
Troubleshoot  ORA-1653: unable to extend table SYS.IDL_UB2$ by 128 in tablespace SYSTEM    최길호 2022/07/26 11
WebLogic  which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace    최길호 2022/07/20 15
Troubleshoot  ORA-04021 / ORA-00054 / select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0    최길호 2022/07/08 29
Oracle GoldenGate  ERROR OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available | 1031-ORA-01031: insufficient privileges).    최길호 2022/07/05 30
Troubleshoot  DDE: Problem Key 'ORA 600 [13310]' was completely flood controlled (0x6)    최길호 2022/06/29 40
Oracle GoldenGate  Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.    최길호 2022/06/25 39
Admin  ORA-14452: attempt to create, alter or drop an index on temporary table already in use    최길호 2022/06/24 29
Admin  external table expdp    최길호 2022/06/18 46
Admin  clob to file / file to clob / clob_to_file / file_to_clob    최길호 2022/06/17 51
Troubleshoot  ORA-13203: failed to read USER_SDO_GEOM_METADATA view    최길호 2022/06/14 46
Troubleshoot  ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table    최길호 2022/06/13 71
Troubleshoot  Exception in kzam_upd_props, 942:ORA-00942: table or view does not exist    최길호 2022/06/11 44

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[145]   [다음 10개]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
08/10
[운영체제]
mobaxterm Remote desktop (RDP,....
by 최길호
08/09
[ORACLE]
ORA-12521 listener does not cu....
by 최길호
08/08
[ORACLE]
ogg save table DML total count....
by 최길호