OracleRDA4.20 initial experience

The full name of RDA, RemoteDiagnosticAgent, is a tool used by Oracle to collect and analyze databases. However, the statistical information is far greater than that of the database. It can also be said that it is the OracleDBSERVER information that must be mastered by an Oracledba role, including database installation, configuration, performance, backup, and other information, operating system parameters, network, and even other product information such as timesten, ibmwebsphere, and Workspace

RDA full name RemoteDiagnostic Agent is a tool used by Oracle to collect and analyze databases. However, the statistical information is far greater than that of databases, it can also be said that the information of an Oracle db server that an Oracle dba role needs to master, including database installation, configuration, performance, backup, and other information, operating system parameters, network, in addition, other product information such as timesten, ibm websphere, Workspaces, WebLogic Server, WebCenter, rac, EBS, and Oracle SSO can be collected ....

Generally, the official Oracle technical support is used to understand the basis required by the user's database information. For example, if a bug occurs, you can link the database error information to the compressed package generated by RDA and discard it to Oracle, in addition, we can also use our own inspection, but many people choose awr and write many scripts by themselves. The information collected by RDA includes the basic information of ADDM, AWR, and ASH.

To install RDA, you only need to download the compressed package from the Internet and decompress it. It is written in perl. the Linux directory contains two main files: rda. pl, rda. sh, functions are the same. If there is no perl environment, of course rda. sh is the first choice. Many supported platforms include Unix, Linux, and Windows.

Oracle database collection and analysis tool RDA (RemoteDiagnostic Agent) See http://www.linuxidc.com/Linux/2011-09/42743.htm

The following describes my experience.

Environment Red Hat 5 el

My Installation File is zipcompressed, And the Linux version in the format of .tar .tar.gz should not be decompressed in Windows before being passed to Linux. It will damage the original file and pass the file directly to Linux in binary mode.

Unzip decompress the package to generate a directory named rda. the directory contains instructions. Read the details in readme_unix.txt. You are advised to read them carefully.

Ensure rda. sh or rda. pl has the execution permission. We recommend that you install Oracle under the database user. If su is under root, do not include '-' Because Oracle environment configuration is required.

At the beginning of initialization, You need to configure the initialization parameters, prompting that there are a lot of interactions and patience. Take the default value and press Enter.

./Rda. sh-S

The setup. cfg configuration file is generated in the current directory. You can check the report directory = return. All the files generated later are in this directory.

The following information is generated.

./Rda. sh

Open the notebook and check it.