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
Label:The first step: the installation of Oracle services, two unpacking, respectively extracted after merging into a folder, click EXE installation (if you encounter path problem during installation, directly ignore it) Step two: Use SQLPlus to test whether successful installation succeeded: CMD = "SQLPlus = =" Username =>pwd "= connect to ... Indicates success. Step three: Connect using Plsql, the connection failure is found because there is no conf
Win8 64-bit connection to oracle Database Using plsql developer, win8plsql
Problem: When plsql developer is used on a 64-bit win8 system to connect to a local oracle database, an inexplicable problem may occur. The error prompt bo
: Configure PL/SQL developer Start PL/SQL developer, In the Login window interface, click the Cancel button to make the main interface, click Tools->preferences, in the connection need to configure the following two parameters: oracle home:c:\oracle\instantclient_11_2 oci Library:c:\oracle\instantclient_11_2\oci.dll This configuration is complete, now can be n
for Oracle and grant write permissions to the Oracle user to execute permissions to the DBA group. 8 , and system environment configuration. 1) Add the following line to the/etc/sysctl.conf file:Execute the sudo gedit/etc/sysctl.conf command to edit the file.Kernel.shmall = 2097152Kernel.shmmax = 2147483648Kernel.shmmni = 4096Kernel.sem = 250 32000 100 128Fs.file-max = 65536Net.ipv4.ip_local_port_range = 1
to at least 4g,2 a G is very card.2. While hard disk space is generally no problem, set aside about 2G.3. The installation is complete, there will be an interfaceWe can either unlock the required account or change the user name in password management. Careful to find that there is such a sentence: The database control URL bit https://localhost:1158/em. This is equivalent to Enterprise Manager in SQL Server. Unlike it, the manager is managed with a br
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
Software environment: 64-bit win7, 32-bit Oracle 10g, PL/SQL 9.0.4.1644
In the past, 32-bit systems were used for development and suddenly switched to 64-bit systems. The installation e
connected Oracle successd! The database connection was successful.
WIN7 64-bit connection to Oracle database issues
I've met and solved it.The unit's server configuration of CentOS 5.5 X64, My computer is also Win7 x64, installed Oracle 10g x86
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 orig
installation (requires a reboot to remove the catalog).
Perform Oracle 11g Client Setup.exe on a 64-bit SQL Server machine,Must be installed in the first version of the meta- 。
Choose "Customize" When choosing an installation type.
Need to m
Software environment: 64-bit win7, 32-bit Oracle 10g, PL/SQL 9.0.4.1644
In the past, 32-bit systems were used for development and suddenly switched to 64-bit systems. The installation e
Recently made a small system, need to build a database environment at the customer site. Before we have been to visit a company's test library, now needs to be developed in the field, the site of the Orcal server has been installed 12C , we do not intend to reload server-side orcal, so we will be our own computer The orcal client is reloading to 10.2, trying to match the 12C client, but 10.2 of the
bytes
Database mounted.
Database opened.
Sql>
7. To all objects under the 64-bit platform
Sql> @?/rdbms/admin/utlirp.sql
8. Reconstruction Data Dictionary (10.2.0.5)
sql> @ $ORACLE _home/rdbms/admin/catupgrd.sql
About more than 40 minutes, indicating that there are partially invalid objects, you need to compile these invalid objects.
9. Perform the foll
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.