今天启oracle,无缘无故启不来。
>sqlplus sys/psw@sid as sysdba
进入正常,但是数据库应该没起来。我想startup。
---------------------------------------------------------------------------------------------
sql>startup
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
---------------------------------------------------------------------------------------------
我查了一下帮助文档,描述如下:
There are two possible cause for this error: 1) The DB_RECOVERY_FILE_DEST parameter was in use when no DB_RECOVERY_FILE_DEST_SIZE parameter was encountered while fetching initialization parameter. 2) An attempt was made to set DB_RECOVERY_FILE_DEST with the ALTER SYSTEM command when no DB_RECOVERY_FILE_DEST_SIZE was in use.
我在init.ora里重设了db_recovery_file_dest_size,使之增大,再startup,还是报ORA-19802。 startup不行,我就尝试shutdown
---------------------------------------------------------------------------------------------
sql>shutdown
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
---------------------------------------------------------------------------------------------
我上网查了一下,均说是ORACLE_HOME和ORACLE_SID未设置正确,我在注册表HKEY_LOCAL_MACHINE\ SOFTWARE\ORACLE\KEY_OraDb10g下查得ORACLE_HOME='E:\Database\oracle\product \10.2.0\db_1'、ORACLE_SID='myerp',均正确。 在尝试修复期间,我重启过oracle各项服务,重新设置过listener.ora,重启过机器,均无效。
下面我分别贴出listener.ora、init.ora、近期alter_myerp.log,请大家帮忙看看。谢谢。
>sqlplus sys/psw@sid as sysdba
进入正常,但是数据库应该没起来。我想startup。
---------------------------------------------------------------------------------------------
sql>startup
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
---------------------------------------------------------------------------------------------
我查了一下帮助文档,描述如下:
There are two possible cause for this error: 1) The DB_RECOVERY_FILE_DEST parameter was in use when no DB_RECOVERY_FILE_DEST_SIZE parameter was encountered while fetching initialization parameter. 2) An attempt was made to set DB_RECOVERY_FILE_DEST with the ALTER SYSTEM command when no DB_RECOVERY_FILE_DEST_SIZE was in use.
我在init.ora里重设了db_recovery_file_dest_size,使之增大,再startup,还是报ORA-19802。 startup不行,我就尝试shutdown
---------------------------------------------------------------------------------------------
sql>shutdown
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
---------------------------------------------------------------------------------------------
我上网查了一下,均说是ORACLE_HOME和ORACLE_SID未设置正确,我在注册表HKEY_LOCAL_MACHINE\ SOFTWARE\ORACLE\KEY_OraDb10g下查得ORACLE_HOME='E:\Database\oracle\product \10.2.0\db_1'、ORACLE_SID='myerp',均正确。 在尝试修复期间,我重启过oracle各项服务,重新设置过listener.ora,重启过机器,均无效。
下面我分别贴出listener.ora、init.ora、近期alter_myerp.log,请大家帮忙看看。谢谢。
# listener.ora Network Configuration File: E:\Database\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = MYERP)
(ORACLE_HOME = E:\Database\oracle\product\10.2.0\db_1\)
(SID_NAME = MYERP)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = AdrianNet)(PORT = 1521))
)
---------------------init.ora---------------------
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
#########################################################################################################################
# NLS
###########################################
nls_language="SIMPLIFIED CHINESE"
nls_territory="CHINA"###########################################
# SGA Memory
###########################################
sga_target=289406976###########################################
# Optimizer
###########################################
star_transformation_enabled=TRUE###########################################
# Job Queues
###########################################
job_queue_processes=10###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=myerpXDB)"###########################################
# Miscellaneous
###########################################
compatible=10.2.0.1.0###########################################
# Security and Auditing
###########################################
audit_file_dest=E:\Database\oracle\product\10.2.0/admin/myerp/adump
remote_login_passwordfile=EXCLUSIVE###########################################
# Archive
###########################################
log_archive_format=ARC%S_%R.%T###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=96468992###########################################
# Database Identification
###########################################
db_domain=""
db_name=myerp###########################################
# File Configuration
###########################################
control_files=("E:\Database\oracle\product\10.2.0/oradata/myerp/control/\control01.ctl", "E:\Database\oracle\product\10.2.0/oradata/myerp/control/\control02.ctl", "E:\Database\oracle\product\10.2.0/oradata/myerp/control/\control03.ctl")
db_recovery_file_dest=E:\Database\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size=536870912###########################################
# Cursors and Library Cache
###########################################
open_cursors=300###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=E:\Database\oracle\product\10.2.0/admin/myerp/bdump
core_dump_dest=E:\Database\oracle\product\10.2.0/admin/myerp/cdump
user_dump_dest=E:\Database\oracle\product\10.2.0/admin/myerp/udump###########################################
# Processes and Sessions
###########################################
processes=50
sessions=60###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=32
Mon Jul 07 08:51:03 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1437M/2046M, Ph+PgF:3351M/3938M, VA:1939M/2047M
Mon Jul 07 08:51:03 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 08:54:57 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 08:56:57 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 08:57:29 2008
WARNING: inbound connection timed out (ORA-3136)
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 09:16:14 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1284M/2046M, Ph+PgF:3159M/3938M, VA:1939M/2047M
Mon Jul 07 09:16:14 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 09:16:32 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 09:20:41 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1315M/2046M, Ph+PgF:3153M/3938M, VA:1939M/2047M
Mon Jul 07 09:20:41 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 09:21:20 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1307M/2046M, Ph+PgF:3152M/3938M, VA:1939M/2047M
Mon Jul 07 09:21:20 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 09:21:50 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1316M/2046M, Ph+PgF:3152M/3938M, VA:1939M/2047M
Mon Jul 07 09:21:50 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 09:32:52 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1292M/2046M, Ph+PgF:3082M/3938M, VA:1940M/2047M
Mon Jul 07 09:32:52 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 09:33:22 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 09:52:54 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1490M/2046M, Ph+PgF:3375M/3938M, VA:1940M/2047M
Mon Jul 07 09:52:54 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 10:03:26 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1494M/2046M, Ph+PgF:3374M/3938M, VA:1940M/2047M
Mon Jul 07 10:03:26 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 10:04:35 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1488M/2046M, Ph+PgF:3367M/3938M, VA:1940M/2047M
Mon Jul 07 10:04:35 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 10:05:11 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 10:31:35 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 10:36:09 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 10:37:46 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Dump file e:\database\oracle\product\10.2.0/admin/myerp/bdump\alert_myerp.log
Mon Jul 07 10:45:22 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1332M/2046M, Ph+PgF:3178M/3938M, VA:1940M/2047M
Mon Jul 07 10:45:22 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Mon Jul 07 10:46:09 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
sql>startup pfile='初始化文件init.ora';
sql>create spfile from pfile='初始化文件init.ora';
sql>shutdown;
sql>startup;
因为你的实例启动是读spfile,所以你改pfile没用,只有指定用pfile启动才行