Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Connection to istance Oracle 8.1.6.2

SOLVED
Go to solution
Donato Sciannameo
Occasional Contributor

Connection to istance Oracle 8.1.6.2

Ciao,
it's possible read the connection to Oracle DB istance 4 days old?
Today, I want check the connection to db in 13 Juin: it' possible?
Thanks a lot,
Donato
4 REPLIES
Yogeeraj_1
Honored Contributor

Re: Connection to istance Oracle 8.1.6.2

hi,

Yes. You can have a look at your

$ORACLE_HOME/network/log/listener.log

Hope this helps!

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Christian Gebhardt
Honored Contributor

Re: Connection to istance Oracle 8.1.6.2

Hi

Maybe your listener-log is at another place:

- Login as owner of the oracle-installation
- lsnrctl status
(listener_name mostly is LISTENER or you can get it from listener.ora file)

--> you get the name of the logfile

Chris

twang
Honored Contributor

Re: Connection to istance Oracle 8.1.6.2

As Christian mentioned, you can use lsnrctl to find out the logfile location:
oracle@svr_a$ lsnrctl status prod

LSNRCTL for HPUX: Version 8.1.7.4.0 - Production on 16-JUN-2003 22:04:09

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=prod))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for HPUX: Version 8.1.7.4.0 - Production
Start Date 11-JUN-2003 13:30:32
Uptime 5 days 8 hr. 33 min. 39 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oraapp/oracle/product/817/network/admin/listener.ora
Listener Log File /oraapp/oracle/product/817/network/admin/prod.log
Services Summary...
extproc has 1 service handler(s)
prod has 1 service handler(s)
prod has 1 service handler(s)
The command completed successfully

then, you can search the logfile for the connection history, for instance:
30-MAY-2003 17:54:14 * (CONNECT_DATA=(SID=prod)(CID=(PROGRAM=)(HOST=svr_a)(USER=
ora))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49289)) * establish * prod
* 0
30-MAY-2003 17:54:14 * (CONNECT_DATA=(SID=prod)(CID=(PROGRAM=)(HOST=svr_a)(USER=
ora))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49290)) * establish * prod
* 0
Massimo Bianchi
Honored Contributor
Solution

Re: Connection to istance Oracle 8.1.6.2

Hi Donato,
usually , as staed above, you can check connections from the listener.log

But if you want a deeper knoledge, you can turn on auditing. This will require a bounce of the instance.

For privileged users, this is turned on by default. You can check the connections from $ORACLE_HOME/rdbms/audit.

HTH,
Massimo