开库报错
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 658509392 bytes
Database Buffers 184549376 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
Oracle版本
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
告警日志的信息
[root@node2 trace]# tail -f alert_prod2.log
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun May 11 13:03:44 2014
Stopping background process VKTM:
Sun May 11 13:03:46 2014
NOTE: Shutting down MARK background process
Sun May 11 13:03:48 2014
freeing rdom 0
Sun May 11 13:03:51 2014
Instance shutdown complete
Sun May 11 13:06:13 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 eth1 10.10.10.0 configured from GPnP Profile for use as a cluster interconnect
Interface type 1 eth0 192.168.10.0 configured from GPnP Profile for use as a public interface
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
NOTE: Volume support enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/db_1/dbs/initprod2.ora
System parameters with non-default values:
processes = 150
spfile = "+DG1/prod/spfileprod.ora"
memory_target = 812M
control_files = "+DG1/prod/controlfile/current.260.833306653"
control_files = "+RCY1/prod/controlfile/current.256.833306655"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "location=/u01/arch"
cluster_database = TRUE
db_create_file_dest = "+DG1"
db_recovery_file_dest = "+RCY1"
db_recovery_file_dest_size= 3852M
thread = 2
undo_tablespace = "UNDOTBS2"
instance_number = 2
remote_os_authent = TRUE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=prodXDB)"
remote_listener = "scan_host:1521"
audit_file_dest = "/u01/app/oracle/admin/prod/adump"
audit_trail = "DB"
db_name = "prod"
open_cursors = 300
diagnostic_dest = "/u01/app/oracle"
Deprecated system parameters with specified values:
remote_os_authent
End of deprecated system parameter listing
Cluster communication is configured to use the following interface(s) for this instance
10.10.10.22
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
网上的说法是remote_os_authent参数已经弃用了
备份spfile
SQL> create pfile='/home/oracle/init.ora' from spfile='+DG1/prod/spfileprod.ora';
File created.
Reset remote_os_authent参数后
SQL> alter system reset remote_os_authent scope=spfile sid='*';
System altered.
从新启动实例，没有报错
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 658509392 bytes
Database Buffers 184549376 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
11g中哪些参数是depercated的
SQL> col name for a30
SQL> col DESCRIPTION for a50
SQL> r
1* select name,description from v$parameter where isdeprecated = 'TRUE'
NAME DESCRIPTION
------------------------------ --------------------------------------------------
lock_name_space lock name space used for generating lock names for
standby/clone database
instance_groups list of instance group names
resource_manager_cpu_allocatio Resource Manager CPU allocation
n
active_instance_count number of active instances in the cluster database
buffer_pool_keep Number of database blocks/latches in keep buffer p
ool
buffer_pool_recycle Number of database blocks/latches in recycle buffe
r pool
log_archive_start start archival process on SGA initialization
standby_archive_dest standby database archivelog destination text strin
g
log_archive_local_first Establish EXPEDITE attribute default value
parallel_server if TRUE startup in parallel server mode
parallel_server_instances number of instances to use for sizing OPS SGA stru
ctures
fast_start_io_target Upper bound on recovery reads
serial_reuse reuse the frame segments
max_enabled_roles max number of roles a user can have enabled
remote_os_authent allow non-secure remote clients to use auto-logon
accounts
global_context_pool_size Global Application Context Pool Size in Bytes
cursor_space_for_time use more memory in order to get faster execution
plsql_v2_compatibility PL/SQL version 2.x compatibility flag
plsql_debug PL/SQL debug
background_dump_dest Detached process dump directory
user_dump_dest User process dump directory
commit_write transaction commit log write behaviour
sql_trace enable SQL trace
parallel_automatic_tuning enable intelligent defaults for parallel execution
parameters
parallel_io_cap_enabled enable capping DOP by IO bandwidth
25 rows selected.