首页 » ORACLE » oracle controlfile Multipath 控制文件多路径标点符号

oracle controlfile Multipath 控制文件多路径标点符号

今天 在配置多controlfile 多路径时,出了点小问题,结果发现是标点符号引起的

–by anbob.com

操作如下

SQL> show parameter spfile

NAME                                 TYPE        VALUE
———————————— ———– ——————————
spfile                               string      D:\ORACLE\PRODUCT\10.1.0\DB_1\
                                                 DATABASE\SPFILEORCL.ORA
SQL> show controlfile
SP2-0735: unknown SHOW option beginning “controlfil…”
SQL> show parameter control

NAME                                 TYPE        VALUE
———————————— ———– ——————————
control_file_record_keep_time        integer     7
control_files                        string      D:\ORACLE\PRODUCT\10.1.0\ORADA
                                                 TA\ORCL\CONTROL01.CTL
SQL> alter system set control_files=’D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL’ scope=
spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
C:\>copy D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL
已复制         1 个文件。

C:\>copy D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL
已复制         1 个文件。

C:\>
SQL> startup
ORACLE instance started.

Total System Global Area  201326592 bytes
Fixed Size                   788128 bytes
Variable Size             145488224 bytes
Database Buffers           54525952 bytes
Redo Buffers                 524288 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
SQL> alter system set control_files=(‘D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL’) scop
e=spfile;
alter system set control_files=(‘D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL’) scope=spf
ile
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set control_files='(D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CTL)’ scop
e=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  201326592 bytes
Fixed Size                   788128 bytes
Variable Size             145488224 bytes
Database Buffers           54525952 bytes
Redo Buffers                 524288 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

SQL> alter system set control_files=”D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL
spfile;
alter system set control_files=”D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL,D:\oracle\product\10.1.0\oradata\orcl\CONTROL03.CT
e
                               *
ERROR at line 1:
ORA-00972: identifier is too long
SQL> alter system set control_files=”D:\oracle\product\10.1.0\oradata\orcl\CONTROL01.CTL”,”D:\oracle\product\10.1.0\oradata\orcl\CONTROL02.CTL”,”D:\oracle\product\10.1.0\oradata\orcl\CON
ope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  201326592 bytes
Fixed Size                   788128 bytes
Variable Size             145488224 bytes
Database Buffers           54525952 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.
SQL>

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Refugio Pirillo | #1
    2011-12-21 at 05:46

    family lawyers paramatta: