Foto Nu Long Dong Silver

Oracle Streams Oracle and SQL Server





Last week I were asked if we could share the supplier master contained in a table on an Oracle db with our warehouse management software that uses a database on SQL Server 2005 platform. A quick Google search led me to

linked servers, or components of Microsoft SQL Server (I used version 2005 Standard Edition) that allow this RDBMS to communicate with heterogeneous data sources such as Oracle or AS400 and even Excel spreadsheets!

The components of a linked server are two: *

OLE DB (a DLL that handles communication with a data source) * OLE DB data source

Looking for a guide that explains how to set up a linked server from SQL Server to Oracle I came across this blog post by Greg Wright
, really clear and well done. Basically, Greg suggests in the first instance to install the Oracle client (Possibly in a version compatible with the Oracle db which must be connected) on the same machine on which you installed SQL Server, and then, using Net Manager or by manually editing the tnsnames.ora file, you must configure a service name that points db Oracle desired. In the post, following the configuration of the linked server, and finally launched an example of a query via SQL Server db on Oracle to which you connect to.

In particular, wanting to run a SELECT db on Oracle via linked server, the syntax is:

select * from OPENQUERY (linked server, 'select * from dbname.tablename where clause') The key to the previous statement is function openquery whose purpose is to return a table with a record set of the query (the second parameter of the function) run on the db (Oracle) to which you connect through linked server (the first parameter of the function).
Wishing You can also perform joins between tables in SQL Server and Oracle tables with a syntax like this: select
tabellaSQLServer.campo1, X.campo2, X.campo3 from tabellaSQLServer
join openquery (nomeLinkedServer, 'select * from AltraTabella where Condition = 1 ') X = on tabellaSQLServer.campoSQLServer X.campoAltraTabella

Well, everything is now continuing with my connection test SQL Server - Oracle!

Kates Plaqyground Vids

L ' ABC


work with Oracle for a couple of years and almost got in a head that big will the DBA, yes! :-D

Like anyone approaching for the first time to a new topic, I immediately searched the documentation that would clarify the various aspects of Oracle.
In my experience, the main sources from which to draw information: *

colleagues (very useful to directly ask those who know more) * books (the old print media is always a good starting point) * Internet

after breaking up a few boxes just not willing connects with all my questions (forgive me) and seeing that the role DBA increasingly fascinated me, I started to browse through literally hundreds of pages in pdf format on many different subjects that revolve around this RDBMS, subscribe to forums, mailing lists, groups on Facebook, etc.. All this has allowed me from time to time, to solve problems of various kinds, for example relating to the installation of Oracle Database Server, or the backup management, or execution of SQL queries to generate reports, and so away, but I always felt that I lacked a more orderly way (from the standpoint of DBA, as always) like this:

BASES FOR ORACLE -> Install DBMS -> DB CREATION -> Backup Manager - -> PERFORMANCE TUNING

Unfortunately, this led me to having to take back many times the same things maybe because I discovered not to have them studied and thorough enough before, or they may discover a document that I should study before losing, in fact, long .

With this post I intend to csotruire a sort of primer (see image at the beginning of post) useful for an orderly approach to Oracle and its documentation.
1) BASIS OF ORACLE: Oracle Database Concepts

Oracle is the official document that explains the foundations of the popular RDBMS

2) INSTALLATION: in this case comes to rescue an entire section Oracle documentation team (version 10.2 of the DBMS). It is not necessary to read all the documents proposed (I have a lot), but simply choose the suitable one according to its platform hw (32/64 bit) and SW (Microsoft Windows, FNU / Linux, Solaris, etc.)

3) CREATING DB: the essential guide to reference (and even more technical), is known
Administrator's Guide


4) MANAGEMENT BACKUP: You can find the section (Backup and Recovery) in the homepage of the Documentation for Oracle Database
Server 10.2 through the tab "Administration"

5) PERFORMANCE TUNING: topic
the "Performance Tuning Guide"
on how to configure and monitor the performance of Oracle Database Server


points made above are, in my view, the wealth of knowledge that should be right of the figure and from which the DBA before interested in other aspects of this complex and powerful RDBMS.
Happy reading!

How Do You Wear Sleeveless Sweater Vests?

DBA Oracle Critical Patch Update January 2009



Tuesday, January 13 was a full day rather than in terms of patch simultaneously with the release of security bulletin MS09-001
Microsoft on the Windows SMB protocol and Critical
Patch Update released by Oracle for this first quarter of 2009.
take advantage of this double issue to create a parallel between my own personal activities of the system and the database administrator with regard to the installation of the patches (I have no certificates for any of the two roles, but in fact is what I'm involved to work):

1) both must be able to document any patch updates even before they are issued, in order to gather information on the vulnerabilities covered by the patches, set up a test on which to test it before going into production, the operation schedule update and experience, as a result, users of any downtime of the services offered by the servers affected by the update. In this sense, a good starting point it provides the network. The administrator of Microsoft Windows will not wait for the automatic notification of Windows Update, but will use sites like Feliciano Intini Blog
, for example, in the same way, the Oracle DBA can refer to
OTN (Oracle Technology Network )
.
short, the imperative is
ALWAYS BE ADVISED!

2) the output of a new patch, both the sysadmin and the DBA should consider the impact that the application of the patch itself will have on their servers can test it, if time permits, on a

"sandbox" , ie a test environment. The testing phase is vital to ensure that the update is successful and does not create problems, once installed, the configuration of server / DBMS
3) after a necessary and crucial phase of testing, the application the patch must be done also in the production (which should take place when users are not connected and should not cause problems, if enough testing has been carried out as described in step 2) The purpose of this post First of all, is to acquire the skills necessary to install the CPU January 2009 (1), while the phase installation of the patch update in a test environment (step 2) will be the topic of a post I will publish soon!
Ok first of all need to read up on so I head
section dedicated to the OTN Critical Patch Update
, my goal is to answer some questions: *
what vulnerabilities are resolved by the January 2009 CPU?
* in which products (and version) Oracle can apply? * should install it or are there any contraindications? * as you install it? Link on CPU on OTN contains lots of useful information, for example, we learn that the update patches are issued on a quarterly basis, In fact, the upcoming release dates are: April 14, 2009 *

* * July 14, 2009 October 13, 2009 * January 12, 2010
addition, OTN provides two useful links to resources that indicate respectively how to enable the notification
email
the CPU as soon as they are released and a PDF document with
"Best Practices"
to install the patch updates.
In particular, the OTN
page dedicated to the CPU
January 2009 contains a list setting out for comfort even in the picture below, with all the versions of Oracle software and interested in the application of the patch:



Assuming, as in my case, it will apply the patch to the component of Oracle Database Server 10g, you can see from the above table, for example, as the version 10.2.0.1 of the DBMS is not supported (some more information it can
read from this thread on the forum
OTN), as well as Oracle Database Server versions prior to 9.2.0.8, and so on.
you read on the same page on OTN, it was discovered that the patch updates are cumulative for many Oracle products (not all though), that is, each CPU includes all previous fixes of the CPU. Fortunately, this case applies to Oracle Database Server and then just install the patch to update for January 2009 also fixes the previous patch updates!
Still the same page of OTN contains a table, reproduced below, with the list of products affected by the January 2009 CPU, the links to the risk matrices (tables that set out a list of vulnerabilities and their description for each family of commodities for which Oracle recommends that you install the patch), links to Metalink, etc..







It follows, then, include a table taken from the Metalink note 753340.1 on the CPU in January 2009, as supplied, the summary notes, also on Metalink, to access documentation and download the CPU JAN 2009 for various platforms and versions of Oracle Database Server:

For this time all the material there is plenty to digest. In the next post will deal installing CPU Jan 2009 on my test system, ie a virtual machine Debian GNU / Linux installed with Oracle Database version 10.2.0.4, all VMware ESXi!

Help For Dexedrine Side Effects

Extend the functionality that Blogger




Yesterday I found myself with some free time so I took the opportunity to study the potential of Blogger, the platform made available by Google to quickly and easily create a blog, just like this. Blogger allows, once set up the skeleton of your blog (via GUI css ready for use, gadgets for inclusion in the side panel to enrich your pages, etc.), to further extend the functionality through the inclusion of widgets created by third parties, provided compatible with the platform itself. Definitely cool to do some testing!

First I tried a few online resources covering the topic well and I ended up Creareblog . The howto presented by Tenebrae, the author of the blog, there are indeed numerous and well made and I recommend you read if you're interested in this!
Changes to my blog are both aesthetic and functional:

- removed the top bar added to the default platform blogspot blog (do not incur any legal dispute by doing so, then why not?)
- Blogger does not by default, to publish only an introduction to the homepage Articles are too long and while posting entirely in separate page (accessible by the user clicking on a link type "Read more" ). Now you can! :-D Very comfortable!

- To differentiate the lines of code from the rest of the text, while composing the post using the pre tag

and

tt. So I changed the css by adding the following lines: / * Code style * /
.
code {font-family: courier new;
font-size: 85%;}
blockquote.code {background: Gainsboro;
border: 1px solid LightSlateGray;
padding: 5px 5px ;
white-space: pre;}


The result you can see above.
- I added a tag cloud
the side panel. Certainly less comfortable than traditional well-ordered list of tags, is also likely to be seasick, but I like me ;-) - I also added a search engine that uses Google as the basis for the articles the blog (including this component is accessible from the sidebar). It was practically forced addition, since removing the top bar of Blogger (see point 1), I found myself without a search engine with which post in my blog.

Although the focus of this blog is more to a kind of notebook where exactly everyday experiences, trial and error combined by me and others, as long as it rotates around the world of Oracle, the mere fact that someone can read what I write is for me a source of satisfaction. As some readers will not give me more obnoxious, in fact, comments and any collaboration proposals are always welcome, I thought of putting into practice the tips of

Creareblog
for the positioning of my blog in the major search engines, starting from the same Google that is most commonly used at the global level and then passing to

Microsoft Live Search and Yahoo

.

addition to indexing of my blog on the main search engines, I have also
article Creablog of publishing the sitemap for a site on Google, Live Search, or Yahoo
.
What's a Sitemap? I quote from above post:

[cut]

The sitemap is a document that contains information about the post and the hierarchical structure of a blog. It 's very similar to the feed and in the case of feed ATOM formats match. The Sitemap of your blog can be sent to a search engine so that they are properly indexed pages.

Google Webmaster Tools is the best known tool for the reporting of your sitemap and in general for information and statistics on its website in terms of search engine. Contrary to popular belief, tell them your sitemap to Google does not imply a better ranking in search results, at best allows it to be our blog for a more coherent approach to issues it contains. Report on our website also does not accelerate the process of indexing the pages. This is what is explicitly stated by Google, and that there is actually the field.
[/ cut] Google Webmaster Tools allows you to have significant statistics for your site / blog provided directly from Google.