Oracle Audit-related issues (dual-machine software Roseha)

Database issues with the authentication server

1. Environment construction
The remotely connected server is Windows 10.10.10.40 that needs to be installed Xmangager
Roseha 9.0 is a graphical management interface, Linux-enabled graphical interface
Dual-Machine ip:10.10.10.9
10.10.10.10
Drift ip:10.10.10.11
2. Open Xbrowser 5
New XDMCP session, enter IP 10.10.10.9 default port, connection successful
3. Log in as root, open terminal, enter HCC to open Roseha Control Center graphical interface
After logging in, bring out, exit the dual machine
4. Generally, two simple commands to check
Two commands that are often required to detect:
--Display current disk space and usage in an easier-to-read manner
Df–h
----is to delete the larger useless files-----------large files occupy a large amount of disk capacity
--View normal, no abnormal usage situation
--Display disk usage in Inode mode
Df–i
----To delete too many small files-----------too many files occupy a large number of inode numbers
--Found an exception, one unexpectedly occupies 100%, after analysis to see that the directory is too many files caused
/u01/app/oracle/admin/radius/adump/
----Online inquiry is caused by an audit, need to turn off the audit
5. Process
SSH Login 10.10.10.9
--Delete files under this folder for more than 10 hours
rm–rf/u01/app/oracle/admin/radius/adump/
mkdir/u01/app/oracle/admin/radius/adump/
chmod 777/u01/app/oracle/admin/radius/adump/
--Mounting equipment
Mount/dev/mapper/mpathbp1/oradata
Su–oracle
Sqlplus "/as sysdba"
sql>startup;
Sql> alter system set AUDIT_TRAIL=FALSE Scope=spfile;
Sql>shutdown immediate;
sql>startup;
--After startup, view Adump's files
Sql>shutdown immediate;
sql>quit;
Umount/oradata Uninstall

SSH Login 10.99.100.10
--Fewer files for this server are removed from this folder
rm–rf/u01/app/oracle/admin/radius/adump/
mkdir/u01/app/oracle/admin/radius/adump/
chmod 777/u01/app/oracle/admin/radius/adump/
--Mounting equipment
Mount/dev/mapper/mpathbp1/oradata
Su–oracle
Sqlplus "/as sysdba"
sql>startup;
Sql> alter system set AUDIT_TRAIL=FALSE Scope=spfile;
Sql>shutdown immediate;
sql>startup;
--After you start, view the files in the Adump
6. Before processing, the database restarts for a while, adump file crazy long, open this file is slow to kill
7. Start the dual-computer software, switch the test, after a period of observation, no problem found

Oracle Audit-related issues (dual-machine software Roseha)