xfp 10g

Solve the problem of EM,DBCA Chinese block garbled in Oracle 10g database under Linux Today in Linux installed Oracle 10g database, installed after the Linux system language switch to Chinese, found Oracle's EM (Enterprise Manager), DBCA (Database configuration Assistant Chinese interface, buttons are all squares or garbled, very people headache. Through Google, Baidu to find the reason, after many attempt

functionality of this feature, I recommend that you read Oracle magazine's article "Use VPD to keep information private". Policy type The repetitive analysis required to generate a predicate is an overhead that can be trimmed in some cases. For example, in most cases the predicate is not static as Am_name = ' SCOTT ', and it may be more dynamic based on the user's identity, the user's level of authority, and the account manager is reporting to. The string created and returned by the policy fu

This article focuses on the complete steps for creating a tablespace for Oracle 10g, including the creation and deletion of tablespaces, the creation of users for the app, and the granting of permissions, to help you. AD:WOT2014: User labeling system and user data Operation training sessionIn Oracle 10g databases, when creating users in a database, it is best to create separate tablespaces for different use

In the linux,oracle 10g/11g x64bit Environment, a script that goldengate automatically starts with the OS startupBackground Description:Goldengate installed in the/u01/ggs directoryrhel5.5 Oracle 10g/11g X64bitOracle GoldenGate Command interpreter for oracleversion 11.1.1.0.0 Build 078Linux, x64, 64bit (optimized), Oracle one on Ju L 28 2010 13:13:42To implement the Goldengate auto-Start process:1. Establis

Windows7 Install Oracle 10g Prompt "program aborted, an unknown error occurred" workaround1. 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=256#Minimum CPU speed required f

Label:The story of Ash and awr 1.1 About Ash As we all know, when a user performs an operation in an Oracle database, it is necessary to create the appropriate connection and session, where all current session information is saved in the dynamic performance view v$session, where the DBA can see what the user is actually doing, or the current wait event. This part of the information is usually the key information in the tuning process, however, once the connection is broken. The session informati

/10.2.0/db_1/cfgtoollogs/opatch/opatch2016-03-29_16-10-36pm.logPatch history File:/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txtLsinventory Output file Location:/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/ Lsinventory2016-03-29_16-10-36pm.txt--------------------------------------------------------------------------------Installed top-level products (2):Oracle Database 10g 10.2.0.1.0Oracle Database

Tags: style blog color os io using AR for dataMetalink Note 283107.1 describes how to set up an IPMP for a VIP, where the setup process is recorded. o Existing 10g RAC installation ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ the ^^ ^^ ^^ ^^ ^^ ^ for Existing 10g RAC installations, use SRVCTL to Modify the VIP to use all the NIC ' s within the same IPMP group. The following example is configuring the VIP for

A colleague creates an instance on Oracle 10g, and at the end of the page, an error pops up, prompting for a failed listener. View the service without generating a listening service. So I deleted it, tried it several times, and so on.It's really upsetting. The hint says port 1521, is this port occupied? With the Netstat-aon command looked down, and did not. And there is no place to set up the port during the creation of the instance.Later, the net man

Oracle 10g Advanced Replication instances (multi-agent replication)Objective:Configured three times, two is one way. The last time is finally two-way. Also a little bit of success in the joy. Joy? Joy does not. It's such a simple thing that I feel ashamed for so long. A lot of data on the network. But they seem to have a bit of a casual writing. Sometimes a little bit of error can make you only have to redo. I'm going to write it again. Available only

Tags: UIL mini ted Options win2003 2.0 dba Grant IAThave been trying to find out the way ORCL right, today tested a 10g, you can successfully put right. c:\wmpub>sqlplus scott/[email protected] Sql*plus:release 10.2.0.1.0-production on Monday October 31 07:41:29 2016 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connect to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-productionWith th

Label:Installs 64-bit Oracle 10g Ultra-Detailed tutorial 1. Installation Preparation phase 1.1 installing the Oracle EnvironmentAfter the previous blog post, the installation of the Linux system has been completed, this example uses X-manager to implement a connection to the Linux system, and all the commands and operations used in this example are performed under X-manager. X-manager after the installation is complete, the following configuration met

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