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]

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.

[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]

use dbca to create a database, then learn how to do it - we are going round in circles here

[gandolf989]

use dbca to create a database, then learn how to do it - we are going round in circles here

I agree with using dbca. And furthermore, if you use dbca there is an option to have the scripts created for you and someone can then either run those scripts manually or just read them to know what they are missing.

But some people are just stubborn...

[vnktummala]

If you still don't want to use dbca, in your manual db creation script make sure SYSTEM and SYSAUX table spaces are at least 350 MB size and auto extend on.

Thanks,