10g fet

The following articles mainly introduce the correct handline for Oracle 10g uninstallation. We are familiar with Oracle 10g, which can be called a regular visitor in practical applications, the following articles mainly explain the correct uninstall process. I hope you will get it after browsing. (1) If the database is configured with Automatic Storage Management ASM, delete the aggregation Synchronization

Due to oracle version problems, the following error will be reported when the default exported tables for 11g cannot be imported to 10g: Connectedto: OracleDatabase10gEnterpriseEditionR Due to oracle version problems, the following error will be reported if the tables exported by 11g by default cannot be imported to 10g: Connected to: Oracle Database 10g Enterpri

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

Oracle 10g ClientThe installation configuration is very important for Oracle users. installing and configuring the Oracle client properly will bring great convenience to our work. This article describes how to install and configure the Oracle 10g client. 1. Configure the listener for the Oracle server Modify the listener. ora and tnsnames. ora files in the The listener file is roughly as follows: # L