oracle 11g dba tutorial

Tags: capacity www. Lib BST ksh opening an ace share pictureReference article:Http://www.cnblogs.com/lightnear/archive/2012/10/07/2714247.htmlHttp://www.cnblogs.com/xqzt/p/5456401.htmlHttp://www.cnblogs.com/anzerong2012/p/7528311.htmlFirst, installation environmentCentOS Linux release 7.2.1511 (Core)Oracle Database 11g Release 2 (11.2.0.4)Second, before the installation of 2.1 modify host nameModify the hos

Tags: Oracle Linux virtual machineEnvironment:(1) Linux localhost.localdomain 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 11:47:41 EST. x86_64 x86_64 x8 6_64 Gnu/linux(2) Memory: 2G(3) HDD Capacity: 30G(4) The system must have a desktop(5) Yum is well-equipped in advance.(6) If you are working on a virtual machine, make a mirror first before performing the following steps.Steps:#!/bin/bashFor i in ' cat 1.txt ';Do Yum install-y $iDone#Groupadd OinstallGroupa

/security/limits.confAdd content below: and save exitOracle Soft nproc 4096 Oracle hard nproc 16384 oracle soft Nofile 4096 Oracle hard nofile 65536 oracle soft stack 10240 6. Modify the/etc/pam.d/login file, enter the command: Gedit/etc/pam.d/login, and ad

"rolling upgrade" for ORACLE11g and later versions. In other words, you cannot use this function to upgrade ORACLE10g databases to 11G. Before performing a rolling upgrade, make sure your environment is ready. For example, if you use the ORACLE Clusterware software, you must complete the upgrade to the next version that meets the requirements before rolling the upgrade. Of course, you should also use the r

[-Z ' $PACKINSTALL '];then????? true?? else?? echo "The followling packages would be install: $PACKINSTALL"??? read-p "Continue? (y/n): "Answer?? case $answer in? ? ? ? ([yy]| [Yy] [Ee] [Ss])??????? Echo 1??????. yum-y install $PACKINSTALL;;? ? ? ? (*);;?? esacFiCat/etc/group |grep oinstall >/dev/null | | /usr/sbin/groupadd OinstallCat/etc/group |grep dba >/dev/null | | /usr/sbin/groupadd DBAID Oracle >/de

Level 9Bmb, 9,' 2nd level BMB ', ten,' 3rd level BMB ', one,' Bitmap block ', A,' Bitmap index BTenLock, and' File header block ', +,' Unused ', and,' System Undo Header ', +,' System und OneO Block ', +,' Undo Header ', ,' Undo Block '), count,time from x$kcbwait where IND AX!=04: Understand data file information of Oracle system by querying Dba_data_files data1[Email protected] ~]$ Sqlplus/as sysdba;2 3Sql*plus:release 11.2.0.3.0 Production on Th

soft nofile 1024oracle hard nofile 65536grid soft nproc 2047grid Hard Nproc 16384grid soft nofile 1024grid hard Nofile 65536[Email protected] ~]# Vi/etc/pam.d/loginSession required pam_namespace.so #下面添加一条pam_limits. SoSession required/lib64/security/pam_limits.soSession required/lib/security/pam_limits.soSession Required Pam_limits.sostep-7# creating users and Groups[Email protected] ~]# Groupadd Oinstall[[email protected] ~]# Groupadd DBA[Email pro

An overviewTwo-SQL planning baseline Plan Baseline architectureThree-load SQL plan baselinesFour Evolutionary SQL plan baselinesFive important baseline SQL plan propertiesSix-SQL Plan selectionSeven possible SQL plan manageability ScenariosEight SQL performance analyzers and SQL plan baseline scenariosNine automatically load SQL plan baseline scenariosTen clear SQL Management library policiesA OverviewThere may be a performance risk when a SQL statement's SQL execution plan changes.There are man

Tags: Oracle Linux due to project requirements, the need to install Oracle 11g on 64-bit Linux systems, a lot of content on the Internet, combined with their own practical experience, finally installed successfully, recorded, and shared to the needy comrades. First, installation Preparation If you are using a text-interface Linux, install the Linux GUI first. Bec

will automatically create an event (incident), capture information related to the event, and automatically perform database health check and notify DBA. In addition, this information can be packaged and sent to the Oracle Support Team.◆ Incident Packaging Service)If you need to further test or retain relevant information, this feature can package information related to an event. You can also send the packa

65500 Fs.file-max = 6815744 Kernel.shmall = 10523004 Kernel.shmmax = 6465333657 Kernel.shmmni = 4096 Kernel.sem = 250 32000 100128 net.core.rmem_default=262144 net.core.wmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_max=1048576 FS.AIO-MAX-NR = 1048576 # sysctl-p #从配置文件 "/etc/sysctl.conf" load kernel parameter settings # sysctl-a #查看所有系统变量 # vi/etc/security/limits.conf #末尾添加如下: Oracle Soft Nproc 2047