oracle 11g dba tutorial

Groupadd OinstallGroupadd dbaGroupadd OperGroupadd AsmadminGroupadd ASMDBAGroupadd AsmoperUseradd-g oinstall-g dba,asmdba,asmadmin,asmoper GridUSERADD-G oinstall-g DBA,OPER,ASMDBA Oraclepasswd gridpasswd OracleMkdir-p/u01/app/11.2.0/gridMkdir-p/u01/app/gridMkdir-p/u01/app/oracleChown Grid:oinstall/u01/app/11.2.0/gridChown Grid:oinstall/u01/app/gridChown-r oracle:oinstall/u01/app/oracleChmod-r 775/u01/Chown-

Tags: strong software proc Elf terminal. So data BMS kernelSUSE11 virtual machine installation with Oracle 11g installation All the parameters required in this article are in the appendix to the end of this document.Create a new virtual machine, select SUSE11 After you start the virtual machine, select the second installationSelect languageSkip a CD CheckChoose a New InstallationSelect the default physical

pam_limits.so at the end Adding profile environment Profiles #vim/etc/profile at the end of the add if [$USER = "Oracle"] | |[$USER = "Grid"];thenif [$SHELL = "/bin/ksh"]; Thenulimit-p 16384ulimit-n 65536elseulimit-u 16384-n 65536fiumask 022fi Create users and groups and create the appropriate passwords #/usr/sbin/groupadd-g 501 OINSTALL#/USR/SBIN/GROUPADD-G 502 dba#/usr/sbin/gr

Label:First, download the official Oracle website, you can download the latest version of Oracle Database 11g release2http://www.oracle.com/index.htmlCentOS5.5I386 32-bit---Linux x86========================find a way to transfer the following 2 files into the Linux operating system Linux_11gR2_database_1of2.ziplinux_11gR2_database_2of2.zip to use a software filez

background processes.B.orae grid Infrastructure (grid base layer, grid foundation software, cluster Software): is a software, responsible for managing nodes in the cluster, various resources and storage management, is the basis of RAC. Install the GI first and then install the RAC. GI can then be divided into:A. Oracle clusterwareB. Automated Storage Management ASM (Oracle Automatic Storage Management) for

Oracle Database 11g performance optimization strategy-optimizing Table PerformanceIntroduction 1-1 Create a database with optimal performance problem description www.2cto.com you realize that when you first create a database, there are some attributes (if enabled) it will have a long-term impact on the performance and availability of tables in the database. Specifically, when creating a database, you need t

Tags: mount character rom echo dia article RAC get preService-side Character Set modification 1, confirming the service-side character set1 Select userenv ('language' from dual;2. Modify the service-side character set to first log in to Oracle as a DBA. Run commands directly under the Windows system under the command lineSqlplus/as sysdbaor run the command under SQL PLUS/as sysdba。 Then run the command in t

Test environment: VMware Workstation V6.5.1, Oracle Database 11g Release 2 (11.2.0.1.0) Enterprise/Standard Edition for Linux x86-X64 Intel Core2 P8700 2.53 gb cpu, 1 GB memory, 40 Gb hard disk. Use the Virtual Machine installation method. First, download the oracle_data warehouse Installation File linux.x64_11gr2_database_1of2.zip linux.x64_11gr2_database5of2.zip on the official website. Http://www.ora

Reference article: http://tutorialforlinux.com/2016/03/09/ how-to-install-oracle-11g-r2-database-on-ubuntu-14-04-trusty-lts-64bit-easy-guide-managing-db-troubleshootings/Reference article: http://m.oschina.net/blog/318293I. Get the resource bundle, download the 64-bit version of the website yourself, a total of two compressed packages: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/

/packages/4. Install with RPM-IVHPS: Increase virtual memoryDD If=/dev/zero of=/swapadd bs=1024 count=4524288 create partition fileMkdir/mnt/swapCD/MV Swapadd/mnt/swapMkswap/mnt/swap/swapadd setting up swap filesSwapon/mnt/swap/swapadd Enabling virtual memoryFree-mSwapoff-v/mnt/swap/swapadd When you do not need to use the new virtual memory############################################Write/etc/fstab so that it is enabled at boot time:/mnt/swap/swapadd swap swap defaults 0 02. Create users and Gro

Oracle 11g Release 2 Basic login operations after new installation, oracle11g First, you can select either desktop or server. The desktop class is relatively simple and requires no configuration. During installation, you are prompted to enter the password of the SYS user. For the server class, you can configure everything, including several sysdba passwords. Enable SQL plus when you want to log on with th

Oracle 11g installation causes the database to fail to automatically collect statistics, oracle11g Recently, it was found that some 11 GB 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 = 'Auto optimizer stats collect ';CLIENT_NAME STATUS---------------------------------------------------

Oracle 11g online reconstruction table Before Oracle9i appeared, you can only re-define the table by moving or exporting and importing the table. Therefore, the table redefinition process may be quite long or offline, during this period, the application will fail to operate on the table. Besides this, if exp is used, we cannot guarantee that the data in the table is not changed (unless it is a single user)

Hand first need to download oracle11g patch installation package, generally only paid users to obtain the installation package, other users can not get, how to do?Omnipotent Internet can do, can use http://www.wangpansou.cn/all other users put in the network disk inside the patch pack, is not very hanging?Oracle 11g Official Download version is 11.1 of the vulnerabilities are many, if you need to download a

++-33 Curl Curl-devel elfutils-libelf-devel.x86 _64#安装桌面环境 (later with graphical installation)Yum groupinstall-y "desktop" "Desktop Platform" "Desktop Platform Development" "Fonts" "General Purpose Desktop" "Graphical administration Tools" "Graphics Creation Tools" "Input Methods" "X Window System" "Chinese support [zh]" " Internet Browser "Yum-y Install Xorg-x11-driversYum-y Install Unzip4. Create the system groups and users required to install OracleCreate an

click on the number of buttons: Start debugger or press F9;3), Last click: RUN or Ctrl+r.debugging shortcut keysToggle Breakpoint: Ctrl+bStart: F9Run: Ctrl+rSingle Step Into: Ctrl + NStep Skip: Ctrl+oSingle Step exit: Ctrl+tRun to Exception: Ctrl+y8. Template shortcut keys9. My Objects is automatically selected by default after loginBy default, after Plsql developer is logged in, Brower will select all objects, and if you are logged on as a DBA, you

Oracle 11g backup-based rman duplicate Backup-based rman duplicate command to create standby databasePrerequisites: ensure the backup of the original database and archive is completely visible to the standby end,It is assumed that the storage structure of all files, such as the source database and the target database, and log files, are identical;Configure the master database and the slave database for stat

#!/bin/bash#Purpose: Create and config Oracle install.#Usage: Log on as the superuser (' root ')#1. Create groups and users.Groupadd DBA-G 111Groupadd Oinstall-g 110Useradd oracle-u 110-g 110-g 111echo "Oracle" | passwd--stdin Oracleecho "Export tmp=/tmp" >>/home/oracle/.bas

650) this.width=650; "Src=" http://www.vuln.cn/wp-content/uploads/2016/05/616b40704337a0eebeb0cf9f825ca9d5.jpg " alt= "616b40704337a0eebeb0cf9f825ca9d5.jpg"/>The installation interface just popped up when Oracle was installed with the following error. This is because the hosts file does not have a host name set.Because I do not own the time, here directly to share with you a tutorial on the Web, the content

Getting Started with Oracle 11g installationModify Shell LimitsVi/etc/security/limits.conf---------------------------------------------Oracle Soft Nofile 65536Oracle Hard Nofile 65536Oracle Soft Nproc 16384Oracle Hard Nproc 16384modifying kernel parametersVi/etc/sysctl.conf---------------------------------------------Kernel.shmmax = 4046471168Kernel.shmmni = 4096