Error when i connect to a DB

[FSM]

I've uploaded a db (with a coold backup) but it's giving me a constraint error message when i log in with sqlplus, the erro is:
ERROR:
ORA-06553: PLS-707: unsupported construct or internal error [2603]
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-707: unsupported construct or internal error [2603]

i don't know if the error is because the ORIGNIAL db is with oracle 8.1.6 and the one im running is 8.1.7
but everything is working ok, i just want to know what's the problem.
Thank you guys!!!!

FSM

 

[karluk]

According to Metalink note 167277.1, you have to run the catalog creation scripts (catalog.sql and catproc.sql) as sys. It sounds as if you may have upgraded from 8.1.6 to 8.1.7 without running the scripts, or maybe you ran them but had errors.

 

[FSM]

Ohhhh, OK Karluk, i didn't know i had to run those scripts, so that's whats causing my error right????Can I run those catalogs with my own created user with sysdba privileges?? thanks Karluk


FSM

 

[karluk]

I'm fairly sure you have to run them using the sys or internal ids. Just using an id with sysdba privileges will put the catalog into the wrong schema.

 

[Turkbear]

Hi,
karluk, as usual, is correct..If you read the catalog.sql ( and catproc.sql)files they will say to run it as sys ( or internal ) ...

rem 
Rem Copyright (c) 1988, 2000 by Oracle Corporation
Rem
Rem NAME
Rem   CATALOG.SQL
Rem FUNCTION
Rem   Creates data dictionary views.
Rem NOTES
Rem   Must be run when connected to SYS or INTERNAL.
Rem

 

[FSM]

Thanks a lot guys!!! but i have a little problem, I don't know (i guess) that my "sys" password is change, can i do it with the "internal" id???? because im running the catalog file but it says :
SQL> @catalog.sql
SP2-0310: unable to open file "catalog.sql"
and also i've tried it with the path:
"c:\oracle\ora81\rdbms\admin\catalog.sql" and same result
what could be wrong???
thanks Karluk and Turkbear, you guys have been lot's of help to newbie !!!

FSM

 

[karluk]

catalog.sql should be in your {OracleHome}\rdbms\admin directory. Are you sure that your Oracle home is "c:\oracle\ora81". I would try searching for the file using Windows Explorer (assuming you're on a Windows platform).

I think you will probably have to run the scripts in Server Manager rather than SQL*Plus. To start Server Manager, type "svrmgrl" from a command prompt.

 

[FSM]

Thanks guys it works perfectly!!!!


FSM