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 최길호