| ORA-1501 signalled during: CREATE DATABASE pcmdb1 [message #64589] |
Thu, 10 February 2005 21:03  |
Madhavi Daroor
Messages: 1
Registered: February 2005
|
Junior Member |
|
|
Hi,
I'm getting the following error while trying to craete a database. What is wrong? I'm doing it on Solaris 2.9.
The contents of the alert log is as below:
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Feb 11 13:43:33 2005
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Feb 11 13:43:36 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size = 16777216
java_pool_size = 117440512
control_files = /export/home/oracle/lsphome/oradata/pcmdb1/control01.ctl, /export/home/oracle/lsphome/oradata/pcm
db1/control02.ctl, /export/home/oracle/lsphome/oradata/pcmdb1/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = pcmdb1
dispatchers = (PROTOCOL=TCP) (SERVICE=pcmXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /export/home/oracle/lsphome/admin/pcmdb1/bdump
user_dump_dest = /export/home/oracle/lsphome/admin/pcmdb1/udump
core_dump_dest = /export/home/oracle/lsphome/admin/pcmdb1/cdump
sort_area_size = 524288
db_name = pcmdb1
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Feb 11 13:43:38 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Feb 11 13:43:39 2005
CREATE DATABASE pcmdb1
DATAFILE 'ORACLE_HOME/oradata/pcmdb1/system01.dbf'
SIZE 50M
AUTOEXTEND ON
NEXT 5M
MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE 'ORACLE_HOME/oradata/pcmdb1/temp01.dbf'
SIZE 40M
AUTOEXTEND ON
NEXT 640K
MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1
DATAFILE 'ORACLE_HOME/oradata/pcmdb1/undotbs01.dbf'
SIZE 50M
AUTOEXTEND ON
NEXT 5M
MAXSIZE UNLIMITED
LOGFILE
group 1
('ORACLE_HOME/oradata/pcmdb1/redo01.log')
size 100M,
group 2
('ORACLE_HOME/oradata/pcmdb1/redo02.log')
size 100M,
group 3
('ORACLE_HOME/oradata/pcmdb1/redo03.log')
size 100M
Fri Feb 11 13:43:42 2005
Database mounted in Exclusive Mode.
ORA-1501 signalled during: CREATE DATABASE pcmdb1
DATAFILE 'ORACLE_HOME/orada...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
