Posted on 2010-01-27 filed under: Oracle 26 views
As a DBA, you sure have a lot of software, scripts and applications to help you complete the daily operations, some of which may be written in your own, while others may be to provide a great deal of help to you the characteristics of very large business solutions program.
However, there are tools created by the community to meet the requirements, fortunately, around the database (in particular, Oracle) of the open source community, in the past few years, indeed explosive growth in the OTN page on the Oracle has a special detail of their involved in all projects, and many community projects, and, in the SourceForge search returned 52 results, a clear reference to Oracle's had more than 500 projects.
There are too many to sift through, so we will use two articles for everyone to show some of the more major projects.
Library and language interface
If you are engaged in software development, and language and development platform in the selection stage, the first thing you need to know what type of database interface support, fortunately, there are too many choices.
DBD:: Oracle (http://search.cpan.org/dist/DBD-Oracle/)
If you're writing perl scripts to do monitoring program or by using mod_perl to do web development, there is no more than dbd:: Oracle, for Oracle's DBI-driven, more appropriate, and he provides all the important features and let you out of the complexity of the OCI , connection, parsing, implementation and extract the contents of your heart.
mod_perl (http://perl.apache.org/)
When you're working on perl, you will clearly want to get this Apache module, more than your code as a CGI to run better, mod_perl into Apache so perl parser memory space, speed up the implementation, the cache code and to provide persistence.
Apache:: OWA (http://sourceforge.net/projects/owa/)
For pl / sql developers with mod_perl in parallel to become a great Apache module, Apache is no wonder that the middle layer into the fusion? This is a hint.
cx_Oracle (http://www.python.net/crew/atuining/cx_Oracle/)
If you prefer to use python programming, you can also find here the right.
If you plan to use c + + developing an application, there are a number of packaged libraries to provide you with a good OCI functions, you choose from the following one.
tinyOcci (http://sourceforge.net/projects/tinyocci)
ORA + + OCI Library (http://mywebpages.comcast.net/jimcainadmin/orapp/)
OCIPlus (http://ociplus.sourceforge.net/)
oci-wrappers (http://sourceforge.net/projects/oci-wrappers)
Oracle in recent years, increasing attention on the php, even in the OTN on the php specially opened a development center: http://www.oracle.com/technology/tech/php/index.html, so php against Oracle provided substantial support.
OCIPHPSess (http://sourceforge.net/projects/ociphpsess/)
The Oracle database to help you to build scalable php code for you to share the session by providing a function realization.
Tracking + Analysis Tool
etprof (http://sourceforge.net/projects/etprof)
10046 is an extension of Oracle tracking program, for diagnosis and follow-precision positioning of the session very useful, etprof can be used for scanning and formatting the output files described to allow for better readability.
Orate (http://orate.gnuadvantage.com/)
This library provides the added log messages to your pl / sql code-compatible way in order to facilitate the code behind to track, and you add in the c code is very similar to printf in your code can be added in the right place "to enter X process" the news in order to facilitate later face the problem for debugging.
Hotsos Oracle Instrumentation Library (http://sourceforge.net/projects/hotsos-ilo/)
Hotsos are often used to track the data locate and isolate bottlenecks in the database and use them with a pioneering approach to install this library to the target database to define, measure and use SQL trace data.
Tools
GTKO (http://gsqlr2.sourceforge.net/)
A considerable number of tools for development, but I just want to say something worth observing tools, the tool including the implementation plan, syntax highlighting, statement, tracking and browser programs. It is based on GTK, so in most Linux distributions can be used on, and it is also more frequent updates, so it is still in the development of active.
SchemaDiff (http://sourceforge.net/projects/schemadiff/)
As a consultant, I have visited many Web sites, and reviewed the many applications have been procedures, and based database programs, often useful to repeat the program different from the landing, no one can determine the beginning is to create what are used, You have to be careful, in a production system, Do not interrupt any of the services in operation, this SchemaDiff tool in its place, its view the two Oracle database program and to tell you about the columns, data types are different, indeed is a convenient tool, so no recent update, it is not well supported 10g, for those who need to purchase must be careful, you need to review, test and make appropriate modifications.
Around the database (in particular, Oracle) of the open source community, in the past few years, indeed explosive growth, this article relates to the Oracle management, security, benchmarking and monitoring open source tools for discussion.
Manager
JoraStat (http://sourceforge.net/projects/jorastat/)
This tool can help you predict the database need to change, if you are in your database, drawing a trend chart, you can step ahead of their good planning, the use of java as a front end, using stored procedures to integrate it into the database, in the the items on the sourceforge page or activity, so you can be very formal way to view their revised and updated content, it is still in beta stage.
EasyStandby for Oracle (http://sourceforge.net/projects/shana)
Database Journal last month, I wrote an article on Oracle Standard Edition, on hand to create a standby database of articles, under normal circumstances the need Oracle Enterprise Edition, which includes the DataGuard, it is a complete solution for Oracle standby, but the price factors also need to consider, Enterprise Edition per processor, the price is 10 times the standard version, although it can not get support from Oracle, adequate testing, but this tool has been proven to be useful to your knitting and helpful, and check code, in your sandbox development environment to test a few months, if it meets your needs, then you're in luck.
Jdul / dude (http://sourceforge.net/projects/jdul/)
Anyone who might have been loading data into Oracle database, the person may need to uninstall the data, or dump into a stream file, this tool will definitely meet your needs, make your work easier, although Oracle does not provide specifically for the sql * loader to provide a tool for data loading, but it is not too difficult, Tom Kyte in the Ask Tom Web site provides a wealth of solutions (http://asktom.oracle.com/tkyte/flat/index.html).
Oracle Database Dashboard (http://odd.deskweb.nl/)
This tool is also a surveillance system, but it is prepared specifically for Oracle, you can monitor the query and a session, check the system parameters and so on, it is quite simple, as an open-source tool, you can customize to your heart.
Noguska Oracle to MySQL Data Converter (http://sourceforge.net/projects/nog-omdc/)
This is an amazing tool for you, people often move data between databases, from MySQL to Oracle or from Oracle to MySQL, this tool to help you complete the transfer of tasks, create a corresponding MySQL tables, columns, and Oracle table with the same data type, and then entered into the database using the php script certification rates.
Easy Data Extract (http://sourceforge.net/projects/easydataextract/)
This tool I will be regarded as experimental areas, a little background: Oracle data files for the operating system is the rules, for example, if you use a hex editor to open them, you will see the data bits, a number of the table with you Similar data scattered around in the file, but the format of these documents are proprietary, and was precise to protect, such as the header format, block, etc. are not made public, but for an experienced reverse engineers can get It is clear that the details of precisely because of these reasons, I would like to caution in a production environment to use this tool to be cautious, in addition to Oracle data file format changes in different versions of the direct addition to the regular, if not a small release, all the principles of will not support the positive side is used to extract data, so you do not write these data files or else they will be more dangerous, but in spite of your extracted data is still in the format have changed.
LobShooter - (http://oraload.sourceforge.net/)
In Oracle, if you have a large object, such as the library files, images, or very large text, and you want to store them in a database, you use the LOB or large object data types, BLOB is binary data, CLOB is a character data, They are different, so you can search the text, while the binary data can not easily search, the tool to fill this gap, making it easier for you data into or out of the Oracle database.
Oracle-Admin - (http://sourceforge.net/projects/oracleadmin/)
If you ever want to withdraw from the command line, using a web-based tool to manage your Oracle databases, OEM you may be considering, it comes from Oracle, to support very well, and has all the features you want, but it is very bulky, consume a lot of system resources, Oracle-Admin is a community-based development tools, but also provides a web interface, you can add to it, write some code and submit it, perhaps in the future it becomes part of the project of the .
Security Tools
Oracle password storage (http://sourceforge.net/projects/opr)
This tool allows you to save your password in a location not in your backup and other management scripts, you can prevent you from passing them on the command line, but kept in one place will help when you need to change them easier.
Oracle Password Checker (http://www.red-database-security.com/software/checkpwd.html)
Code-breaking patents is not a hacker, they should become an important tool library for each administrator one, this tool can run on many platforms.
Oracle Audit Tools (http://www.cqure.net/wp/?page_id=2)
It is a java-based tool in linux and windows client, provide a password guessing, query tool, listener check and more.
Pete Finnigan's website (http://www.petefinnigan.com/tools.htm)
Want to connect more about Oracle security information, I strongly recommend you to take a look at pete's website, here including more tools such as code-breaking devices, file systems and operating scanners, listener configuration testing, etc., while Here also provides a frequently updated business solutions.
Benchmark
Hammerora (http://hammerora.sourceforge.net/index.html)
Most of the names of Oracle database tools are boring, not exciting, but the name of this tool is absolutely let you eyes bright, if you want to do in your database, load testing, this tool provides a large number of election Xiang, TPC-C and TPC-H test, multi-user tests, web load test.
Simora (http://www.scaleabilities.co.uk/content/view/27/60/)
Oaktable network, one of founding members James Morle has brought us a tool, from the tracking data for your database application to create simulated benchmark tests.
Monitoring Tools
incanto (http://incanto.sourceforge.net/)
Apache ANT is a java-based creation tools such as Make it replaced and its descendants, incanto to access Oracle tools such as sqlplus and import / export tool provides ANT tasks.
Ad Oracle Manager - (http://sourceforge.net/projects/oraman/)
Active Directory AD is as famous for another tool, Active Directory is Microsoft LDAP, or Lightweight Directory Access Protocol shameless re-naming, this tool allows you to use Active Directory management of the household to use your database, tables, views.
Summary
Hope that the Oracle-related trip to the open source application lets you open the appetite, at sourceforge there are incredible number of tools and activities of the project to provide support for Oracle, I would encourage everyone to sourceforge. net search tool for your own interest, but also please take heed of Oracle-L mailing list, there is a lot of code snippets, as well as SQL solution, although they are not yet a project, community-based and community-driven technology is indeed open-source the essence.
| Original Address http://blog.sina.com.cn/s/blog_525394060100ffgd.html |
| Published on: 2010-01-27, modified on: 2010-01-27 11:13 has been here 8 times, there have been comments 0 recommend Complaints |
| | |
| | |