1、为了试验需要,现删除D:\work_tools\oracle\product\10.2.0\db_1\database下,SPFILEDXM.ORA 和 INITdxm.ORA
2、SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\DB
_1\DATABASE\INITDXM.ORA'
SQL>
3、利用D:\work_tools\oracle\product\10.2.0\admin\dxm\bdump\alert_dxm.log 创建 文本参数文件
创建D:\work_tools\oracle\product\10.2.0\db_1\database\INITdxm.ORA
将alert_dxm.log中的如下部分,copy到INITdxm.ORA
processes = 400
__shared_pool_size = 88080384
shared_pool_size = 37748736
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 285212672
control_files = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL01.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL02.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 176160768
db_cache_size = 50331648
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\work_tools\oracle\product\10.2.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=dxmXDB)
job_queue_processes = 10
audit_file_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\ADUMP
background_dump_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\BDUMP
user_dump_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\UDUMP
core_dump_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\CDUMP
db_name = dxm
open_cursors = 300
pga_aggregate_target = 94371840
-------------------------------------------------------------------------------------------------
4、然后
SQL> startup force
ORA-01078: failure in processing system parameters
LRM-00116: syntax error at 'dispatchers' following '='
SQL>
5、根据错误提示,修改INITdxm.ORA
processes = 400
__shared_pool_size = 88080384
shared_pool_size = 37748736
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 285212672
control_files = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL01.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL02.CTL, D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ORADATA\DXM\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 176160768
db_cache_size = 50331648
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\work_tools\oracle\product\10.2.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=dxmXDB)'
job_queue_processes = 10
audit_file_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\ADUMP
background_dump_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\BDUMP
user_dump_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\UDUMP
core_dump_dest = D:\WORK_TOOLS\ORACLE\PRODUCT\10.2.0\ADMIN\DXM\CDUMP
db_name = dxm
open_cursors = 300
pga_aggregate_target = 94371840
6、根据文本文件INITdxm.ORA 启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1248552 bytes
Variable Size 100664024 bytes
Database Buffers 176160768 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
7、根据文本文件创建二进制文件
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
SQL> create spfile from pfile;
File created.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> startup force
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1248552 bytes
Variable Size 100664024 bytes
Database Buffers 176160768 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\WORK_TOOLS\ORACLE\PRODUCT\1
0.2.0\DB_1\DATABASE\SPFILEDXM.
ORA
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13726712/viewspace-682774/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13726712/viewspace-682774/