topic Re: New Problem, Different Day! in Operating System - HP-UX

New Problem, Different Day!

Scott Buckingham — Mon, 01 Oct 2001 13:34:33 GMT

Hello.

Are you getting tired of me yet? I hope not. Today's issue is trying to "connect" my new user to an 8.1.7 Oracle database using SQL*Plus. When I do this, I receive the following:

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

So I connect as SYSTEM and run this script. The results are the same. Any suggestions?

Re: New Problem, Different Day!

Thierry Poels_1 — Mon, 01 Oct 2001 14:12:00 GMT

hmmmz,

to get rid of that "error", only thing you've got to do is to execute $ORACLE_HOME/sqlplus/admin/pupbld.sql as SYSTEM. This should result in a table system.sqlplus_product_profile along with a view and a public synonym for that view.
nothing I can add :(

good luck,
Thierry.

Re: New Problem, Different Day!

Andreas D. Skjervold — Mon, 01 Oct 2001 20:19:41 GMT

Hi again Scott!

Here is Oracles solution:
If you have run the "PUPBLD.SQL" script and are still receiving this warning,
then do the following:

Connect as user system, drop the PRODUCT_PRIVS view and rerun the "PUPBLD.SQL"
script.

Andreas

And remember New problems is what we live for..

Avoid ending up in "Same thing Different Day" - Stephen King: Dreamcatcher

Re: New Problem, Different Day!

Andreas D. Skjervold — Fri, 05 Oct 2001 05:38:47 GMT

Hi again Scott;
Did you solve this one?

Just curious

Andreas

Re: New Problem, Different Day!

Scott Buckingham — Fri, 05 Oct 2001 14:56:17 GMT

Sorry Andreas, I haven't been able to get back to this project yet. But I'm hoping today! Thanks for the suggestion and I'll be sure to let you know when I get to that point.

By the way, what can you tell me about running three different versions of Oracle on one box? We have 7.3.4.5 in one instance, 8.1.5 in another, and now 8.1.7 in yet another. Can all 3 of these coexist AND run without conflict? I'm suspecting not.

Re: New Problem, Different Day!

Stefan Farrelly — Fri, 05 Oct 2001 15:05:41 GMT

You can run multiple versions of Oralce on the same HP server, we do here a lot. As long as you have clearly defined installation directories for each version, and enough system resources (RAM, disk etc.) then no conflicts.

Re: New Problem, Different Day!

Scott Buckingham — Fri, 05 Oct 2001 15:33:54 GMT

Hi Andreas,

I tried your suggestion but the results are the same. Could it be that my new user (test817) doesn't have the right permissions or something on that line?

Re: New Problem, Different Day!

Thierry Poels_1 — Fri, 05 Oct 2001 16:04:07 GMT

hi,
do you get the error only for the new user (test817)??
The script should grant to public, so it should be all or nothing.

regards,
Thierry.

Re: New Problem, Different Day!

Scott Buckingham — Fri, 05 Oct 2001 16:23:01 GMT

Thierry,

Yes, it only occurs on user test817. However, that is the only user I have so far. I used the Enterprise Manager to create this user, using CONNECT and RESOURCE roles. This seems to be consistent with what was done in the past so I was following the previous DBA's lead. Is there more to it in 8.1.7?

Re: New Problem, Different Day!

Thierry Poels_1 — Fri, 05 Oct 2001 16:50:25 GMT

YES!! I'v got the 10-pointer ;))

You've been running the wrong pupbld.sql! Run the pupbld.sql script from the Oracle 8.1.7 directory, and your problems are gone.
(Thank you for your question about multiple databases on one serer, this question really bugged me :)))

Thierry.

Re: New Problem, Different Day!

Thierry Poels_1 — Fri, 05 Oct 2001 17:13:17 GMT

hmmmz, I'm losing confidence in my answer :(
I checked Oracle Metalink and found more options:

1. your SYSTEM tablespace might be short on space, increase size and rerun catalog.sql, catproc.sql, pupbld.sql

2. due to multiple environments some environment variable might be wrong, check all and exec:
export TNS_ADMIN=${ORACLE_HOME}/network/admin
export ORA_NLS33=${ORACLE_HOME}/ocommon/nls/admin/data
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${ORACLE_HOME}/network/lib
export LIBPATH=${ORACLE_HOME}/lib

3. execute each step in pupbld.sql manually and correct any errors; only drop should generate errors.

good luck,
Thierry.