SQL*Plus Logins as ODS and ASR Replication Admin User to Replica OID 11g Database Returns: Error accessing PRODUCT_USER_PROFILE
Last updated on MARCH 08, 2017
Applies to:Oracle Internet Directory - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Oracle Internet Directory (OID) 11g (11.1.1.x.0)
Setup a Master OID and then a Replica by following ASR based replication documentation:
Oracle Fusion Middleware Administrator's Guide for Oracle Internet Directory 11g Release 1 (11.1.1) Part Number E10029-02
Appendix C Setting Up Oracle Database Advanced Replication-Based Replication
Logins to the Master/MDS OID Database (DB) with sqlplus as ODS, or the Replication Admin user (i.e., repadmin) are both successful.
But logins to the Replica/RMS OID DB with sqlplus as ODS, or the Replication Admin user return the following warning message:
SQL*Plus: Release 126.96.36.199.0 - Production on Thu Aug 26 14:14:05 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production
Does this indicate a problem with the Replica? If not, how to eliminate this warning?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms