Installing Satellite 5.5 with external Oracle database encounters error 'ORA-02291: integrity constraint (RHNSAT.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found'
Issue
- The following error was encountered while re-populating a Satellite 5.5 external database:
./install.pl --answer-file=/root/sat-inst-answers.txt --clear-db --skip-selinux-test --skip-ssl-cert-generation --skip-ssl-vhost-setup --external-db
** Database: Services stopped. Clearing DB.
*** Progress: #################################
Could not populate database.
insert into rhnPackageSyncBlacklist (package_name_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (RHNSAT.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found
- Satellite 5.5 installation with External database fails with following error:
Database service name (SID)? rhnsat
** Database: Testing database connection.
** Database: Populating database.
:
:
*** Progress: #################################
Could not populate database.
In /var/log/rhn/populate_db.log:
insert into rhnPackageSyncBlacklist (package_name_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (RHNSAT.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found
OR
Database service name (SID)? rhnsat
** Database: Testing database connection.
** Database: Populating database.
:
:
*** Progress: #################################
Could not populate database.
In /var/log/rhn/populate_db.log:
insert into rhnPackageSyncBlacklist (package_name_id)
*
ERROR at line 1:
ORA-02291: integrity constraint (RHNSUSER.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found
Environment
- Red Hat Network (RHN) Satellite 5.5
- External Oracle 11g
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
