rickyr
asked on
cannot load library unit (referenced by SYS.DBMS_APPLICATION_INFO)
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
Try logging as sys and run
@$ORACLE_HOME/sqlplus/admi
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.
@$ORACLE_HOME/sqlplus/admi
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.
ASKER
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/admi
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>
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/admi
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>
ASKER
Also.............
What has this done?????
SQL> @$ORACLE_HOME/rdbms/admin/
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
What has this done?????
SQL> @$ORACLE_HOME/rdbms/admin/
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@$ORACLE_HOME/rdbms/admin/