qsfp 10g

whole database backup available to you. which two statements are true in this scenario? (Choose two .) A) The instance aborts. B) The database cannot be recovered. C) The database can be recovered by restoring the control files from the backup. D) The database remains opened and you have to shut it down with the ABORT option. E) The database can be restored till the point of the last closed whole database backup. Answer: AE 127. While running the Oracle Universal Installer on a Unix platform t

control file. D. The trace file contains the instructions to manually re-create the control file. E. The trace file is an image copy of the control file created during the backup of the control file. Answer: B Online Documentation: An alternative to the create controlfile statement is alter database backup controlfile to trace, which generates a SQL script in the trace file to re-create the controlfile Http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5003.htm 5. While r

Since Oracle version 10g, data Pump is provided as a new data mobile technology. The technical tools are expdp and impdp respectively. We often use them in actual projects, such as migrating data from the production database to the test database. I will introduce the usage, usage, and differences between these two tools and the imp/exp of 9i. Expdp and impdp have three main purposes: 1. implement logical backup and recovery of databases; 2. Move datab

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 requires a separate configuration file. In additi

Install Oracle 10g RAC with 64-bit redhat4.8_64 under VMware-simple script I. Preparations 1. System Information [Root @ r4r4o10n1 ~] # Uname- Linux r4r4o10n1 2.6.9-89.EL #1 Mon Apr 2010:edt 2009 x86_64 x86_64 x86_64 GNU/Linux VM: vmware workstation9 OS: redhat4.8 DATABASE: ORACLE10201 2. Configure the network [Root @ r4o10n1 ~] # System-config-network [Root @ r4o10n1 ~] # More/etc/hosts # Do not remove the following line, orvarious programs # That re

Today, we will introduce the entire process of installing Oracle 10 Gb in Red Hat Enterprise Linux AS 5.4. 1. Download Oracle 10g First, describe in detail my environment, system: Virtual Machine Red Hat Enterprise Linux AS 5.4, Database: Oracle Database 10g Release 2 (10.2.0.1 ). Go to the official website to download Oracle. The downloaded file is 10201_database_linux32.zip. Ii. configuration before 10 Gb

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)Role of Wallet Starting from Oracle 10g R2, any user can log on to the database without a password by using Oracle Wallet (non-operating system authentication ), this is very useful for scripts that use user passwords to log on to the database for operations in shell, and does not expose the user password. for example, on the Oracle clientMkstore command settingsThe Wallet authentication information can be directly connected to the database through

= 262144 Kernel. shmall = 2097152Kernel. shmmax = 2147483648 # modify according to the actual situation, usually twice the memoryKernel. shmmni = 4096# Semaphores: semmsl, semmns, semopm, semmniKernel. sem = 250 32000 100 128Fs. file-max = 6815744Fs. aio-max-nr = 1048576Net. ipv4.ip _ local_port_range = 9000 65500Net. core. rmem_default = 4194304Net. core. rmem_max = 4194304Net. core. wmem_default = 262144Net. core. wmem_max = 10448756 2.Vi/etc/security/limits. confOracle soft nproc 2047Hard

42424 4096 Oct 23 2005 database-Rw-r -- 1 root 801603584 Oct 14 2009 10201_database_linux_x86_64.cpio2. Create a software installation environment2.1 create an Oracle account and directory:Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/--> [root @ Fantasy ~] # Groupadd oinstall[Root @ Fantasy ~] # Groupadd dba[Root @ Fantasy ~] # Useradd-g oinstall-G dba oracle[Root @ Fantasy ~] # Passwd oracleChanging password for user oracle.New UNIX password:B

Oracle 10g environment variables for NLS have changed a bit: For RDBMS 7.2.x version the variable is called ORA_NLS.For version 7.3.x the variable is called ORA_NLS32. For Oracle 8, 8i and 9 variable is called ORA_NLS33. For Oracle 10g the variable is called ORA_NLS10. ORA_NLS33 setting value: ORA_NLS33 = $ ORACLE_HOME/ocommon/nls/admin/data ORA_NLS10 only needs to be set: ORA_NLS10 = $ ORACLE_HOME/n

Oracle 10g SQL paging query statement and Efficiency Analysis When using the Oracle database for paging query algorithm design, the paging query SQL statements can basically be applied according to the template given below:Paging Query format:SELECT * FROM(Select a. *, ROWNUM RNFROM (SELECT * FROM TABLE_NAME)Where rownum )Where rn> = 11 SELECT * FROM TABLE_NAME indicates the original query statement that does not flip pages. ROWNUM The paging query st

Oracle 10g one master multiple slave construction skills In the Oracle database environment, one-master-one-slave mode is a traditional method of use. In case of a disaster, you can flexibly switch the master-slave role to maintain service accessibility. However, some core systems still have more filters, and one master and one slave seem to be unsecure. If there is a problem with the master and slave databases, there is still room for choice if there

Oracle 10g quick manual database creation steps, oracle10 g manual database creation steps0. Modify Environment Variables[Oracle @ ocm1 ~] $ Vi. bash_profileAdd the following content: export ORACLE_SID = PRODExport ORACLE_BASE =/u01/app/oracleexport ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1export PATH = $ ORACLE_HOME/bin: $ ORACLE_HOME/jdk/bin: $ PATH1. Modify the logon identifier and Default Editor (optional)Modify $ ORACLE_HOME/sqlplus/admin/g

Install Oracle 10g client for Linux under fedora6 1. Ignore system check./Runinstaller-ignoresysprereqs 2. The error message "libxp. so.6" is missing.Yum-y install libxp. so.6 Run again. OK. The installation page is displayed. 3. Oracle 10g does not support Chinese characters by defaultChange Lang in/etc/sysconfig/i18n to EN during installation. 4. Oracle client does not support UTF-8 EncodingAfter i

After the computer name is changed, all Oracle services cannot be started.We recommend that you do not modify the computer name at will, because it is troublesome to modify many Oracle configurations after you modify the computer name. My original computer name is 53m6df34f7.The modified computer name is sgliuya2. First, solve the oracledbconsole * service.Run the command emctl start dbconsole In the CMD window and the following information is displayed: C:/Documents and Settings/LiuYa> emctl st

Originally, I only wanted to install an Oracle client with the imp/exp command. However, instantclient does not have these two commands and does not want to download 10 Gb client software of over 600 mb, which is also troublesome to install. The 10g express edition is found, and the Deb installation package for Debian is also available. I am from Hangzhou. Because it is necessary to support Chinese characters, it is natural to use the universal versio

to modify the Oracle 10g RAC Listener Port number 1523OneModify the Listener.ora to change the 1521 to 1523. Make a backup of the file in advance for quick recoveryTwoModify the Tnsnames.ora, change the remote_listener corresponding value in the Tnsnames.ora parameter to 1523, make a backup of the file in advance for quick recoveryThreemodifying Local_listener database initialization parameters alter system set Local_listener = ' (ADDRESS = (PROTOCOL

common maintenance commands for Oracle 10g Dataguard. Basic common 1. Stop standbySelect process, status from V$managed_standby; --See if the standby is restored in the application logALTER DATABASE recover managed standby database cancel;Shutdown immediate;2. Switch to read-only mode-----switched from Shutdown mode to read-only mode-------Startup Nomount;ALTER DATABASE mount standby database;ALTER DATABASE open read only;-----switched from Applica

An error occurred while installing the Oracle 10g database, previously installed on the Windows7, and now share the solutions and reasons for the problem. Installation behavior: 1. Install the default path that is different from before. Formerly: d:oracleproduct10.2.0 or f:oracleproduct10.2.0 Now: c:userscynthiaoracleproduct10.2.0 2. After entering the password next time, install oracle10g "program abnormally terminated." An internal error has oc