oracle 11g dba tutorial

Oracle began with the 11g, the log structure has made a relatively large adjustment, log storage directory and storage format has changed. The following summarizes the storage directory and directory structure for Oracle Database, Oracle snooping, ASM, and Oracle GI logs.1.

Tags: des style color data art reRecently installed in SOLARIS11 Oracle 11g database, originally thought is a family, installation should be very simple, the fact that I really can't think of, really twists,Now record it:1, download Sol-11-1111-text-x86.iso2, download P10404530_112030_solaris86-64_1of6.zip, P10404530_112030_solaris86-64_2of6.zip (This is the oracle11g version of 11.0.3.0, 11.0.1.0 version i

Oracle 11g two nodes RAC build a single instance DG Process Problems and Solutions I used to build a single-instance database of DG, and it was quite simple. Later I came to the company's first project to build a DG for RAC. I was confident that I was so confident that I had to go through all kinds of questions, baidu finally completed the task with great difficulty. The problems we encountered are describe

install ksh yum install libaio yum install libaio.i686 yum install libaio-devel yum install libaio-devel.i686 #yum install libgcc #yum install libgcc.i686 #yum install libstdc++ yum install libstdc++.i686 #yum install libstdc++-devel #yum install make #yum install numactl yum install numactl-devel yum install sysstat yum install unixODBC yum install unixODBC.i686 yum install unixODBC-devel yum install unixODBC-devel.i686 Create new user groups and users for database installation. groupadd oins

Official Document: Http://docs.oracle.com/cd/E11882_01/nav/portal_11.htm1: Basic EnvironmentRedhat Enterprise Linux 6.132bitMemory: 1GBDisk space: 30GB2: Check the required packages for Oracle 11g, if not found in the Redhat Enterprise Linux 6.1 installation CD, and then install.Oracle Official offer: http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm· binutils-2.20.51.0.2-5.11.el6 (x86_64)· c

the knowledge point outside, For example, online looking for information to read or do some of their own related practice. Next is the review, I basically refer to the "OCA-OCP Oracle 11g all-in-one Exam" to review and carefully completed each chapter after the practice, for the wrong topic not only to analyze the answer and to do a hands-on look. Finally, the exam, 051 for developers Basic is a piece of

Tags: Oracle 11g installationOracle 11g Installation1, modifying the Linuxshell parameterVi/etc/security/limits.confOracle Soft Nofile 65536Oracle Hard Nofile 65536Oracle Soft Nproc 16384Oracle Hard Nproc 16384modifying kernel parametersVi/etc/sysctl.confKernel.shmmax = 4046471168Kernel.shmmni = 4096Kernel.shmall = 2097152Kernel.sem = 250 32000 100 128Fs.file-max

I. Create an Oracle User1.root User: Create Oracle Installation Group Oinstall, DBA for DB Administrators group, and Oracle userThe command is as follows:[Email protected] ~]#/usr/sbin/groupadd Oinstall[[email protected] ~]#/usr/sbin/groupadd DBA[[email protected] ~]#/usr/sb

; ------------------------------------------------------------------------------------------------ 6. Create and manage rolesA role is not a schema object, is not owned by anyone, shares the same namespace with a user, and the role cannot have the same name.Predefined roles:· CONNECT: Only the Create session permission, which also has the system permissions for creating the Datastore object before 11g.· RESOURCE: You can create data objects and proc

/limits.conforacle softnproc 2047oraclehard nproc 16384oraclesoft nofile1024oracle hardnofile 65536grid Soft nproc 2047grid hard nproc 16384grid soft nofile 1024grid hard Nbsp;nofile 65536vim/etc/pam.d/login session requiredpam_limits.sovim/etc/profile if [/$USER = "Oracle"] | | [/$USER = "Grid"]; then IF [/$SHELL = "/bin/ksh"]; then ulimit-p 16384 nbsp Ulimit-n 65536 else nbsp ulimit-u 16384-n 6553

1002 runningUseradd-u 1000-G oinstall-G dBA, role OraclePasswd Oracle Mkdir-P/u01/APP/OracleChown-r ORACLE: oinstall/u01Chmod-r 775/u01 Log on to SFTP (using filezilla) with the new Oracle user to upload and download the database directory (extracted from two zip files) to u01/APP. At this time, everything is read

Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux 1. re-build the Oracle user group of the host and standardize uid gid to ensure the permission specification for shared storage mounting or other requirements Userdel-r oracleGroupadd-g 500 oinstallGroupadd-g 501 dbaUser add-g oinstall-G

OinstallGroupadd dbaTo create an Oracle user and password, enter the command:Useradd-g oinstall-g dba-moraclepasswd OracleThen will let you enter the password, the password any input 2 times, but must be consistent, enter the confirmationCreate database software directory and data file directory, directory location, according to their own situation, pay attention to disk space, here I put it under the

Tags: style blog http color using OS IO file0The first few in turn introduce the basic installation of CentOS and the installation configuration of common software, then we will challenge the installation configuration of Oracle 11g. Unlike previously installed software, because Oracle is not open source free software (need to purchase authorization to

-g oinstall-g dba,asmadmin,asmdba,asmoper gridModify the configuration file on R1, R2Vim/home/grid/.bashrcExport Oracle_base=/u01/app/OracleExport ORACLE_home=/u01/app/11.2.0/gridExport path=$ORACLE_home/bin: $PATHExport Oracle_owner=OracleExport Oracle _SID=+ASM1 #r2节点为 export Oracle_SID=+ASM2Export ORACLE_term=vt100Export Threads_flag=nativeExport ld_library_path=$ORACLE_home/lib: $LD _library_pathExport

How to SetOracle11gImport backup10g 11g Export Statement: expdp userid ='Facial/Facial@OrclAs sysdba 'schemas = facial directory = DATA_PUMP_DIRdumpfile = aa. dmp logfile = aa. log version = 10.2.0.1.0 The red text is rewritten as needed. For example, my usersFacialThe password isFacial, Database sid isOrclThe username to be exported by schemas isFacialTo import it to the Oracle database of version 10.2.0.

log switch occurs. The DBA can start the checkpoint process by modifying the ckeckpoint_process in the initialization parameter SPFile to TrueLog write process (LGWR)Writes data from the redo log buffer to the redo log file. The Oracle system first writes the user's modification log information to the log file, and then writes the result of the modification to the data file.Oracle instances generate a larg

1. Preparations for configuration in Linux Environment: Linux: RedHat Enterprise 5.4, DB: Oracle 11g R2 X64, Oracle installed in the/home/oralce_11 directory. The configuration process is as follows: (most of the content is online, and individuals follow the online steps) 1) Check the basic requirements (this must meet the requirements for the awesome server and

Oracle's official SQL Developer comes with Oracle migration Workbench. What is Oracle SQL Developer? On the official page, this is how it is presented: Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug

First, prepare the single instance database server1. Preparing the operating systemNote: It is recommended to install an Oracle database using the Oracle Linux operating system, which is the operating system for Oracle Linux 6.8.#关闭iptablesChkconfig iptables off#关闭selinuxVim/etc/sysconfig/selinuxSelinux=disabled#将主机名添加到hosts文件Vim/etc/hosts188.188.1.120 OracleDB#重