After reading the upgrade documents provided by Oracle, the upgrade failed several times according to the method described above. After more experiments, the upgrade is successful. Now I will share the upgrade process with you.
1. Install Oracle 10 Gb to a 64-bit system. Do not create a database.
2. Shut down the original 32
Install the Oracle database under a 64-bit operating system and download a new 64-bit database (if the 32-bit database is installed on a 64-bit operating system, either the client or the server side, do not select the C:\Program F
Through all kinds of hardships, finally the work of 32 Oracle 10g loaded to 64-bit windows7 on the. Do not ask me why I do not install 64 Oracle or Oracle 11g, which is the only reason for the job needs.
Encountered a variety of problems, bypassing the detour will not wordy,
Method One: Use Sqlplus
64-bit:
[Oracle@qs-wg-db2 ~]$ Sqlplus/as sysdba;
Sql*plus:release 10.2.0.5.0-productionon Sun Sep 25 08:57:22 2011
Copyright (c) 1982, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise editionrelease 10.2.0.5.0-64bit Production
With the partitioning, OLAP, Data min
Tags: content svc bit Delete base features do not install environment interfaceThe first step: Download the instant client package on the ORALCE official website to load the Oracle instantclient Basic packages. The address is as follows: Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html,Instant Client for Microsoft Windows (32-
VS2010 run the program without any problems, but after publishing to IIS, connect the database times wrong: "Throws badimageformatexception when attempting to load the Oracle client library. This problem occurs if you are running in 64-bit mode with the 32-bit Oracle client
Description
The official recommended migration to the same version, such as: 10.2.0.1 (32) migrated to 10.2.0.1 (64).
Upgrade to 10.2.0.5 (64).
First, the environment introduction
Source Library
Operating system version: OEL5.8 32bit
Database version: 10.2.0.1 32bit
Database SID Name: ORCL
Test Library
Operating system version: OEL5.8 x64
Database version: 10.2.0.5 x64
Database SID Name: ORCL
Second, the Source library
1. Close Source Lib
Tags: io os sp for on BS nbsp SQL installationSystem platform: 64-bitMSSQL 2005 32-bitAfter installing the 32-bit Oracle client, create the Dblink times error in sql:The OLE DB provider "MSDAORA" for linked server "Szmesp" reported an error. The provider did not give any information about the error.Cannot initialize th
Simple query of oracle client bits 32-bit or 64-bit, oracle32bitDirectory
Directory
Linux platform
Windows Platform
Linux platform
Go to the bin directory of the client installation directory (CLIENT_HOME ).
$ Cd CLIENT_HOME/bin Use the file command to verify the executable files $ File sqlpl
Today, I want to write a program. The environment is win7vs2008oracle. First, you must ensure that you can connect to the database. Check that the code is correct, but take it directly. Error: "BadImageFormatException is thrown when you try to load the Oracle client database. If you run the 32-bit Oracle client in 64-
In the project of the Security Supervision Bureau, the Internet website needs to display the enterprise declaration result. The website is developed by another company and the database is Oracle. We originally wanted to open an account to allow them to access our database, but people do not want. Later, after being determined by the information center, they opened the database. We created tables with the same structure in their
Encounter this problem, online search a lot, most of the inaccurate interpretation, after exploring according to their own understanding to write how to solve.Phenomenon: The problem is more clear on the Internet, the use of Plsql Developer connection to the database will report a problem with the inability to locate the Oci.dll file, there may be different reports, but the problem is to say this file problem.Cause: The Plsql Developer used here is 32
Tags:httpcom use data html cti This you need to install a 32-bit Oracle client to use Plsql, but at this time sqlplus can not be used, hehe . I tried the following method, successfully, haha 1) install Oracle 11g 64-bit 2) Install the
Tags: style c a color data RGBOracleClient Program to connect Oracle database, the following error is indicated:The data connection is unsuccessful, check that the database is started when attempting to load an Oracle client when BadImageFormatException is raised. This issue occurs if you run in 64-bit mode with the 32
method One: Use Sqlplus# # #64位: [[email protected] ~]$ sqlplus/as sysdba sql*plus:release 11.2.0.3.0 Production on Fri Oct 318:44:05 Copyri Ght (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition release11.2.0.3.0-64bit productionwith The partitioning, OLAP, Data Mining and Realapplication testing options sql> If it is 64 bits, the specific bit information will be di
SSMS Linked Server (Success)Finally, the driver of Oracle HOME1 can be found in 64bit ODBC, so the ODBC test connection succeeds in modifying the TNS file in the Oracle Client installation directory.In SSMs, create a new linked Server, select the Oracle Provider for OLE DB directly, enter the appropriate configuration, enter the user name, password in the securi
Tags: folder copy files SQL Instant DMI 1.2 directory Oracle System installation1. Unzip the J:\ software \ (computer) Computer class software \oracle\plsqldeveloper\instantclient_11_2To product under the Oracle installation directoryC:\app\Administrator\product2, put the C:\app\Administrator\product\11.2.0\dbhome_1 directoryThe network folder is copied to the ex
Tags: position 64-bit system body exception 64-bit ORACL. dll ACL RACThe client installs the 32-bit Ora client in the Win7 64-bit system, and the NET install post-connection database raises badimagefomatexception.Installing a 64-bit
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.