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,
Printable View
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,
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!
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?
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.
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... :confused:
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..