search

martindsouza / docker-oracle-ords

ORDS Docker Image
MIT License
33 stars 25 forks source link

Error when deploying #22

Open scottcourtney opened 4 years ago

scottcourtney commented 4 years ago

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

  1. 00000 - "line %s, column %s:\n%s" Cause: Usually a PL/SQL compilation error. Action:`
martindsouza commented 4 years ago

@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.

scottcourtney commented 4 years ago

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 notifications@github.com, 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.

martindsouza commented 4 years ago

@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