View Poll Results: Is it Useful topic !
- Voters
- 1. You may not vote on this poll
-
catproc.sql error
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
-
tell me bro whats ur system datafile size if is less then autoextend ur datafile by this command
alter database datafile 'path' autoextend on.
-
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
Last edited by 4iappsDBA; 03-04-2010 at 07:05 AM.
-
Originally Posted by 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
use dbca to create your databases as you are clearly doing something wrong
-
what user are using to run the catproc.sql script? This needs to be SYS.
Anyone can hold the helm when the sea is calm.
-
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
-
Originally Posted by 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.
what? what has this got to do with anything
-
use dbca to create a database, then learn how to do it - we are going round in circles here
-
Originally Posted by davey23uk
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...
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Tags for this Thread
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
|