SQL*Plus Logins as ODS and ASR Replication Admin User to Replica OID 11g Database Returns: Error accessing PRODUCT_USER_PROFILE (Doc ID 1189695.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Directory - Version 11.1.1.1.0 and later
Information in this document applies to any platform.

Goal

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:

> sqlplus ods@myoiddb

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Aug 26 14:14:05 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter password:
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

SQL>



Does this indicate a problem with the Replica?  If not, how to eliminate this warning?

Solution

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