Previously, it was very easy to install and use ORACLE on 32-bit Windows 7. But now the system has been upgraded. tools like PL/SQL developer or navicat premium cannot connect to 64-bit oracle. 32-bit oracle can be installed in a 64-bit system, but it is not suitable. I have seen many methods on the Internet and succeeded. Now I will propose my method.
Get
Install Oracle 9.2.0 in Linux as 2.1
As early as in the Forum, many colleagues praised how Redhat as 2.1 was easy to use and never had a chance to try this trendy environment. Since the Oracle OCM test environment is also RH as 2.1, I want to install it more. I did not think that this test allowed me to install the OS four times and Oracle three times. It is real
Oracle BBED (oracle block browser and editor tool)Installation and Use
BBEDTools can be used to change dataBlockBut not officially supported.
The installation process is as follows:
$Cd $ ORACLE_HOME/rdbms/lib
$Ls-al * bb *. o
-Rw-r --1 oracleOinstall1671 May 10 2008Sbbdpt. o
-Rw-r --1 oracleOinstall900 May 10 2008Ssbbded. o
$Make-f ins_rdbms.mk $ ORACLE_HOME/rdbms/lib/bbed
Linking BBED utility (bbed)
Rm
Beijing Time October 24, 2006-Oracle Developer (Oracle Depot) was announced at the Oracle Global Technology and Applications Conference, held in San Francisco for 2006. This is a free downloadable tool designed to improve the efficiency of software developers, and can greatly simplify how Java developers find, configure, and use Java applications during the learn
Oracle released Oracle medical supplier supply chain analysis software:
1. Oracle recently announced the release of Oracle medical supplier Supply Chain analysis software (Oracle Healthcare Provider Supply Chain Analytics), the latest Component of
classic block, but the operating system is 5. x or 6.x, but the database is 10. x or 11.x.
The following is a simple record and summary of the installation process.1. First install oracle10g1. Create a group required for oracle InstallationRoot User executionGroupadd oinstallGroupadd dbaGroupadd rule2. Create an oracle userRoot User executionUseradd oracle-g oin
The uninstallation program that comes with Oracle cannot fundamentally uninstall Oracle, which leaves a hidden danger for the next installation. How can we completely uninstall oracle?To clear the Registry directly, follow these steps:
1. Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle ser
Oracle review, oracle
After I got back, I recorded several sets of videos, but I didn't know how to record them when I started recording them. If I recorded a few sets, I had nothing to do. I could record each set for dozens of minutes, in the process, I also read this part of the Oracle database, and gained a lot. learning is a process of repeated accumulation.
Summary of Oracle database architecture, oracle Architecture
Oracle DB Architecture An Oracle DB server consists of one Oracle DB and one or more database instances. An instance consists of a memory structure and background processes. Whenever an instance is started, a sha
Oracle data file structure, oracle Data Structure
Oracle data structures are divided into physical and logical structures.
Physical Structure: data block of the Operating System-> data file datafiles
Logical Structure: Minimum database block --> extent --> segement --> tablespace --> databases
One tablespace can have multiple datafiles, and one datafiles can b
Label:Preparing to install the Oracle database, refer to: http://blog.csdn.net/mchdba/article/details/430860371, workaround (1), ignore system prereqs[Email protected] database]# export display=192.168.121.218:1.0[Email protected] database]# Xhsot +-bash:xhsot:command not found[Email protected] database]# Xhost +Access control disabled, clients can connect from any host[Email protected] database]# su-oracle
(1) Select the most efficient table name order (valid only in the rule-based optimizer):The Oracle parser processes the table names in the FROM clause in a right-to-left order, and the FROM clause is written in the final table (the underlying table, driving tables) will be processed first, and in the case where the FROM clause contains more than one table, you must select the table with the fewest number of record bars as the underlying table. If you
The remote connection of Oracle database can be implemented in a variety of ways, this article mainly introduces four methods and considerations of remote connection, and through the examples to illustrate, then we begin to introduce.First case:If the Oracle server is installed on this machine, then there is not much to say, the connection is only the user name and password problem. However, be aware that t
Label:Recently began to learn OpenStack, because there is no environment, so do not know how to get started, so download the OpenStack for Oracle Linux version, ready to play (with Oracle account, hehe). This reference is still a lot of information on the Oracle website, I refer to the Ronen Kofman hands-on lab:getting Started with OpenStack on
Oracle knowledge sorting notes, oracle sorting notes
I want to help you with my learning notes on Oracle knowledge.
1. a brief comparison between SQL Server and OracleLet me show you a picture:
After installing SQL Server, we can see that many databases have System databases and user databases after opening and connecting to the database engine. After
Summary of Oracle parameter viewing methods and oracle parameter Summary
Oracle provides a large number of system parameters. The following is a summary of the query methods.Current System Parameter
The current system parameters involve these views: v $ parameter, v $ parameter2, v $ system_parameter, v $ system_parameter2, and v $ spparameter.V $ parameter
If th
Quickly deploy an Oracle RAC environment using an Oracle VM Template
Oracle VM templates are pre-packaged and pre-configured virtual machines. In the communication between enterprise-level customers, I often use "simple, fast, and error-free" to deploy applications using Oracle VM templates. The
Http://www.itpub.net/thread-1478468-1-1.html
http://tomszrp.itpub.net/post/11835/520574
Starting with version 11.2.0.1, Oracle offers a new way to allocate space: When you create a segment table, the table is not created immediately, but it is created until the first row of records is inserted, segment, This is not the same as our previous segment creation and spatial allocation methods. Such segments are also calledDelay Segment. Starting with versi
Corresponding certificateOracle Certified Expert-OCP (Oracle certified Professional)Certification Prerequisites For OCP certification, OCA, OCP certification training and exams are required through the Oracle Licensing Training Test Center. OCA is a primer for Oracle certification system, proving that you have mastered the basic knowledge of the database, you can
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.