Application of single channel 10G Wavelength Division transmission SystemInternet has become an indispensable tool for Gaga households, because the network era, People's happiness index is more and more high, the rate of Internet broadband is more and more high, the trend determines the network needs to be reformed. In the early stage of the first set of fiber-optic networks, over time fiber resources have been very scarce, in this context, the emerge
Oracle
8.1.7
. 4. Upgrade Oracle 10.2
Oracle provides an update tool that allows you to upgrade the database from a lower version to a later version, and the 8i can be upgraded directly
10g
But 8i must be
8.1.7
. 4 (inclusive) or later versions, 8.1.7.0 is not supported. Oracle provides two upgrade Methods: Wizard upgrade and manual upgrade. The following describes the upgrade process respectively.
1. Wizard upgrade
1. First, you shoul
Contents
I. Hardware requirementsIi. SoftwareIii. System Installation notes4. system preparation before Oracle Installation5. install and configure Oracle6. Upgrade Oracle to patchset 10.2.0.47. Use rlwrap to call historical commands in sqlplus
I. Hardware requirements
1. Memory swap
Minimum: 1 GB of RAMRecommended: 2 GB of Ram or more
Check memory # Grep memtotal/proc/meminfo # grep swaptotal/proc/meminfo
2. Hard Disk
Since centos is installed almost 4 ~ 5 GB, plus Oracle an
Install DDL objects
Log on to sqlplus as an oracle user at the source end and execute the following script:
Run marker_setup
Make sure that the related process of goldengate is closed. Any application using Oracle is closed and no new session is generated. Run the following command:
[Goldengate @ gg1 ~] $ CD/opt/Gg/goldengate/[Goldengate @ gg1 goldengate] $ sqlplus/As sysdba
SQL> @ marker_setup
Marker setup script
You will be prompted for the name of a schema for the goldengate database objects.
cases about this mistake, I know there are 2 kinds of cases, the following is excerpts from the Internet:
1, recently in the configuration of Oracle 10G streaming replication environment, encountered a problem, shut down the database (shutdown immediate), through the SQL plus connection database: Conn sys/his@orc0 as SYSDBA, the following error occurred:
Ora-12514:tns: The listener is currently unable to recognize the service requested in the connect
not be less than 1024m;Later found that there may be an Oracle 10g for Win32 a bug, the internet has been patched, after the release of the patch is: 10.2.0.3, but also suspected that Windows 2003 TCP connections are not enough, the internet to say that seems to have this problem, under a 2003 patch, The TCP connection number is expanded to 1000, the result can reach 350 concurrent connections, but no more is not connected;It is not clear what parame
1. Introduction
This article focuses on the benefits of using SQL Server Integration Services to extract data from heterogeneous data sources and to import data into Microsoft®sql server™ for Business Intelligence (BI) analysis and reporting. Oracle database 10g data is used as the primary data source.
Readers of this article include IT professionals, database administrators, and system architects. Readers should have a general understanding of data
Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison.
First, compare the difference between exp general mode, exp direct path mode, and EXPDP three ways of exporting.
This example exports a scenario on a 10g database that is greater than 40G:
$ sqlplus "/as SYSDBA"
Sql*plus:release 10.2.0.3.0-production on Friday June 1 02:11:29 2007
Copyright (c) 1982
In the 10g. When the ORA-00020 occurs, Sqlplus log in will be reported "connected to an idle instance"From:Sqlplus Logon Reports ' connected to a idle instance ' when ORA-20 happens in 10g (document ID 1370000.1)Speak more classic, do not translate, direct reprint:Applies To:Oracle server-enterprise edition-version:10.1.0.4 to 10.2.0.5-release:10.1 to 10.2Information in this document applies to any platform
oracle9i and 10g differencesBriefly said: 10g supports grids (GRID) and supports automatic management (Automatic Management). Detailed said: 10g g is "grid" abbreviation, support grid computing, that is, multiple node servers using high-speed network to form a virtual high-performance server, load in the entire grid balance (load Balance), on-demand additions an
How to import Oracle11g backup to 10g, 10g Import Statement: IMPDPUSERID
How to import Oracle 11g backup to 10g, 10g Import Statement: impdp userid =
2. Use the impdp command to restore data on a 10 Gb Server
Preparations: 1. Create a database 2. Create a tablespace 3. Create a user and authorize 4. Copy aa
What is the difference between Oracle 10g versions!
Oracle 10g Standard Edition Enterprise Edition
Oracle10g is divided into four versions:1. Oracle Database Standard Edition one, the most basic commercial version, including basic database functions.2. Oracle Database Standard Edition, Standard Edition, including the features and Rac of the above version. RAC is included only in the 10 Gb Standard Edition
Oracle 10g AND Oracle 11g manual database creation case -- Oracle 11g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we will make a simple comparison from 10g and 11g. We can see a simple difference between 11g and 10
Full explanation of Oracle 10g RAC Installation
Directory1. ORACLE Database RAC description... 1-21.1RAC system description... 1-21.2 preparations before installation... 1-21.2.1 hardware preparations... 1-21.2.2 quasi-work on software... 1-22. Installation preparation... 2-32.1 modify the network configuration file... 2-32.2 create an ORACLE user and user group... 2-32.3 modify system parameters... 2-52.4 create the home Directory of CRS... 2-52.5 st
If reproduced, please indicate the source: http://blog.csdn.net/robinson_0612/archive/2010/03/30/5431428.aspxAlthough Oracle 10g Database Release 2 has been released for several years, this version is still a version that many beginners learn. The following describes how to install Oracle 10g in detail.
I. Linux version Selection
Currently, the main version of Linux (RHEL) is version 5.4. You can download t
Tags: des using io for file AR data Art spIn the Oracle 10g database, a database object with a Recycle Bin (Recycle bin) was introduced.The Recycle Bin, in principle, is a data dictionary table that places the user's dropped database object information. Objects that are dropped by the user are not deleted by the database and will still occupy space. Unless the user is manually purge or because the storage space is not enough to be erased by the databa
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
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.