Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

LDAP and transaction support

19643Oct 2 2001

Hi all,

In our system, when we create a new user account, the userName
and password are stored in ldap server, but the user profile is
stored in a separate database. Is it possible to put those two
operations in the same transaction context? I.e.: if we can't
store the profile, then ldap would rollback the entry contains
user name and password.

We are using Oracle Internet Directory version 2.0.1.

Thanks.

asifkabirdba

Go ahead with your plan.

Regards
Asif Kabir

1 person found this helpful

CKPT

user645399 wrote:
Hi everyone!

I noticed that in all the oracle databases, the trace files are piling and alert log is growing like anything ....

Thought of making a copy of the trace files somewhere and remove them from the hard disk excluding the most recent ones.

For alert log, thought of making a copy and renaming the current file so that Oracle can create a new one.

Any advice if there are better approaches in handling this?

Thanks in advance.

better if you keep 1 week older of alert /trace files, Older than those you can remove.
If you rename/delete current alert log file, oracle will create a new one.

1 person found this helpful

user645399

Hi asifkabirdba,

Thanks for your reply.

Should I automate this with some script or checking myself once in a blue moon and clearing them off will do?

Any suggestion?

CKPT

check this

http://dbarajabaskar.blogspot.com/2008/12/remove-old-trace-file-in-oracle-using.html

asifkabirdba

You can automate this with the scripts also check that your scripts are working.

Regards
Asif Kabir

1 person found this helpful

orawiss

I would include the alert log file in my backup strategy as it includes many important information; database parameter values,when and how the database was shut down, the important database errors and when they occur , etc ... I usually backup the alert log file once a month and keep 1 year of alert log file copies..

1 person found this helpful

user645399

Dear CKPT,

Thanks for your reply.

Should I automate this process or its needed only once a year?

Whats your view on this?

Thanks!

user645399

Orawiss,

You mean we should include it to our regular backup just like control file?

But isn't its a little too big to include the alert log into regular backups?

Thanks!

user645399

CKPT,

Thanks for the link. But, I am working on Windows platform. Any such methods to automate it in Windows?

I am also searching for such stuffs in Google.

Thanks!

orawiss

user645399 wrote:
Orawiss,

You mean we should include it to our regular backup just like control file?

But isn't its a little too big to include the alert log into regular backups?

Thanks!

:)
Regular does not mean every day :) You can do it once a month or once 2 weeks or so. Up to you!
Thanks

1 person found this helpful

CKPT

user645399 wrote:
CKPT,

Thanks for the link. But, I am working on Windows platform. Any such methods to automate it in Windows?

I am also searching for such stuffs in Google.

Thanks!

check this

http://www.dba-oracle.com/t_windows_oracle_dos_script_trace_file_days.htm

user645399

Thanks a lot!

I am unable to open the link but finding my way to learn dos commands to get this working!

Thank You to everyone!

If any of you have any script that can remove the trace files based on certain dates, then pls send me the link.

Thank You!

CKPT

user645399 wrote:
Thanks a lot!

I am unable to open the link but finding my way to learn dos commands to get this working!

Thank You to everyone!

If any of you have any script that can remove the trace files based on certain dates, then pls send me the link.

Thank You!

Here is script of that link

dir c:\oracle\product\10.2.0\admin\orcl\bdump

forfiles /p c:\oracle\product\10.2.0\admin\orcl\bdump /m *.trc /d -30 -c "cmd /c del/q @FILE"

dir c:\oracle\product\10.2.0\admin\orcl\bdump

exit

user645399

or what about zipping old files? any way to automate this using winzip or some other utility or even using windows?

Appreciate if someone has some suggestion?

Thanksssssssssssssss

oradba

Unfortunately you hide your database version (but I guess it's lower than 11gRx, otherwise by default 'bdump' wouldn't longer exist). But one day you will upgrade to 11g and then you will have a new trace-/logfile concept - the ADR (Automatic Diagnostic Repository). Then you should leave manual scripts and use ADRCLI:

http://gavinsoorma.com/2010/09/purging-trace-and-dump-files-with-11g-adrci/

That works for both - Unix/Linux and Windows.

Werner

user645399

Hi oradba,

I am using Oracle 10.2.0.4

Thanks for the info on 11g.

Will go through that.

Appreciate that help.

Thanks a lot.

CKPT

Answer

user645399 wrote:
or what about zipping old files? any way to automate this using winzip or some other utility or even using windows?

Appreciate if someone has some suggestion?

Thanksssssssssssssss

Well, I can say it is out of question of ORACLE, You can get lot of stuff by googling. ;-)
to zip or anything you have to automate scripts by creating any *.bat* files. you have some third party tools where you can schedule all those.
example:-
pkzip -ex txtfiles.zip *.txt

Marked as Answer by user645399 · Sep 27 2020

user645399

Thanks to everyone.

Ya, I just zipped and stored them separately.

Thanks a lot.

1 - 18

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2001

Added on Oct 2 2001

#identity-management, #identity-manager

0 comments

179 views

Security Software

LDAP and transaction support

Comments

Post Details