If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

SYS as SYSDMA is needed.

Originally Posted by hany

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.

"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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.