ORACLE

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]

기념일

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