http://iotn.co.kr ¿¬¶ôó: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / ìíÜâïÙݤªÏìíÜâÏÚªÎàõîÜÒ¿ÖË?ßåíºªËÞóñªª¹ªÙª­. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [71]
02.File Book
File ÀÚ·á½Ç [95]
Site Link [17]
°³ÀÎÆú´õ [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [41]
DB2 [79]
ORACLE [2955]
PSQL [132]
±âŸÁ¤º¸ [155]
¿î¿µÃ¼Á¦ [591]
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, Á¶È¸ : 207

[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

timedatectl set-timezone Asia/Seoul

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
* soft stack 10240

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

shut immediate
startup
@?/rdbms/admin/catbundle.sql cpu apply

alter system set sga_max_size=20g scope=spfile;
alter system set sga_target=0 scope=spfile;
alter system set audit_trail='NONE' scope=spfile;
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
alter system set log_archive_dest_1='location=/oracle/arch/';
create directory expdp as '/oracle/backup';
alter system set streams_pool_size=200m;
drop public synonym OlapFactView;
drop public synonym OlapDimView;
drop public synonym DBMS_ODM;
delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'  and schema= 'SYS';
commit;


44.200.145.223


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Admin  [ °øÁö ] 😃 ¼­ºñ½º ½Ã°£ 08:00 ~ 23:00 / ¾ÈµÇ¸é ³ªÁß¿¡ ´Ù½Ã ¹æ¹® ÇØÁÖ¼¼¿ä~.😅    ÃÖ±æÈ£ 2008/11/26 113
Admin  [ ÇÊ¿ä ÇÏ½Å°Ô ÀÖÀ¸½Ã¸é ÂÊÁö ¶Ç´Â gilho.kr@gmail.com ¸ÞÀÏ ÁÖ¼¼¿ä~ ]    ÃÖ±æÈ£ 2006/07/14 134
Troubleshoot  ORA-27303: additional information: requested interface enp0s8 interface not running    ÃÖ±æÈ£ 2023/06/05 1
Install and Config  ORA-19504: failed to create file "+DATA" ORA-17502: ksfdcre:4 Failed to create file +DATA ORA-28040: No matching authentication protocol    ÃÖ±æÈ£ 2023/06/01 2
Troubleshoot  SEVERE: Inventory does not exist.    ÃÖ±æÈ£ 2023/05/31 1
Troubleshoot  ora.LISTENER.lsnr status: INTERMEDIATE / Not All Endpoints Registered,STABLE    ÃÖ±æÈ£ 2023/05/28 5
Admin  [INS-30515] Insufficient space available in the selected disks. 12.2 MGMT Á¦¿Ü ¼³Ä¡    ÃÖ±æÈ£ 2023/05/25 3
Admin  Error 12541 received logging on to the standby    ÃÖ±æÈ£ 2023/05/20 6
Admin  SQL ±âÃÊ ±³À° [ pdf ppt ]     ÃÖ±æÈ£ 2023/05/11 16
Admin  java delete [ java archvie log delete source ] ÆÄÀÏ °³¼ö À¯Áö [ ORACLE SQL> ½ÇÇà ] PLS-00311: the declaration of    ÃÖ±æÈ£ 2023/04/17 15
Install and Config  create user MDSYS / INSERT INTO MDSYS.CS_SRS Áö¸®Á¤º¸Ã¼°è(GIS) °ø°£Á¤º¸ /    ÃÖ±æÈ£ 2023/04/05 21
Admin  ORA-00279 ORA-279 signalled during: alter database recover if needed    ÃÖ±æÈ£ 2023/04/04 18
Admin  Java (1.7) could not be located. OPatch cannot proceed! / OPatch returns with error code = 1    ÃÖ±æÈ£ 2023/03/14 9
Admin  EXP-00111: Table CREATE$JAVA$LOB$TABLE resides in an Encrypted Tablespace / ORA-39189: unable to decrypt dump file set    ÃÖ±æÈ£ 2023/03/10 9
Admin  ORA-02292 ORA-02298    ÃÖ±æÈ£ 2023/02/28 16

    ¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö 1 [2][3][4][5][6][7][8][9][10]..[148]   [´ÙÀ½ 10°³]
       

Copyright 1999-2023 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/05
[ORACLE]
ORA-27303: additional informat....
by ÃÖ±æÈ£
06/02
[°Ô½ÃÆÇ]
2023³â Àû¿ë SW(¼ÒÇÁÆ®¿þ¾î)±â¼úÀÚ Æò±ÕÀÓ±Ý ....
by ÃÖ±æÈ£
06/01
[ORACLE]
ORA-19504: failed to create fi....
by ÃÖ±æÈ£