Oracle Database Listener.log Analize

Hello, We are creating a new listener log file from listener.log file. ErmanTESTDB:/oracle/grid/diag/tnslsnr/ErmanTESTDB/listener/trace#cp listener.log a_listener.log   1. create a new directory for listener.log file. create directory erman_log_dir as ‘/oracle/grid/diag/tnslsnr/alioth/listener/trace’; 2. create a new table for listener.log file create table erman_log ( log_date date, connect_string varchar2(300), protocol_info varchar2(300), action varchar2(15), service_name varchar2(15), return_code number(10) ) organization […]

Oracle Database Listener.log File Location

Hello, I am just getting my feet wet with 11gR1. When I executed lsnrctl status, I get the following: Connect to terminal with Oracle user than run this command: {ermanTestDB:oracle}/home/oracle/>lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 08-JAN-2018 10:59:28 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of […]