首页 » ORACLE » oracle 重置初始化参数 reset parameter value

oracle 重置初始化参数 reset parameter value

先前更改了os_authent_prefix为空,后来想改回原来的值,如果你不知道原值怎么办?重置

connect !

SQL> show parameter os

NAME TYPE
———————————— ———————-
VALUE
——————————
optimizer_index_cost_adj integer
100
os_authent_prefix string

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

SQL> alter system reset os_authent_prefix scope=spfile sid=*;
alter system reset os_authent_prefix scope=spfile sid=*
*
ERROR at line 1:
ORA-01780: string literal required

SQL> alter system reset os_authent_prefix 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 562036736 bytes
Fixed Size 1220556 bytes
Variable Size 239075380 bytes
Database Buffers 314572800 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.

SQL> set linesize 200
SQL> show parameter os_au

NAME TYPE VALUE
———————————— ———————- ——————————
os_authent_prefix string ops$
remote_os_authent boolean FALSE
SQL>

到此修改完成,至于为什么非要加sid, 记的在TOM大叔的书上有讲,是出于考虑多实例。

打赏

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

  1. Ted Kiely | #1
    2011-12-21 at 05:41

    Would you be engaged utilizing updating backlinks to your site?

  2. Susy | #2
    2011-06-16 at 11:53

    Fell out of bed feeling down. This has brgihnteed my day!

    • Dolley | #3
      2011-06-23 at 10:22

      That addresses several of my coencrns actually.

      • Indian | #4
        2011-09-03 at 04:01

        In awe of that anwser! Really cool!