未分类 - 6. page

先写结果：

1.验证ifcfg-eth2与ifcfg-eth2bak这种格式的，service network restart 时会读取这种配置文件
如果改为mv ifcfg-eth2bak ifcfg-eth3.bak，则不会被读取。
2.验证了文件名的使用顺序，两个配置文件对应同一网卡时，以最早使用的配置文件的为准。

##########################################测试过程：
1.验证ifcfg-eth2与ifcfg-eth2bak这种格式的，service network restart 时会读取这种配置文件
如果改为mv ifcfg-eth2bak ifcfg-eth3.bak，则不会被读取。
[root@bys1 network-scripts]# mv ifcfg-eth3 ifcfg-eth3bak
[root@bys1 network-scripts]# mv ifcfg-eth2bak ifcfg-eth2.bak
[root@bys1 network-scripts]# service network restart
Shutting down interface eth0: [ OK ]
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
Bringing up interface eth3bak:
Determining IP information for eth3…^C
—改为ifcfg-eth3.bak，不会使用
[root@bys1 network-scripts]# mv ifcfg-eth3bak ifcfg-eth3.bak
[root@bys1 network-scripts]# service network restart
Shutting down interface eth0: [ OK ]
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
—-改回去 ifcfg-eth3bak验证会使用
[root@bys1 network-scripts]# mv ifcfg-eth3.bak ifcfg-eth3bak
[root@bys1 network-scripts]# service network restart
Shutting down interface eth0: [ OK ]
Shutting down interface eth3bak: [ OK ]
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
Bringing up interface eth3bak:
Determining IP information for eth3…^C

####################################
2.测试同一网卡，不同配置文件名时的使用顺序及对应IP生效情况
验证了文件名的使用顺序，两个配置文件对应同一网卡时，以最早使用的配置文件的为准。

配置文件情况
[root@bys1 network-scripts]# cat ifcfg-eth1
# Intel Corporation 82540EM Gigabit Ethernet Controller
DEVICE=eth1
BOOTPROTO=none
ONBOOT=yes
HWADDR=08:00:27:A0:5F:E7
NETMASK=255.255.255.0
IPADDR=192.168.10.1
[root@bys1 network-scripts]# cat ifcfg-eth1bak
# Intel Corporation 82540EM Gigabit Ethernet Controller
DEVICE=eth1
BOOTPROTO=none
ONBOOT=yes
HWADDR=08:00:27:A0:5F:E7
NETMASK=255.255.255.0
IPADDR=192.168.11.1

—实验1;将IP192.168.10.1对应的配置文件先读取，后续eth1bak配置文件不会影响。
[root@bys1 network-scripts]# service network restart
Shutting down interface eth0: [ OK ]
Shutting down interface eth1: [ OK ]
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
Bringing up interface eth1: [ OK ]
Bringing up interface eth1bak: [ OK ]
[root@bys1 network-scripts]# ifconfig

eth1 Link encap:Ethernet HWaddr 08:00:27:A0:5F:E7
inet addr:192.168.10.1 Bcast:192.168.10.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:104 errors:0 dropped:0 overruns:0 frame:0
TX packets:35 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:15754 (15.3 KiB) TX bytes:5698 (5.5 KiB)

–实验2：将IP192.168.11.1对应的配置文件先读取，会使用此配置文件的信息。
[root@bys1 network-scripts]# mv ifcfg-eth1 ifcfg-eth1b
[root@bys1 network-scripts]# mv ifcfg-eth1bak ifcfg-eth1a
[root@bys1 network-scripts]# service network restart
Shutting down interface eth0: [ OK ]
Shutting down interface eth1a: [ OK ]
Shutting down loopback interface: [ OK ]
Bringing up loopback interface: [ OK ]
Bringing up interface eth0: [ OK ]
Bringing up interface eth1a: [ OK ]
Bringing up interface eth1b: [ OK ]
[root@bys1 network-scripts]# ifconfig eth1
eth1 Link encap:Ethernet HWaddr 08:00:27:A0:5F:E7
inet addr:192.168.11.1 Bcast:192.168.11.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:136 errors:0 dropped:0 overruns:0 frame:0
TX packets:62 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:19100 (18.6 KiB) TX bytes:9287 (9.0 KiB)

LINUX上安装11.2.0.4 RAC时，安装grid运行root.sh报错ORA-15020 discovered duplicate ASM disk排查。
[root@lnx67 rules.d]# ls -al /dev/asm*
brw-rw—- 1 grid asmadmin 250, 0 Jan 5 14:47 /dev/asm-diskb
brw-rw—- 1 grid asmadmin 250, 16 Jan 5 14:47 /dev/asm-diskc
brw-rw—- 1 grid asmadmin 250, 32 Jan 5 14:47 /dev/asm-diskd
修改UDEV规则，将ASM使用的盘名字改为：
[root@lnx67 Packages]# ls -al /dev/asm*
brw-rw—- 1 grid asmadmin 250, 16 Jan 6 08:24 /dev/asm-diskarch
brw-rw—- 1 grid asmadmin 250, 0 Jan 5 14:47 /dev/asm-diskb
brw-rw—- 1 grid asmadmin 250, 16 Jan 5 14:47 /dev/asm-diskc
brw-rw—- 1 grid asmadmin 250, 32 Jan 5 14:47 /dev/asm-diskd
brw-rw—- 1 grid asmadmin 250, 32 Jan 6 08:24 /dev/asm-diskdata
brw-rw—- 1 grid asmadmin 250, 0 Jan 6 08:45 /dev/asm-diskocr
此时原来的绑定规划生成的盘符没有消失，新的盘符产生了。
之后安装GRID运行root.sh时报错：
ORA-15018: diskgroup cannot be created
ORA-15020: discovered duplicate ASM disk “DGOCR_0000”

——-2016/2/29帮人查问题发现最新信息： 12cR1安装时同样问题，只报错ORA-15018:这一行。。。

原因就是使用ASM_DISKSTRING参数是/dev/asm*,此时比如同一磁盘B对应了/dev/asm-diskb及/dev/asm-diskocr。
从操作系统层面使用start_udev，旧的没产生，最终是重启解决盘符问题。
GRID安装出错后，新安装环境就使用了重新安装的方式。
————root.sh报错信息
[root@lnx67 Packages]# sh /u01/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization – successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding Clusterware entries to upstart
CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘lnx67’
CRS-2676: Start of ‘ora.mdnsd’ on ‘lnx67’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘lnx67’
CRS-2676: Start of ‘ora.gpnpd’ on ‘lnx67’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘lnx67’
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘lnx67’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘lnx67’ succeeded
CRS-2676: Start of ‘ora.gipcd’ on ‘lnx67’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘lnx67’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘lnx67’
CRS-2676: Start of ‘ora.diskmon’ on ‘lnx67’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘lnx67’ succeeded

Disk Group dgocr creation failed with the following message:
ORA-15018: diskgroup cannot be created
ORA-15020: discovered duplicate ASM disk “DGOCR_0000”

Configuration of ASM … failed
see asmca logs at /u01/app/oracle/cfgtoollogs/asmca for details
Did not succssfully configure and start ASM at /u01/11.2.0/grid/crs/install/crsconfig_lib.pm line 6912.
/u01/11.2.0/grid/perl/bin/perl -I/u01/11.2.0/grid/perl/lib -I/u01/11.2.0/grid/crs/install /u01/11.2.0/grid/crs/install/rootcrs.pl execution failed
You have new mail in /var/spool/mail/root

客户反映归档的位置不太多，再仔细看归档的名字也不对；检查下发现指定 归档目录类似
/arch/test 而不是/arch/test/
如下测试验证log_archive_dest_1与log_archive_format对生成的归档文件名的影响。
1.log_archive_dest_1指定的目录后面还有字段

1.1. 字段对应的无同名目录，生成归档文件名=log_archive_dest_1+log_archive_format

1.2 字段对应的有同名目录，生成归档文件在同名目录下，文件名为log_archive_format
2.log_archive_dest_1指定的目录不存在–报错
3.log_archive_dest_1指定的目录
归档文件名=log_archive_format

———————————–
1 log_archive_dest_1指定的目录后面还有字段

1.1. 字段对应的无同名目录，生成归档文件名=log_archive_dest_1+log_archive_format

归档文件名=log_archive_dest_1+log_archive_format
SQL> alter system set log_archive_dest_1=’LOCATION=/u01/oracle/base/oracle/oradata/arch/test’;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/base/oracle/oradata/arch/test
Oldest online log sequence 24
Next log sequence to archive 26
Current log sequence 26
SQL> show parameter log_archive_format
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_format string %t_%s_%r.dbf
SQL> alter system switch logfile;
System altered.
——–生成的文件名
[oracle@bys1 arch]$ pwd
/u01/oracle/base/oracle/oradata/arch
[oracle@bys1 arch]$ ls
test1_26_900253622.dbf

1.2 字段对应的有同名目录，生成归档文件在同名目录下，文件名为log_archive_format

文件在同名目录下，文件名为log_archive_format

SQL> alter system switch logfile;
System altered.

[oracle@bys1 test]$ pwd
/u01/oracle/base/oracle/oradata/arch/test
[oracle@bys1 test]$ ls
1_40_900253622.dbf

2.log_archive_dest_1指定的目录不存在–直接报错
SQL> alter system set log_archive_dest_1=’LOCATION=/u01/oracle/base/oracle/oradata/arch/test/’;
alter system set log_archive_dest_1=’LOCATION=/u01/oracle/base/oracle/oradata/arch/test/’
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory

3.log_archive_dest_1指定目录
归档文件名=log_archive_format
[oracle@bys1 arch]$ mkdir test
[oracle@bys1 arch]$ ls
test test1_26_900253622.dbf
SQL> alter system set log_archive_dest_1=’LOCATION=/u01/oracle/base/oracle/oradata/arch/test/’;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/base/oracle/oradata/arch/test/
Oldest online log sequence 25
Next log sequence to archive 27
Current log sequence 27
SQL> show parameter log_archive_format
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_format string %t_%s_%r.dbf
SQL> alter system switch logfile;
System altered.
———
[oracle@bys1 arch]$ cd test
[oracle@bys1 test]$ ls -al
total 12
drwxr-xr-x 2 oracle oinstall 4096 Feb 1 16:13 .
drwxr-xr-x 3 oracle oinstall 4096 Feb 1 16:13 ..
-rw-r—– 1 oracle asmadmin 2560 Feb 1 16:13 1_27_900253622.dbf
[oracle@bys1 test]$ pwd
/u01/oracle/base/oracle/oradata/arch/test

TRUNCATE表后对表大小进行查询，表的空间没有释放完毕？
对此进行实验测试，结果如下：(测试环境LINUX+ORACLE11.2.0.3)
创建表时语句指定了storage (MINEXTENTS 5);时，TRUNCATE后还有5个EXTENT；
创建表时语句不指定storage (MINEXTENTS参数，即使用默认值时；TRUNCATE后只有1个EXTENT；
———— 实验1：指定了storage (MINEXTENTS 5)
SQL> create tablespace test2 datafile ‘/u01/oracle/base/oracle/oradata/bys7/test2.dbf’ size 10m uniform size 40k;
Tablespace created.

SQL> show user
USER is “TEST”
SQL> create table test1(aa number,name varchar2(128)) tablespace test2 storage (MINEXTENTS 5);
Table created.
SQL> select owner,SEGMENT_NAME,TABLESPACE_NAME,EXTENT_ID from dba_extents where SEGMENT_NAME=’TEST1′;
OWNER SEGMENT_NAME TABLESPACE_NAME EXTENT_ID
—————————— ———— ————— ———-
TEST TEST1 TEST2 0
TEST TEST1 TEST2 1
TEST TEST1 TEST2 2
TEST TEST1 TEST2 3
TEST TEST1 TEST2 4

SQL> insert into test1 select object_id,object_name from dba_objects;
13723 rows created.
SQL> commit;
Commit complete.
SQL> select owner,SEGMENT_NAME,TABLESPACE_NAME,EXTENT_ID from dba_extents where SEGMENT_NAME=’TEST1′;
OWNER SEGMENT_NAME TABLESPACE_NAME EXTENT_ID
—————————— ———— ————— ———-
TEST TEST1 TEST2 0
TEST TEST1 TEST2 1
TEST TEST1 TEST2 2
TEST TEST1 TEST2 3
TEST TEST1 TEST2 4
TEST TEST1 TEST2 5
TEST TEST1 TEST2 6
TEST TEST1 TEST2 7
TEST TEST1 TEST2 8
TEST TEST1 TEST2 9
TEST TEST1 TEST2 10
TEST TEST1 TEST2 11
12 rows selected.

SQL>truncate table test1;
Table truncated.

SQL> select owner,SEGMENT_NAME,TABLESPACE_NAME,EXTENT_ID from dba_extents where SEGMENT_NAME=’TEST1′;

OWNER SEGMENT_NAME TABLESPACE_NAME EXTENT_ID
—————————— ———— ————— ———-
TEST TEST1 TEST2 0
TEST TEST1 TEST2 1
TEST TEST1 TEST2 2
TEST TEST1 TEST2 3
TEST TEST1 TEST2 4

SQL> select SEGMENT_NAME,TABLESPACE_NAME,BYTES/1024 kb,EXTENTS,BLOCKS,INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS from dba_segments where SEGMENT_NAME=’TEST1′;
SEGMENT_NAME TABLESPACE_NAME KB EXTENTS BLOCKS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
———— ————— ———- ———- ———- ————– ———– ———– ———–
TEST1 TEST2 200 5 25 204800 40960 1 2147483645

实验2：创建表时不指定storage (MINEXTENTS参数 使用默认值
SQL> create table test2 tablespace test2 as select object_id,object_name from dba_objects;
Table created.

SQL> set pagesize 1000
SQL> select owner,SEGMENT_NAME,TABLESPACE_NAME,EXTENT_ID from dba_extents where SEGMENT_NAME=’TEST2′;
OWNER SEGMENT_NAME TABLESPACE_NAME EXTENT_ID
—————————— ———— ————— ———-
TEST TEST2 TEST2 0
TEST TEST2 TEST2 1
TEST TEST2 TEST2 2
TEST TEST2 TEST2 3
TEST TEST2 TEST2 4
TEST TEST2 TEST2 5
TEST TEST2 TEST2 6
TEST TEST2 TEST2 7
TEST TEST2 TEST2 8
TEST TEST2 TEST2 9
TEST TEST2 TEST2 10
TEST TEST2 TEST2 11
12 rows selected.

SQL> truncate table test2;
Table truncated.

SQL> select owner,SEGMENT_NAME,TABLESPACE_NAME,EXTENT_ID from dba_extents where SEGMENT_NAME=’TEST2′;
OWNER SEGMENT_NAME TABLESPACE_NAME EXTENT_ID
—————————— ———— ————— ———-
TEST TEST2 TEST2 0