Home » RDBMS Server » Server Administration » Meaning of Audit_trail (Oracle 11.2.0.1.0,SunOS)
Meaning of Audit_trail [message #552351] Wed, 25 April 2012 03:43 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

In my database ,audit is set to OS.I checked the meaning of it in document and found the below one.

audit_trail string
OS
os- Auditing is enabled, with all audit records directed to the operating system's audit trail.

Can somebody explain the meaning of above sentence ?

Thank you

Report message to a moderator

Re: Meaning of Audit_trail [message #552352 is a reply to message #552351] Wed, 25 April 2012 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your sysadmin where the OS audit trail is.

Regards
Michel

Report message to a moderator

Re: Meaning of Audit_trail [message #552499 is a reply to message #552352] Thu, 26 April 2012 05:42 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Quote:
Ask your sysadmin where the OS audit trail is.


Can you tell me why should i ask such question to sysadmin?

Thank you

Report message to a moderator

Re: Meaning of Audit_trail [message #552501 is a reply to message #552499] Thu, 26 April 2012 05:43 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
Because they should know the answer obviously.

Report message to a moderator

Re: Meaning of Audit_trail [message #552679 is a reply to message #552501] Fri, 27 April 2012 05:02 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
This forum is not providing sufficient answers to me nowadays.

Report message to a moderator

Re: Meaning of Audit_trail [message #552680 is a reply to message #552679] Fri, 27 April 2012 05:07 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
The OS audit trail is a file on the OS.
The servers administrator should know which file it is.

Report message to a moderator

Re: Meaning of Audit_trail [message #552736 is a reply to message #552680] Fri, 27 April 2012 11:57 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Cookie,

Thanks for your answers.

Quote:
The OS audit trail is a file on the OS.

Does this file has the information about database or only OS ?

Regards

Report message to a moderator

Re: Meaning of Audit_trail [message #552737 is a reply to message #552736] Fri, 27 April 2012 12:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Does this file has the information about database or only OS ?

yes

inspect the contents & you see the answer

Report message to a moderator

Re: Meaning of Audit_trail [message #552738 is a reply to message #552736] Fri, 27 April 2012 12:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It contains all information that anyone records in it, OS, databases or anyone else.
Just have a look at the Windows event log on your PC.

Regards
Michel

Report message to a moderator

Re: Meaning of Audit_trail [message #552769 is a reply to message #552738] Sat, 28 April 2012 01:30 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you Michel/Swan

Quote:
Just have a look at the Windows event log on your PC.

The OS we use is Sun solaris and not Windows or PC.

Quote:
The OS audit trail is a file on the OS.
The servers administrator should know which file it is.

Is that not possible to find out audit trail file name and the path (where it is in OS) from database ?

With Regards,

Report message to a moderator

Re: Meaning of Audit_trail [message #552772 is a reply to message #552769] Sat, 28 April 2012 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
The OS we use is Sun solaris and not Windows or PC


What I meant is that on your PC you have an event log/audit and you can see it to see what is inside. It is just an example to make you learn, you don't need any server for this; OS audit log is something generic not specific to your environment or to Oracle.

Quote:
Is that not possible to find out audit trail file name and the path (where it is in OS) from database ?


No.

Regards
Michel

Report message to a moderator

Re: Meaning of Audit_trail [message #552773 is a reply to message #552772] Sat, 28 April 2012 02:47 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Michel,
Quote:
What I meant is that on your PC you have an event log/audit and you can see it to see what is inside


Can you tell me how to find out the path on windows PC?

Regards

Report message to a moderator

Re: Meaning of Audit_trail [message #552774 is a reply to message #552773] Sat, 28 April 2012 04:19 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your version but it is something like Configuration Panel -> Administrative Tools -> Event Log

Regards
Michel

Report message to a moderator

Previous Topic: Index tablespace isnot growing
Next Topic: Upgrade 10.2.0.5 to 11.2.0.3
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 12:34:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.