Skip to Main Content

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.

Comments

asifkabirdba
Go ahead with your plan.


Regards
Asif Kabir
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.
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
orawiss
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.
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..
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
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.

Post Details

Locked on Oct 30 2001
Added on Oct 2 2001
0 comments
178 views