ORA-32004&ORA-27125

一个朋友数据库在启动的时候提示下面错误
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-27125: unable to create shared memory segment
Linux-x86_64 Error: 1: Operation not permitted

oracle@linux-0ygf:~> oerr ora 32004
32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause:  One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete.
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.

oracle@linux-0ygf:~> oerr ora 27125
27125, 00000, "unable to create shared memory segment"
// *Cause: shmget() call failed
// *Action: contact Oracle support
对于ora-32004 让查看alert日志
.......
  pga_aggregate_target     = 1593835520
Deprecated system parameters with specified values:
  log_archive_start
End of deprecated system parameter listing
PMON started with pid=2, OS id=18705
..........
在10g中不支持该参数。当打开归档模式(archive log mode) ，则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式，但是自动归档没有被设定的情况了。这也算是 Oracle 修正的一个小Bug。如果是从 9i 升级到 10g 的话，不注意可能会有点小问题的。要解决该问题，需要重置 log_archive_start 参数。

日志中记录了修改过该参数。
OBJNO                 FROM SYS.EXU9TYPTU2                 WHERE TABOBJNO = :1 )      ORDER  BY SYNTIME
Thu Dec  1 04:04:37 2011
ALTER SYSTEM SET log_archive_start=FALSE SCOPE=SPFILE;
Thu Dec  1 04:04:48 2011
Starting background process EMN0
EMN0 started with pid=33, OS id=18695

SQL> alter system reset log_archive_start scope=spfile;    
alter system reset log_archive_start scope=spfile
                                                *
ERROR at line 1:
ORA-00905: missing keyword

SQL> alter system reset log_archive_start scope=spfile sid='*';

System altered.

SQL> SHUTDOWN immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

对于第二个问题：
参考：http://hi.baidu.com/jadesuper6/blog/item/aa5f07298483082a349bf7b6.html

修改完过后重启启动数据库，完成。

查看那些参数是被10g启用的。

SQL> select name,description from v$parameter where isdeprecated='TRUE'

NAME                      DESCRIPTION
------------------------- ---------------------------------------------
lock_name_space           lock name space used for generating lock name
                          s for standby/clone database

buffer_pool_keep          Number of database blocks/latches in keep buf
                          fer pool

buffer_pool_recycle       Number of database blocks/latches in recycle
                          buffer pool

max_commit_propagation_de Max age of new snapshot in .01 seconds
lay

remote_archive_enable     remote archival enable setting
log_archive_start         start archival process on SGA initialization
parallel_server           if TRUE startup in parallel server mode
parallel_server_instances number of instances to use for sizing OPS SGA
                           structures

fast_start_io_target      Upper bound on recovery reads
logmnr_max_persistent_ses maximum number of threads to mine
sions

serial_reuse              reuse the frame. segments
max_enabled_roles         max number of roles a user can have enabled
global_context_pool_size  Global Application Context Pool Size in Bytes
plsql_compiler_flags      PL/SQL compiler flags
sql_trace                 enable SQL trace
parallel_automatic_tuning enable intelligent defaults for parallel exec
                          ution parameters

drs_start                 start DG Broker monitor (DMON process)

17 rows selected.

替代参数
 
BUFFER_POOL_KEEP (replaced by DB_KEEP_CACHE_SIZE)
BUFFER_POOL_RECYCLE (replaced by DB_RECYCLE_CACHE_SIZE)
PLSQL_COMPILER_FLAGS (replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG)
DRS_START (replaced by DG_BROKER_START)
FAST_START_IO_TARGET (replaced by FAST_START_MTTR_TARGET)
MTS_CIRCUITS (replaced by CIRCUITS)
MTS_DISPATCHERS (replaced by DISPATCHERS)
MTS_MAX_DISPATCHERS (replaced by MAX_DISPATCHERS)
MTS_MAX_SERVERS (replaced by MAX_SHARED_SERVERS)
MTS_SERVERS (replaced by SHARED_SERVERS)
MTS_SESSIONS (replaced by SHARED_SERVER_SESSIONS)
PARALLEL_SERVER (replaced by CLUSTER_DATABASE)
PARALLEL_SERVER_INSTANCES (replaced by CLUSTER_DATABASE_INSTANCES)

废弃参数
DBLINK_ENCRYPT_LOGIN
HASH_JOIN_ENABLED
LOG_PARALLELISM
MAX_ROLLBACK_SEGMENTS
MTS_CIRCUITS
MTS_DISPATCHERS
MTS_LISTENER_ADDRESS
MTS_MAX_DISPATCHERS
MTS_MAX_SERVERS
MTS_MULTIPLE_LISTENERS
MTS_SERVERS
MTS_SERVICE
MTS_SESSIONS
OPTIMIZER_MAX_PERMUTATIONS
ORACLE_TRACE_COLLECTION_NAME
ORACLE_TRACE_COLLECTION_PATH
ORACLE_TRACE_COLLECTION_SIZE
ORACLE_TRACE_ENABLE
ORACLE_TRACE_FACILITY_NAME
ORACLE_TRACE_FACILITY_PATH
PARTITION_VIEW_ENABLED
PLSQL_NATIVE_C_COMPILER
PLSQL_NATIVE_LINKER
PLSQL_NATIVE_MAKE_FILE_NAME
PLSQL_NATIVE_MAKE_UTILITY
ROW_LOCKING
SERIALIZABLE
TRANSACTION_AUDITING
UNDO_SUPPRESS_ERRORS
DISTRIBUTED_TRANSACTIONS
MAX_TRANSACTION_BRANCHES
PARALLEL_BROADCAST_ENABLED
STANDBY_PRESERVES_NAMES
ALWAYS_ANTI_JOIN
ALWAYS_SEMI_JOIN
DB_BLOCK_LRU_LATCHES
DB_BLOCK_MAX_DIRTY_TARGET
DB_FILE_DIRECT_IO_COUNT
GC_DEFER_TIME
GC_RELEASABLE_LOCKS
GC_ROLLBACK_LOCKS
HASH_MULTIBLOCK_IO_COUNT
INSTANCE_NODESET
JOB_QUEUE_INTERVAL
OPS_INTERCONNECTS
OPTIMIZER_PERCENT_PARALLEL
SORT_MULTIBLOCK_READ_COUNT
TEXT_ENABLE

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22779291/viewspace-719185/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779291/viewspace-719185/