oracle 11g dba tutorial

started.Total System Global area 236000356 bytesFixed Size 451684 bytesVariable Size 201326592 bytesDatabase buffers 33554432 bytesRedo buffers 667648 bytesDatabase mounted.Database opened.Sql> select * from V$nls_parameters;SlightlyRows selected.We see that this process is identical to the internal procedure of the alter DATABASE CHARACTER set operation, which means that the help provided by Internal_use is to makeThe Oracle database bypasses the ch

Kernel.shmmax = 2147483648 Kernel.shmmni = 4096 Kernel.sem = 32000 Net.ipv4.ip_local_port_range = 9000 65500 Net.core.rmem_default = 4194304 Net.core.rmem_max = 4194304 Net.core.wmem_default = 262144 Net.core.wmem_max = 1048576 5) Edit/etc/profile, enter the command: Vi/etc/profile, Press the I key to enter the editing mode, the following content to join the file. if [$USER = "Oracle"]; The

sysconfig] # rpm-qa | grep unixODBC UnixODBC-devel-2.2.14-11.el6.i686 UnixODBC-2.2.14-11.el6.i686 Modify the kernel parameters and run sysctl-p to make the modification take effect. [Root @ redhat ~] # Vi/etc/sysctl. conf Kernel. shmall = 268435456 Kernel. shmmni = 4096 Kernel. sem = 250 32000 100 128 Net. ipv4.ip _ local_port_range = 1024 65000 Net. core. rmem_default = 4194304 Net. core. rmem_max = 4194304 Net. core. wmem_default = 262144 Net. core. wmem_max = 262144 Fs. aio-max-nr = 1048576

Tags: oracle oracle 11g Redhat DatabaseFor beginners who want to learn Oracle, see the veteran. Operating System Information: VBox virtual machine software version: Install the required software: Required Software:Http://pan.baidu.com/s/1mgl8kzu Specific installation steps:A. Create a new virtual machine and install

When Oracle 11g is exported using EXP, empty tables cannot be exported, and 11 gexp I. cause:There is a new feature in 11G. When the table has no data, no segment is allocated to save space.1. insert a row and then roll back to generate a segment.This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be export

The new cloud host environment, the system is CentOS 7 x86_64, needs to be installed on the installation of oracle11.2g. Groping for a long time, finally toss the fix.Download Oracle : Oracle 11.2.0.2 (only download 11.2.0.2 because it is not a paid user, cannot download the latest 11.2.0.4. 囧 After downloading, there are two compressed packages: Linux.x64_11gR2_database_1of2.zip

First install CentOS6.0 ============== Not to mention. Install it. The only thing to note is that the Checking the Software Requirements section in the Oracle 11G Installation guide will require the Installation of some Software. These software are available in CentOS6 DVD images. You can configure the repos of a DVD image by yourself. The command format is as follows:Rpm-qa | grep nameBinutils-2.17.50.0.6

Use BBED for Oracle 11g Compilation Environment: RHEL 6.4 + Oracle 11.2.0.4 1. Copy the missing file 2. Compile BBED 3. BBED Test Reference 1. Copy the missing file Several related files are missing in 11g, but we can actually copy the related files from 10g to the corresponding directory of

Logonpasswords is not case sensitive.If the user is importing from Oracle 10g, then the value of Password_versions is "10G", and maintaining a case-sensitive password does not depend on the Sec_case_sensitive_logon parameter setting. Assuming that the Sec_case_sensitive_logon parameter is set to True, the password becomes immediately case sensitive.Sql> SELECT * from V$version whererownum=1;BANNER------------------------------------------------------

Install Oracle 11g on CenOS1. System check 1.1 memory requirements:Memory I set 1.5 GB (unit: 4 GB memory)# Cat/proc/meminfo // view memory size1.2 requirements for swap partitions:Swap partition is 1.5 times the memory, which can be adjusted according to the actual situation# GrepSwapTotal/proc/meminfo // view swap partition size1.3 hard disk space requirementsHard Disk Space must meet the required softwar

Delete Oracle 11g R2 in Linux 6.4 Close DatabaseSQL> shutdown [immediate] Stop Listener[Oracle @ ora920 oracle] $ lsnrctl stop If an application service exists, stop the application service first.[Oracle @ ora920 oracle] $ ORACLE_

=+asmExport ld_library_path= $ORACLE _home/lib: $LD _library_pathExport path= $ORACLE _home/bin: $PATHExport Lang=en_usAlias sqlplus= ' Rlwrap sqlplus 'Alias lsnrctl= ' Rlwrap lsnrctl 'Alias asmcmd= ' Rlwrap asmcmd '(2) Oracle and grid users belong to the appropriate user group respectivelyUSERADD-G oinstall-g Dba,oper

, here Pdksh not installed no relationship, You've got Ksh installed here.[Email protected] ~]# yum-y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc Glibc-comm On Glibc-devel gcc gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-devel make Sysstat unixODBC unixodbc-devel PdkshKsh libaio.i686 glibc.i686 compat-libstdc++-33.i686 libaio-devel.i686 libgcc.i686 libstdc++.i686 unixODBC.i686 unixodbc-devel.i6862. Start creating

the memory is large, the SGA target cannot exceed the TMPFS size, so you need to adjust the TMPFS to a value larger than the SGA target. Edit/etc/fstab, modify the TMPFS line:#所有节点均执行Tmpfs /dev/shm tmpfs defaults,size=102400m 00 # If the server memory 128GB,SGA target is 90GB, you can set TMPFS to 100GBRe-mount and see if the TMPFS setting is in effect:#所有节点均执行[Email protected]:~] $mount-o remount/dev/shm [[email protected]:~] $DF-HUser and group c

Finally, we have installed Oracle 11g in RedHat. First, we will write a summary, and I will repeat it over the weekend. 1. Download oracle11g for linux Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip;Http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_databasesilicate f2.zip; 2. Check and install the installation package Rpm-q gcc make binutils setarch compa

Tags: Linux oracle 11gOracle 11g installation on Linux Create the required users and groups Vim mk_user.sh GROUPADD-G 501 OinstallGROUPADD-G 502 DBAGROUPADD-G 503 OperUseradd-u 501-g oinstall-g Dba,oper Oracle SH mk_user.sh Create the desired directoryVim mk_dir.sh Mkdir-p/u01/app/orainve

Oracle 11g R2 rac rman backup script example 1. Switch RAC to archive Mode 1. Modify the archive mode of the database. Generally, archive is configured and the flash back area is used when RAC is installed. you can skip the steps below if you have configured archive. SQL> alter system set cluster_database = false scope = spfile sid = '*'; 2. Shut down all instances (shutdown on both sides) SQL> shutdown imm

/dongfangmn/blog/item/23f7ccd813c9213831fa1c67.html2. IP planning[Root @ rac2 app] # cat/etc/hosts# Do not remove the following line, or various programs# That require network functionality will fail.127.0.0.1 localhost. localdomain localhost#: 1 localhost6.localdomain6 localhost6# Public ip192.168.18.101 rac1192.168.18.103 rac2# Priv ipThe 192.168.0.101 rac1-private192.168.0.103 rac2-private# Vip ip192.168.18.121 rac1-vip192.168.18.123 rac2-vip# Scan ip192.168.18.100 rac-scan(Note: All host nam

Install oracle 11g and oracle11g in linux Oracle 11g Installation I. Environment preparation /15000 M /Tmp 4096 M /Boot 100 M Swap 4096 M /U01 remaining space 2. Change the Host Name and IP address 3. install the software package The environment for the linux system to be prepared for oralce wi

, because the flashback log file is deleted under certain conditions, not always in the Flashback recovery area Flash back TableThe flashback table, which restores the table to a certain point in time or the specified SCN without recovering the data file, provides the DBA with an online, quick, and convenient way to recover from the error of modifying, deleting, inserting, and so on. 利用闪回表技术恢复表中的数据的过程，实际上是对表进行DML操作的过程。