oracle 10g book

Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oelr5u8-1.localdomain 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/LinuxSYS @ PROD> select * from v $ versio

(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 conten

OBIEE 11g BI Management tool connection OCI 10g/11g data source times wrong [connection failed] OBIEE 11g Client Admin tools Connection to Datasource in Offline Mode fails Wit H Error "The Connection has FailedUsing OBIEE 11g BI management tool to import metadata, when connecting the OCI 10g/11g data source, click Connect will error [connection failed], such as: R

Tags: oracle11g cross-version 10g import error 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: A previous s

, you have already covered various other options ). 　 Some taboos during Oracle Learning 1) incorrect text I often see a lot of people taking 8i, 9i materials on 10g, 11g experiment, don't say, also said oracle is not good that is not good! 2) less detours To learn about Oracle databases, you should carefully read

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

technology, parallel technology, in Oracle 10g, and RAC in conjunction with the simultaneous scanning of multiple nodes, the effect is very good, can be a task, such as Select a full table scan, the average allocation to multiple RAC nodes. in an OLAP system, you do not need to use BIND (BIND) variables because the overall system is small, the analysis time is negligible for execution time, and the wrong

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit) Http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip Http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip Http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip Http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip

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

Recently, many employees who have installed Oracle 10g RAC on the RHEL 5.X platform do not have much difficulty, but repetitive manual work is still relatively high. Therefore, a semi-automatic installation script is compiled by the way. Install operating system patches, create database users, and modify user configuration files. Issues to be resolved:1. The host name is automatically configured, which requ

[Oracle @ node1 pfile] $ export ORACLE_SID = MRAC1 [Oracle @ node1 pfile] $ sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on Thu Sep 27 10:27:35 2012 Copyright (c) 1982,200 5, Oracle. All rights reserved. Oracle Database 10g Enterprise Edition Release 10.2.0.

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

perform the corresponding operations until the installation is successful.Iii. Installation Problems 1 Q: After the./runInstaller is executed, the installation interface cannot be displayed, and the following error message is displayed:Bytes ---------------------------------------------------------------------------------------------Xlib: connection to ": 0.0" refused by serverXlib: No protocol specifiedError: Can t open display: 0.0A: run the following command as root on the machine where

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 fo

After you modify the computer name or the configuration of Oracle when using the Oracle 10g Database, the Oracle Enterprise Manager fails, causing the Database Control Service to fail to start normally, this will cause a lot of trouble. The re-configuration method of EM is described below. Microsoft Windows 2000 [versi

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

Restoration Method for Oracle 10g Clusterware Votedisk corruption Votedisk 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, c

Environment Settings...First, check your physical memory size. We recommend that you increase the memory size by 1 GB.# Grep MemTotal/proc/meminfo Check whether your swap partition size meets the requirements. Generally, it is twice the physical memory size ..# Grep SwapTotal/proc/meminfo Check whether the size of the partition mounted to/tmp is sufficient. If the size is smaller than 400 MB, delete other junk files and increase the space.# Df-k/tmp View the cpu type.# Grep "model name"/proc/cpu

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

When Oracle database is created, a series of default user and table spaces are created User name/password for Oracle 10g default installation Username Password Description See Also Ctxsys Ctxsys The Oracle Text account