Oracle 9 Is Incompatible With Version Or Windows
Nov 9, 2010
I am trying to install Oracle 9i 32bit client on a windows 2008 server 64 bit OS. In the installation once I select the Oracle home directory and click on Next the whole pc just hangs. Nothing happens. When I checked the Application log I see an error with the following information.
the application (Oracle 9, from vendor Oracle) has the following problem. Oracle 9 is incompatible with this version or windows. For more information, contact Oracle.
View 13 Replies
ADVERTISEMENT
Sep 3, 2012
import from dump (.dmp) file. I'm running Oracle database 11g Enterprise edition release 11.1.0.6.0.
the import statement I'm using is
impdp system/password@orcl full=Y DIRECTORY=data_pump_dir dumpfile=mydmpfile.dmp logfile=min.log
and the error I'm getting is "incompatible versionnumber 3.1 in the dumpfile mydmpfile.dmp"
The dump file was exported using oracle 11.2.0.2.0. I tried to download/unzip the client version of instantclient 11.2.0.2 and add it to the PATH variable in windows and then re-run the script, but it didn't work.
How I should go from here to import this dump file without reinstalling the whole database?
View 3 Replies
View Related
Jul 1, 2011
I have installed oracle 10g version 10.2.0.4.0 on Windows 7 64 bit from the following link.
[URL].........
After login to SQL* plus, when i see the version, it shows as 10.2.0.3.0. Is this correct?
View 8 Replies
View Related
Aug 22, 2011
Which version of 32 bit oracle client should I install on 10204_vista_w2k8_x64_production_db and Windows Server 2008 R2 x64 operating system?
10203_vista_w2k8_x86_production_client - This version does not work (no pre-requisite checks found in oraparam.ini)
View 15 Replies
View Related
May 10, 2012
I have Windows 7 (System Type - 64-bit OPerating System & ACPI X64 PC Type) and want to install Oracle Database.
The compatible version with the above operating system and send me the direct link for downloading.
View 17 Replies
View Related
Mar 14, 2012
Is there a way to check which versions or oracle installed on the machine from command line?
The thing is I don't want to login to the database so I can't use SQL Plus also, till now I ran tnsping and checked the output but in case there are several versions of different platform I got only one version that was first on the path env.
View 1 Replies
View Related
Dec 14, 2011
i need Oracle Developer Suite 9i version for windows xp and windows 7.
tell me where i can download it?
View 6 Replies
View Related
Jun 26, 2012
We are running Oracle Enterprise software on various client and DB servers and we are experiencing a problem (outlined here [URL] .....) where the apparent mismatch between the oracle drivers are causing the errors.
Our db servers are using 10.2.0.4 and 10.2.0.5 drivers and the clients are using 10.2.0.1.
Firstly, are the drivers the same on the Express and Enterprise editions so that if I update a development server using Express version (I don't have the authority to upgrade the Enterprise version nor the time to commission that) and it is successful, can I reasonably expect an upgrade to the Enterprise client versions on other servers to be safe/error free, baring environmental factors of course ?
Secondly, can I upgrade to version 10.2.0.5 now or do I have to go to the 11g version only ?
View 2 Replies
View Related
Nov 20, 2012
I have a procedure that needs to be scheduled as a job. This procedure takes an average of 20-25 minutes to complete. The constraint is that these jobs are submitted using dbms_job.submit with an interval of 5 minutes.
For Example:
Job1 Procedure_B 20-Nov-12 21:05:00
Job2 Procedure_B 20-Nov-12 21:10:00
Job3 Procedure_B 20-Nov-12 21:15:00
Job4 Procedure_B 20-Nov-12 21:20:00
So, will Job2 execute only after Job1 completes [even though Job1 takes 25 minutes to complete] or is there any other mechanism for setting incompatibility for a job with itself.
View 5 Replies
View Related
Mar 30, 2012
I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?
View 4 Replies
View Related
Dec 12, 2011
is Forms [32 Bit] Version 10.1.2.0.2 not supported with Windows Server 2008 64 bit ?? i tried to install it and it was failed.!
View 2 Replies
View Related
Sep 17, 2010
installing Oracle 9i and Oracle 10 g client on a single PC.
What are the things I should take not of for the installation?
View 4 Replies
View Related
Aug 16, 2013
when migrating from 32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of?
View 2 Replies
View Related
Dec 19, 2011
i need to upgrade this version to 10.1.2.3, and i don't have an account in metalink to download the patch.
View 11 Replies
View Related
Oct 15, 2010
We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.
if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.
Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.
View 3 Replies
View Related
Aug 25, 2011
I am working on a report which shows a summarized data from 4 different tables. I have 2 columns which shows certain amount.
The data in both the columns comes from different table.
I want to compare these 2 columns for which i placed a formula column in data model. the code goes this way:
function CF_RECV_PAYFormula return Character is
V_RESULT VARCHAR2(50);
begin
IF :TOTAL_IOU_AMT >= :EXP_AMT THEN
[code].....
The compilation is successful. but when i am running the report i am getting an error Rep-1517 :Column 'CF_RECV_PAY' references column TOTAL_IOU_AMT and EXP_AMT has incompatible frequency.
View 4 Replies
View Related
Jun 3, 2010
I have a report of version 10g . I want to run this report in oracle reports 6i version.
View 1 Replies
View Related
Dec 1, 2011
I have created dataguard between two instances hosted in two different servers. I have done switchover from primary to standby & then again standby to primary with DGMGRL utility.
1- When I done switchover to primary & trying to open standby database in readonly mode it was giving below error-
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
Why this error was coming ?
2- As I was not able to open standby database in read only mode, I have executed below command-
alter database recover managed standby database disconnect from session;
which return an error as-
ORA-01153: an incompatible media recovery is active
After this I have executed-
alter database recover managed standby database cancel;
which executed successfully.
& then after standby database open in read only mode.
Why above error was coming ?
3- After this I had tried to check the checkpoint_change# & controlfile_change# from primary database and result shows both number were different.
Why they are not matching ?
View 6 Replies
View Related
Jul 16, 2008
We have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.
We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:
Problem Event Name: APPCRASH
Application Name: javaw.exe
Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?
We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .
View 4 Replies
View Related
May 31, 2010
How to know the uses to oracl9i version ?
View 2 Replies
View Related
May 28, 2008
difference between oracle version 10.2.0.3 and 10.2.03.I searched a lots of sites to get the details about these versions but unable to collect.
Oracle released both version or 10.2.0.3 and 10.2.03 are same versions treated by oracle.
View 2 Replies
View Related
Feb 27, 2012
can i install oracle 10g at windows 7 ultimate 32 bit
View 1 Replies
View Related
Jan 9, 2011
Does Oracle Database 10.1.0.2 (64-bit) compatible with windows 2003 R2 standard X64 edition with Service pack 2.
View 1 Replies
View Related
Mar 21, 2011
In my test server ..When i'm going to check the oralce verion .which version this one ? im not seeing anything from oracle EE or standard edition & personal edition ...
SQL> select BANNER from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
View 2 Replies
View Related
Apr 18, 2013
My oracle version is 10g.I want to update a table which has 2 million rows and 20 columns. I want to update 3 columns in my table based on a query output.
Say:-
select decode(col1,'a',col2,col3) up_col1, decode(col5,'Y',20,30)* col6 up_col2, col7 up_col3 from base_tab a, update_tab b where a.key = b.key
I tried the simple update SQL, it hangs and never comeback even after 2 hrs.So I resort to PLSQL to complete my job using bulk collect with limits. Now I am stumbled upon with the Bulk update step.I referred to the BULK Update example given in [URL]...
I gone by 9i approach, I got invalid rowid error. Since the example doesn't uses a join.
I am little bit worried to go by 10g approach given in the example. I have to fetch entire row from my update table. My update table has 5 varchar(1000) fields. Anyway I am not going to affect them in my update. Whether it will occupy memory and again leads to hanging of my procedure.
View 2 Replies
View Related
Jun 11, 2013
In production server, already Oracle 10 and 11g sare installed. The new application designed to work on Entity Framework which nees ODP.Net 112030 Release 4 version.
As soon as ODP.Net Release got installed ont the server, the SQL Plus couldn't connect the Oracle databae. But the same setup is working all other lower environment
View 1 Replies
View Related
Dec 20, 2012
Database: oracle 9i sitting on a 32 bit machine.
Client: windows7 64 bit computer
installed oracle 11gr2 client
Is there a way to connect to oracle 9i database from C:WindowsSysWow64odbcad32.exe on windows 7 machine? or what is the possible way to connect to Oracle 9i database?What we need is to run crystal reports from windows 7.
View 4 Replies
View Related
Mar 26, 2008
I want to find out the oracle client version on a particular server. How can I do that? I used to know some files to look at, and part of the file name indicated the version #, but it's been too long and I don't remember which files they are.
View 2 Replies
View Related
Nov 1, 2010
Where to download the oracle software for building a production server? What are steps ?
View 1 Replies
View Related
Apr 28, 2011
I installed 11.1.0.6. on Linux RedHat 5.5. Then upgraded to 11.1.0.7. However when I issue sqlplus /nolog and do select banner from v$version it shows 11.1.0.6. Although the install and upgrade were successful. I wonder why it does not show 11.1.0.7. I upgraded using the installer and not dbua could this be the reason why?
View 17 Replies
View Related
