목록ORACLE (44)

DoubleDBDeep

[ORACLE] RMAN FULLBACKUP Shell Script

내가 쓸거 참조용 + archive log file도 같이 받음 + tnsnames.ora에 명시된 DB(@EM19)로 접속 ########################################################################## # # ORACLE ENV # ########################################################################## #!/usr/bin/bash ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1 ORACLE_SID=EM191 ORACLE_UNQNAME=EM19 BACKUP_LOG_PATH=/u01/rman/..
ORACLE/Backup & Recovery 2023. 12. 9. 19:16
[ORACLE] 19c 2 node RAC GRID Silent mode Installation

OS Requirement 설정부터 grid 설치까지.. 간단정리해두기 용 node 1 node 2 hostname CMDB1.localdomain CMDB2.localdomain pulic-ip 10.0.5.111 10.0.5.112 private-ip 10.0.1.111 10.0.1.112 virtual-ip 10.0.5.121 10.0.5.122 * 1번 노드 OS 설정 - SELINUX (CMDB1 root) vi /etc/selinux/config SELINUX=permissive setenforce permissive - hostname (CMDB1 root) hostnamectl status hostnamectl set-hostname CMDB1.localdomain - PROCESS 정리 ..
ORACLE/INSTALL 2023. 11. 19. 04:26
[ORACLE] 19c DBCA Silent mode command

내가 자주 써먹으려고 찌는 dbca command $ORACLE_HOME/bin/dbca -createDatabase -silent -gdbName [GLOBAL_DB_NAME] -sid [ORACLE_SID] \ -sysPassword "SYSPASSWORD" -systemPassword "SYSPASSWORD" \ -databaseType MULTIPURPOSE -responseFile NO_VALUE \ -dvConfiguration false -olsConfiguration false \ -registerWithDirService false -asmSysPassword "ASM SYSPASSWORD" \ -asmsnmpPassword "ASM SYSPASSWORD" -storageType ASM ..
ORACLE/INSTALL 2023. 9. 19. 13:17
이전 Prev 1 2 3 4 5 6 7 ··· 15 Next 다음