10g router

The Oracle HR example uses 10g, 11g, and oracle11g. Oracle HR example users can create 10g, 11g First, add the 10. SQL files in the attachment (see the end of the article) to this path: $ ORACLE_HOME/demo/schema/human_resources Script Name Description Hr_anz. SQL Collects statistics on the tables in the schema. Hr_code. SQL Creates procedural objects in the schema.

Installing oracle in Linux is a daunting task. Its complexity far exceeds that of installing the Linux operating system. If Oracle is successfully installed, some Linux technologies are also mastered. This article describes how to install Oracle 10 Gb in RedHat Linux. Here, we will explain that Oracle 10 Gb G stands for grid, which is a cutting-edge network computing technology. Oracle 10g has very high requirements on hardware and software, so it ta

Manual configuration of Oracle 10g Enterprise ManagerThe following error is reported when oracle is installed several times; Enterprise Manager Configuration failed due to the following errorAn error occurred while starting Database Control.For more information, see log files in E: \ oracle \ product \ 10.2.0 \ db_1 \ export toollogs \ dbca \ oradb \ emconfig. log.You can manually run the E: \ oracle \ product \ 10.2.0 \ db_1 \ bin \ emca script to re

The operating system version is Solaris 10, after installing the 11.2 grid, installing the 11g RAC database is fine. However, when installing 10g RAC database, the progress bar to 50%, always reported OUI-35000 Fatal Cluster error errors. At this time banner has been disable. There is no problem with SSH node1 date and SSH node2 date to check the mutual trust of each node. But with the following command check but the error of mutual trust problems.

Oracle 10g 10.2.0.1 RAC ORA-12520This error is very common. I have encountered it once on a single machine. The solution is to set local_listener. This time, I will try to see how it works.[Oracle @ R1 ~] $ Sqlplus system/test @ RACSQL * Plus: Release 10.2.0.1.0-Production on Fri Feb 3 11:24:31 2012Copyright (c) 1982,200 5, Oracle. All rights reserved.ERROR:ORA-12520: TNS: listener cocould not find available handler for requested typeServerEnter user-

Previous installation summary, now put it out, although 10g now slowly less, but also have a lot of production library run 10g.1.Vi/etc/hosts10.168.39.243 ORCLDB110.168.39.245 ORCLDB2192.168.39.243 Orcldb1-priv192.168.39.245 Orcldb2-priv10.168.39.242 ORCLDB1-VIP10.168.39.244 ORCLDB2-VIP2.Groupadd OinstallGroupadd dbaUseradd-g oinstall-g dba-d/oracle OracleUSERADD-G oinstall-g dba Oraclepasswd OracleID Oracl

Friends who recently saw a lot of novice Oracle on the Web or upgraded from an older version of Oracle to 10G asked how to build the library manually in Oracle 10G. Today is free, so the Oracle 10G in the process of hand-built library, for you to engage in Oracle work and learning with friends for reference, hope to be helpful to everyone. There are usually two

Oracle finally provides support for regular expressions in 10G, where complex matches that need to be done by like can be simpler to implement using regular expressions. Oracle 10g Regular expressions improve SQL flexibility. It effectively solves the problem of data validity, recognition of repetitive words, extraneous blank detection, or decomposition of multiple regular strings. 1. Oracle

Oracle upgrades from 10g to 11g detailed stepsold Database version: 10.2.0.4 Database new version: 11.2.0.2 OS Version: Solaris 10 Reference Documentation:Complete Checklist for Manual upgrades to 11GR2 [ID 837570.1] Part I-Installing 11GR2 software Here to Software 'sinstallationIt is not explained in detail, you can refer to the appropriate documentation. Here is the note: If you want to 11gr2 on the latest PSU or CPU, you can first at the software

In Oracle 10G, the concept of a Recycle Bin (recycle Bin) is introduced. 　　 The Recycle Bin, in principle, is a data dictionary table, where the user drops the database object information. The object that the user is dropping is not deleted by the database. will still occupy space. Unless the user is manually purge or the database is cleared because of insufficient storage space. The database has this function, can reduce a lot of unnecessary troubl

Oracle First week: Flash back query Get a movie instead of a picture: Flash back version query No setting required to immediately recognize all changes to a row In the Oracle9i Database, we saw that it introduced a "time Machine" in the form of a flashback query. This feature allows the DBA to see the column value at a specific time, provided that the previously mirrored copy of the data block is available in the restore segment. However, a flash-back query provides only a fixed snapshot of

Reference: ORACLE 10G official documentationReference: A Bone theory version 2012 Oracle free Video TutorialFirst, install Linux1, note partition: Memory is less than 4G, then swap partition = memory, memory is greater than 4G, swap partition = memory size;2, TMP directory is greater than 10G;3. root directory >25G;4, the development of the toolkit all selected;5. After the installation is complete, install

Excerpt from: http://blog.csdn.net/javaee_sunny/article/details/53439980Directory (?) [-] The Oracle 10g materialized view syntax is as follows Example Demo Main steps Creating the original table and materialized view logs on a node Create a remote link to a node on the B node Create the target table at the B node and the same materialized view as the target table name Refresh materialized view at B