10g fet

cenOS5.5 installation oracle10g (Fool article) http://www.cnblogs.com/fnng/archive/2012/06/19/2554159.html (Turn)Installing Oracle 10G on cenOS5.5 It's not that fresh stuff, but it took a week to build it around. I think everyone will encounter some different problems when installing. Since it is a fool's article, it must be very stupid. Ha ha!!================== Required Equipment =============================Virtual Machine VirtualBoxHttps://www.vir

Oracle 10g version is 10201_database_win32, installation Prompt "program terminated abnormally, an unknown error occurred."1. Modify Oracle 10g\database\stage\prereq\db\refhost.xmlIn 2. Locate the Oraparam.ini file in the install directory and#Windows =4.0,5.0,5.1,5.2Modified into#Windows =4.0,5.0,5.1,5.2,6.1and add the following[Windows-6.1-required]#Minimum display colours for OUI to runmin_display_colors

This article mainly introducesOracle 10g isqlplusUseDBA accountNext, we will introduce them one by one. 1. vi. bash_profile Add Environment Variables exportJAVA_HOME=$ORACLE_HOME/jdk Save and exit. source.bash_profile 2. Switch to the correct directory cd$ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus 3. Run the JAZN shell. $JAVA_HOME/bin/java-Djava.security.properties=$ORACLE_HOME/sqlplus/admin/iplus/

Step by step to clean up the oracle 10g RAC environment that fails to be installed due to problems with the previous installation of clusterware, so reinstall the environment, but each time you execute the root. sh always has Failure at final check of Oracle CRS stack. 10. start querying questions. the previously installed crs is not deleted. the following is a post about How to Clean and delete crs.10g RAC

Oracle 10g installation does not find a prerequisite error solution when installing oracle 10g (Version: 10.2.0.1, haha, 10201) error: In oraparam. the prerequisite check is not found in ini, and the system prerequisite check is not executed. Start oracle universal installer c: \ e ~ from the following address ~ 1 \ admini ~ 1 \ locals ~ 1 \ temp \ orainstall2008-12-30_10-40-42PM. please wait ...... after t

Author: Jiangnan BaiyiFrom 8 I to 10g, Oracle constantly evolved its own SQL tuning intelligence, and some secret-level optimization tips have expired.However, I like to be ineffective. I don't have to worry about it. I love to stick to toad for Oracle Xpert, and I love to do things based on the general direction of comfort and server optimization. 1. excution planExcution plan is the most basic optimization concept, no matter how complicated your opt

Installing oracle in Linux is a daunting task. Its complexity far exceeds that of installing the Linux operating system. If Oracle is successfully installedAt the same time, I also mastered some Linux technologies. This article describes how to install Oracle 10 Gb in RedHat Linux. Description 1: Oracle10g is short for grid, which is currently a cutting-edge network computing technology. ---Www.bianceng.cn Oracle 10g has very high requirements on hard

process reads the MV log to identify these changes. Needless to say, this requirement increases the total execution time of the operation. In addition, the additional insert operation consumes the CPU cycle and I/O bandwidth. Fortunately, in Oracle Database 10g 2nd, the PCT does not need music video logs. Let's take a look at how it works. First, check that the table ACCOUNTS does not contain MV logs. SQL> select * 2 from dba_mview_logs 3 w

With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer: Oracle RMAN compatibility and FAQs between different versions and different platforms This article demonstrates an example of restoring 10 Gb to 11 GB in linux. Target end: OS: Oracle Linux 6.1 64-bit DB: 11.2.0.3 Source end: OS: Oracle Linux 6.1 64-bit DB: 10.2.0.5 Note: Oracle 10.2.0.1 cannot be upgraded

I. The following error is reported when 10gRAC uses DBCA to reconstruct asm:The ASM instance configured on the local node is a single-instance ASM. to create a single-instance database using this ASM instance, restart DBCA and select the single-instance database option, to create a RAC database using this ASM instance, convert it to rac asm first. This is because the instance content in/etc/oratab is not removed. II. The complete process of re-establishing the ASM instance1. Stop the instance.Sr

Oracle Introduction Oracle is the first word for English translation of oracle (Oracle bone inscriptions) Unearthed from Yin. Oracle is the world's largest supplier of information management software and services. It was founded in 1977 and is headquartered in Redwood shore, California. Oracle is famous for its complex relational database products. Oracle's relational database is the world's first database that supports the SQL language. Oracle 10g Da

[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.0-Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> alter system set log_archive_dest_1 = '+ archlog' scope = both; Alter system set

Ubuntu 10.10 Oracle 10g Installation Guide Ubuntu 10.10 Oracle 10g Installation Guide Step 1: Download The oracle10 installation package (server and client)Http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zipHttp://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip Step 2: install the required package 32-bit: apt-get install gcc make binutils lesstif2 libc6 lib

Ubuntu 10.10 Oracle 10g graphic tutorial Environment: Host XP, 3 GB memory, VMware: Ubuntu10.10, hard disk 30 GB, memory 1024 MB The installation of virtual machines is not described. 2. Update ubuntuSudo apt-get updateSudo apt-get upgradeOracle is written in java, so JDK is required. You can search for jdk in [Ubuntu Software Center]. After installing OpenJDK, you do not need to set the path. 3. Install the missing package1). sudo apt-get install gc

Oracle10g manually create a database stored in ASMProject Process:0. Add two SCSI hard disks to the computer.1. Install ASM2. Create two ASM disk groups: GROUP1 and GROUP23. Create a database. First, create a parameter file and save it as $ ORACLE_HOME/dbs/initnestling. ora.4. Create a password file $ ORACLE_HOME/dbs/orapwdnestling5. Create a path for tracking and log files6. Start the database to the nomount status.7. Create and run the database creation script8. Create an erp tablespace9. Crea

How to add a node Oracle 10g RAC Add a node The current RAC environment is as follows. You must delete racdb3 first. SQL> select INSTANCE_NAME, HOST_NAME, VERSION, STARTUP_TIME, STATUS, ACTIVE_STATE, INSTANCE_ROLE, DATABASE_STATUS from gv $ INSTANCE;INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS ACTIVE_ST INSTANCE_ROLE DATABASE_STATUS------------------------------------------------------------------------------------------------------------------

Oracle 10g installation in win7, select advanced options, prompt program abnormal termination, an unknown error occurs Modify Oracle 10g \ database \ stage \ prereq \ dB \ refhost. xml In the Go to the install directory and find the oraparam. ini file. # Windows = 4.0, 5.0, 5.1, 5.2 Modify # Windows = 4.0, 5.0, 5.1, 5.2, 6.1 Add [Windows-6.1-required]# Minimum Display colours for Oui to runMin_display_c

My Oracle 10g version is 10.2.0.1.0. (10.1 is the same as that for advanced installation.) The system prompts "the program is terminated abnormally and an unknown error occurs ". 1. modify Oracle 10g \ database \ stage \ prereq \ dB \ refhost. xml When refhost. XML is enabled ..... Add 2. Find the oraparam. ini file in the install directory and# Windows = 4.0, 5.0, 5.1, 5.2Modify# Windows = 4.0, 5.0,

/standbyarchive/log_1_2_626449270.arcMedia Recovery Log/home/oracle/oradata/rac/standbyarchive/log_1_3_626449270.arcMedia Recovery Log/home/oracle/oradata/rac/standbyarchive/log_1_4_626449270.arcMedia Recovery Log/home/oracle/oradata/rac/standbyarchive/log_rj5_626449270.arcMedia Recovery Waiting for thread 1 sequence 6Mon Jul 9 18:54:03 2007Redo Shipping Client Connected as PUBLIC-- Connected User is ValidRFS [1]: Assigned to RFS process 3025RFS [1]: Identified database type as 'physical standby

Export of Oracle 10g Data Pump Partition Table In Oracle 10 Gb, Data Pump supports local export/import of Partition Table partitions, but NET_LINK does not support partition tables. The following are some export experiments. Local export: C: \ Users \ xionglang> expdp test/test dumpfile = test. dmp logfile = test. log directory = dir_dump tables = t: p1 Export: Release 10.2.0.4.0-64bit Production on Tuesday, 19 June, 2012 22:57:09 Copyright (c) 2003,2