Advertisement

08.19.2008 at 09:53PM PDT, ID: 23662025
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
7.8

create database issue

Asked by dbaseek in Oracle 10.x, Oracle Database

Sir ,

I was trying to create database manually in oracle 10g  
I created instance set oracle_sid=new
I created instance..
everthing is fine....
In
startup nomount
Oracle instance started.
when I used the script to create the database here is the error
error at line 1
ora-01092:Oracle instance terminated. Disconnection forced
----------------------
Below is my create databse script, alertlog and initnew.ora
please help me to create database successfuly?
create databse script:
create database new
  logfile   group 1 ('C:\oracle\product\10.2.0\oradata\new\redo1.log') size 10M,
            group 2 ('C:\oracle\product\10.2.0\oradata\new\redo2.log') size 10M,
            group 3 ('C:\oracle\product\10.2.0\oradata\new\redo3.log') size 10M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
            extent management local
  sysaux datafile 'C:\oracle\product\10.2.0\oradata\new\sysaux.dbf'
            size 10M
            autoextend on
            next 10M
            maxsize unlimited
  undo tablespace undo
            datafile 'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
  default temporary tablespace temp
            tempfile 'C:\oracle\product\10.2.0\oradata\new\temp.dbf'
            size 10M;
==============================================
alertlog
Dump file c:\oracle\product\10.2.0\admin\new\bdump\alert_new.log
Tue Aug 19 19:06:42 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU                 : 2 - type 586
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:660M/1917M, Ph+PgF:2051M/3965M, VA:1939M/2047M
Tue Aug 19 19:06:42 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 176160768
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 574619648
  control_files            = C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 381681664
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = C:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=newXDB)
  local_listener           = LISTENER_NEW
  job_queue_processes      = 10
  audit_file_dest          = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\ADUMP
  background_dump_dest     = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\BDUMP
  user_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\UDUMP
  core_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\CDUMP
  db_name                  = new
  open_cursors             = 300
  pga_aggregate_target     = 189792256
PMON started with pid=2, OS id=2592
PSP0 started with pid=3, OS id=3296
MMAN started with pid=4, OS id=6080
DBW0 started with pid=5, OS id=4076
LGWR started with pid=6, OS id=4516
CKPT started with pid=7, OS id=2656
SMON started with pid=8, OS id=3964
RECO started with pid=9, OS id=5268
CJQ0 started with pid=10, OS id=4008
MMON started with pid=11, OS id=5740
Tue Aug 19 19:06:42 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Aug 19 19:06:42 2008
starting up 1 shared server(s) ...
MMNL started with pid=12, OS id=5804
Tue Aug 19 19:24:28 2008
create database new
  logfile   group 1 ('C:\oracle\product\10.2.0\oradata\new\redo1.log') size 10M,
            group 2 ('C:\oracle\product\10.2.0\oradata\new\redo2.log') size 10M,
            group 3 ('C:\oracle\product\10.2.0\oradata\new\redo3.log') size 10M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
            extent management local
  sysaux datafile 'C:\oracle\product\10.2.0\oradata\new\sysaux.dbf'
            size 10M
            autoextend on
            next 10M
            maxsize unlimited
  undo tablespace undo
            datafile 'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
  default temporary tablespace temp
            tempfile 'C:\oracle\product\10.2.0\oradata\new\temp.dbf'
            size 10M
Tue Aug 19 19:24:31 2008
Errors in file c:\oracle\product\10.2.0\admin\new\udump\new_ora_2072.trc:
ORA-00200: control file could not be created
ORA-00202: control file: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL01.CTL'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Tue Aug 19 19:24:31 2008
ORA-1501 signalled during: create database new
  logfile   group 1 ('C:\oracle\product\10.2.0\oradata\new\redo1.log') size 10M,
            group 2 ('C:\oracle\product\10.2.0\oradata\new\redo2.log') size 10M,
            group 3 ('C:\oracle\product\10.2.0\oradata\new\redo3.log') size 10M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
            extent management local
  sysaux datafile 'C:\oracle\product\10.2.0\oradata\new\sysaux.dbf'
            size 10M
            autoextend on
            next 10M
            maxsize unlimited
  undo tablespace undo
            datafile 'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
  default temporary tablespace temp
            tempfile 'C:\oracle\product\10.2.0\oradata\new\temp.dbf'
            size 10M...
Tue Aug 19 19:27:04 2008
create database new
  logfile   group 1 ('C:\oracle\product\10.2.0\oradata\new\redo1.log') size 10M,
            group 2 ('C:\oracle\product\10.2.0\oradata\new\redo2.log') size 10M,
            group 3 ('C:\oracle\product\10.2.0\oradata\new\redo3.log') size 10M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
            extent management local
  sysaux datafile 'C:\oracle\product\10.2.0\oradata\new\sysaux.dbf'
            size 10M
            autoextend on
            next 10M
            maxsize unlimited
  undo tablespace undo
            datafile 'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
  default temporary tablespace temp
            tempfile 'C:\oracle\product\10.2.0\oradata\new\temp.dbf'
            size 10M
Tue Aug 19 19:27:06 2008
Database mounted in Exclusive Mode
Tue Aug 19 19:27:08 2008
Successful mount of redo thread 1, with mount id 2144538056
Assigning activation ID 2144538056 (0x7fd30dc8)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\REDO1.LOG
Successful open of redo thread 1
Tue Aug 19 19:27:08 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Aug 19 19:27:08 2008
SMON: enabling cache recovery
Tue Aug 19 19:27:08 2008
create tablespace SYSTEM datafile  'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
           
  EXTENT MANAGEMENT LOCAL online

Tue Aug 19 19:27:10 2008
Completed: create tablespace SYSTEM datafile  'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
           
  EXTENT MANAGEMENT LOCAL online
Tue Aug 19 19:27:10 2008
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Tue Aug 19 19:27:14 2008
Thread 1 advanced to log sequence 2
  Current log# 2 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\REDO2.LOG
Tue Aug 19 19:27:16 2008
CREATE UNDO TABLESPACE UNDO DATAFILE  'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
 

Tue Aug 19 19:27:17 2008
ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDO DATAFILE  'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
 
...
Tue Aug 19 19:27:17 2008
Errors in file c:\oracle\product\10.2.0\admin\new\udump\new_ora_2072.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

Tue Aug 19 19:27:17 2008
Errors in file c:\oracle\product\10.2.0\admin\new\udump\new_ora_2072.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 5792
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Tue Aug 19 19:27:17 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_pmon_2592.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:27:18 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_reco_5268.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:27:18 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_smon_3964.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:27:18 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_ckpt_2656.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:27:18 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_lgwr_4516.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:27:19 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_dbw0_4076.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:27:19 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_mman_6080.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:27:19 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_psp0_3296.trc:
ORA-01519: error while processing file '' near line

Instance terminated by USER, pid = 2072
ORA-1092 signalled during: create database new
  logfile   group 1 ('C:\oracle\product\10.2.0\oradata\new\redo1.log') size 10M,
            group 2 ('C:\oracle\product\10.2.0\oradata\new\redo2.log') size 10M,
            group 3 ('C:\oracle\product\10.2.0\oradata\new\redo3.log') size 10M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
            extent management local
  sysaux datafile 'C:\oracle\product\10.2.0\oradata\new\sysaux.dbf'
            size 10M
            autoextend on
            next 10M
            maxsize unlimited
  undo tablespace undo
            datafile 'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
  default temporary tablespace temp
            tempfile 'C:\oracle\product\10.2.0\oradata\new\temp.dbf'
            size 10M...
Tue Aug 19 19:45:21 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 176160768
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 574619648
  control_files            = C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 381681664
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = C:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=newXDB)
  local_listener           = LISTENER_NEW
  job_queue_processes      = 10
  audit_file_dest          = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\ADUMP
  background_dump_dest     = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\BDUMP
  user_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\UDUMP
  core_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\CDUMP
  db_name                  = new
  open_cursors             = 300
  pga_aggregate_target     = 189792256
PMON started with pid=2, OS id=5876
PSP0 started with pid=3, OS id=2492
MMAN started with pid=4, OS id=5000
DBW0 started with pid=5, OS id=4080
LGWR started with pid=6, OS id=2260
CKPT started with pid=7, OS id=5612
SMON started with pid=8, OS id=5868
RECO started with pid=9, OS id=2008
CJQ0 started with pid=10, OS id=4784
MMON started with pid=11, OS id=2180
Tue Aug 19 19:45:22 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Aug 19 19:45:22 2008
starting up 1 shared server(s) ...
Tue Aug 19 19:45:22 2008
ALTER DATABASE   MOUNT
MMNL started with pid=12, OS id=5244
Tue Aug 19 19:45:26 2008
Setting recovery target incarnation to 1
ORA-1079 signalled during: ALTER DATABASE   MOUNT...
Tue Aug 19 19:46:43 2008
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Tue Aug 19 19:46:50 2008
Stopping background process CJQ0
Tue Aug 19 19:46:51 2008
Stopping background process MMNL
Tue Aug 19 19:46:52 2008
Stopping background process MMON
Tue Aug 19 19:46:52 2008
Shutting down instance (immediate)
License high water mark = 1
Tue Aug 19 19:46:52 2008
Stopping Job queue slave processes
Tue Aug 19 19:46:52 2008
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Aug 19 19:46:53 2008
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Tue Aug 19 19:53:08 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 176160768
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  sga_target               = 574619648
  control_files            = C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 381681664
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = C:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=newXDB)
  local_listener           = LISTENER_NEW
  job_queue_processes      = 10
  audit_file_dest          = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\ADUMP
  background_dump_dest     = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\BDUMP
  user_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\UDUMP
  core_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\NEW\CDUMP
  db_name                  = new
  open_cursors             = 300
  pga_aggregate_target     = 189792256
PMON started with pid=2, OS id=5156
PSP0 started with pid=3, OS id=5024
MMAN started with pid=4, OS id=2988
DBW0 started with pid=5, OS id=3848
LGWR started with pid=6, OS id=3076
CKPT started with pid=7, OS id=352
SMON started with pid=8, OS id=4536
RECO started with pid=9, OS id=5200
CJQ0 started with pid=10, OS id=128
MMON started with pid=11, OS id=4440
Tue Aug 19 19:53:09 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Aug 19 19:53:09 2008
starting up 1 shared server(s) ...
MMNL started with pid=12, OS id=4648
Tue Aug 19 19:53:41 2008
create database new
  logfile   group 1 ('C:\oracle\product\10.2.0\oradata\new\redo1.log') size 10M,
            group 2 ('C:\oracle\product\10.2.0\oradata\new\redo2.log') size 10M,
            group 3 ('C:\oracle\product\10.2.0\oradata\new\redo3.log') size 10M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
            extent management local
  sysaux datafile 'C:\oracle\product\10.2.0\oradata\new\sysaux.dbf'
            size 10M
            autoextend on
            next 10M
            maxsize unlimited
  undo tablespace undo
            datafile 'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
  default temporary tablespace temp
            tempfile 'C:\oracle\product\10.2.0\oradata\new\temp.dbf'
            size 10M
Tue Aug 19 19:53:42 2008
Database mounted in Exclusive Mode
Tue Aug 19 19:53:44 2008
Successful mount of redo thread 1, with mount id 2144556293
Assigning activation ID 2144556293 (0x7fd35505)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\REDO1.LOG
Successful open of redo thread 1
Tue Aug 19 19:53:45 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Aug 19 19:53:45 2008
SMON: enabling cache recovery
Tue Aug 19 19:53:46 2008
create tablespace SYSTEM datafile  'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
           
  EXTENT MANAGEMENT LOCAL online

Tue Aug 19 19:53:48 2008
Completed: create tablespace SYSTEM datafile  'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
           
  EXTENT MANAGEMENT LOCAL online
Tue Aug 19 19:53:48 2008
create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
  storage (initial 50K next 50K)
Tue Aug 19 19:53:52 2008
Thread 1 advanced to log sequence 2
  Current log# 2 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\NEW\REDO2.LOG
Tue Aug 19 19:53:54 2008
CREATE UNDO TABLESPACE UNDO DATAFILE  'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
 

Tue Aug 19 19:53:55 2008
ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDO DATAFILE  'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
 
...
Tue Aug 19 19:53:55 2008
Errors in file c:\oracle\product\10.2.0\admin\new\udump\new_ora_3040.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

Tue Aug 19 19:53:55 2008
Errors in file c:\oracle\product\10.2.0\admin\new\udump\new_ora_3040.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 5792
ORA-00604: error occurred at recursive SQL level 1
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type

Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Tue Aug 19 19:53:55 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_pmon_5156.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:53:55 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_reco_5200.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:53:55 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_smon_4536.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:53:56 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_ckpt_352.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:53:56 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_lgwr_3076.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:53:56 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_dbw0_3848.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:53:57 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_mman_2988.trc:
ORA-01519: error while processing file '' near line

Tue Aug 19 19:53:57 2008
Errors in file c:\oracle\product\10.2.0\admin\new\bdump\new_psp0_5024.trc:
ORA-01519: error while processing file '' near line

Instance terminated by USER, pid = 3040
ORA-1092 signalled during: create database new
  logfile   group 1 ('C:\oracle\product\10.2.0\oradata\new\redo1.log') size 10M,
            group 2 ('C:\oracle\product\10.2.0\oradata\new\redo2.log') size 10M,
            group 3 ('C:\oracle\product\10.2.0\oradata\new\redo3.log') size 10M
  character set          WE8ISO8859P1
  national character set utf8
  datafile 'C:\oracle\product\10.2.0\oradata\new\system.dbf'
            size 50M
            autoextend on
            next 10M maxsize unlimited
            extent management local
  sysaux datafile 'C:\oracle\product\10.2.0\oradata\new\sysaux.dbf'
            size 10M
            autoextend on
            next 10M
            maxsize unlimited
  undo tablespace undo
            datafile 'C:\oracle\product\10.2.0\oradata\new\undo.dbf'
            size 10M
  default temporary tablespace temp
            tempfile 'C:\oracle\product\10.2.0\oradata\new\temp.dbf'
            size 10M...
============================================
initnew.ora
new.__db_cache_size=381681664
new.__java_pool_size=4194304
new.__large_pool_size=4194304
new.__shared_pool_size=176160768
new.__streams_pool_size=0


*.audit_file_dest='C:\oracle\product\10.2.0\admin\new\adump'
*.background_dump_dest='C:\oracle\product\10.2.0\admin\new\bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\oracle\product\10.2.0\oradata\new\control01.ctl','C:\oracle\product\10.2.0\oradata\new\control02.ctl','C:\oracle\product\10.2.0\oradata\new\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\new\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='new'
*.db_recovery_file_dest='C:\oracle\product\10.2.0\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=newXDB)'
*.job_queue_processes=10
*.local_listener='LISTENER_NEW'
*.open_cursors=300
*.pga_aggregate_target=189792256
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=571473920
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\new\udump'
==============================================
please help me thanks
Start Free Trial
[+][-]08.19.2008 at 10:24PM PDT, ID: 22266406

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.19.2008 at 11:34PM PDT, ID: 22266708

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.20.2008 at 12:53AM PDT, ID: 22266987

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Oracle Database
Sign Up Now!
Solution Provided By: sujith80
Participating Experts: 3
Solution Grade: A
 
 
[+][-]08.20.2008 at 03:17AM PDT, ID: 22267775

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.20.2008 at 05:52AM PDT, ID: 22268829

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.20.2008 at 12:27PM PDT, ID: 22273048

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.20.2008 at 01:15PM PDT, ID: 22273445

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.20.2008 at 10:06PM PDT, ID: 22276356

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628