1) Oracle 12c 다운로드
- 오라클 다운로드 : https://edelivery.oracle.com/osdc/faces/Home.jspx
- 회원가입 또는 로그인
- 'Oracle Database 12c Enterprise Edition' 검색 후 'DLP: Oracle Database 12c Enterprise Edition 12.2.0.1.0 ( Oracle Database Enterprise Edition )' 로 접속
※ 아래와 같이 이미 다운로드 대기열에 있다고 팝업창이 뜨면 'View Items'에서 'Continue' 클릭
- 'Oracle Database 12.2.0.1.0', ' Oralce Database Client 12.0.1.0' 체크 후 'Continue' 클릭
(필요한 구성에 따라 항목을 선택해 설치하시면 됩니다. )
설치 시 필수/선택 여부
필수:
- Oracle Database 12c Enterprise Edition
- Oracle Database Grid Infrastructure (RAC 환경 필요 시)
선택:
- Oracle Database Client: 클라이언트 시스템에서 사용
- Oracle HTTP Server: 웹 서비스 제공 시 필요
- Oracle Database Global Service Manager: 로드 밸런싱 및 글로벌 환경 구축 시
- Oracle NoSQL Database: 비정형 데이터 사용 시
- 라이센스 동의 후 'Continue' 클릭
- 'Download' 클릭
- 다운로드된 exe파일을 실행하여 Oracle 설치파일들 다운
2) CentOS7 VM만들기
- VM 환경구성
* 'Minimal Install' 에서 옵션 전부 체크 후 설치!
3) OS 환경설정
- 네트워크 설정
- 네트워크 파일 수정 및 확인
vi /etc/sysconfig/network-scripts/ifcfg-Ethernet_connection_1
MACADDR=08:00:27:C6:9E:@@
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=none
IPADDR=192.168.@@.@@@
PREFIX=24
GATEWAY=192.168.@@.@@@
DNS1=8.8.8.8
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME="Ethernet connection 1"
UUID=c341c578-384a-4d4f-b67d-e17016473fdd
AUTOCONNECT_PRIOPITY=-999
ONBOOT=yes
- /etc/hosts 파일 수정
[root@localhost ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
# 해당 IP 추가
192.168.@@.@@@ centos7 loghost
- 네트워크 및 인터페이스 활성화
systemctl restart network -- 네트워크 서비스 재시작
# nmcli connection reload -- 네트워크 서비스 재시작
# ip link set enp0s8 up -- 인터페이스 활성화
- 오라클 필수 라이브러리 설치 (root 계정)
yum install -y binutils compat-libcap1 compat-libstdc++-33 \
gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel \
libX11 libXau libXi libXtst libgcc libstdc++ libstdc++-devel \
make sysstat unixODBC unixODBC-devel
yum install -y smartmontools net-tools
yum install java-1.8.0-openjdk-devel -y* 라이브러리 설치 안될 시 아래 '더보기' 참조
더보기
1. 'connot find a valid baseurl for repo: base/7/x86_64' 에러
## 장애현상
[root@localhost ~]# yum -y install compat-libstdc++-33.x86_64 binutils elfutils-libelf elfutils-libelf-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Could not retrieve mirrorlist http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=os&infra=stock error was
14: curl#6 - "Could not resolve host: mirrorlist.centos.org; Unknown error"
One of the configured repositories failed (Unknown),
and yum doesn't have enough cached data to continue. At this point the only
safe thing yum can do is fail. There are a few ways to work "fix" this:
1. Contact the upstream for the repository and get them to fix the problem.
2. Reconfigure the baseurl/etc. for the repository, to point to a working
upstream. This is most often useful if you are using a newer
distribution release than is supported by the repository (and the
packages for the previous distribution release still work).
3. Run the command with the repository temporarily disabled
yum --disablerepo=<repoid> ...
4. Disable the repository permanently, so yum won't use it by default. Yum
will then just ignore the repository until you permanently enable it
again or use --enablerepo for temporary usage:
yum-config-manager --disable <repoid>
or
subscription-manager repos --disable=<repoid>
5. Configure the failing repository to be skipped, if it is unavailable.
Note that yum will try to contact the repo. when it runs most commands,
so will have to try and fail each time (and thus. yum will be be much
slower). If it is a very temporary problem though, this is often a nice
compromise:
yum-config-manager --save --setopt=<repoid>.skip_if_unavailable=true
Cannot find a valid baseurl for repo: base/7/x86_64
## 해결방안
# 1. CentOS-Base.repo 파일에서 모든 'mirrorlist' 항목을 주석 처리하고 'baseurl' 값은 http://vault.centos.org/7.9.2009/os/$basearch/ 으로 변경
[root@localhost ~]# vi /etc/yum.repos.d/CentOS-Base.repo
[base]
name=CentOS-$releasever - Base
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os&infra=$infra
baseurl=http://vault.centos.org/7.9.2009/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
#released updates
[updates]
name=CentOS-$releasever - Updates
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates&infra=$infra
baseurl=http://vault.centos.org/7.9.2009/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
#additional packages that may be useful
[extras]
name=CentOS-$releasever - Extras
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras&infra=$infra
baseurl=http://vault.centos.org/7.9.2009/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
#additional packages that extend functionality of existing packages
# 2. resolv.conf에 nameserver 추가
[root@localhost ~]# vi /etc/resolv.conf
# Generated by NetworkManager
nameserver 8.8.8.8 # 추가
nameserver 8.8.4.4 # 추가
# 3. yum 캐시 삭제
[root@localhost ~]# yum clean all
2. 'Protected multilib versions: glibc-2.17-317.el7.i686 != glibc-2.17-326.el7_9.x86_64' 에러
## 장애현상
[root@localhost ~]# yum -y install compat-libstdc++-33.x86_64 binutils elfutils-libelf elfutils-libelf-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Package matching binutils-2.27-44.base.el7.x86_64 already installed. Checking for update.
Package elfutils-libelf-0.176-5.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.el7 will be installed
---> Package elfutils-libelf-devel.x86_64 0:0.176-5.el7 will be installed
--> Processing Dependency: pkgconfig(zlib) for package: elfutils-libelf-devel-0.176-5.el7.x86_64
--> Running transaction check
---> Package zlib-devel.x86_64 0:1.2.7-18.el7 will be installed
--> Processing Dependency: zlib = 1.2.7-18.el7 for package: zlib-devel-1.2.7-18.el7.x86_64
--> Running transaction check
---> Package zlib.i686 0:1.2.7-18.el7 will be installed
--> Processing Dependency: libc.so.6(GLIBC_2.4) for package: zlib-1.2.7-18.el7.i686
--> Running transaction check
---> Package glibc.i686 0:2.17-317.el7 will be installed
--> Processing Dependency: glibc-common = 2.17-317.el7 for package: glibc-2.17-317.el7.i686
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.17-317.el7.i686
--> Processing Dependency: libfreebl3.so for package: glibc-2.17-317.el7.i686
--> Running transaction check
---> Package glibc-common.x86_64 0:2.17-317.el7 will be installed
---> Package nss-softokn-freebl.i686 0:3.44.0-8.el7_7 will be installed
--> Finished Dependency Resolution
Error: Multilib version problems found. This often means that the root
cause is something else and multilib version checking is just
pointing out that there is a problem. Eg.:
1. You have an upgrade for glibc which is missing some
dependency that another package requires. Yum is trying to
solve this by installing an older version of glibc of the
different architecture. If you exclude the bad architecture
yum will tell you what the root cause is (which package
requires what). You can try redoing the upgrade with
--exclude glibc.otherarch ... this should give you an error
message showing the root cause of the problem.
2. You have multiple architectures of glibc installed, but
yum can only see an upgrade for one of those architectures.
If you don't want/need both architectures anymore then you
can remove the one with the missing update and everything
will work.
3. You have duplicate versions of glibc installed already.
You can use "yum check" to get yum show these errors.
...you can also use --setopt=protected_multilib=false to remove
this checking, however this is almost never the correct thing to
do as something else is very likely to go wrong (often causing
much more problems).
Protected multilib versions: glibc-2.17-317.el7.i686 != glibc-2.17-326.el7_9.x86_64
Error: Protected multilib versions: zlib-1.2.7-18.el7.i686 != zlib-1.2.7-20.el7_9.x86_64
Error: Protected multilib versions: nss-softokn-freebl-3.44.0-8.el7_7.i686 != nss-softokn-freebl-3.67.0-3.el7_9.x86_64
## 무시
3. 'Failed to set locale, defaulting to C' 에러
## 장애현상
[root@localhost ~]# yum clean all
Failed to set locale, defaulting to C
## 해결방법
# 1. bashrc 파일에 export LANG 추가 후 적용
[root@localhost ~]# vi /etc/bashrc
export LANG=C
[root@localhost ~]# source /etc/bashrc
- 커널 파라미터 값 설정
아래와 같이 sysctl.conf파일에 파라미터값 설정
[root@localhost ~]# vi /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
kernel.sem = 1000 32000 1000 1000
kernel.shmmni = 16384
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 16777216
#fs.inode-max=67108864
fs.aio-max-nr = 1048576
- 커널 파라미터 값 적용
[root@localhost ~]# /sbin/sysctl -p
- SELINUX 설정 해제
[root@localhost ~]# vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
#SELINUX=enforcing
SELINUX=disabled <- 추가
# SELINUXTYPE= can take one of three values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
- 방화벽 해제
[root@localhost ~]# systemctl disable firewalld
4) 유저 생성 및 환경변수, 권한 설정
- 오라클 유저 생성 및 패스워드 설정
[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# useradd -g oinstall -G dba oracle
[root@localhost ~]# passwd oracle
Changing password for user oracle.
New password: {패스워드 입력}
BAD PASSWORD: The password is shorter than 8 characters
Retype new password: {패스워드 입력}
passwd: all authentication tokens updated successfully.
- 오라클 계정의 리소스 제한 설정
[root@localhost ~]# vi /etc/security/limits.conf
# 아래 5줄 추가
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
- 오라클 계정 환경변수 설정
[oracle@localhost ~]$ vi .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export TMP=/tmp
export TMDIR=$TMP
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=orcl
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1
export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl
export LD_LIBRARY=_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH=$ORACLE_HOME/bin:$PATH
alias sql='sqlplus /as sysdba'
alias oh='cd $ORACLE_HOME'
5) 오라클 설치
- 설치 전 설치 경로 생성 및 권한 설정
mkdir -p /u01/app/oracle
mkdir -p /home/oracle/oraInventory
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /home/oracle/oraInventory
chmod -R 755 /u01/app/oracle
chmod -R 755 /home/oracle/oraInventory
chmod g+s /u01/app/oracle
chmod g+s /home/oracle/oraInventory
- 오라클에서 다운받은 Oracle설치파일 압축해제 및 response파일들(.rsp) 복사
# V839960-01.zip -> Oracle_Database_12.2.0.1.0_for_Linux_x86-64.zip 으로 이름 변경함
[oracle@localhost ~]$ unzip Oracle_Database_12.2.0.1.0_for_Linux_x86-64.zip
# 압축해제 후
[oracle@localhost ~]$ cd /home/oracle/database/response
[oracle@localhost response]$ cp *.rsp ~/
# 홈 디렉토리로 이동
- db_install.rsp 파일 수정 및 Oracle 12c 엔진 설치
# 복사된 파일 확인
[oracle@localhost ~]$ ls -al
-rwxr-xr-x 1 oracle oinstall 22924 Nov 20 10:30 db_install.rsp
-rwxr-xr-x 1 oracle oinstall 25502 Nov 20 10:30 dbca.rsp
-rwxr-xr-x 1 oracle oinstall 6209 Nov 20 10:30 netca.rsp
# db_install.rsp파일 수정
#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0
#-------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
# - INSTALL_DB_SWONLY
# - INSTALL_DB_AND_CONFIG
# - UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/home/oracle/oraInventory
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#-------------------------------------------------------------------------------
ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/oracle
#-------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value should contain only one of these choices.
# - EE : Enterprise Edition
# - SE2 : Standard Edition 2
#-------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
.
.
.
#------------------------------------------------------------------------------
# Specify whether to enable the user to set the password for
# My Oracle Support credentials. The value can be either true or false.
# If left blank it will be assumed to be false.
#
# Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
#------------------------------------------------------------------------------
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be true.
#
# Example : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=true
* db_install.rsp 파일의 수정된 부분 확인
- runinstaller 명령으로 silent모드로 db_install.rsp 파일 테스트 및 실행
[oracle@localhost ~]$ cd database
[oracle@localhost database]$ ./runInstaller -silent -executePrereqs -responseFile ~/db_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 24679 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3967 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-11-20_10-53-08AM. Please wait ...[oracle@localhost database]$ [WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /tmp/OraInstall2024-11-20_10-53-08AM/installActions2024-11-20_10-53-08AM.log
ACTION: Identify the list of failed prerequisite checks from the log: /tmp/OraInstall2024-11-20_10-53-08AM/installActions2024-11-20_10-53-08AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
A log of this session is currently saved as: /tmp/OraInstall2024-11-20_10-53-08AM/installActions2024-11-20_10-53-08AM.log. Oracle recommends that if you want to keep this log, you should move it from the temporary location.# 오라클 엔진 설치
[oracle@localhost database]$ ./runInstaller -waitforcompletion -showProgress -silent -responseFile ~/db_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 25604 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3935 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-11-21_01-23-00PM. Please wait ...You can find the log of this install session at:
/home/oracle/oraInventory/logs/installActions2024-11-21_01-23-00PM.log
Prepare in progress.
.................................................. 8% Done.
Prepare successful.
Copy files in progress.
.................................................. 17% Done.
.................................................. 22% Done.
.................................................. 27% Done.
.................................................. 32% Done.
.................................................. 40% Done.
.................................................. 45% Done.
.................................................. 50% Done.
.................................................. 55% Done.
.................................................. 60% Done.
.................................................. 65% Done.
.................................................. 70% Done.
.................................................. 75% Done.
.................................................. 80% Done.
....................
Copy files successful.
Link binaries in progress.
..........
Link binaries successful.
Setup files in progress.
..............................
Setup files successful.
Setup Inventory in progress.
Setup Inventory successful.
Finish Setup successful.
The installation of Oracle Database 12c was successful.
Please check '/home/oracle/oraInventory/logs/silentInstall2024-11-21_01-23-00PM.log' for more details.
Setup Oracle Base in progress.
Setup Oracle Base successful.
.................................................. 95% Done.
As a root user, execute the following script(s):
1. /home/oracle/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/12.2.0/dbhome_1/root.sh
.................................................. 100% Done.
Successfully Setup Software.
* '[WARNING] [INS-13014] Target environment does not meet some optional requirements.' 뜬 경우
- 대상 환경이 일부 선택적 요구 사항을 충족하지 않아 경고문 출력이 됨
- 해당 결과에 출력된 로그(/tmp/OraInstall2024-11-20_10-53-08AM/installActions2024-11-20_10-53-08AM.log) 확인 후 오류 내용이 기록되어 있지 않다면 무시하고 그대로 진행해도됨
Oracle Listener 생성
- 'SHOW_GUI' 를 false로 변경
[oracle@localhost ~]$ vi netca.rsp
.
.
.
#-------------------------------------------------------------------------------
# Name : SHOW_GUI
# Datatype : Boolean
# Description: This variable controls appearance/suppression of the NetCA GUI,
# Pre-req : N/A
# Default : TRUE
# Note:
# This must be set to false in order to run NetCA in silent mode.
# This is a substitute of "/silent" flag in the NetCA command line.
# The command line flag has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
SHOW_GUI=false
- natca.rsp 실행
[oracle@localhost bin]$ cd $ORACLE_HOME/bin
[oracle@localhost bin]$ ./netca /silent /responsefile ~/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/oracle/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/12.2.0/dbhome_1/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
데이터베이스 생성
- dbca.rsp 파일 수정
[oracle@localhost ~]$ vi dbca.rsp
# 아래 항목들 수정
gdbName=orcl
sid=orcl
databaseConfigType=SI
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=orapdb
pdbAdminPassword=oracle
templateName=General_Purpose.dbc
sysPassword=oracle
systemPassword=oracle
datafileDestination=/oradata
recoveryAreaDestination=/FRA
storageType=FS
characterSet=AL32UTF8
nationalCharacterSet=AL16UTF16
listeners=LISTENER
databaseType=MULTIPURPOSE
automaticMemoryManagement=FASLE
totalMemory=1024
데이터베이스 설치
- dbca.rsp 파일 설정
[oracle@centos ~]$ vi dbca.rsp
#아래 항목들 수정
gdbName=orcl
sid=orcl
databaseConfigType=SI
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=orapdb
pdbAdminPassword=oracle
templateName=General_Purpose.dbc
sysPassword=oracle
systemPassword=oracle
datafileDestination=/u10/app/oracle/oradata
recoveryAreaDestination=/u10/app/oracle/fast_recovery_area
storageType=FS
characterSet=AL32UTF8
nationalCharacterSet=AL16UTF16
listeners=LISTENER
databaseType=MULTIPURPOSE
automaticMemoryManagement=FALSE
totalMemory=1024
- dbca.rsp 실행
[oracle@centos bin]$ ./dbca -silent -createDatabase -responseFile ~/dbca.rsp
[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
[WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards.
CAUSE:
a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
b.The password entered is a keyword that Oracle does not recommend to be used as password
ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.
Copying database files
1% complete
13% complete
25% complete
Creating and starting Oracle instance
26% complete
30% complete
31% complete
35% complete
38% complete
39% complete
41% complete
Completing Database Creation
42% complete
43% complete
44% complete
46% complete
49% complete
50% complete
Creating Pluggable Databases
55% complete
75% complete
Executing Post Configuration Actions
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.* 'Oracle recommends that the password entered' 패스워드가 정책에 맞지 않아 경고가 발생, 무시하고 진행
- 설치 확인
[oracle@centos bin]$ sql
SQL> select instance_name from v$instance;
INSTANCE_NAME
--------------------------------
orcl
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
0
PL/SQL Release 12.2.0.1.0 - Production
0
CORE 12.2.0.1.0 Production
0
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
TNS for Linux: Version 12.2.0.1.0 - Production
0
NLSRTL Version 12.2.0.1.0 - Production
0
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
[oracle@centos bin]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-NOV-2024 09:08:27
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=centos)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 21-NOV-2024 17:12:34
Uptime 0 days 15 hr. 55 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/centos/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "27690e6c60826ab0e063f214a8c0aaa0" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orapdb" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
