xfp 10g

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|window Download today to Oracle 10g for Windows 32bit, install screenshots, give you a reference. This step takes a long time. It is illustrated above. Overall, 10g is more convenient to install, there will be no 9i when some problems. But some things are not tested, we still have to pay attention to: installation path or try not to conta

Oracle Week Three: Table space management What does the name contain? : Improved table space management Table space management has been significantly improved, which can be attributed to a sparser SYSTEM, support for user-defined default tablespace, new Sysaux, and even renaming How many times have you been hurt by the user's creation of a non-SYS and system segment in the system table space? Before Oracle9i Database, if you do not specify a default tablespace when you create a user, it de

The Oracle 10g version is designed to redesign the operational functions of data entry and output to increase the ability to disconnect and connect in the input or output work. Minor changes to these features can facilitate the operation of the DBA table space. Output table space as a whole unit There are 3 modes of output and input in the past: dependent on object output, such as a single table of indexes, output of all objects of a user, and outpu

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. This article compares the differences between IMP and IMPDP import. The comparison of exp and data pump export, you can see that the data pump export speed and direct path, compared to the speed is not the essence of improvement, the following look at the data pump Import mode and imp difference. The imported DMP file is the result of the above

Label:Transferred from: http://blog.itpub.net/27006877/viewspace-739059/As Oracle takes out the 10g download, it writes the Oracle 10g address here for backup.Note: Directly copy the address to the Thunder download canRelease Notes_database_*.zip--is the Oracle database Server Software installation package, if you want to create a database, please download this version_client_*.zip---is the Oracle database

"Original" About Oracle 10g various service parsing (2014/10/16-8:39:40) Time: 2014-10-16 8-58-30 ssslinppp1. When the Oracle 10g is first installed, two Oracle services are set to start automatically, such as: oracleoradb10g_home1tnslister Service For database listener services, ifwant to passPlsql Developand other softwareto access the Oracle database remotely, this service must be started! By default, th

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

Install Oracle 10g in Win7Database installation may fail due to some errors. This article describes common Oracle 10g installation errors and solutions in Win7. Next, let's take a look at this part. First of all, the version of Oracle 10g Support Win7: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_production_db.zip Error: Checking operati

Start-run-enter services. MSC-An error occurred while starting the oracledbconsoleorcl service. Start manually from the CMD command line:C:/Documents and Settings/wangnc> emctl start dbconsoleEnvironment Variable oracle_sid not defined. Please define it. Set oracle_sid environment variables:C:/Documents and Settings/wangnc> set oracle_sid = orcl C:/Documents and Settings/wangnc> emctl start dbconsole. Still not, to the directory c:/Oracle/product/10.2.0/db_1/Solaris/J2EE found only oc4j_dbconsol

Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19)Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19) I. Preparations 1. database environment Operating system version: RedHat 5.8x64Database Version: Oracle 10.2.0.5 x64 RACCluterware: 10.2.0.5Oracle database: 10.2.0.5.0PSU Patch: 10.2.0.5.19 (second half of 2015)2. Prepare the content OPatch: p6880880_102000_Linux-x86-64.zipDb psu: p20299014_10205_Linux-x86

While I was unable to upgrade my laptop to 1 GB of memory, I was suffering from installing Sun Solaris 10 U3 + Oracle 10g R2 in my current book, I got a laptop for the competition, haha ...... Comfortable. The following is my Installation Record Based on Quick Installation officially provided by Oracle.Hardware:DELL D400CPU: PM 1.6 cache 2 MRAM: 512 M on board + 512 M for a single entry = 1024 MHDD: Fujitsu 40 GBLCD: 12 "1024*768LAN: 100 m lan + 54 M

Introduction Recently I want to study LoadRunner to test Oracle performance, and then I started to try to install Oracle on Linux. I felt that this was not easy. I heard a friend say that he had to pay a lot of twists and turns during the installation and re-installed it many times. I asked a lot of people to solve it, however, after installation, it is easy. Now I want to share my experience with you. I am also a Linux cainiao. Material Source: detailed image description of Oracle

Oracle 11g Database shutdown causes the crsd process of 10g Database to restart The customer has an Oracle 10 Gb RAC environment. Due to an occasional demand, a database of 11 GB needs to be temporarily started. When we mount the software and datafile volumes of 11 GB, the database of 11 GB can be started normally, but when the database of 11 GB is shut down, the crsd process of 10 Gb is restarted. In the 10 Gb crsd log, you can see:11:35:35. 827: [OC

Oracle 10g quick manual database creation procedure Step record of Oracle 10g quick manual database creation: 0. Modify Environment Variables[Oracle @ ocm1 ~] $ Vi. bash_profileAdd the following content:Export ORACLE_SID = PRODExport ORACLE_BASE =/u01/app/oracleExport ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1Export PATH = $ ORACLE_HOME/bin: $ ORACLE_HOME/jdk/bin: $ PATH1. Modify the logon identifier a