You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:`
The text was updated successfully, but these errors were encountered:
@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.
On Jan 20, 2020, 3:55 PM -0500, martindsouza ***@***.***>, 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
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:`
The text was updated successfully, but these errors were encountered: