Operating System - HP-UX
1748056 Members
4955 Online
108758 Solutions
New Discussion юеВ

Re: 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 4
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