Oracle's day-to-day maintenance, fault location, and troubleshooting

Fault classification one database suspend failure

1 Death of the database due to archive suspend

2 nit file in the SGA area set too large, resulting in insufficient memory, database and system are dead

3 The database was suspended because the temporary table space could not be extended

4 suspending the database when an Rman backup is not patched

Fault classification two database function/performance exception

5 because the number of table records of BLOB type is too many and too frequent causes the database efficiency to be poor

6 The database operation is particularly slow due to a periodic table analysis without a large table (up to or exceeding 1 million records)

7 Extended index failure due to insufficient space cause to insert data

8 Database exception due to Redolog damage

9 The database does not start properly because the control file is corrupted

10 The database does not start properly due to data file loss or damage

11 Because the space parameter setting unreasonable causes the expansion table space, the index and so on failure

12 because the time format of the environment variable settings problem resulting in the statement can not be in storage

13 transaction hangs because a large rollback segment is not used by a large transaction

14 Number of server processes or memory exhaustion due to too many database connections

15 The database operation is particularly slow due to the use of MTS (including backup)

16 due to a large transaction operation, resulting in poor database performance or frequent log switching

17 The database table is locked because there is no commit

18 indexing is unreasonable, causing database queries to be particularly slow

19 Exp failure due to unreasonable buffer parameter setting

20 because exp is not up-compatible, language is incompatible, resulting in different versions, different character sets of the database can not be imported

21 creates a tablespace by mistakenly creating it in ' local administration ', causing all objects on the table space to be unable to modify their storage parameters

22 incorrectly building unrelated data files on system tablespace

The Oracle client was not successfully installed on the P4

24 network problems caused by Listener.ora or Tnsnames.ora configuration problems

25 Versoin version startup problem due to environment variable setting problem

26 Data recovery under User data and table destruction

27 Database ORA-600 error due to OS layer problems

Fault Classification III will result in failure of database installation or patching failure

28 Database installation failure due to environment variable or no make file installed

29 The database does not install properly due to a small file system setting such as/tmp

Hpux The database does not start properly due to incorrect core parameter settings

31 failed to hit 32 on the 64-bit ORACLE817.

32 due to the installation of the machine database is the use of the copy mode, so that the install patch on the standby failed

33 incorrectly creating link in the $oracle_home directory when ORACLE is installed, causing the patched version to be copied to the standby failed

The character set problem under Oracle

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/