OFSAA 8.0 Installation Schema Creation Failed. Errors Missing Grants
(Doc ID 2041249.1)
Last updated on FEBRUARY 28, 2025
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and laterOracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
On OFSAA 8.0.0, while doing the installation and running the offline schema creator script osc.sh, the script fails with the following errors:
ERROR
./osc.sh -o :
===================================================================================
Validating Connection URL ...jdbc:oracle:thin:@<HOSTNAME>:1521/<SID>
Successfully connected to User - infocfg URL - jdbc:oracle:thin:@<HOSTNAME>:1521/<SID>
<USER> User doesn't have SELECT grant on the table - DBA_ROLES
====================================================================
Schema Creation Failed.
====================================================================
Log file:
[Mon 03/8/2015 12:59:05] [SCHEMAUTILITY] [ INFO] - Validating Connection URL ...jdbc:oracle:thin:@<HOSTNAME>:1521/<SID>
[Mon 03/8/2015 12:59:05] [SCHEMAUTILITY] [ INFO] - Successfully connected to User - <USER> URL -jdbc:oracle:thin:@<HOSTNAME>:1521/<SID>
[Mon 03/8/2015 12:59:05] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from USER_TAB_PRIVS where UPPER(TABLE_NAME) = 'DBA_ROLES' and UPPER(PRIVILEGE) = 'SELECT'
[Mon 03/8/2015 12:59:06] [SCHEMAUTILITY] [ERROR] - <USER> User doesn't have SELECT grant on the table - DBA_ROLES
The user is setup such that the connecting user <USER> does have SELECT privilege on DBA_ROLES, but there is no role listed in USER_TAB_PRIVS.
The issue can be reproduced at will with the following steps:
1. Run osc.sh in offline mode, with database user that has the following privileges:
1. CREATE SESSION
2. SELECT on DBA_ROLES
3. SELECT on DBA_USERS
4. SELECT on DBA_DIRECTORIES
5. SELECT on DBA_TABLESPACES
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 |