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 [2888]
PostgreSQL [103]
±âŸÁ¤º¸ [150]
¿î¿µÃ¼Á¦ [577]
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, Á¶È¸ : 28

[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

3.235.78.122


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  [ °øÁö ] 😃 ¼­ºñ½º ½Ã°£ 08:00 ~ 23:00 / ¾ÈµÇ¸é ³ªÁß¿¡ ´Ù½Ã ¹æ¹® ÇØÁÖ¼¼¿ä~.😅    ÃÖ±æÈ£ 2008/11/26 113
Admin  [ ÇÊ¿ä ÇÏ½Å°Ô ÀÖÀ¸½Ã¸é ÂÊÁö ¶Ç´Â gilho.kr@gmail.com ¸ÞÀÏ ÁÖ¼¼¿ä~ ]    ÃÖ±æÈ£ 2006/07/14 134
Troubleshoot  DDE: Problem Key 'ORA 600 [13310]' was completely flood controlled (0x6)    ÃÖ±æÈ£ 2022/06/29 2
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 12
Admin  ORA-14452: attempt to create, alter or drop an index on temporary table already in use    ÃÖ±æÈ£ 2022/06/24 6
Admin  external table expdp    ÃÖ±æÈ£ 2022/06/18 26
Admin  clob to file / file to clob / clob_to_file / file_to_clob    ÃÖ±æÈ£ 2022/06/17 24
Troubleshoot  ORA-13203: failed to read USER_SDO_GEOM_METADATA view    ÃÖ±æÈ£ 2022/06/14 17
Troubleshoot  ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table    ÃÖ±æÈ£ 2022/06/13 21
Troubleshoot  Exception in kzam_upd_props, 942:ORA-00942: table or view does not exist    ÃÖ±æÈ£ 2022/06/11 20
Install and Config  Rocky Linux 8.6 Oracle 11.2    ÃÖ±æÈ£ 2022/06/03 28
Admin  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time    ÃÖ±æÈ£ 2022/06/02 31
Admin  http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm    ÃÖ±æÈ£ 2022/05/30 22
Admin  ÇÑ±Û ÆÄÀÏ ORA-22288: ÆÄÀÏ ¶Ç´Â LOB FILEOPEN ÀÛ¾÷ÀÌ ½ÇÆÐµÇ¾ú½À´Ï´Ù    ÃÖ±æÈ£ 2022/05/26 36
Admin  ORA-00001: unique constraint (SCOTT.TEST_PK) violated    ÃÖ±æÈ£ 2022/05/06 212
Troubleshoot  windows ORA-01031: insufficient privileges    ÃÖ±æÈ£ 2022/04/22 56
Admin  impdp ORA-01400: cannot insert NULL into , ORA-01449: column contains NULL    ÃÖ±æÈ£ 2022/04/19 52

    ¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö 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 ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by ÃÖ±æÈ£
06/25
[ORACLE]
Replication may not be valid i....
by ÃÖ±æÈ£
06/22
[¿î¿µÃ¼Á¦]
CentOS7 ȨÆäÀÌÁö Migration ¸Þ¸ð.
by ÃÖ±æÈ£