Oracle Uses TNS Listener for handling the client connections and then Oracle DB service to handle the DB files
Oracle TNS Listener Log file location can be found from below:
[root@ProdDB01 ~]# lsnrctl status
LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 20-MAR-2014 10:48:58
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.21.201.217)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 8.1.6.0.0 – Production
Start Date 20-MAR-2014 10:45:55
Uptime 0 days 0 hr. 3 min. 3 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /opt/oracle/product/8.1.6/network/admin/listener.ora
Listener Log File /opt/oracle/product/8.1.6/network/log/listener.log
Services Summary…
PLSExtProc has 1 service handler(s)
inst1 has 1 service handler(s)
inst3 has 1 service handler(s)
The command completed successfully
[root@ProdDB01 ~]#
Oracle DB log file location can be found from below:
[root@ProdDB01 ~]# su – oracle
-bash-3.1$ sqlplus ‘/ as sysdba’
SQL*Plus: Release 8.1.6.0.0 – Production on Thu Mar 20 12:44:12 2014
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production
With the Partitioning option
JServer Release 8.1.6.0.0 – Production
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production
With the Partitioning option
JServer Release 8.1.6.0.0 – Production
-bash-3.1$
-bash-3.1$ sqlplus ‘/ as sysdba’
SQL*Plus: Release 8.1.6.0.0 – Production on Thu Mar 20 12:45:02 2014
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production
With the Partitioning option
JServer Release 8.1.6.0.0 – Production
SQL> select value from v$parameter where name = ‘background_dump_dest’;
VALUE
——————————————————————————–
/opt/db1/inst3/bdump
SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production
With the Partitioning option
JServer Release 8.1.6.0.0 – Production
-bash-3.1$
