docker-oracle-ords
docker-oracle-ords copied to clipboard
martindsouza
Error when deploying
Any thoughts on why I am getting this error? Thanks.
`[*** script: ords_prereq_env.sql]
INFO: Checking prerequisites for Oracle REST Data Services
Error starting at line : 47 in command -
begin
for c1 in (
select username from sys.dba_users where username in ('^ORDSSCHEMA', '^ORDSPUBUSR') order by 1
) loop
if (c1.username = 'ORDS_PUBLIC_USER' ) and (upper('^EXCLUDE_PUBLIC_USER') = 'TRUE') then
dbms_output.put_line('Exclude existence of common ORDS_PUBLIC_USER');
else
raise_application_error(-20002, 'ERROR: The user ' || c1.username || ' already exists. You must first uninstall ORDS using ords_uninstall.sql prior to running the install scripts.');
end if;
end loop;
end;
Error report -
ORA-06550: line 3, column 36:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 3, column 11:
PL/SQL: SQL Statement ignored
ORA-06550: line 5, column 11:
PLS-00364: loop index variable 'C1' use is invalid
ORA-06550: line 5, column 7:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:`
@scottcourtney What command did you use to launch this? Specifically is this to generate the configuration file? If so please check the -e SYS_PASS=Oracle18 \ password. In the example provided Oracle18 is just an example and is probably not your password.
So I am building it with Jenkins. Within Jenkins it does a "docker build -t bip-fasmod-ords .”
Thanks, Scott On Jan 20, 2020, 3:55 PM -0500, martindsouza [email protected], wrote:
@scottcourtney What command did you use to launch this? Specifically is this to generate the configuration file? If so please check the -e SYS_PASS=Oracle18 \ password. In the example provided Oracle18 is just an example and is probably not your password. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe.
@scottcourtney The build command just builds the docker container and only needs to be done once per docker image. Not sure why it would even be part of a Jenkins command (not an expert on Jenkins). The only reason we have the build command is because we can't post the image on Docker hub