My Oracle Support Banner

Error While Running redeploy.sh While Upgrading To OPA 12.2.13 From 12.2.5 (Doc ID 2523604.1)

Last updated on NOVEMBER 18, 2020

Applies to:

Oracle Policy Automation - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms


Unable to upgrade to OPA 12.2.13 from 12.2.5

Facing below error while running redeploy.sh on the server:

Executing sql update script...
Delimiter set to '/'
Delimiter set to ';'
com.oracle.determinations.hub.exception.HubRuntimeException: error updating db schema
  at com.oracle.determinations.hub.exec.UpgradeDatabaseCommand.exec(UpgradeDatabaseCommand.java:127)
  at com.oracle.determinations.hub.exec.customer.BuildInstallAndRedeployCommand.exec(BuildInstallAndRedeployCommand.java:62)
  at com.oracle.determinations.hub.exec.HubExecCmdLineCustomer.main(HubExecCmdLineCustomer.java:184)
Caused by: java.io.IOException: Error executing sql from input stream.
SQL was 'create table NTP_OPA.SSL_PUBLIC_CERTIFICATE (
ssl_certificate_id NUMBER(9) NOT NULL,
certificate CLOB NULL,
last_updated DATE NULL,
fingerprint_sha256 VARCHAR(100) NULL,
CONSTRAINT ssl_certificate_pk PRIMARY KEY (ssl_certificate_id),
CONSTRAINT ssl_cert_unique_fingerprint UNIQUE (fingerprint_sha256)
) '.
Message was: ORA-00955: name is already used by an existing object

  at com.oracle.determinations.hub.exec.HubExecUtil.executeSQLStream(HubExecUtil.java:398)
  at com.oracle.determinations.hub.exec.UpgradeDatabaseCommand.exec(UpgradeDatabaseCommand.java:118)
  ... 2 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object






Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.