-
After running catqm.sql i still get the same error. And there is no table of the name XMLTYPE either.
SQL> select object_name, object_type , owner , status from dba_objects where object_name='XMLTYPE';
OBJECT_NAME OBJECT_TYPE OWNER STATUS
------------------------------ --------------- --------------- -------
XMLTYPE TYPE SYS VALID
XMLTYPE TYPE BODY SYS VALID
XMLTYPE SYNONYM PUBLIC VALID
When everything is lost, future still remains.
-
Did you get any errors when you ran catqm.sql? And can you
describe xdb.xdb$config?
-
Yes I did get some errors while running catqm.sql
Apart from the errors for re-creating existing objects I got ORA-0600 a couple of times.Below is a sample of the error
declare
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [unable to load XDB library], [],
[], [], [], [], [], []
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at line 129
And no i cannot describe xdb.xdb$config.
Last edited by Shivdeep; 12-29-2003 at 07:27 AM.
When everything is lost, future still remains.
-
Hi Again,
It might be a problem with your LD_LIBRARY_PATH...
Set LD_LIBRARY_PATH and LIBPATH to the values
csh :
$ setenv LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ setenv LIBPATH=$ORACLE_HOME/lib
ksh :
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ export LIBPATH=$ORACLE_HOME/lib
if they are not already set and then rerun catqm.sql
-
Originally posted by Shivdeep
Yes I did get some errors while running catqm.sql
Apart from the errors for re-creating existing objects I got ORA-0600 a couple of times.Below is a sample of the error
declare
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [unable to load XDB library], [],
[], [], [], [], [], []
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at line 129
And no i cannot describe xdb.xdb$config.
Well, that's the problem. Did you get the ORA-600 after setting LD_LIBRARY_PATH and LIBPATH?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by jperusco
Hi Again,
It might be a problem with your LD_LIBRARY_PATH...
Set LD_LIBRARY_PATH and LIBPATH to the values
csh :
$ setenv LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ setenv LIBPATH=$ORACLE_HOME/lib
ksh :
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
$ export LIBPATH=$ORACLE_HOME/lib
if they are not already set and then rerun catqm.sql
Hi,
If that is the case then i must get this message for all the databases in the oracle home where i have the database in question. The other databases DO NOT return ORA-604 on startup.
When everything is lost, future still remains.
-
Originally posted by julian
Well, that's the problem. Did you get the ORA-600 after setting LD_LIBRARY_PATH and LIBPATH?
As i had replied to jperusco, i should get the same message for the other database in the same oracle home also. But i don not.
What should be the values for LD_LIBRARY_PATH and LIBPATH wrt to ORACLE_HOME?
When everything is lost, future still remains.
-
a simple test on the other databases would be to see if you
can describe xdb.xdb$config. my bet is you can.
the value of ORACLE_HOME should already be set. if you run
echo $ORACLE_HOME
this should return something like /u01/oracle/product/9.2.0.3/
or something similar.
Then run the two exports above and you should be able to echo $LD_LIBRARY_PATH and $LIBPATH which something like /u01/oracle/product/9.2.0.3/lib.
HTH
-
The problem lies in the xdb schema. On removing the schema by running catnoqm.sql, the message during startup did not appear. It seems that the schema xdb was not set up correctly.
When everything is lost, future still remains.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|