- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Connection to istance Oracle 8.1.6.2
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-16-2003 04:42 AM
тАО06-16-2003 04:42 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-16-2003 05:00 AM
тАО06-16-2003 05:00 AM
Re: Connection to istance Oracle 8.1.6.2
Yes. You can have a look at your
$ORACLE_HOME/network/log/listener.log
Hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-16-2003 05:13 AM
тАО06-16-2003 05:13 AM
Re: Connection to istance Oracle 8.1.6.2
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-16-2003 06:10 AM
тАО06-16-2003 06:10 AM
Re: Connection to istance Oracle 8.1.6.2
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-17-2003 10:57 PM
тАО06-17-2003 10:57 PM
Solutionusually , 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