View Poll Results: Is it Useful topic !
- Voters
- 1. You may not vote on this poll
-
also post the complete version of Oracle. you just installed the base version binaries or after base version have you applied any patch sets to upgrade...etc
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by 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,,
brothers.. i have created another database i successfully ran the catalog.sql file.,, afterwards i randed "catproc.sql" still same error..
ERROR:
ORA-03114: not connected to ORACLE
i have created very correctly by my recorded syntax.. if anyone need i can give the syntax's for check!
-
Originally Posted by vnktummala
also post the complete version of Oracle. you just installed the base version binaries or after base version have you applied any patch sets to upgrade...etc
Thanks,
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
-
- What is the alert log file telling you?
- Are you seeing the error right after the script starts executing, or on the creation of a specific package, procedure, ..
- What are the values of memory related parameters in your pfile/spfile?
Anyone can hold the helm when the sea is calm.
-
Originally Posted by hany
- What is the alert log file telling you?
- Are you seeing the error right after the script starts executing, or on the creation of a specific package, procedure, ..
- What are the values of memory related parameters in your pfile/spfile?
Mon Mar 08 16:58:24 2010
ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
Mon Mar 08 16:58:24 2010
Errors in file c:\oracle\product\10.2.0\db_1\admin\apps\bdump\india_smon_3148.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
1:
Mon Mar 08 17:03:25 2010
ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
ORA-1655: unable to extend table SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
Mon Mar 08 17:03:25 2010
Errors in file c:\oracle\product\10.2.0\db_1\admin\apps\bdump\india_smon_3148.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.SMON_SCN_TO_TIME by 2 in tablespace SYSTEM
2:
Yes am seeing the Error after running that "catproc.sql".,
few lines shows procedure created,, at final that was the error.
3:
here is the memory parameters,
sga_target=200m;
pga_aggregate_target=200m
db_block_size=8192
am using 10g.. so i didn't found any other parameters.
Last edited by 4iappsDBA; 03-08-2010 at 08:05 AM.
-
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.
-
Originally Posted by 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,
Ok brother let me try on that way !.. thank u for all those who given me reply and useful tips..
thanks a lot..
Brothers and friends, i have tried in dbca, and its working fine without any error.
now i came to a conclusion..
if am not wrong !
A Manual Creation Database should contain system and sysaux file must above 400MB. this is the best way i found from my scenario.
thank u for ur all support to my first step on this field..
Last edited by 4iappsDBA; 03-09-2010 at 12:40 AM.
Reason: tested and varifield myself
-
Originally Posted by 4iappsDBA
system and sysaux file must above 400MB
mmmmhhhh somehow Yes. You are reaching this conclusion for all wrong reasons.
Research SYSTEM, SYSAUX.
Last edited by PAVB; 03-09-2010 at 09:17 AM.
Reason: typo
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|