catproc.sql error

[4iappsDBA]

Dear brothers,

after creating a fresh database manually we have to run Catproc.sql which is use to build PL/SQL Procedures, Packages etc.

but for my database am getting this error.. what could be this error,, anyone please let me know..

SQL> @C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catproc.sql
DOC>######################################################################
DOC>######################################################################
DOC> The following PL/SQL block will cause an ORA-20000 error and
DOC> terminate the current SQLPLUS session if the user is not SYS.
DOC> Disconnect and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#
RAISE_APPLICATION_ERROR (-20000,
*
ERROR at line 6:
ORA-06550: line 6, column 9:
PLS-00201: identifier 'RAISE_APPLICATION_ERROR' must be declared
ORA-06550: line 6, column 9:
PL/SQL: Statement ignored


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[naman20k]

tell me bro whats ur system datafile size if is less then autoextend ur datafile by this command
alter database datafile 'path' autoextend on.

[4iappsDBA]

datafile 'C:/oracle/product/10.2.0/oradata/iapps/system.dbf' size 50m autoextend on next 2m maxsize 90m



any error in this, its a gradual increment for my local test database,..

as per your advice i have On the autoextend. now its showing

ERROR:
ORA-03114: not connected to ORACLE

[davey23uk]

tell me bro whats ur system datafile size if is less then autoextend ur datafile by this command
alter database datafile 'path' autoextend on.

what? what has this got to do with anything

[davey23uk]

datafile 'C:/oracle/product/10.2.0/oradata/iapps/system.dbf' size 50m autoextend on next 2m maxsize 90m



any error in this, its a gradual increment for my local test database,..

as per your advice i have On the autoextend. now its showing

ERROR:
ORA-03114: not connected to ORACLE

use dbca to create your databases as you are clearly doing something wrong

[hany]

what user are using to run the catproc.sql script? This needs to be SYS.

[LKBrwn_DBA]

what user are using to run the catproc.sql script? This needs to be SYS.

Exactly, look at the message:

SQL> @C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catproc.sql
DOC>######################################################################
DOC>######################################################################
DOC> The following PL/SQL block will cause an ORA-20000 error and
DOC> terminate the current SQLPLUS session if the user is not SYS.
DOC> Disconnect and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#

Also I agree with davey23uk, use dbca to create the database.

[4iappsDBA]

thank u brother for u r kind advice using DBCA, but to be a good DBA i must know the manual creation's and all,., is in it,, am not neglecting ur arguments,,,but i must know this solution.

thank u

[vnktummala]

as the other members suggested, please check if you connected with SYS user or not.

Thanks,

[4iappsDBA]

yes,, i am in sys user only,, still having the same result,, am really fed up with this,,

am going to create another new database,, and am requesting u all to give me time to create it once again,,