以下为实践样例:
- Last login: Thu Mar 28 11:22:31 2013 from 10.4.101.66
- Sun Microsystems Inc. SunOS 5.9 Generic May 2002
- [oradev@misp5]/home/oradev>cd $ORACLE_HOME/admin
- [oradev@misp5]/data/bjdev/db/9.2.0/admin>ls -l
- 总数 2
- drwxr-xr-x 5 oradev dba 512 2007 7月 14 BJDEV_misp5
- [oradev@misp5]/data/bjdev/db/9.2.0/admin>cd *
- [oradev@misp5]/data/bjdev/db/9.2.0/admin/BJDEV_misp5>cd bdump
- [oradev@misp5]/data/bjdev/db/9.2.0/admin/BJDEV_misp5/bdump>ls -l *.log
- -rw-r--r-- 1 oradev dba 5141496 3月 28 11:37 alert_BJDEV.log
- -rw-r--r-- 1 oradev dba 8414 2012 4月 13 alert_BJPRD.log
- [oradev@misp5]/data/bjdev/db/9.2.0/admin/BJDEV_misp5/bdump>tail -50 *DEV*
- Thu Mar 28 11:25:11 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:25:11 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:25:11 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:27:11 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:27:11 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:27:11 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:27:11 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:29:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:29:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:29:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:29:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:31:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:31:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:31:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:31:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:33:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:33:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:33:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:33:12 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:35:13 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:35:13 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:35:13 2013
- ORA-1653: unable to extend table APPLSYS.FND_CONCURRENT_PROCESSES by 65 in tablespace APPLSYSD
- Thu Mar 28 11:35:13 2013
- ORA-1653: unable to extend table APPLSYS.FND_ENV_CONTEXT by 5 in tablespace APPLSYSD
- Thu Mar 28 11:37:12 2013
- alter tablespace applsysd add datafile '/data/bjdev/data/applsysd17.dbf' size 1m autoextend on next 512k maxsize 2000m
- Thu Mar 28 11:37:12 2013
- Completed: alter tablespace applsysd add datafile '/data/bjde
- [oradev@misp5]/data/bjdev/db/9.2.0/admin/BJDEV_misp5/bdump>cd /data/bjdev/data
- [oradev@misp5]/data/bjdev/data>ls -l applsysd*
- -rwxr-xr-x 1 oradev dba 6291464192 3月 28 11:37 applsysd01.dbf
- -rwxr-xr-x 1 oradev dba 6417293312 3月 28 11:34 applsysd02.dbf
- -rwxr-xr-x 1 oradev dba 5397716992 3月 28 11:13 applsysd03.dbf
- -rwxr-xr-x 1 oradev dba 6291464192 3月 28 11:37 applsysd04.dbf
- -rwxr-xr-x 1 oradev dba 6291464192 3月 28 11:35 applsysd05.dbf
- -rwxr-xr-x 1 oradev dba 5368717312 3月 28 00:50 applsysd06.dbf
- -rwxr-xr-x 1 oradev dba 5368717312 3月 28 11:34 applsysd07.dbf
- -rwxr-xr-x 1 oradev dba 5242888192 3月 28 00:50 applsysd08.dbf
- -rwxr-xr-x 1 oradev dba 9431949312 3月 28 11:03 applsysd09.dbf
- -rwxr-xr-x 1 oradev dba 3145736192 3月 28 00:50 applsysd10.dbf
- -rwxr-xr-x 1 oradev dba 3145736192 3月 28 00:50 applsysd11.dbf
- -rwxr-xr-x 1 oradev dba 4294975488 3月 28 00:50 applsysd12.dbf
- -rwxr-xr-x 1 oradev dba 4294975488 3月 28 11:13 applsysd13.dbf
- -rwxr-xr-x 1 oradev dba 4294975488 3月 28 11:13 applsysd14.dbf
- -rwxr-xr-x 1 oradev dba 4294975488 3月 28 11:34 applsysd15.dbf
- -rw-r----- 1 oradev dba 2097160192 3月 28 11:39 applsysd16.dbf
- -rw-r----- 1 oradev dba 1056768 3月 28 11:37 applsysd17.dbf
- [oradev@misp5]/data/bjdev/data>sqlplus / as sysdba
- Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
- where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
- <logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
- <start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
- "-H" displays the SQL*Plus version banner and usage syntax
- "-V" displays the SQL*Plus version banner
- "-L" attempts log on just once
- "-M <o>" uses HTML markup options <o>
- "-R <n>" uses restricted mode <n>
- "-S" uses silent mode
- [oradev@misp5]/data/bjdev/data>sqlplus '/ as sysdba'
- SQL*Plus: Release 9.2.0.6.0 - Production on Thu Mar 28 11:43:55 2013
- Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
- Connected to:
- Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
- With the Partitioning, OLAP and Oracle Data Mining options
- JServer Release 9.2.0.6.0 - Production
- SQL> alter tablespace applsysd add datafile '/data/bjdev/data/applsysd18.dbf' size 1m autoextend on next 512k maxsize 2000m;
- Tablespace altered.
- SQL>
转载于:https://blog.51cto.com/baser/1165231