?
Solved

cannot load library unit  (referenced by SYS.DBMS_APPLICATION_INFO)

Posted on 2003-03-14
5
Medium Priority
?
5,615 Views
Last Modified: 2007-12-19


Does anyone know what this means
.................
sun250cs-B% sqlplus loginname/passwd@db

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Mar 14 12:26:49 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06550: line 0, column 0:
PLS-00907: cannot load library unit  (referenced by
SYS.DBMS_APPLICATION_INFO)
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> exit

and.............

Why would all users, even sa lose acess to the all_objects table?

are these related?


thanks and regards

Ricky
0
Comment
Question by:rickyr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 5

Expert Comment

by:DrJekyll
ID: 8136080
Try logging as sys and run
@$ORACLE_HOME/rdbms/admin/dbmsutil.sql
0
 

Expert Comment

by:SReddy88
ID: 8139481
Try logging as sys and run
@$ORACLE_HOME/sqlplus/admin/pupbld.sql

I guess this is something to do with PORDUCT_USER_PROFILE if you have not run this script after your database creation along with catalog.sql and catproc.sql scripts.
0
 
LVL 3

Author Comment

by:rickyr
ID: 8150825
DrJekyll, what has this just done?????
how do i get it back to how it was before?
The last thing i want is to be getting solutions from here that cause more problems?

SQL> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
DROP SYNONYM PRODUCT_USER_PROFILE
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist



Table created.

DROP TABLE PRODUCT_USER_PROFILE
           *
ERROR at line 1:
ORA-00942: table or view does not exist



Table altered.

CREATE TABLE SQLPLUS_PRODUCT_PROFILE
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object


DROP TABLE PRODUCT_PROFILE
           *
ERROR at line 1:
ORA-00942: table or view does not exist


DROP VIEW PRODUCT_PRIVS
*
ERROR at line 1:
ORA-00942: table or view does not exist



View created.


Grant succeeded.


Synonym dropped.


Synonym created.

DROP SYNONYM PRODUCT_USER_PROFILE
             *
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist



Synonym created.


Synonym dropped.


Synonym created.

SQL>

0
 
LVL 3

Author Comment

by:rickyr
ID: 8150854
Also.............
What has this done?????

SQL> @$ORACLE_HOME/rdbms/admin/dbmsutil.sql

Package created.


Synonym dropped.


Synonym created.


Grant succeeded.


Package created.


Synonym dropped.


Synonym created.


Grant succeeded.


Package created.


Synonym dropped.


Synonym created.


Grant succeeded.


Package created.


Synonym dropped.


Synonym created.


Grant succeeded.


Package created.


Synonym dropped.


Synonym created.


Grant succeeded.


Package created.


Synonym dropped.


Synonym created.


Grant succeeded.


Package created.


Synonym dropped.


Synonym created.


Grant succeeded.

SQL>


Sorry i got your names mixed up, but could each of you explain briefly what happened?

The problem i logged seemd to have fixed itself after a reboot, without applying the above!

If you both give detailed accounts, I'll give an a for this one, and repost to give the other an a.

thanks and regards
Ricky
0
 
LVL 5

Accepted Solution

by:
DrJekyll earned 500 total points
ID: 8151465
Rickyr,

What you have just done is probably fixed your problem.
Those errors are perfectly fine. It is just saying before
trying to recreate them it drops them first. Since they were not there you got errors. Perfectly Ok, I would say you are good to go on this issue.  By the way the solutions
you got here are right on<g>... you provided the proof in
a perfect output listing.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to recover a database from a user managed backup
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question