Information to be collected and the commands for the Oracle 11g database for BMU

1

Database alarm log file

$ cd ${ORACLE_BASE}/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace

Log in to the database server as the oracle user, run this command to go to the directory for storing log files, and find the alert_$ORACLE_SID.log file.

2

Database tracing file

$ cd ${ORACLE_BASE}/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace

Log in to the database server as the oracle user, run this command to go to the directory for  storing log files, and find the .TRC file.

3

Initialization parameter file

SQL>create pfile='/opt/oracle/init.ora' from spfile;

Log in to the database server as the oracle user, run this command to go to the directory for  storing log files, and find the .TRC file.

4

Current process information

$ cd ${ORACLE_HOME}/network/admin/

Log in to the database server as the oracle user, run this command to go to the directory for  storing process information, and find the listener.ora and tnsnames.ora files.

5

Database version

$ sqlplus /nolog

Run this command as the oracle user and record version information.

6

Database status information

$ sqlplus / as sysdba

> select * from v$instance;

Run this command as the oracle user.

7

Database listener information

$ lsnrctl status

Run this command as the oracle user.

8

Tablespace status information

> select tablespace_name, status from dba_tablespaces;

Run this command as the oracle user.

9

Free tablespace information

> select tablespace_name, bytes from dba_free_space;

Run this command as the oracle user.

10

Memory usage of the database server

# top>file2.txt

Run this command as the root user, wait for 5 seconds, press Ctrl+C to stop, and submit the result to Huawei maintenance engineers.

11

Service data

$ exp system/password@sdp buffer=8092 full=y inctype=complete file=backup.dmp

Export data from the database and back up the data.

• Run this command as the oracle user.

• password: specifies the login password of the system user. Set this parameter based on the site requirements.

• sdp: specifies the database instance name. Set this parameter based on the site requirements.