search

oracle / adb-free

Universal Permissive License v1.0
35 stars 4 forks source link

Input JSON not found #18

Closed ACCBMW closed 2 months ago

ACCBMW commented 2 months ago

I had installed Oracle 19C on docker Run this command --> docker run -d -p 1521:1522 -p 1522:1522 -p 8443:8443 -p 27017:27017 -e WORKLOAD_TYPE='ATP' -e WALLET_PASSWORD=pass123 -e ADMIN_PASSWORD=pass123 --cap-add SYS_ADMIN --device /dev/fuse --name adb-free ghcr.io/oracle/adb-free:latest

Container starts but after few mins. it gives below error

Also Run this command but nothing happens, command --> docker exec adb-free adb-cli add-database --workload-type "ADW" --admin-password "Welcome_1234"

2024-04-18 11:53:14 Archive: /u01/POD1.zip 2024-04-18 11:53:14 creating: /u01/app/oracle/oradata/ 2024-04-18 11:53:14 creating: /u01/app/oracle/oradata/POD1/ 2024-04-18 11:53:14 creating: /u01/app/oracle/oradata/POD1/1448BDF51BE70DD7E063853946645191/ 2024-04-18 11:53:14 creating: /u01/app/oracle/oradata/POD1/1448BDF51BE70DD7E063853946645191/datafile/ 2024-04-18 11:53:14 inflating: /u01/app/oracle/oradata/POD1/1448BDF51BE70DD7E063853946645191/datafile/o1_mf_tempm01dvz70.tmp
2024-04-18 11:53:15 inflating: /u01/app/oracle/oradata/POD1/redo01.log
2024-04-18 11:53:15 creating: /u01/app/oracle/oradata/POD1/14716035B722431CE0636402000A9BD7/ 2024-04-18 11:53:15 creating: /u01/app/oracle/oradata/POD1/14716035B722431CE0636402000A9BD7/datafile/ 2024-04-18 11:53:15 inflating: /u01/app/oracle/oradata/POD1/redo02.log
2024-04-18 11:53:15 creating: /u01/app/oracle/oradata/POD1/147167519AA8472EE0636402000A7798/ 2024-04-18 11:53:15 creating: /u01/app/oracle/oradata/POD1/147167519AA8472EE0636402000A7798/datafile/ 2024-04-18 11:53:15 creating: /u01/app/oracle/oradata/POD1/datafile/ 2024-04-18 11:53:15 inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_undotbs1m01fswxh.dbf
2024-04-18 11:53:15 inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_tempm01dvy2l.tmp
2024-04-18 11:54:47 inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_systemm01dogtm.dbf
2024-04-18 11:55:47 inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_sysauxm01dogv2.dbf
2024-04-18 11:55:47 inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_tempm01fsxpg.tmp
2024-04-18 11:55:51 inflating: /u01/app/oracle/oradata/POD1/datafile/o1_mf_datam01dogvl.dbf
2024-04-18 11:55:51 creating: /u01/app/oracle/oradata/POD1/onlinelog/ 2024-04-18 11:55:51 creating: /u01/app/oracle/oradata/POD1/1471656206A546B4E0636402000ACA7D/ 2024-04-18 11:55:51 creating: /u01/app/oracle/oradata/POD1/1471656206A546B4E0636402000ACA7D/datafile/ 2024-04-18 11:55:51 creating: /u01/app/oracle/oradata/POD1/1449FAC698DB3341E0638539466443E4/ 2024-04-18 11:55:51 creating: /u01/app/oracle/oradata/POD1/1449FAC698DB3341E0638539466443E4/datafile/ 2024-04-18 11:55:51 inflating: /u01/app/oracle/oradata/POD1/1449FAC698DB3341E0638539466443E4/datafile/o1_mf_tempm01dw17o.tmp
2024-04-18 11:55:51 creating: /u01/app/oracle/oradata/POD1/controlfile/ 2024-04-18 11:55:52 inflating: /u01/app/oracle/oradata/POD1/controlfile/o1_mfm01dy2hr.ctl
2024-04-18 11:55:52 TIME ELAPSED Unzipping /u01/POD1.zip: 2 minutes and 38 seconds elapsed 2024-04-18 11:55:52 User input JSON not found 2024-04-18 11:55:52 Traceback (most recent call last): 2024-04-18 11:55:52 File "/u01/scripts/user_input.py", line 91, in 2024-04-18 11:55:52 generate_default_input_json() 2024-04-18 11:55:52 File "/u01/scripts/user_input.py", line 67, in generate_default_input_json 2024-04-18 11:55:52 raise ValueError(f"{database_name} is not alphanumeric") 2024-04-18 11:55:52 ValueError: MY'ATP' is not alphanumeric

aosingh commented 2 months ago

@ACCBMW

The error is -> MY'ATP' is not alphanumeric

Try the container start command without single quotes in WORKLOAD_TYPE

docker run -d \
-p 1521:1522 \
-p 1522:1522 \
-p 8443:8443 \
-p 27017:27017 \
-e WORKLOAD_TYPE=ATP \
-e WALLET_PASSWORD=pass123 \
-e ADMIN_PASSWORD=pass123 \
--cap-add SYS_ADMIN \
--device /dev/fuse \
--name adb-free \
ghcr.io/oracle/adb-free:latest

Also, the password pass123 does not meet complexity requirements. You might have to increase the length to alteast 8 characters and also include an uppercase character

ACCBMW commented 2 months ago

Thanks Its working now,