Tags: smart action ACL Database framework global Load nbsp WarehouseThe key role of Oracle 10g database: 1, reduce management costs; 2, improve performance; Enhancements to Oracle 10g include: 1, high availability enhancement, new flashback ability, support rollback update operation; 2, to enhance the security, easy to manage a large number of users; 3, the BI aspect enhancement, including the improved SQL
Label:Issue: Oracle Database 10g is not certified in the current operating system Install Oracle 10g in Windows 7. The Orcale version used is 10g. Step 1: Download on Orcale official website for: Http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip Can be copied directly to the Thunderbolt download. Size is 778M. Step 2: Click
(1) Download Oracle 10g software on Oracle official website at: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_ Production_db.zip, can directly copy in the Thunder and other download software directly to download.(2) then modify the following files, the first one is the Refhost.xml file under disk1\stage\prereq\db\ Add the following content:The second is \disk1\stage\prereq\db_prereqs\db under the Refhost.xml file add the follo
SOURCE program AcquisitionDownload Oracle 10g from Oracle's official website:
10203_vista_w2k8_x86_production_db.zip;==> Server (required)
10203_vista_w2k8_x86_production_client.zip;==> client (useless, can not download);
Configuring Refhost.xml File Modification Decompression10203_vista_w2k8_x86_production_db.zip,find a refhost.xml under/db/disk1/stage/prereq/db. Under
Microsoft Windows 7-->
OPERATING_SYSTEM>
VERSION VA
If you are confused about Oracle 10g automatic SGA Management in actual operations of Oracle 10g automatic SGA management, you can use the following articles to learn about its practical application and functions. The following is a detailed introduction of the article.Java code
Java code
Sample configuration of Automatic Memory Sharing in Oracle 10g automatic S
To change the listener port of Oracle 9i, you only need to change it in listener. ora and then restart it. The Migration Group on Oracle 10g rac needs to load data and only allow migration users to access it. It is best to change the port of Oracle 10g. The details are as follows:
1. the listener. after the ora port is changed to 1533, the listener is stopped and the listener is restarted. It is found that
Hangcheck-timer module of Oracle9i10g11gR1IO-Fencing in Linux platform, Hangcheck-timer is a kernel-level IO-Fenc provided by Linux.
Hangcheck-timer module of Oracle 9i/10g/11gR1 IO-Fencing in Linux. Hangcheck-timer is a kernel-level IO-Fenc provided by Linux.
I.Official Website description
Refer to MOS:
9i, 10g, and11gR1 RAC [ID 726833.1]
Hangcheck_timermodule is required to run a supported configurati
1. Start to install and configure Java. If Java is not installed on your computer, you can download the Java installation file from Sun Developer Network.
(1) install JavaC:/> java-versionjava version "1.6.0 _ 13" Java (TM) SE Runtime Environment (build 1.6.0 _ 13-b03) Java HotSpot (TM) client VM (build 11.3-b02, mixed mode, sharing) sets JAVA_HOME and CATALINA_OPTS environment variables C:/> echo % JAVA_HOME % C:/Program Files/Java/jdk1.6.0 _ 13
(2) Deploy the Pentaho Platform [// download Pent
.
Although only users with sysdba and role permissions are saved in the password file, other users are also affected.
1.2 example
Here we conduct a test on Oracle 10 Gb. To avoid the impact of OS authentication, we can disable OS authentication here.
Oracle OS authentication password file and password loss
Http://blog.csdn.net/tianlesoftware/article/details/4698293
SQL> select * from V $ version;
Banner
----------------------------------------------------------------
Oracle Database
10g RAC use service to implement taf and ractaf
As one of the key concepts in oracle databases, service can be used properly to facilitate database management and improve database execution efficiency.
With service, oracle can implement server side taf to simplify the maintenance of the client. Next we will look at how to experiment with service to implement serve side taf at 10 Gb rac.
Use dbca to configure taf
You can easily configure server side ta
Oracle 10g 10.2.0.1 in Oracle Linux 5.4 32Bit RAC installation manual (a touch of Xiangyang), 10.2.0.1 installation manual
Oracle 10g 10.2.0.1 installation manual in Oracle Linux 5.4 32Bit rackets (step by step)
Http://download.csdn.net/detail/rlhua/7699223
How to install ORACLE 10g rac in LINUX and run it normally?
Echo 250 32000 100 128>/proc/sys/kernel/sem
Error Caused by Oracle 11g import to 10g
Environment Introduction
Old Environment
New Environment
Operating System:
RedHat5.8 64-bit
Redhat6.4 64-bit
Database Version:
Oracle 10.2.0.4 64-bit
Oracle 11.2.0.4 64-bit
Background: The old database rac was built based on oracle10g and has been running for several years. Now, the front-end application is ready to be upgraded. Considerin
Solutions to OUI-25031 during Oracle 10g RAC setup
The OS version is Enterprise Linux Server release 5.4.DB version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biWhen you install the clusterware component during RAC configuration, the following script execution prompt appears:
If the preceding error occurs, run/u01/app/oracle/root on the two nodes. before sh, we recommend that you modify $
1. EnvironmentUbuntu8.04.1 desktop edition (under WMWare virtual machine)
2. Download Oracle-xe-universal_10.2.0.1-1.0_i386.deb: Http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html
After downloading the file, use ftp to upload it to a ubuntu folder, such as/home/ftp.
3. Procedure (for root users)
3.1 update the systemApt-get updateApt-get upgrade
3.2 Installation started
3.2.1 install libaio1Apt-get install libaio1
3.2.2 switch to the oracle folder and run the
Oracle 10g Linux Installation notes
I. Create a user and a directory
1. Create user group#/Usr/sbin/groupadd oinstall#/Usr/sbin/groupadd DBA2. Create a user and set a password#/Usr/sbin/useradd-G oinstall-g dba Oracle# Passwd Oracle3. Create a directory (which can be divided into two subdirectories in one directory)/Ora10g/APP/Oracle/Ora10b/oradata4. Set directory permission# Chown-r ORACLE: oinstall/ora10g/APP/Oracle/ora10b/oradata# Chmod-r 775/ora10
Restoration Method for 10g Clusterware Votedisk corruption, clusterwareVotedisk is very important for RAC (10g Clusterware, 11g GI). We call it an arbitration disk, when a node in the RAC cluster fails and the network is disconnected, it determines whether to kick it out of the Cluster to ensure normal operation of the cluster. When votedisk is damaged, as a result, cluster services cannot be started, clust
After some hard work, I finally got to install oracle in win7. I 'd like to share the process and notes.
1. Chinese considerations
2. During the installation process, select the compatibility mode, such as a chip.
Select "compatibility" and run as administrator. Otherwise, a 2012 disaster will occur.
The next step is simple. perform the following operations: non-original
Note: This article is transferred from another user, but the installation is successful according to this method.
I.Pre
I. Problem Description
Installation environment: Oracle Linux 6.1
Database: 10.2.0.1
When Oracle 10g RAC is installed, an error is reported when root. Sh is executed on the first node, as shown below:
[Root @ Rac1 ~] #/U01/APP/10.2.0/GRID/root. Sh
Warning: directory '/u01/APP/10.2.0' is notowned by root
Warning: directory '/u01/app' is not ownedby Root
Warning: directory '/u01' is not owned byroot
Checking to see if Oracle CRS stack isalready confi
Many friends feedback on the win 64-bit operating system can not use bbed (including the 9I,10G,11G,12C database version), previously wrote an article, the perfect implementation of the win platform versions of the database version on top of the implementation of the use of bbed (in win run the Bbed program), Unfortunately, I did not mention the platform information, leaving a lot of doubt, today on its own computer to achieve this function again, to
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.