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?
View 11 RepliesJust 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?
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"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 Windows 2008 R2 64 Bit Operating Server Installed.
Other software that are Installed :
1) Visual Studio 2010 Ultimate 32 Bit.
2) Microsoft SharePoint server 2010 64 Bit.
For my development purpose I want to install both oracle 11g client 32 bit and oracle 11g client 64 on the same machine.
Is it possible to install both 32 and 64 bit instance on the same machine.
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?
View 6 Replies View RelatedI need to do the following:
(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).
we have moved our database to a new server which is 64bit. (earlier database was 32bit)
when i try to connect my crystal report or Vs .net to the new server i'm getting below error.
ORA-03113: end-of-file on communication channel
my computer is Win 7 (32bit)
I have come across one odd situation where by i have got 2 .dmp files to restore at 10g win 2k3 sp2 32bit platform.the problem is that there is no information available related to username/password or any other info related to database.there is no information of from username as it require for importis there anyway to restore it?
View 1 Replies View RelatedI have oracle 9i dump...now i want to import this dump into oracle 10g.....is it possible.
View 4 Replies View Relatedi am working on oracle 11g r2. is there any way to go back to oracle 9i with use of import/export utility. Should i take downgraded export from oracle 11g for oracle 9i.
View 2 Replies View RelatedWhile doing import got the below errors.
Failing sql is:
BEGIN DBMS_JOB.ISUBMIT( JOB=> 361, NEXT_DATE=> TO_DATE('2010-09-06 21:18:27', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'SYSDATE
+ 45/86400', WHAT=> 'PK_MONITORS.SP_OVERDUE_JOB;', NO_PARSE=> TRUE); END;
ORA-39083: Object type JOB failed to create with error:
[code]...
I do not import a full database.
View 3 Replies View RelatedWe have a table in Oracle9i database with around 14 million records and we would like to import that table into 10g database with similar structure. We have exported the table from 9i database and would like to import the table into 10g database within same schema name with different table name as we already have the table with same name in 10g database in same schema. Is it possible to import a table with different table name?
We have a way around to import the table into 10g database in another schema and then push the data into our main table but want to know whether the above requirement is possible.
How to import a dump file into different tablespace.
normally when i am importing a dump file it goes to the table space where it was exported but i need to import in to different tablespace
I have a backup of Oracle Database 10g (business_bk.dmp). Now I would like to import it into Oracle DB 9i.
View 9 Replies View RelatedORA 12899 prompts when we are doing import from 10.2.0.3 -> 11g R2. Also it is cross platform, AIX -> windows 2003.
View 7 Replies View RelatedI have Live Server with 11g R2 with Dataguard on server 2008 server 64 bit. I exporting the DMP from live and importing in 10g on Server 2003 32 bit. All tables are not imported.
View 3 Replies View RelatedI 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?
View 2 Replies View Relatedwhere i can get oracle 10gr2 64bit download for windows 7 64bit?
View 2 Replies View RelatedI have taken an export using expdp of schema, data of the schema spread across different tablespaces , now i want to import the data to only one tablespace.
View 1 Replies View RelatedI am getting the below error when I import a table from Prod to Dev. I understand this error will be occured if length of the datatype is low. First I got the error when the datatype(length) which is 25 for the column PASSWORD column.Then I increased the length of this column to 45, then it was imported successfully.
why am facing the error when the datatye and length for this table is same in prod and dev? What are the possible ways to import the data without increasing the PASSWORD column length?
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "ANEES"."SALSA_WEB_ACCESS"."PASSWORD" (actual: 28, maximum: 25)
[code]....
I was asked to do export/import of some schemas from 10g(linux) to 11g(AIX) using original expor/import method. I did not consider the character set and started doing export and import. while exporting, I get questionable statistics error in export log file. In the import log, I see the error like CREATE DATABASE LINK "xxxxxxxxxxxxx" CONNECT TO "xxxx" IDENTIFIED BY...
What can be done with these errors?
I'm unable to do an import of a *.dmp file.
[oracle@oracledbserver ASG1]$ cd /media/volume-01/u01/app/oracle/product/
[oracle@oracledbserver product]$ ls
11.2.0 20-04-2013full_backup.dmp full01-03-2013_backup.dmp new.dmp today.dmp
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$ impdp full=Y directory=agge_dir dumpfile=/media/volume-01/u01/app/oracle/product/new.dmp NOLOGFILE=y;
Import: Release 11.2.0.1.0 - Production on Tue May 7 16:51:47 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39088: file name cannot contain a path specification
[oracle@oracledbserver product]$
This is Oracle 11g hosted on an eucalyptus cloud instance.
I am trying to import .dmp file to my database
I am trying to run the imp command from dos prompt.
Here is the error I got .
C:Documents and SettingssairammMy Documentsartmsexp_AUDT2_04292012>imp
sairamm/mypassword@aws fromuser=AUDT2 toUSER=SAIRAMM file=exp_AUDT2_04292012.dmp
log=imp_AUDT2_04292012.log BUFFE
R=10000000 GRANTS=y
Import: Release 9.2.0.1.0 - Production on Mon Apr 30 14:23:29 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing option
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
The way to do IMPORT of a schema's ALL the TABLES only. Through Data Pump. I don't want to import any other objects like 'package',procedure etc...
Is it the only way is specifying them within EXCLUDE parameter?
Whats is the usage of log file in Import/export .If i use following command ,it exports successfully
exp scott/tiger file=check.dmp log=empc.log tables=emp
and if i remove .log from here it will also export successfully So why do we use .log in import/export.
How to skip one table while import in traditional exp/imp not in DP.
View 4 Replies View RelatedI have exported a schema dump with schema name as 'A'.I want to import that dump in to schema 'B'.how ?
View 5 Replies View Related