BenChiM888,我的数据库 已经是服务启动时启动例程了 oradim -Edit -SID jddb -STARTMODE auto -spfile
环境变量 ORACLE_SID 定义的是哪一个?
Dump file e:\oracle\product\10.1.0\admin\jddb\bdump\alert_jddb.log Fri Oct 12 11:24:30 2012 ORACLE V10.1.0.2.0 - Production vsnsta=0 vsnsql=13 vsnxtr=3 Windows XP Version V5.1 Service Pack 3 CPU : 2 - type 586, 2 Physical Cores Process Affinity: 0x00000000 Memory (A/P) : PH:1223M/1791M, PG:3280M/3685M, VA:1955M/2047M Fri Oct 12 11:24:30 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 KCCDEBUG_LEVEL = 0 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. Dynamic strands is set to TRUE Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 10.1.0.2.0. System parameters with non-default values: processes = 150 shared_pool_size = 83886080 large_pool_size = 8388608 java_pool_size = 50331648 control_files = E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\CONTROL03.CTL db_block_size = 8192 db_cache_size = 25165824 compatible = 10.1.0.2.0 db_file_multiblock_read_count= 16 db_recovery_file_dest = e:\oracle\product\10.1.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=JDDBXDB) job_queue_processes = 10 background_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\JDDB\BDUMP user_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\JDDB\UDUMP core_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\JDDB\CDUMP sort_area_size = 65536 db_name = JDDB open_cursors = 300 pga_aggregate_target = 25165824 PMON started with pid=2, OS id=1744 MMAN started with pid=3, OS id=968 DBW0 started with pid=4, OS id=1776 LGWR started with pid=5, OS id=3008 CKPT started with pid=6, OS id=2188 SMON started with pid=7, OS id=1952 RECO started with pid=8, OS id=2084 CJQ0 started with pid=9, OS id=3920 Fri Oct 12 11:24:30 2012 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... Fri Oct 12 11:24:30 2012 alter database mount exclusive Fri Oct 12 11:24:30 2012 Controlfile identified with block size 16384 Fri Oct 12 11:24:34 2012 Setting recovery target incarnation to 3 Fri Oct 12 11:24:34 2012 Successful mount of redo thread 1, with mount id 1584833006 Fri Oct 12 11:24:34 2012 Database mounted in Exclusive Mode. ORA-1991 signalled during: alter database mount exclusive... Fri Oct 12 11:25:44 2012 alter database open Fri Oct 12 11:25:44 2012 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=13, OS id=1288 ARC0: Archival started Fri Oct 12 11:25:44 2012 LGWR: STARTING ARCH PROCESSES COMPLETE Fri Oct 12 11:25:44 2012 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Fri Oct 12 11:25:44 2012 LGWR: Primary database is in CLUSTER CONSISTENT mode Maximum redo generation record size = 120832 bytes Maximum redo generation change vector size = 116476 bytes Private_strands 4 at log switch Thread 1 opened at log sequence 1 Current log# 2 seq# 1 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\REDO02.LOG Successful open of redo thread 1 Fri Oct 12 11:25:45 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Oct 12 11:25:45 2012 SMON: enabling cache recovery Fri Oct 12 11:25:45 2012 Successfully onlined Undo Tablespace 1. Fri Oct 12 11:25:45 2012 SMON: enabling tx recovery Fri Oct 12 11:25:45 2012 Database Characterset is ZHS16GBK Fri Oct 12 11:25:45 2012 Published database character set on system events channel ARC1 started with pid=14, OS id=840 Fri Oct 12 11:25:45 2012 ARC1: Archival started Fri Oct 12 11:25:45 2012 All processes have switched to database character set ARC1: Becoming the heartbeat ARCH Fri Oct 12 11:25:46 2012 Starting background process QMNC QMNC started with pid=15, OS id=2632 Fri Oct 12 11:25:47 2012 replication_dependency_tracking turned off (no async multimaster replication found) Fri Oct 12 11:25:48 2012 Starting background process MMON MMON started with pid=16, OS id=2448 Fri Oct 12 11:25:48 2012 Starting background process MMNL MMNL started with pid=17, OS id=3900 Fri Oct 12 11:25:49 2012 Completed: alter database open Fri Oct 12 11:25:54 2012 db_recovery_file_dest_size of 2048 MB is 0.03% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup.
环境变量定义的就是不正常的这个,JDDB
这不显示已经启动了么 Fri Oct 12 11:25:49 2012 Completed: alter database open Fri Oct 12 11:25:54 2012
这个是我手动 Alter DataBase Open
Database mounted in Exclusive Mode. ORA-1991 signalled during: alter database mount exclusive...重建密码文件兄弟。
http://zhidao.baidu.com/question/113949114.html 不过我喜欢这样,将oracle服务改成自动启动但是不启动实例,等需要的时候再startup
节省系统资源。
oradim -Edit -SID jddb -STARTMODE auto -spfile
Fri Oct 12 11:24:30 2012
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:1223M/1791M, PG:3280M/3685M, VA:1955M/2047M
Fri Oct 12 11:24:30 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = e:\oracle\product\10.1.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=JDDBXDB)
job_queue_processes = 10
background_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\JDDB\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\JDDB\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.1.0\ADMIN\JDDB\CDUMP
sort_area_size = 65536
db_name = JDDB
open_cursors = 300
pga_aggregate_target = 25165824
PMON started with pid=2, OS id=1744
MMAN started with pid=3, OS id=968
DBW0 started with pid=4, OS id=1776
LGWR started with pid=5, OS id=3008
CKPT started with pid=6, OS id=2188
SMON started with pid=7, OS id=1952
RECO started with pid=8, OS id=2084
CJQ0 started with pid=9, OS id=3920
Fri Oct 12 11:24:30 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Oct 12 11:24:30 2012
alter database mount exclusive
Fri Oct 12 11:24:30 2012
Controlfile identified with block size 16384
Fri Oct 12 11:24:34 2012
Setting recovery target incarnation to 3
Fri Oct 12 11:24:34 2012
Successful mount of redo thread 1, with mount id 1584833006
Fri Oct 12 11:24:34 2012
Database mounted in Exclusive Mode.
ORA-1991 signalled during: alter database mount exclusive...
Fri Oct 12 11:25:44 2012
alter database open
Fri Oct 12 11:25:44 2012
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=13, OS id=1288
ARC0: Archival started
Fri Oct 12 11:25:44 2012
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Oct 12 11:25:44 2012
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Oct 12 11:25:44 2012
LGWR: Primary database is in CLUSTER CONSISTENT mode
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 4 at log switch
Thread 1 opened at log sequence 1
Current log# 2 seq# 1 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\JDDB\REDO02.LOG
Successful open of redo thread 1
Fri Oct 12 11:25:45 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Oct 12 11:25:45 2012
SMON: enabling cache recovery
Fri Oct 12 11:25:45 2012
Successfully onlined Undo Tablespace 1.
Fri Oct 12 11:25:45 2012
SMON: enabling tx recovery
Fri Oct 12 11:25:45 2012
Database Characterset is ZHS16GBK
Fri Oct 12 11:25:45 2012
Published database character set on system events channel
ARC1 started with pid=14, OS id=840
Fri Oct 12 11:25:45 2012
ARC1: Archival started
Fri Oct 12 11:25:45 2012
All processes have switched to database character set
ARC1: Becoming the heartbeat ARCH
Fri Oct 12 11:25:46 2012
Starting background process QMNC
QMNC started with pid=15, OS id=2632
Fri Oct 12 11:25:47 2012
replication_dependency_tracking turned off (no async multimaster replication found)
Fri Oct 12 11:25:48 2012
Starting background process MMON
MMON started with pid=16, OS id=2448
Fri Oct 12 11:25:48 2012
Starting background process MMNL
MMNL started with pid=17, OS id=3900
Fri Oct 12 11:25:49 2012
Completed: alter database open
Fri Oct 12 11:25:54 2012
db_recovery_file_dest_size of 2048 MB is 0.03% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Oct 12 11:25:49 2012
Completed: alter database open
Fri Oct 12 11:25:54 2012
ORA-1991 signalled during: alter database mount exclusive...重建密码文件兄弟。
http://hi.baidu.com/jiaozhenqing/item/f5a83f30f393e985c2cf2993