- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- New Problem, Different Day!
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2001 06:34 AM
тАО10-01-2001 06:34 AM
New Problem, Different Day!
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2001 07:12 AM
тАО10-01-2001 07:12 AM
Re: New Problem, Different Day!
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2001 01:19 PM
тАО10-01-2001 01:19 PM
Re: New Problem, Different Day!
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2001 10:38 PM
тАО10-04-2001 10:38 PM
Re: New Problem, Different Day!
Did you solve this one?
Just curious
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2001 07:56 AM
тАО10-05-2001 07:56 AM
Re: New Problem, Different Day!
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2001 08:05 AM
тАО10-05-2001 08:05 AM
Re: New Problem, Different Day!
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2001 08:33 AM
тАО10-05-2001 08:33 AM
Re: New Problem, Different Day!
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2001 09:04 AM
тАО10-05-2001 09:04 AM
Re: New Problem, Different Day!
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2001 09:23 AM
тАО10-05-2001 09:23 AM
Re: New Problem, Different Day!
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2001 09:50 AM
тАО10-05-2001 09:50 AM
Re: New Problem, Different Day!
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.