本文主要是介绍去客户那增加 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了。
这篇关于去客户那增加 Oracle tablespace的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
