Error when upgrading the Site Admin schema with ALM 12.53 with Oracle 12c

When upgrading a site admin schema on Oracle 12 using ALM 12.53 the following error might occur…

ERROR: The database administrator [qcsiteadmin_db] does not have all the required permissions, or the schema password does not meet the password policy requirements.

This error will occur with a valid password and permissions in place.

This error will occur when ALM 12.53 is being deployed on either Windows or Linux platforms.

This error will occur if the Oracle Administrator specified in ALM 12.53 is the “system” or “sys” user.

Create a new Oracle user with elevated credentials using the below script…

create user <oraAdminUserName> identified by <password>
default tablespace alm_data temporary tablespace temp;
grant create session to <oraAdminUserName> with admin option;
grant create user to <oraAdminUserName>;
grant drop user to <oraAdminUserName>;
grant create table to <oraAdminUserName> with admin option;
grant create view to <oraAdminUserName> with admin option;
grant create trigger to <oraAdminUserName> with admin option;
grant create sequence to <oraAdminUserName> with admin option;
grant create procedure to <oraAdminUserName> with admin option;
grant ctxapp to <oraAdminUserName> with admin option;
grant select on dba_free_space to <oraAdminUserName>;
grant select on sys.dba_tablespaces to <oraAdminUserName>;
grant select on sys.dba_users to <oraAdminUserName>;
grant select on sys.dba_registry to <oraAdminUserName>;
grant select on sys.dba_roles to <oraAdminUserName>;
grant QC_SELECT_ON_SYS_OBJECTS to <oraAdminUserName>;
grant select any table to <oraAdminUserName> with admin option;
grant insert any table to <oraAdminUserName>;

Then specify the user created in the above script as the Oracle admin user in ALM 12.53.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s