My Oracle Support Banner

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 AUGUST 11, 2021

Applies to:

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


Oracle Internet Directory (OID) 11g (11.1.1.x.0)

Setup a Primary OID Node and then a Replica Node 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 Primary 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@oiddb

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

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

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

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


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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.