本机的ORACLE突然起不来了 本机数据库名ORCL 机器名称7fa310ace79640e 版本为10.2.0
LISTENER配置为SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 7fa310ace79640e)(PORT = 1521))
)
)
TNSNAME配置为ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 7fa310ace79640e)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
在SQLPLUS /NOLOG中 CONN USER/PASSWORD可以连接上 但是CONN USER/PASSWORD@SID 就会直接死掉 无论是PL/SQL还是SQLPLUS或者是TOAD都是这样的情况
ALTER.LOG内容如下
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Fri May 01 23:18:30 2009
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:1159M/2037M, Ph+PgF:2948M/3930M, VA:1940M/2047M
Fri May 01 23:18:30 2009
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 = 138412032
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 461373440
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
_kgl_large_heap_warning_threshold= 10485760
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 202375168
PMON started with pid=2, OS id=1140
PSP0 started with pid=3, OS id=3196
MMAN started with pid=4, OS id=3200
DBW0 started with pid=5, OS id=4024
LGWR started with pid=6, OS id=164
CKPT started with pid=7, OS id=2020
SMON started with pid=8, OS id=2144
RECO started with pid=9, OS id=580
CJQ0 started with pid=10, OS id=2952
MMON started with pid=11, OS id=3656
Fri May 01 23:18:30 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1708
Fri May 01 23:18:30 2009
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri May 01 23:18:30 2009
alter database mount exclusive
Fri May 01 23:18:34 2009
Setting recovery target incarnation to 2
Fri May 01 23:18:34 2009
Successful mount of redo thread 1, with mount id 1213514310
Fri May 01 23:18:34 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri May 01 23:18:35 2009
alter database open
Fri May 01 23:18:35 2009
Thread 1 opened at log sequence 46
Current log# 3 seq# 46 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Fri May 01 23:18:35 2009
SMON: enabling cache recovery
Fri May 01 23:18:36 2009
Successfully onlined Undo Tablespace 1.
Fri May 01 23:18:36 2009
SMON: enabling tx recovery
Fri May 01 23:18:36 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=200
Fri May 01 23:18:44 2009
Completed: alter database open
Fri May 01 23:18:45 2009
db_recovery_file_dest_size of 2048 MB is 0.00% 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.是在不知道是什么问题 这种问题出现过很多次了 以前都是重装ORACLE 但是一般过几天就会ORACLE服务起不来了
请大家帮忙 谢谢了
LISTENER配置为SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 7fa310ace79640e)(PORT = 1521))
)
)
TNSNAME配置为ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 7fa310ace79640e)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
在SQLPLUS /NOLOG中 CONN USER/PASSWORD可以连接上 但是CONN USER/PASSWORD@SID 就会直接死掉 无论是PL/SQL还是SQLPLUS或者是TOAD都是这样的情况
ALTER.LOG内容如下
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Fri May 01 23:18:30 2009
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:1159M/2037M, Ph+PgF:2948M/3930M, VA:1940M/2047M
Fri May 01 23:18:30 2009
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 = 138412032
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 461373440
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
_kgl_large_heap_warning_threshold= 10485760
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 202375168
PMON started with pid=2, OS id=1140
PSP0 started with pid=3, OS id=3196
MMAN started with pid=4, OS id=3200
DBW0 started with pid=5, OS id=4024
LGWR started with pid=6, OS id=164
CKPT started with pid=7, OS id=2020
SMON started with pid=8, OS id=2144
RECO started with pid=9, OS id=580
CJQ0 started with pid=10, OS id=2952
MMON started with pid=11, OS id=3656
Fri May 01 23:18:30 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1708
Fri May 01 23:18:30 2009
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri May 01 23:18:30 2009
alter database mount exclusive
Fri May 01 23:18:34 2009
Setting recovery target incarnation to 2
Fri May 01 23:18:34 2009
Successful mount of redo thread 1, with mount id 1213514310
Fri May 01 23:18:34 2009
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri May 01 23:18:35 2009
alter database open
Fri May 01 23:18:35 2009
Thread 1 opened at log sequence 46
Current log# 3 seq# 46 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Fri May 01 23:18:35 2009
SMON: enabling cache recovery
Fri May 01 23:18:36 2009
Successfully onlined Undo Tablespace 1.
Fri May 01 23:18:36 2009
SMON: enabling tx recovery
Fri May 01 23:18:36 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=200
Fri May 01 23:18:44 2009
Completed: alter database open
Fri May 01 23:18:45 2009
db_recovery_file_dest_size of 2048 MB is 0.00% 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.是在不知道是什么问题 这种问题出现过很多次了 以前都是重装ORACLE 但是一般过几天就会ORACLE服务起不来了
请大家帮忙 谢谢了
你conn user/pwd@SID 和数据库同台机器连不上,还是只有在不同台连不上。这里可能是tns这块的问题叻,你试试tnsping tnsname先。
====================================================================================
Inthirties提供专业的针对Oracle的数据库优化,安全,恢复,迁移以及Oracle DBA培训等专业
服务。同时还提供针对企业ERP实施和建设的规划,开发和实施等ERP企业咨询服务。如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
QQ群: 85837884(注明:数据库)
电子邮件:[email protected]
网站: http://www.inthirties.com
自然就是死了么。。
可能你的电脑存在病毒.
出问题时,是在和数据库同台的机器么。加上SID和不加SID的不同,也就是sid是通过listener来进行连接的。
但凡TNSPING通畅的,一般sqlplus也是没问题的 :)
你是用的windows?你需要配loopback网卡,并将数据库使用该IP。
ORACLE的文档专门有针对这个问题的说明。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 7fa310ace79640e)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
这个操作应该是在建库前进行。
如果还不行的话,就备份后,重建库。