Day-to-day maintenance commands for Oracle in Linux

1. Check Oracle's Process

$ ps-ef|grep "Ora_" |grep-v grep

Oracle 5998 1 0 11:15:59 0:01 ora_j000_pprd10

Oracle 2968 1 0 21:16:57 0:00 ora_q000_pprd10

Oracle 2927 1 0 21:16:33 0:00 ora_pmon_pprd10

Oracle 2933 1 0 21:16:34 0:07 ora_dbw0_pprd10

Oracle 2945 1 0 21:16:34 0:02 ora_mmon_pprd10

Oracle 2931 1 0 21:16:33 0:00 ora_mman_pprd10

Oracle 2949 1 0 21:16:34 0:00 ora_d000_pprd10

Oracle 2970 1 0 21:16:57 0:00 ora_q001_pprd10

Oracle 2935 1 0 21:16:34 0:05 ora_lgwr_pprd10

Oracle 2951 1 0 21:16:34 0:00 ora_s000_pprd10

Oracle 2939 1 0 21:16:34 0:06 ora_smon_pprd10

Oracle 2957 1 0 21:16:47 0:00 ora_qmnc_pprd10

Oracle 2943 1 0 21:16:34 0:05 ora_cjq0_pprd10

Oracle 2947 1 0 21:16:34 0:00 ora_mmnl_pprd10

Oracle 2937 1 0 21:16:34 0:18 ora_ckpt_pprd10

Oracle 2941 1 0 21:16:34 0:00 ora_reco_pprd10

Oracle 2929 1 0 21:16:33 0:00 ora_psp0_pprd10

After checking Oracle's process command output, the output display should include at least some of the following processes:

Oracle writes the data file the process, the output displays as: "ORA_DBW0_ORCL"

Oracle writes the log file process, the output appears as: "ORA_LGWR_ORCL"

Oracle listens for the process of instance state, the output is shown as: "ORA_SMON_ORCL"

Oracle listens for the process state of the client connection process with the output displayed as: "ORA_PMON_ORCL"

Oracle archiving process with output displayed as: "ORA_ARC0_ORCL"

Oracle checkpoint process with output displayed as: "ORA_CKPT_ORCL"

Oracle for [Url=javascript:;] Restore the [/url] process with the output displayed as: "ORA_RECO_ORCL"

2. To view an instance of a database:

Sql> select Instance_name,status,version,database_status from V$instance;

instance_name STATUS VERSION Database_status

----------------        ------------   -----------------    -----------------

PPRD10 OPEN 10.2.0.4.0 ACTIVE

Where "status" indicates the current instance state of Oracle and must be "OPEN" to indicate the status of the Oracle current database and must be "active" database_status.

3. View the log mode of the database, open mode

Sql> select Name,log_mode,open_mode from V$database;

NAME Log_mode Open_mode

---------      ------------          ----------

PPRD10 Noarchivelog READ WRITE

Where "Log_mode" represents the current archiving method for Oracle. "Archivelog" means that the database is running in archive mode and "Noarchivelog" means that the database is running in non-archive mode.

4. To view error messages for ora-in the database alert_sid.log:

$ More/u01/app/oracle/admin/pinnsoft/bdump/alert_pinnsoft.log | Grep-i ora-

Warning:inbound Connection timed out (ORA-3136)

Warning:inbound Connection timed out (ORA-3136)

Ora-12012:error on auto execute of Job 78677

ora-20820:ora-20820:

Ora-06512:at "Ps_system. row_validator_t ", line 912

This article URL address: http://www.bianceng.cn/OS/Linux/201410/45428.htm