- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 8.1.7 in HP-UX B.11.0.0 : trace login a...
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
тАО12-02-2009 01:43 AM
тАО12-02-2009 01:43 AM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 02:55 AM
тАО12-02-2009 02:55 AM
Re: Oracle 8.1.7 in HP-UX B.11.0.0 : trace login and logout
very old version for oracle and HPUX 11 !
Anyway,as I understand you want to capture login and logout information.
For this you need to create triggers on the database :
- After logon trigger
- Before logoff trigger
There are manyb threads on oracle forums for this.
examples :
http://www.dba-oracle.com/art_builder_sec_audit.htm
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:49818662859946
http://www.databasejournal.com/features/oracle/article.php/3299231/The-Trigger-Happy-DBA---System-Triggers.htm
http://forums.oracle.com/forums/thread.jspa?threadID=920051
You will need to decide on what information you want to record for the table design. All depends on your specific rquirements.
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 04:32 AM
тАО12-02-2009 04:32 AM
Re: Oracle 8.1.7 in HP-UX B.11.0.0 : trace login and logout
I shouldn't want to fit these events on DB tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 05:15 AM
тАО12-02-2009 05:15 AM
Re: Oracle 8.1.7 in HP-UX B.11.0.0 : trace login and logout
May be you could detail what you try to achieve exactly ?
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 05:52 AM
тАО12-02-2009 05:52 AM
Re: Oracle 8.1.7 in HP-UX B.11.0.0 : trace login and logout
You said:
"the listener will only have the information for connection over SQLNet not local connection".
It's Truth, but how I can also trace Oracle access from local connections ( e.g. by console) . Can you suggest me what files I have to set please ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 06:12 AM
тАО12-02-2009 06:12 AM
Re: Oracle 8.1.7 in HP-UX B.11.0.0 : trace login and logout
No disrespect intended, but just because you happen to know that the listener log file mostly provides what you desire, does NOT make it the right place to focus on.
The is an ORACLE, platform independent question.
Listen (read) carefully to what Jean-Luc offered up. Follow those links and google some more, using the terms learned.
That will lead to the right solution for you.
It may not be the solution you wanted to hear, but it will be the right one, so give Jean-Luc 10 points the next time you get that opportunity!
Cheers,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 12:43 PM
тАО12-02-2009 12:43 PM
SolutionI suppose you can also use the AUDIT command inn the datbase. the logging can either be recording in the database or OS file.
SQL> connect / as sysdba
Connected.
SQL> AUDIT SESSION;
Audit succeeded.
you will have to set up an init.ora parameter :audit_trail
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams016.htm
for more :
http://www.camden.rutgers.edu/HELP/Documentation/Oracle/server.815/a67781/c27audit.htm
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 11:08 PM
тАО12-02-2009 11:08 PM