I recently got a new PC at work which is Windows 7 64 bit.
We run lots of crystal reports(1000's) that pull data from an oracle back end.
I have installed the Oracle Client 32 bit on this machine and have no problem connecting to the database and pulling back data.
However, when I use crystal to access the TNS Name it gives me the following error.
[URL]
My path variable on the PC has "C:oracleproduct10.2.0client_1BIN;".
I also tried to create and ODBC using the 32bit ODBC on the machine and that connects fine, but when you try to access the DSN from Crystal, I still get the 12154 error.
"How to Migrate Oracle 11gR2 32bit to 11gR2 64bit on Microsoft Windows"
Currently we are having Microsoft Windows Server 2003 standard Edition service pack 2 and we are trying to migrate it to microsoft windows server 2008 Release 2 standard Edition
I am using DataBase Express 11g as a development site.I have developed a Delphi GUI to run with it. (32bit). All runs as expected!My associate has a Windows 7 (64bit) machine. Express installation does not supply an ODBC driver. DataBase Express installs without problem, but it is the connectivity that is the problem
I understand that 11g(full) supplies both 32 & 64 OBDC drivers.I do not want to install the full 11g database if it can be avoided.
This is going to be more of a problem the more 64bit machines get into the workplace.Is there an alternative connection method available?
I have taken export from ORACLE 11g R1 64-bit software and now when I am trying to import it on ORACLE 11g R1 32-bit version, I am not able to do so. Is it possible to import from export file take from 64-bit to 32-bit version?
We are planning upgrade three 32-bit 9i databases (on three physical machines) to a single 64-bit 11g VMware box. Average size of DB is 300GB.Planning to move the first 9i DB by the end of this month, followed by 2 and 3.How to do this using hot backup?
Just wanted to know if 11XE (R2,32bit) will install and work correctly on Windows Server 2008 R2 x64?
I would like to install either the Oracle 11g Client and/or ODP.NET(x86 and x64) on the same machine, would this work? I cannot find any documentation regarding this and so far I am having some issues. At this point in time I have 11XE and ODP.Net (both x86) on this x64 machine under separate Oracle_homes and I cannot connect to the XE database from either SQLPlus client installed with the respective Oracle_Home..
Can I use a 32bit client to connect to a 64bit server?
(1) Move my 10gR2 database from 32-bit Linux to 11gR2 64-Bit Linux (using an RMAN backup from 10gR2 restored on the 64-bit machine) then
(2) Bring up the database on 64-bit hardware and then upgrade to 11.2.0.3 (64-Bit) [Without installing the 10.2.0.3 64-Bit software]
Haven't tried restoring to 11.2.0.3 from a RMAN 10.2.0.3 backup. I was trying not to have to install the Oracle 10.2.0.3 software for 64-bit on the 64-bit machine. Was hoping to go directly to 11.2.0.3 (64-bit).
I am developing an 64bit And-In software. My OS is windows7 64bit Ultimate. Developer tool is Microsoft Visual Studio 2010 Ultimate 64bit any-CUP.Server is SUN server and Oracle database 10.2.0.5 64bit enterprise edition.I have installed instantclient-odbc-win64-10.2.0.5 on my computer.I am able to connect through the command line sqlplus user/pass@server.In date source(c:windowssystem32odbcad32.exe), ODBC Driver connection successful.But in VS2010 C#, use Tools -> Connect Database,I get an error 193 (Oracle in instantclient10_2,c:ora10_64SQORA32.dll) cann't be loaded.SQORA32.dll is 32bit ODBC Driver or 64bit ODBC Driver?How can I connect database with vs2010 64bit?
One of my developer creating views in his own schema,we are able to see that views from sqlplusw. But we are unable view them from crystal report tool(CRW32) ,Except this schema all are visible...
where can i find it ? I dont even see a link for oracle 10g client download on otn .i have a 32bit 10g oracle client that i am currently using on win7 64 bit OS but i need 64bit oracle 10g client.
When executing a SELECT with JOIN in oracle error as I am having the title. If I change the JOIN to where the procedure works normally. When installing my application, it works normally for a day or two, then it only shows the end of communication error. What I do is select the following:
I decided to work on Oracle.I downloaded Oracle 10g for windows 32bit to run on XP. But i can not finish installation.
Here is what i've done so far.
1. I installed Microsoft Loopback Adapter and configured it with 192.168.1.10 for IP and 255.255.255.0 for NetMask. 2. I ran setup. The installation holds on a while on "Loading Sun JDK extensions" step. 3. The installation can not execute "Checking network configuration requirements" on the "product-specific prerequisite checks" step.
I've been trying to install it for a few days but i could not go one step further.
P.S: I could not URL. Here are the images. (remove the blanks on addressline.[URL]....
I have an 11g installation on a school harddrive that doesn't seem to have any of the environment variables set properly. Even ORACLE_HOME is not set. How can I fix that situation and how many environment variables need to be defined?
Also some of the Oracle scripts seem to use the forward-slash rather than the back-slash for paths. Will Win7 care?
We are going to upgrade our Oracle client on our clients to 11.2.0.3. But I can not record a resopnsfile with setup.exe. Have Oracle removed this feature?
Here's a dump from setup.exe
There is no possibility to run setup.exe witch -record -destinationfile option:
Preparing to launch Oracle Universal Installer from C:UsersTestAppDataLocal TempOraInstall2013-01-14_02-12-48PM. Please wait ... Usage: setup [-options] [(<CommandLineVariable=Value>)*]
Where options include:
-clusterware oracle.crs,<crs version>
Version of Cluster ready services installed.
-crsLocation <Path>
Used only for cluster installs, specifies the path to the crs home locat ion. Specifying this overrides CRS information obtained from central inventory.
-invPtrLoc <full path of oraInst.loc>
Unix only. To point to a different inventory location. The orainst.loc f ile contains: inventory_loc=<location of central inventory> inst_group=<>
-jreLoc <location>
Path where Java Runtime Environment is installed. OUI cannot be run with out it.
-logLevel <level>
To filter log messages that have a lesser priority level than <level>. V alid options are: severe, warning, info, config, fine, finer, finest, basic, gen eral, detailed, trace. The use of basic, general, detailed, trace is deprecated.
-paramFile <location of file>
Specify location of oraparam.ini file to be used by OUI.
-responseFile <Path>
Specifies the response file and path to use.
-attachHome
For attaching homes to the OUI inventory.
-cfs
Indicates that the Oracle home specified is on cluster file system (shared). This is mandatory when '-local' is specified so that Oracle Universal Installer can register the home appropriately into the inventory.
[code]....
Session/Installer variables are specified using:
[session:]varName=value Ex 1: session:ORACLE_HOME_NAME="OraHome" Ex 2: ORACLE_HOME_NAME="OraHome" The lookup order is session:varName then just varName. The session prefix is used to avoid ambiguity.
Component variables are specified using:
[compInternalName:[Version:]]varName Ex 1: oracle.comp1:1.0.1:varName="VarValue" Ex 2: oracle.comp1:varName="VarValue" The lookup order is compInternalName:Version:varName, then compInternalName: varName, then just varName.
Recently i have installed oracle 10g.2 in my laptop under Win-7 64bit. But cannot connect oracle from Windows form [C#], Office application[Excel] and odbc. Showing error[Tns could not resolve the connect identifier specified Drivers SQLSetconnectAttr failed ]
Though I can connect oracle from toad and sqlplus and form 6i.
i installed windows-7 64bit and i try to run my program(that work's with Oracle 11g) i get this error:
Attempt to load Oracle client libraries threw BadImageFormatException this problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed
and from where i can download 64 bit oracle client ?
Most of the ones I'm seeing online relate to the database, not the client. I have linux.x64_11gR2_client.zip and and trying to do runInstaller and I get up to perform prerequisite tests and it tells me that I am missing packages and that kernel parameters are wrong. I've tried to run the runfixup.sh file and get a lot of this:
./orarun.sh: 186: [: true: unexpected operator./orarun.sh: 848: [: unexpected operator./orarun.sh: 864: [: unexpected operator./orarun.sh: 882: [: unexpected operator./orarun.sh: 903: [: unexpected operator./orarun.sh: 1052: [: unexpected operator./orarun.sh: 1057: [: unexpected operator./orarun.sh: 1075: [: unexpected operator./orarun.sh: 1085: [: unexpected operator./orarun.sh: 1115: [: unexpected operator./orarun.sh: 1143: [: unexpected operator./orarun.sh: 1189: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 139: [: unexpected operator./orarun.sh: 1228: [: unexpected operator./orarun.sh: 1284: [: unexpected operator./orarun.sh: 1342: [: unexpected operator./orarun.sh: 1426: [: unexpected operator./orarun.sh: 1451: [: unexpected operator And many of the supposedly missing packages actually are installed. IE: make. I have make 3.81 installed but the installer insists upon make 3.80.
I downloaded Oracle Fusion Middleware11g Forms and Reports (ofm_frmrpts_win_11.1.2.0.0_64_disk1_1of1). When I begin to extract I am getting bogged down with a password message and that is:
File Windows-amd64 is password protected. please enter the password in the box below.
BTW- I downloaded Windows64 based forms and reports on my windows xp pro machine. I am trying to unzip them and burn it on a DVD so that I can install them on my new dell windows 7 professional laptop.
i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."