oracle 11g dba tutorial

Selection:32-bit memory is a bottleneck, it is already 64-digit era. Use 64-bit CentOS6 and 64-bit Oracle 11g R2In the virtual machine installation, use the Hostonly way to set up the networkNote: The Internet adapter will be able to set up ICS (Internet Connection Sharing) to VMware network Adapter VMnet1So for the virtual machine, the gateway is 192.168.137.1,IP address please also set in 192.168.137.0/24

+ ---------------- Install and configure Oracle 11g R2 on centos 5.5 ----------------- ++ -------------------------------- By kerryhu ------------------------------------ + I. Runtime EnvironmentSystem Environment: centos 5.5 32-bit (graphical installation)Hard Disk Partition:/Boot 150 mSwap 4096 M (at least 3 GB)/10g/Home 5g/Tmp 5g/Usr 10g/Usr/local 10g/Var 10g/OPT 10g/Data all remaining DF-H # S

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 protected] ~]# Groupadd oper[Email protected] ~]# useradd-u600-g Oinstall Oracle[Email protected] ~]# usermod-g dba,oper

BKJIA featured translations] Oracle 11g R2 extends many new feature suites for backup and recovery, including recovery manager RMAN, many of which are extensions for earlier features. BKJIA editing recommendations: New features and application details of Oracle 11g Automated block recovery. In my opinion, the block-lev

The new generation of Oracle will add many exciting new features. The following describes some new features of oracle11g.1. Database Management· Database Replay)This feature can capture the load of the entire data and pass it to a test database created from the backup or standby database, and then replays the role of testing the system after optimization.· SQL replay (SQL replay)Similar to the previous feature. However, it only captures the SQL load,

committed on the master database depends on whether the transaction is accepted on standby and whether the log data on the application is applied. Therefore, data may be lost during Failover. As a DBA, we need to consider how to protect data and reduce data loss (Gap) as much as possible when the site of the Primary site permits (because the fault of the Primary is unknown ).This article mainly demonstrates the Failover process. References: Important

. bridge-nf-call-iptables" is an unknown keyError: "net. bridge. bridge-nf-call-arptables" is an unknown keyNote: The value of kernel. shmmax's is half of the physical memory. My memory is 2 GB, so it is 1073741824Step 2: vi/etc/security/limits. conf, add:OracleSoft nproc 2047OracleHard nproc 16384Oracle soft nofile 1024Oracle hard nofile 65536Step 3: vi/etc/pam. d/login. Add the following parameters:Session required pam_limits.so step4: vi/etc/profile:If [$ USER = "

Oracle 11g, oracle11g General requirements for software environments RHEL 5. x System and RHEL 6. x System Graphical desktop environment + development tools + Chinese Java support -- When installing in RHEL 6. x, ksh needs to use the 5. x software package instead. Preparations: Yum install yum * Yum groupinstall "X Window System" "desktop platform" "Chinese support" "development tools" [Root @ dbserver ~]

Tags: OracleThis blog post focuses on installing Oracle 11g in a CentOS environment. The system environment is CentOS7.2.Pre-installation Environment preparationTo install the required packages:Yum install binutils compat-libcap1 compat-libstdc++ gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel LIBGCC Libs tdc++ libstdc++-devel libxi libxtst make Sysstat unixodbc-devel-yYum install binutils* compat-lib

Tags: replace alt offline routines personal Oracle Ogre Knowledge UserSource: http://blog.csdn.net/liverliu/article/details/6410287 First: The cause of the problem, I previously in the f:/llh/directory created a bookspace table space, and later do not want this table space, so I deleted directly, this error is because I will f:/llh/bookspace.dbf and so on a few files deleted after the appearance.Second, the phenomenon: Sql*plus Unable to connect, the

will appear when the Java exception# to log on as the root user/usr/sbin/Groupadd dba/usr/sbin/Groupadd Oper/usr/sbin/groupadd oinstall# Adding Oracle user useradd Oracle/usr/sbin/usermod-g Oinstall-G dba oracle# add password to Oracle