Please help with Berkeley DB, desperate student here - Berkeley DB High Availability (Replication)

I am a student and I have to complete a project within a week. Problem is, I never used Berkeley DB. What I am supposed to do is this...
Basically, in the Berkeley DB, I need to implement a replication scheme for distributed real-time databases.
The replication scheme simply allows a database which needs temporal data from another database to create a local replica of the data needed from the other database, and to receive the data in constant updates for a specified period of time. This scheme is beneficial because it eliminates the transmission delays from asking for the data every time it needs it from the remote datavabase. The recipient database will not need to keep sending a request for the data, it will automatically be sent to the replica in specified time increments, and for a specified period of time depending on what the transaction specifies.
The DB must support transactions. This is ideally meant for real time databases too.
Could you please tell me who could help me implement this? I really need help with this as soon as possible. I don't know where to get started regarding installing the correct DB, starting it up, and putting in sample data. I need a accurate step by step instruction for which DB to install, how to install it, and how to install sample data and how to access the data, and then how to proceed to modify it so that it can support the replication I mentioned above. Everything. I am new to this. ANyone's help would be the best. Thank you. 

Hi for starters you should take a look at the
Berkeley DB Getting Started Guide for Replication:
http://www.oracle.com/technology/documentation/berkeley-db/db/gsg_db_rep/C/index.html
You most likely would want to start with the Replication Manager and go through the sample code.
Please note that you will be doing the work here, if you get blocked in some way you are welcome to post questions. I mention that respectfully because of your very short timeframe and expectations.
Regards,
Ron 

Ron, thanks for your reply. Problem is I don't know where to start. Basically, I need to know what to download. HOw to install it. How to get it running and if there is a sample database out there I can run it on. I am basically clueless at this point and don't know where to start. I've never used Berkeley DB before. A step by step would be most helpful, and at the point where I get everything installed and running with workable data, I can really get going on what I need to do. Please let me know if you can help me in this regard. Thank you. 

Respectfully,
If you don't know where to start with respect to installing and getting started withBerkeley DB, you are not ready to use Replication or ask for help. I am sorry but I feel like helping you here would take a tremendous amount of time that I and others simply do not have.
Please refrain from posting the same question multiple times. Everyone can see all of the messages so this is not productive.
Thank You
Ron 

You have said you don't know where to start.
Ron has told you where to start. I'll tell you again: read the document he pointed you to.
Here it is again:
http://www.oracle.com/technology/documentation/berkeley-db/db/gsg_db_rep/C/index.html
Once you've read that, you may want to refer back to the section called "For More Information".
Alan Bram
Oracle 

Ok Ron. I understand where you are coming from. I made my situation sound hopeless by implying that I am not capable of installing the product. That is not the case. I just wanted to make sure I installed the correct version.
I just installed version 4.5.20. At this point I would just like someone to help get me started. I have the command prompt up. I just need to know how to implement the scenario I am working on. Can you tell me how I can do this Ron? Once I get the boost and direction I need, I can proceed. Do you think you can help me out with this? 

Alan, thanks for chiming in. I am in the process of reading the link you posted. Thank you. At this point, after having installed Berkeley DB 4.5.20, are there some preliminary steps that you can outline for me in terms of setting up a sample database and getting started? Is there a step-by-step somewhere on the site? After I do that, and then study the link you sent, it is my intent to dive into the code and make the adjustments/additions I need to model the algorithm I need to accomplish.
Disregard my time constraint which I mentioned earlier. I simply need to get everything running as a workable DB with data at this point, and then I can dive into the replication material. Let me know, and thanks for your help.
Ron, sorry for the multiple posts. I was initially trying to post in categories which I believed were relevant to my situation. I will stick to this thread. 

if anybody who can help would like to email me direct, please do so at....
guitar at twcny dot rr dot com
thanks for your help 

if anybody who can help would like to email me direct, please do so at....What more specific things can we help with?
Berkeley DB 4.5.20 is the appropriate version to be using.
This page is a good central location, with links to all relevant documentation, including guides to building Berkeley DB on different platforms: http://www.oracle.com/technology/documentation/berkeley-db/db/index.html
You should read the Getting Started Guides, and look at the sample applications distributed with the release. Once you have specific questions let us know and we will do our best to answer.
Regards,
Alex 

Alex, after reviewing the replication algorithm that I must add to berkeley DB, do you know which C++ file(s) in the replication folders I need to modify? 

Could someone tell me what "Active Configuration" I am to select for building the files under Visual C++? Under "Build" and "Set Active Configuration" I am supposed to select "build all ????" Do I select Win32 release? Win32 Debug? etc, etc. There are a few other choices. I am running on a Pentium 4, which is a 64 bit chip, so I selected x64 Release IA64, but that did not work. Any suggestions? 

Follow the documentation here:
Building Berkeley DB for 64-bit Windows
http://www.oracle.com/technology/documentation/berkeley-db/db/ref/build_win/intro.html
Ron
Oracle, Ron Cohen 

Ron, using the selections for a 64 bit processor does not work, so I selected Win32 release and "Build All" (F7 key in Visual C++ 6.0) and it is compiling smoothly as I speak here. 

Ron, after building the files, and successfully compiling them, I would like to know if there is a step by step somewhere that tells me how to set up some sample databases and carry out operations on them. Is there something like this? 

Hi again,
I would recommend the following course of action in this order:
Go through (entirely) the Getting Started Guide for Berkeley DB:
http://www.oracle.com/technology/documentation/berkeley-db/db/gsg/CXX/index.html
Go through (entirely) the Getting Started Guide Transaction Processing
http://www.oracle.com/technology/documentation/berkeley-db/db/gsg_txn/CXX/index.html
Finally, now that you know a bit about Berkeley DB and building transactional applications you are perhaps ready to read about (HA) Replication.
http://www.oracle.com/technology/documentation/berkeley-db/db/gsg_db_rep/CXX/index.html
So read them in that order. Make sure you go through the sample applications discussed in the manual and also the C++ examples found in your distribution.
Ron

Related

Bl solutions by apex

hi
plz tell me what kind of bl solutions we can make.i have read that we can also make bl application.plz tell me if possible then with example.
thanks in anticipation
nomi 
Nomi - get yourself a free APEX account at Oracle and install one or all of the sample apps. That way you'll quickly see what can be acheived.
Phil 
hi
i have my account but donot know from where to install the sample applications
i have only one sample in my account
thanks
regards 
Nomi,
What is a BI Solution at all? I have created many applications and see no problem for apex
to be used for any kind of them.
Denes Kubicek 
Sir
i dnot know much about them..i need information about apex ..how far apex can go..and in the forum i have read we can develop business logic applications also..i donot know what kind of application these are..hope u can help me out
thanks
Best Regards 
Nomi,
Please try to understand what everyone is telling you...
1. Business Intelligence is a general term which can mean anything, just as accounting is a general term which means different things to different people.
2. Apex is a tool used for development of applications. You have to understand WHAT you want to develop and then figure out how to use Apex to build it. By itself Apex can't solve your application problem. You have to do that.
3. The tool is only as good as the person using it. So you have to understand how to use the tool in order to achieve the best results. Install any of the sample applications and study how Apex works and how to adapt it to your uses.
4. There is little you can't do with Apex since it has the power of the Oracle database behind it.
5. The forum can help you solve your programming problems and help educate you about the tool, it can't do your analysis and design for you. If you need application templates other than those which have already been developed in Apex I suggest you go to sourceforge.net and download and install any of the free applications specific to your needs to give you a start on YOUR design.
Keep Smiling,
Bob R 
Bob,
1. Business Intelligence is a general term which can mean anything, just as accounting is a general term which means different things to different people. I agree 100%, I've lost count of the number of terms I've heard people say things like 'Can APEX do BI" or "Can APEX do ERP", these are catch-all definitions that mean little by themselves. As always the devil is in the details.
By itself Apex can't solve your application problem. You have to do that.Again, agree 100%, you have obviously had the same discussions I've had with people ;)
3. The tool is only as good as the person using it.Absolutely 100% agree, this cannot be over-stated, having the worlds best development tool is no use if you don't take the time to learn how to use it, conversely the best programmer in the world can be 'ham-strung' by using a tool that doesn't let them do their job/task.
4. There is little you can't do with Apex since it has the power of the Oracle database behind it.One of my favorite phrases ;)
5. The forum can help you solve your programming problems and help educate you about the tool, it can't do your analysis and design for you.Absolutely 100% agree again...
Some great points, very well made ;) 
Hi Nomi,
you said that you dont know from where to install the sample aplications.
Well, try this link http://apex.oracle.com/i/index.html
If you want sample aplications just click on the Packaged Applications.
Then download them and install.
hope it helps,
Mzz 
hi brother
thanks for the link
Regards 
Sir
bundle of thanks..it very much clear now..about what is Bl..thanks you so much
Very Best Regards 
Hi brother ;-)
I just had to reply to this thread as I'll included it in my weekly APEX Forum wrap-up (in the funny part). We get a lot of these questions... and the answer is simple APEX runs in the database, if you can do it in the Oracle database, you can probably do it in APEX.
Offtopic; "Nomi2007", while reading this thread I wondered where you come from.
Thanks,
Dimitri
-- APEX Forum wrap-up --
# http://dgielis.blogspot.com 
Hello Sir
i am from uk..studying and doing my thesis now ...i have to develop application in apex.and generate a report including all aspects of apex..with the help of u and other i have come to know very much about it.now i have started my development for the application..i have installed 10g in my system running xp pro sp1..i got a msg....
.Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system. See the Installation Guide for more details on installing the software on systems configured with DHCP.
can u plz tell what should i do now..although all installation completed successfully.
now i want to install apex3..i have downloaded it..when i opened i couldnot find any file to install ..is there any different way to install apex in 10g db..
looking forward to you
Regards 
This forum is not really designed to spoon feed every technical question people have, rather it is a tool where you fall back on once you've "read the manual". I'm sure that many of us would like to see your thesis but before you can start it you'll have to put some effort yourself into getting up to speed on the fundamentals such as setting up and understanding Oracle & systems development. 
Nomi,
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.As the error message tells you, the problem is that your machine has a dynamic IP address (assigned via DHCP), Oracle usually requires the machine to have a static IP address, I say 'usually' because it is possible to use a dynamic address however it will really make your life easier to make your machine have a static address.
This is well documented in the (very comprehensive) installation document for Oracle. I appreciate that it can be daunting to read all of the documentation available for Oracle (there is a HUGE amount of it), however you should really read the install documents before trying to install software as complex/feature rich as Oracle. 
Hi Nomi,
You definitely should install the Microsoft LoopBack Adapter.
I would also suggest to patch your database to the latest version.
How big is the zip (of APEX 3) you downloaded? Do you use winzip to unpack it?
Dimitri

Patch Updates on Oracle database

Hi Friends,
I have a application which uses Oracle 8i. I would like to know,
Will there be any impact for my application, if i apply the patch updates ?
I Wanted a technical answer to my query. If it affects, how it affects? If not, why?
Please give me the explanation in a way that even a person without having proper background can understand it properly.
Some of the Information can be available in the following links.
Some information of the vulnerabilities can be found in the following URL.
Oracle Critical Patch Update April 2006:
http://www.oracle.com/technology/deploy/security/pdf/cpuapr2006.html
http://www.oracle.com/technology/deploy/security/pdf/cpuapr2006.html#Appendix%20A
・Security Focus 17590:
http://www.securityfocus.com/bid/17590
・red database security
http://www.red-database-security.com/advisory/oracle_cpu_apr_2006.html
I would highly appreciate receiving your comment.
Thanks & Best Regards,
Rajesh P 
Nobody atleast on this planet can tell you how a particular patch is going to effect your application. That need some thorough testing, the best way is to apply the patch on some development box first and run you application against that box for some good amount of time and monitor it properly. If everything looks fine then go ahead cross your fingers and apply it on production.
Daljit Singh 
If you know where the information is, are you suggesting we do some reading for you? Come on...
Anyhow, I would go patching only if I was facing any problem that is fixed by that patch.
Good luck.
RK 
The Only information, i have is available in these links. And I don't know how i can proceed furthur only with these links. Could you suggest me the best way to get a good answer for my question. I want to get the answer without testing. I mean, i wann a technical answer. Most of the links shows, oracle fixing the security vulnaribilities and some links related to SQL Injection. But I did'nt get, how these are going to affect a application which uses the oracle database. I was initially trying to prove that, Since the SQL is used for accessing the Oracle database, and hence the patch updates does'nt affect, but i was asked the question that most of the patch updates are with the SQL, then how come it does'nt affect. I want to provide a solid proof for my problem. Please help me in this regard.
Thanks and Best Regards,
Rajesh P 
Hi Daljit Singh,
Think that i don't have any option to test this, applying patch.I require a technical answer to my concern.
Thanks and Best regards,
Rajesh P 
Hi Friends,
Any furthur comments from anybody ???? I want to get a reply as early as possible.
Thanks in Advance,
Rajesh P 
I want to get the answer without testing.Dream on.
Think that i don't have any option to test thisWhy not? I can't imagine applying a patch directly to a production system without doing so in a test instance first.
Most patches include documentation indicating what they are fixing, but there is no document telling you how it will affect your application.
Daljit said it best, install the patch on a test system and test the heck out of it. Whatever you find out there will ultimately be better than any static document. 
Hi Friends,
Atleast is it possible for me to know what are the SQL commands affected due to this patch updates? If So how and why it affects? Anyone can give explanation for this?
Thanks in Advance,
Rajesh P 
Dear,
Are you expecting to receive a positive answer like "Yes... Go ahead" ?
It would be insane and unfair from anybody giving you such advice.
I remember one situation where I was asked to migrate one instance 8.0.5 IBM/AIX to 8.0.6 SUN/SOLARIS without test. After many argumentation I washed my hands and did the migration.
Most of migration went well, but some processes that were run on weekly basis suffered from performance problems in the worst time. There were lots of complaints and quarrel until developers discovered some SQL HINTS that affected negatively the system performance. Those hints used to be fine on the other version. I won't mention the bussiness impact because this migration.
IMHO, I think patching can have several unpredictable results. That's why testing is required.
You might be lucky and surprised having no problems. But on the other hand it might cost your employment.
I could see on this thread that is unanimous the opinion that YOU MUST TEST IT .
Anything else is up to you.
You as a DBA or whatever you are as a technician, must have the skills to show/explain to whoever the pros and cons of this procedure.
I will state it again... Go patching only if you're facing problems solved by that patch. This should be enough to convince somebody that you need patch, the patch solve your problems and make sure it won't cause new ones.
As a last resort try logging a SR on metalink. Probably the will say you to test.
Rember!!!! YMMV.
Regards.
RK
Message was edited by:
RKravcenko

server question

Hi there
How is client parameterisation used to incrementally deploy an upgraded server? 
Maybe if you have switches/parameters/property files/partial license keys which enable or disable a servers functionality.
I wouldn't consider it as upgrading though, more of an incremental implementation.
regards,
Owen 
What academic institution are you actually at, qwwerty ?
D. 
Yeah, actually sounds like management speak.
I think the Dilbert web site allows you to string a whole load of management keywords/jargon together to create a company mission statement. 
Can somone help me out here
Please? 
I did give you a genuine answer already.
The question you posted was more like an "essay type" question in an exam than a simple question with a simple answer.
But to explain my previous answer more fully...
To incrementally upgrade a server, you might deploy a system which has the bugged / non-functioning modules turned off / disabled. Eg. menues greyed out. As I mentioned above, this might be done by property file switches, or licenses which only enable parts of the system.
You might "upgrade" the system by installing patches then enabling the working bits. So, you incrementally upgrade/implement parts of the system.
regards,
Owen

MySQL to Oracle Data Pulling

Hi ,
I don't know whether it's the proper section or not. Admins please move in case it's not.
As per my project requirement we need to pull data every day from a thirdparty mysql database to our oracle database.
So in case anyone is aware could you please suggest whats the best away to do it? 
Mr Lonely wrote:
Hi ,
I don't know whether it's the proper section or not. Admins please move in case it's not.
As per my project requirement we need to pull data every day from a thirdparty mysql database to our oracle database.
So in case anyone is aware could you please suggest whats the best away to do it?quantify "best"
PERL can interoperate against both DB from same program;
so you could SELECT from MYSQL & INSERT into Oracle. 
can it be done through shell?
Is there anyway we can use something like db_link? 
Mr Lonely wrote:
can it be done through shell?yes, not lots of work & not efficient
>
Is there anyway we can use something like db_link?yes, create hetrogenous DB link to MYSQL via Transparent Gateway or what ever it is called today. 
can you please provide some links/ tutorial for "hetrogenous DB link to MYSQL via Transparent Gateway or what ever it is called today."?
I am completely unaware of this 
Mr Lonely wrote:
can you please provide some links/ tutorial for "hetrogenous DB link to MYSQL via Transparent Gateway or what ever it is called today."?
I am completely unaware of thisI am sorry to see that GOOGLE is broken for you.
Please be patient while repairs are completed.
Additional information will be posted when it becomes available. 
good to see people spending so much time to comment sarcastic.
Anyway I already googled and found some info. Seems like it's a job of Oracle DBA. I will contact my DBA team. Thank you. 
Mr Lonely wrote:
good to see people spending so much time to comment sarcastic.
Anyway I already googled and found some info. Seems like it's a job of Oracle DBA. I will contact my DBA team. Thank you.I am glad to see that GOOGLE got repaired & works again for you. 
Mr Lonely wrote:
good to see people spending so much time to comment sarcastic. Commenting on the obvious is a better description I think. Often one only need a scrap of information (keyword or two) to point you in the right direction for arriving at a solution. And in the "+knowledge age+" (as I've heard this decade being called), using Google is an important tool.
Anyway I already googled and found some info. Seems like it's a job of Oracle DBA. I will contact my DBA team. Simplistically:
a) install ODBC manager on Oracle server
b) install mySQL ODBC driver
c) test connectivity to mySQL database (create DSN and use isql)
d) configure an heterogeneous connection for Oracle using this DSN
e) create database link using this connection
Steps detailed in forum {forum:id=61} a couple of times I'm aware of. 
Thank you.

running doris Name:Howard Rogers Handle:howardjr

hi,
i am running (DORIS) version 0.9a script to install oracle in my linux machine.. i somehow do not remember how do i supply os and database versions....i can't acess the installation notes...IF U KNOW DORIS U KNOW WHY..so any body who knows or may be the person whose name on the top may himself tell me..( it will be better if u can send me the installation notes..)
i will be thankful.. 
Howard's material is copyright protected and I imagine he would take a pretty dim view of anyone freely distributing it without his permission (which you won't get). You can use anything you have obtained from his site for your own use but you can't spread it around. I myself have many documents that I have printed from his site over the past few years and out of deference to Howard would not think of making them publicly available.
You might try emailing him.
Tom 
i don't have his e-mail ..also i just need the instructions.i already have the script file 
A little bit of digging on the Internet should turn up his email address. I'm not going to put it out here -- not without Howard's permission. The same thing I said earlier about copyrights applies to the instructions as well as the script itself.
Not having used the DORIS script I can't say for certain but it shouldn't be too difficult to determine how to supply the information it needs. Howard does not obfuscate things as a general rule. His writings tend more towards pointing you in the right direction and leading you to the desired outcome rather than holding your hand each step of the way. He expects a level of competence.
Tom 
Howard has been offline for a while and I don't think he is willing to cooperate with any thing related to the forum. I could be wrong of course about it, but so far he has technically quit.
If you are looking for installation guides, please specify which oracle product you are willing to install. There are several very good install guides that could be helpful.
~ Madrid
http://hrivera99.blogspot.com/

Categories

Resources