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

CategoryTroubleshootStudy BookTuningBackup and RecoveryScriptInstall and ConfigApplication ServerAdminDULToolQ/ARAC,OPStrc filePro*CSQL,PL*SQLPatchTimes TenOracle GoldenGateWebLogicExadata	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
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)