Trying to install an application that is using Oracle database. Platform is Win 2008 Server (64bit) running as a domain controller. Downloaded and installed Oracle 11g (64 bit) and I'm able to connect to the database from a command prompt (sqlplus) as well as from a web browser.
After installing the application, the application will not start. It says "Unable to connect to database server". The application developer has checked into this and found that the oci.dll file in the system is 64 bit and that his application can only handle 32 bit.
Two questions come out of this:
1. Will it work ok to download Oracle 32 bit and install on the 64-bit platform?
2. Is there a way to get this to work on the 64 bit Oracle install (developer mentioned something about a 32-bit client....)
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…