oracle 11g dba tutorial

In a new environment, the company needs to install RHEL (Red Hat EnterPrise Linux, the same below) 5.5 64-bit and Oracle 11g 64-bit in a virtual machine environment, so it has been tossing for three days, the pain, only the person who knows. Here, let's keep a note of the process, hoping that others will take less detours. First, on the virtual machine selection, the options are as follows: (1) The advantag

The concept of SCAN (Single Client Access Name) is introduced in the Oracle 11g RAC cluster, that is, the Single Client Access Name of the cluster. SCAN provides a single host name for the client to access the Oracle database running in the cluster. If you add or delete nodes in a cluster, you do not need to change the TNS configuration of the client that uses SC

Tags: redhat oracle InstallationUpload the Oracle installation file to the Linux server first1. Unzip the zipUnzip Linux.x64_11gR2_database_1of2.zipUnzip Linux.x64_11gR2_database_2of2.zip2. Create the installation directoryMkdir/opt/oracle3. Create a user group:Groupadd dbaGroupadd Oinstall4. Create a User:USERADD-G oinstall-g dba Oraclepasswd

for MigrationImpdp ityy_z1_w/z1_w123 directory = DATA_PUMP_DIR network_link = zqxt logfile = ityy. logThe execution result is as follows:Import: Release 11.2.0.1.0-Production on Friday June 28 16:52:03 2013Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Produc

PID (process identifier) to make sure. So we see the PID of this column identification, look at the 2720 corresponding process is who, if not, we put the following to show all users of the process front of the tick hit, As you can see, the image name is TNSLSNR.exe, and the description is that the main process of Windows is exactly the same as the command view above. 1.5 End the process: Select the process in Task Manager to click the "End Process" button, or enter it

I. Oracle pre-installation PreparationCheck the package and you must install it all:Binutils-2.20.51.0.2-5.43.el6.x86_64compat-libstdc++-296-2.96-144.el6.i686Compat-libstdc++-33-3.2.3-69.el6.x86_64Elfutils-libelf-0.161-3.el6.x86_64Elfutils-libelf-devel-0.161-3.el6.x86_64Gcc-4.4.7-16.el6.x86_64Gcc-c++-4.4.7-16.el6.x86_64Glibc-2.12-1.166.el6_7.3.x86_64glibc-2.12-1.166.el6_7.3.i686Glibc-common-2.12-1.166.el6_7.3.x86_64Glibc-devel-2.12-1.166.el6_7.3.x86_6

= "American_america" in the. Bash_profile in the/home/oracle and/root user directories. UTF8 "statement to close the current SSH window. Drop tablespace ts_data including contents and datafiles; Create tablespace ts_data logging datafile ' D:\tablespace\TS_DATA.dbf ' size 50m autoextend on next 50m maxsize 20480 m extent management local; Drop user User1 cascade; Create user user1 identified by 123456 default Tablespace ts_data; Grant Connect,r

Oracle 11g Flashback Data Archive (flash back Data archiving) UNDO tablespace record rollback information although it can provide flash back query, but for a long time, this information will be overwritten. In fact, as long as the transaction is committed, it will become a writable object. Therefore, when performing a transient query, we will receive the 1555 error because we cannot find the undo block, and

Label:1.Linux Environment Configuration Preparation Environment: Linux:redhat Enterprise 5.4,db:oracle 11g R2 x64,oracle installed into the/home/oralce_11 directory. The configuration process is as follows: (mostly online content, individuals also follow the online steps) 1) Check the basic requirements (for the cool server, this must be satisfied with the requirements, can skip)Memory sizegrep memtotal/pro

1. installation environment: Fedora 10 (kernel version: 2.6.27.5-117. fc10.i686) Oracle Database 11g Release 2 (11.2.0.1.0) (Register and download the corresponding Linux x86 version on the Oracle website) 2. References: Oracle Database 11g Release 2 (11.2) Installation On E

Label:1. Installing Logminer Run the following 2 scripts as DBA users: Dbmslm.sql is used to create a DBMS_LOGMNR package to parse the log file. sql> @ $ORACLE _home/rdbms/admin/dbmslm.sql; Package created. Grant succeeded. Synonym created. Dbmslmd.sql is used to create a dbms_logmnr_d package that is used to create a data diction

One, the database Management Section 1. Database replay (DB replay) This feature captures the load of the entire data and passes it on to a test database created from a backup or standby database, and then repeats the load to test the effect of the system tuning. 2. SQL Replay (Sqlreplay) Similar to the previous feature. But just capture the portion of the SQL payload, not the full load. 3. Planning Management (Plan Management) This feature allows you to fix the query plan for a particular

rights reserved.Please enter username: infomgr Enter password:Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mining and R EAL Application Testing OptionsSql> Show Parameter Deferred_segment_creationNAME TYPE VALUE----------------------------------------------------------------- ------------Deferred_segment_creation boolean FALSE sql> fro

distribution of the extents and segments of the example table spaceThe smallest unit of storage in an Oracle database is a block of data in a--8kb,oracle database that is stored in a data block. The data block is the smallest storage unit that the Oracle server can read or write, and the Oracle server manages the stor

Label:--Create TABLE space CREATE tablespace RH_DMRM (table space) DataFile ' G:\Oracle\data\dmrm1.dbf ' size 800M reuse autoextend on next 5M MaxSize Unlimited, ' G:\Oracle\data\dmrm2.dbf ' size 20M reuse autoextend on next 5M MaxSize Unlimited, ' G:\Oracle\data\dmrm3.dbf ' size 20M reuse autoextend on next 5M MaxSize Unlimited, ' G:\

Solve the problem that the database cannot automatically collect statistics due to Oracle 11g installation. Recently, it was found that some Oracle 11g databases could not automatically collect statistics. Some View query results are as follows: SQL> select client_name, status from dba_autotask_client where client_name

Simple Steps for installing Oracle 11g R2 (11.2.0) on RHEL5.5 1) required rpm for installation:# Rpm-UvhBinutils-2.17.50.0.6Compat-libstdc ++-33-3.2.3Elfutils-libelf-0.125Elfutils-libelf-devel-0.125Elfutils-libelf-devel-static-0.125Gcc-4.1.2Gcc-c ++-4.1.2Glibc-2.5-24Glibc-common-2.5Glibc-devel-2.5Glibc-headers-2.5Kernel-headers-2.6.18Ksh-20060214Libaio-0.3.106Libaio-devel-0.3.106Libgcc-4.1.2Libgomp-4.1.2Lib

Label:How to start OracleOne of the services in Windows system Services is called: "Oracleservice[sid]" SID is your instance name when you install Oracle XE, and if you do not change the default is "XE", Oracleservicexe and Oraclexetnslistener automatically start by default, find the "Oracleservicexe" this service, start it OK.Navicat for Oracle connection settings Log in using Sqlplus (password set yourse

I. Overview Performance risks may occur when the SQL Execution Plan of an SQL statement is changed. There are many reasons for changing the SQL plan, such as the Optimized Program version, optimized program statistics, optimized program parameters, solution definition, system design, and SQL profile creation. In earlier versions of Oracle DB, various plan control technologies (such as storedoutline (9i) and SQL profile (SQLprofile (10g) were introduce

1,oracle Default user name, passwordUsername/Password Login identity (role) descriptionSys/change_on_install SYSDBA, Sysoper cannot log in as NORMALSystem/manager NORMAL cannot log in with SYSDBA, SysoperScott/tiger Normal Normal User2, user sys and system Sys : sysdba(System administrator) Sysoper(System Operator) dba(Database Administrator role) system : DBA(