SQL>  alter system set log_archive_dest_1='LOCATION = +vgexternal' scope=spfile;
 alter system set log_archive_dest_1='LOCATION = /u01' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

SQL> alter system set log_archive_dest_1='LOCATION=+vgexternal' scope=spfile;

 

System altered.

 

SQL> show parameter archive

 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
.....
log_archive_dest_1                   string
log_archive_dest_state_1             string      enable
log_archive_format                   string      %t_%s_%r.dbf
log_archive_local_first              boolean     TRUE
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
.......
SQL> alter system set log_archive_start=true scope=spfile;

 

System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

 

Total System Global Area  167772160 bytes
Fixed Size                   778212 bytes
Variable Size              74457116 bytes
Database Buffers           92274688 bytes
Redo Buffers                 262144 bytes
Database mounted.
SQL> alter database archivelog;

 

Database altered.

 

SQL> alter database open;

 

Database altered.

 

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +VGEXTERNAL
Oldest online log sequence     72
Next log sequence to archive   73
Current log sequence           73
SQL>

SQL> !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.

SQL> alter system reset log_archive_start scope=spfile sid='*'
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

 

Total System Global Area  167772160 bytes
Fixed Size                   778212 bytes
Variable Size              78651420 bytes
Database Buffers           88080384 bytes
Redo Buffers                 262144 bytes
Database mounted.

所有讨厌的信息终于都没了：）

 

第一次创建asm，中途退出。

再次创建发现dbca hang在应该出现创建asm 实例的地方。

检查crs_stat的状态，发现有asm实例在，但是offline。

使用srvctl remove asm -n rac1;srvctl remove asm -n rac2删除asm实例后正常。

5月份要搬到2枢纽大楼。现在正在装修。

本来说要搬到网通大厦，着实让我高兴了一阵。虽然那边上下班打卡，但是我不用上班倒3趟车了。可惜最后还是搬到了现在公司附近的二枢纽。

 

眼看着就搬家了，我们还要从二楼搬到三楼。刚刚做完了电话线。估计下午或者明天就要搬了。

 

上班4年，从省校搬到实业公司，从实业搬到现在的楼，地点一次比一次偏僻。

现在又搬了，可惜没有啥变化。

 

昨天老总开会，说个别国有员工回到主业后，是长长的送了一口气。不知道是不是说给我们参加会议的少数几个国有员工听的。不知道有什么气可松的，每年那么多任务！

国有，呵呵，活不能少干，饭不能多吃，还得经常受敲打。是不是所谓的“稳定”惹的祸？

数据库启动时报这个错误。

$ oerr ora 119
00119, 00000, "invalid specification for system parameter %s"
// *Cause: The syntax for the specified parameter is incorrect.
// *Action: Refer to the Oracle8 Server Reference Manual for the correct syntax.

 

$ oerr ora 132
00132, 00000, "syntax error or unresolved network name '%s'"
// *Cause:  Listener address has syntax error or cannot be resolved.
// *Action: If a network name is specified, check that it corresponds
//          to an entry in TNSNAMES.ORA or other address repository
//          as configured for your system. Make sure that the entry
//          is syntactically correct.

 

觉得可能是remote_listener和local_listener设置有问题了。

询问后得知没有人改过这2个参数。

于是去看tnsnames.ora，果然没有找到2个参数指定的listener的定义。

添加后定义后，数据库启动成功。

LISTENER_FXDB2 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = srgj2)(PORT = 1521))

LISTENERS_FXDB =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = testing2)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = srgj2)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = srgj1)(PORT = 1521))
  )