OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 12.2.0.1
에러 : [FATAL] [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB.
silent mode로 dbca 시 아래 에러 발생
|
1
2
3
|
$ dbca -silent -createDatabase -responseFile ./dbca.rsp
[FATAL] [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB.
CAUSE: The current total physical memory is 5GB.
|
해결 방법 : dbca.rsp 파일을 열어서 automaticMemoryManagement=FALSE 로 변경
dbca.rsp 파일을 열어서 해당 파라미터 변경
|
1
|
automaticMemoryManagement=TRUE
|
TRUE로 되어 있을텐데
|
1
|
automaticMemoryManagement=FALSE
|
FALSE로 변경
dbca 재시도
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
$ 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.
Copying database files
1% complete
2% complete
18% complete
33% complete
Creating and starting Oracle instance
35% complete
40% complete
44% complete
49% complete
50% complete
53% complete
55% complete
Completing Database Creation
56% complete
57% complete
58% complete
62% complete
65% complete
66% complete
Executing Post Configuration Actions
100% complete
Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/ORAC12/ORAC12.log" for further details.
|
정상 완료됨
원인 : AMM을 사용하고싶은 경우 메모리 설정을 4GB 이하로 설정해야함 그이상을 사용하고싶은경우 AMM을 해제해야함
AMM을 사용하고싶은 경우 메모리 설정을 4GB 이하로 설정해야함 그이상을 사용하고싶은경우 AMM을 해제해야함
참조 :
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (2) | 2019.02.18 |
|---|---|
| ORA-01308: dictionary directory is not set (0) | 2019.02.15 |
| DIA0 프로세스의 과도한 pga 사용 문제 (0) | 2019.02.08 |
| 오라클 bdump 경로에 생기는 cdmp 폴더 (0) | 2019.02.01 |
| ORA-12012 , ORA-20001 AND ORA-06512 FROM ORA$AT_OS_OPT_SY_XXX (0) | 2019.01.30 |