oracle 10g book

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 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, extraneo

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

:\oracle\product\10.2.0\db_2\network\admin\listener.ora #GeneratedbyOracleconfigurationtools. SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=PLSExtProc) (ORACLE_HOME=E:\oracle\product\10.2.0\db_2) (PROGRAM=extproc) ) (SID_DESC= (GLOBAL_DBNAME=orcl) (ORACLE_HOME=E:\oracle\product\10.2.0\db_1) (SID_NAME=orcl) ) )

Through all kinds of hardships, finally the work of 32 Oracle 10g loaded to 64-bit windows7 on the. Do not ask me why I do not install 64 Oracle or Oracle 11g, which is the only reason for the job needs. Encountered a variety of problems, bypassing the detour will not wordy, directly to the success of the steps. Oh ~ ~

", "10.2.0.1.0"}Show_splash_screen=falseShow_welcome_page=falseShow_component_locations_page=falseShow_custom_tree_page=falseShow_summary_page=falseShow_install_progress_page=falseShow_required_config_tool_page=falseShow_config_tool_page=falseShow_release_notes=falseShow_rootsh_confirmation=falseShow_end_session_page=falseShow_exit_confirmation=falseNext_session=falseNext_session_on_fail=falseShow_deinstall_confirmation=falseShow_deinstall_progress=falseAccept_license_agreement=truecomponent_lan

from the master database to the Standby DB:SQL> alter system set log_archive_dest_state_2 = defer;Re-enable log transmission after flashing back:SQL> alter system set log_archive_dest_state_2 = enable; Oracle 11g environment:The steps are simpler. The new features of Snapshot Standby Database are added to the 11g, which is actually a package of the above 10g functions, the only difference is that archive l

/zhejiang directory=d_test DUMPFILE=ZHEJIANG.DP Export:release 10.2.0.3.0-64bit Production on Wednesday, 16 January, 2008 22:51:43 Copyright (c) 2003, +, Oracle. All rights reserved. Connect to: Oracle Database 10g Enterprise Edition release 10.2.0.3.0-64bit Production With the partitioning, real application clusters, OLAP and Data Mining options Start "Zheji

AIX 5.3 Under Oracle 10g RAC boot failure--crs boot failureSystem environment:Operating System: AIX 5300-09Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1System Architecture Diagram650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/26/B1/wKioL1NspizDELFmAAFqCT5td6k065.jpg "title=" r2.jpg "alt=" Wkiol1nspizdelfmaafqct5td6k065.jpg "/>Failure phenome

Create a db_link with no domain name in Oracle 10g: The records are as follows: It is invalid to restart the database with ALTER statement this modification method. ALTER DATABASE rename Global_name to ORCL; --use ALTER statement This modification method, restart the database, valid. But not the result I want, although the domain name changes after the shortened, but the establishment of db_link and domain

This article is only used for learning communication, commercial use, please support the genuine! Reprint Please specify: http://www.cnblogs.com/mxbs/p/6217052.htmlPreparation: Oracle 10g for Win (32-bit), System environment Win7 32-bitInstallation:Right-click setup.exe and select "Run as Administrator (A)" To see the prompt version failed,A minor modification is required to install it at this time. Right-c

Cluster_database = False scope = SPFile; Method 2: Use Package/Parameter For 10g, your need to download the package Dbms_awr. Disable_awr available at 436386.1 PackageFor disabling AWR without a diagnostic Pack license in Oracle toInstall, run the package as SYS from Sql*plus:@dbmsnoawr. PLBTo execute the package and use the command:Begin Dbms_awr.disable_awr (); EndFor 11g with the parameter control_man

Oracle 10gORA-074451. Software and version used by the database Serial number Name Content 1 Operating System CentOS release 5.6 (Final) x86-64 2 Database Version Oracle Database 10g Release 2 3 Database installation package:Patch Pack: 10201_database_linux_x86_64.cpio.gzP6810189_10204_Linux-x86-64.zip

Label:The two days of the company's project to use the Oracle database, installed when not installed right, error!Resolute unloading load, the results of incomplete unloading, Reload will error!Now take a note of Oracle's complete uninstall method to prevent future errors!1, find the Start menu inside the run, enter "Services.msc", open the Service interface2. Stop all Oracle-related servicesAfter stopping:

tool to provide you oh ^ ^. So you have to learn another software is VNC. What the? You don't know about VNC? Then go to www.baidu.com or www.google.com to search for it. I personally like these two. Maybe everyone will have their own search engine! As for the use of VNC I do not have to teach it! Hey.......... For these reasons, I decided to install Oracle with the character interface under Linux or UNIX. (I haven't installed

In Oracle 10 Gb database applications, the UNDO tablespace is too large, leading to insufficient disk space and crash. After analyzing the problem, the main reasons for the problem are summarized as follows: 1. There is a large volume of transactions that allow Oracle Undo to automatically expand, resulting in excessive disk space occupation; 2. There are large transactions that have not been contracted or

this case you lose the contents of the block change tracking file. Until the next time you complete a level 0 incremental backup, RMAN must scan the entire file. Using the host operating system commands, move the change tracking file to their new location. Mount the database and move the change tracking file to a, location, and more space. For example:ALTER DATABASE RENAME FILE '/disk1/bct/rdbms/changetracking/o1_mf_2f71np5j_.chg ' to '/disk2/bct/rdbms/ Changetracking/o1_mf_2f71np5j_

oracle|unix| Data can unix Oracle 10g read file data with Utl_file packets? I am under Window Oracle 8i using Utl_file can read the data of text files, I test through, But not on Unix Oracle 10g! Error! Begin Loadfiledata (' D:\or

Oracle 10g rac standby automatic deletion script for archiving logs #! /Bin/bashExport ORACLE_HOME =/opt/oracle/product/10.2.0/db_1Export ORACLE_SID = standby1Export ARCHIVE_DIR =/log/archivelogExport LOG_FILE =/home/oracle/logs/del_archive.log If [! $1]ThenSn = 200ElseSn = $1Fi Echo "begin delete archivelog: 'date'...

Installing Oralce on Linux is cumbersome. The preparations before installation are as follows: Read more: Install Oracle 10g R2 in CentOS 6.3 (x32) 1. Check whether the rpm software package has been installed. Binutils-2.17.50.0.6-6.el5Compat-db-4.2.52-5.1Compat-libstdc ++-33-3.2.3-61Control-center-2.16.0-16.el5Gcc-4.1.2-42.el5Gcc-c ++-4.1.2-42. el5Glibc-2.5-24Glibc-common-2.5-24Libgnome-2.16.0-6.el5Libstdc