去客户那增加 Oracle tablespace

今天去客户那，先发现oracle em 控制台连部上：

 

1：先检查oracle 监听：lsnrctl stauts:

 

oracle@hgpsfe01:/oracle$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 29-NOV-2010 18:24:15

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date                16-NOV-2010 20:08:03
Uptime                    12 days 22 hr. 16 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/app/oracle/product/11g/db/network/admin/listener.ora
Listener Log File         /oracle/app/oracle/diag/tnslsnr/hgpsfe01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=43.82.201.176)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=43.82.201.175)(PORT=1521)))
Services Summary...
Service "sfe" has 2 instance(s).
  Instance "sfe", status UNKNOWN, has 1 handler(s) for this service...
  Instance "sfe", status READY, has 1 handler(s) for this service...
Service "sfeXDB" has 1 instance(s).
  Instance "sfe", status READY, has 1 handler(s) for this service...
The command completed successfully

 

监听没有问题，要是没有起来的话，可以用：lsnrctl start

 

2：看一下em 的服务有没有起来:

 

oracle@hgpsfe01:/oracle$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://hgpsfe01:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /oracle/app/oracle/product/11g/db/hgpsfe01_sfe/sysman/log

要是没有起来的话，可以：emctl start dbconsole

 

3:好，下面开始增加表空间：

 

已开始犯了个错误：

root@hgpsfe01:/# lspv
hdisk6          00cea78553b71557                    sharevg         active
hdisk0          00cea785c1dd8e65                    rootvg          active
hdisk1          00cea785c7046df6                    rootvg          active
hdisk2          00cea7851951d076                    archvg          active
hdisk3          00cea7851961e649                    datavg          active
hdisk4          00cea785196210c6                    datavg          active
hdisk5          00cea785196232e6                    datavg          active

用lsvg datavg发现:(oracle 是装在datavg 上的)

root@hgpsfe01:/# lsvg datavg
VOLUME GROUP:       datavg                   VG IDENTIFIER:  00cea78500004c000000012b196377a5
VG STATE:           active                   PP SIZE:        128 megabyte(s)
VG PERMISSION:      read/write               TOTAL PPs:      2460 (314880 megabytes)
MAX LVs:            512                      FREE PPs:       59 (7552 megabytes)
LVs:                2                        USED PPs:       2401 (307328 megabytes)
OPEN LVs:           2                        QUORUM:         2 (Enabled)
TOTAL PVs:          3                        VG DESCRIPTORS: 3
STALE PVs:          0                        STALE PPs:      0
ACTIVE PVs:         3                        AUTO ON:        no
MAX PPs per VG:     130048                                   
MAX PPs per PV:     1016                     MAX PVs:        128
LTG size (Dynamic): 256 kilobyte(s)          AUTO SYNC:      no
HOT SPARE:          no                       BB POLICY:      relocatable

 

发现只有：7G的样子，而客户要装200G，这个怎么办呢？

请教了一下以前安装的工程师，.....

 

3:换了一个命令：df  -g

 

root@hgpsfe01:/# df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           2.00      1.91    5%     6343     2% /
/dev/hd2           4.00      0.99   76%    55349    20% /usr
/dev/hd9var        1.00      0.54   47%     4938     4% /var
/dev/hd3           4.00      3.57   11%      197     1% /tmp
/dev/hd1           1.00      0.80   20%      453     1% /home
/proc                 -         -    -         -     -  /proc
/dev/hd10opt       1.00      0.89   12%     3466     2% /opt
/dev/lv_oracle     15.00      4.33   72%    49231     5% /oracle
/dev/lv_archlog    100.00     10.94   90%      218     1% /archlog
/dev/lv_oradata    300.00     48.02   84%       31     1% /oradata      (增加前 利用为23%)
/dev/lv_vsopshare    100.00     93.13    7%     1941     1% /vsopshare
/dev/lv_tivoli      2.00      2.00    1%        4     1% /tivoli

 

4:使用命令：

SQL> alter tablespace TBS_SFE_DATA add datafile '/oradata/sfe/tbs_sfe_data_04.dbf' size 50G;
alter tablespace TBS_SFE_DATA add datafile '/oradata/sfe/tbs_sfe_data_04.dbf' size 50G
*
ERROR at line 1:
ORA-01144: File size (6553600 blocks) exceeds maximum of 4194303 blocks

看来比较不顺，把50G降到30G试试：

 

SQL> alter tablespace TBS_SFE_DATA add datafile '/oradata/sfe/tbs_sfe_data_04.dbf' size 30G；

Tablespace altered.

 

5:继续增加：

SQL> alter tablespace TBS_SFE_DATA add datafile '/oradata/sfe/tbs_sfe_data_05.dbf' size 30G;

Tablespace altered.

 

......

 

6: 创建表空间成功。可以去em 控制台看到已经增加到200G了。