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

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...

CURL SSL error in WAMP

I facing problem about certificate error when I using curl to request HTTPS domain. I find cause of problem is there is no certificate configuration in PHP. Below is how to solve my problem. Here is sample of error: * About to connect() to notify-api.line.me port 443 (#0) * Trying {IP Address}... * connected * Connected to notify-api.line.me ({IP Address}) port 443 (#0) * SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed * Closing connection #0 Step to solve this problem Download Certificate Bundle Extract and put PEM file to your web server folder or other folder. Enable mod_ssl in Apache and php_openssl.dll in php.ini Add configuration into php.ini curl.cainfo="C:/wamp/cacert.pem" openssl.cafile="C:/wamp/cacert.pem" Restart Apache Service

Bootstrap 4.1.3

Hot on the heels of v4.1.2, we’re shipping another patch release to address an issue with our browserslist config, fix some CSS bugs, make JavaScript plugins UMD ready, and improve form control rendering. Up next will be v4.2, our second minor release where we add some new features. But first, here are the highlights for v4.1.3. Pay attention to the change to .form-control s which adds a new fixed height . Fixed: Moved the browserslist config from our package.json to a separate file to avoid unintended inherited browser settings across npm projects. Fixed: Removed the :not(:root) selector from our svg Reboot styles, resolving an issue that caused all inline SVGs ignore vertical-align styles via single class due to higher specificity. Fixed: Buttons in custom file inputs are once again clickable when focused. Improved: Bootstrap’s plugins can now be imported separately in any contexts because they...

DEV Fixxer

Search This Blog