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 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
-
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
-
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
-
as the other members suggested, please check if you connected with SYS user or not.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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,,
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
|