How to clear Oracle Alert Log and Trace files using ADRCI command?

Sometime you will face the problem about large alert log and trace files in Oracle database. You can use ADRCI tool to manage them.

Run adrci command

[oracle@dboraclel1 dboraclel1]$ adrci

ADRCI: Release 12.2.0.1.0 - Production on Tue Aug 21 00:20:25 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/oracle"
adrci> show home
ADR Homes:
diag/rdbms/schooldb/schooldb
diag/tnslsnr/dboraclel1/listener
diag/tnslsnr/dboraclel1/listener6
diag/tnslsnr/dboraclel1/listener2
diag/tnslsnr/dboraclel1/listener3
diag/tnslsnr/dboraclel1/listener4
diag/tnslsnr/dboraclel1/listener5
diag/diagtool/user_oracle/adrci_3644429138_107
adrci>

Set home directory to work. If you have only one home folder skip this step.
```
set homepath diag/tnslsnr/dboraclel1/listener
```
Run this command to purge alert log.
```
PURGE -age 1440 -type ALERT
```
This command will be purge alert log older than 1440 minutes. Parameter age is in minute. You can change for your own.
Run this command to purge trace files.
```
PURGE -age 1440 -type TRACE
```
This command will be purge trace files older than 1440 minutes. Parameter age is in minute. You can change for your own.

Comments

Serialize and Deserialize JSON data with C#

This post is about example for serialize and deserialize json data with C#. This example using Newtonsoft.Json to be a library to work with json data. You can add Newtonsoft.Json by download from https://www.newtonsoft.com/json or using Nuget to add it into your project. In this example is Bill object that hold billing data about Car object. Serialize Object to String Below is example code to serialize object to json string. At line 39 is code to convert object into json string with beautiful json format. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Diagnostics; using System.Linq; using System.Text; namespace JSON { class JSonExample { static void Main( string [] args) { List<Car> cars = new List<Car>(); float to...

Make a scheduling job in Spring Boot

You can make a class to run as a schedule job in Spring Boot. By using @EnableSchedule in your project. Below is example code to enable schedule in Spring Boot. Declare Spring Boot application to support schedule By declare @EnableSchedule at the main class (see at line 10). This enables detection of @ Scheduled annotations on any Spring-managed bean in the container. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 package com.myexample; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.context.annotation.Bean; import org.springframework.scheduling.annotation.EnableScheduling; import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor; @SpringBootApplication @EnableScheduling public class MyExampleApplication { public static void main(String[] args) { SpringApplication.run(MyExampleApplication.class, args); } } Declare schedule configuration at...

Install Spring Boot application as a Windows services.

I using WinSW to be wrapper for Spring Boot application to run as a Windows service (following section 61.3 of Spring Boot document). There few easy step to setup. Download WinSW binary distribution from website https://github.com/kohsuke/winsw/releases Copy WinSW.exe into Spring Boot application folder (ex: my file is WinSW.Net4.exe) Rename your WinSW.exe to same as your jar file (for easy to remember). Create XML file name same as jar file. This file is using for configuration of Windows services. Put configuration for services wrapper in your xml file. 1 2 3 4 5 6 7 8 9 <?xml version="1.0" encoding="UTF-8"?> <service> <id>my-application-0.0.1</id> <name>my-application-0.0.1</name> <description>My Exaple Spring Boot Services</description> <executable>java</executable> <arguments>-jar -Xmx1024M -Xms128M "my-application-0.0.1.jar"</arguments> <logmode>rotate...

DEV Fixxer

Search This Blog