Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

cannot load library unit  (referenced by SYS.DBMS_APPLICATION_INFO)

Posted on 2003-03-14
5
Medium Priority
?
6,037 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
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

571 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