oracle 11g dba tutorial

Tags: Oracle 11g installationInstallation platform centos6.5 + Oracle 11gStatement: This article for their own notes collation, non-complete installation steps, for reference only;;;Step one: Specify the host name and planning IP address (requires a system restart)Hostname: XYHDB Modify #vim/etc/hosts file add Xyhdb xyhdb.xyhSystem IP Address: IP 192.168.0.233/24

after the standard creation statement, for example: sql> ALTER TABLE mytab ADD PRIMARY KEY (ID, name) RELY DISABLE; Note : created the rely constraints, Oracle The column is assumed to be unique (give DBA sufficient trust), but the value of the column is not uniquely validated, so the column is unique only by the DBA to proactively main

: [[emailprotected] oracle]# cd/home/oracle/app/oracle/product /11.2.0/dbhome_1 [[emailprotected] dbhome_1]# sh root.sh Running Oracle 11g root.sh script ... The following environment variables is set as:oracle_owner= ORACLE o

1. Check the system version number:uname-aLinux node2 3.10.0-123.el7.x86_64 #1 SMP Mon June 12:09:22 UTC x86_64 x86_64 x86_64 gnu/linuxCat/etc/redhat-release#CentOS Linux release 7.0.1406 (Core) Comment out the previous version numberRedhat-7 manually added2. Create users and GroupsGroupadd OinstallGroupadd dbaUSERADD-G oinstall-g dba-m Oraclepasswd OracleCreate home directories, data catalogs, and dictionary directories and authorizemkdir-p/01/app/

Oracle 11G Single Instance uses asm, and test the migration of data files to other disk groups 1. configure/etc/hosts network vi/etc/hosts192.168.1.181 asm asm.oracle.com 1. disable FIREWALL 2. disable SElinux vi/etc/selinux/config => SELINUX = disabled 2. create a user and group groupadd-g 5000 asmadmingroupadd-g 5001 asmdbagroupadd-g 5002 asmopergroupadd-g 6000 oinstallgroupadd-g 6001 dbagroupadd-g 6002 l

1. Stop the database using Sql*plus[Oracle@oracletest oracle]$ Sqlplus/nologSql> Connect/as SYSDBAsql> shutdown [Immediate]Sql> exit 2. Stop Listener[Oracle@oracletest oracle]$ Lsnrctl Stop 3. Stop HTTP Service[root@oracletest/root]# Service httpd stop 4. Use Su or re-login to root (if you want to reinstall you can

I tried to install Oracle 11g R2 under CenOS s5.5 in VMware. I thought it was simple, but I found many problems. Installation steps: 1. check the corresponding rpm package It doesn't matter if the check is complete. It will check the installation of oracle. According to the official package CHECK, the version can only be high or not low. The following or later ve

Label:Configure local Yum Source [[emailprotected] ~]# cd /etc/yum.repos.d/ [[emailprotected] yum.repos.d]# [[emailprotected] yum.repos.d]# vi local.repo [Local] Name=local baseurl=file:///mnt/Server enable=1 gpgcheck=0 [[emailprotected] yum.repos.d]# yum list Install the required packages # yum -y install binutils-2.* compat-libstdc++-3* elfutils-libelf-0.* elfutils-libelf-devel-0.* elfutils-libelf-devel-static-0.* gcc-c++-4.* glibc-2.* glibc-common-

online Rac1Ora.asmOnline online Rac1 StartedOra.onsOFFLINE OFFLINE Rac1---------------------------------------------------------------------Cluster Resources---------------------------------------------------------------------Ora.cssd1 Online Online Rac1Ora.diskmon1 OFFLINE OFFLINEOra.evmd1 Online Online Rac15) Incorrect permissions for Oracle users[[email protected] ~]# ID OracleUID=1101 (Oracle) gid=1000

Docker Image: wnameless/oracle-xe-11gcommand to start mirroring:Docker run-d-v/data/oracle_data:/data/oracle_data-p 11522:22-p 11521:1521-e oracle_allow_remote=true--name oracle-1 1g wnameless/oracle-xe-11gTo enter the mirroring command:Docker exec-it Oracle-11g/bin/bash1. E

Install oracle 11G on Fedora 16/Etc/sysctl. conf ------------------------------------------- fs. aio-max-nr = 1048576 fs. file-max = 6815744 kernel. shmall = 2097152 kernel. shmmax = 536870912 kernel. shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel. sem = 250 32000 100 128 net. ipv4.ip _ local_port_range = 9000 65500 net. core. rmem_default = 262144. net. core. rmem_max = 4194304. net. cor

Oracle 11g introduces new features Spa (SQL performance Analyze) is now widely used in upgrades and migrations, and of course some other scenarios can be considered, such as optimizer parameter modification, IO subsystem change, etc., which can be used by the DBA Provides detailed information about the performance of SQL statements, such as statistical informatio

Install Oracle 11G Single-instance database on Linux under VM virtual machine1. Environment and pre-installation planning: virtual machines and OS as followsEnvironment: VMware wordstation Ace Edition 6.0.2Operating system: Oraclelinux-r5-u8-server-i386-dvd 3.2GTo install the operating system, it is important to note that there is enough disk space to reserve.My plan is to:The virtual machine allocates 1024

Oracle 11g backup file imported 10g, *. dmp file imported to 10g encountered a lot of problems The following error occurs when I export data from 11 GB and then import the data to 10 Gb. IMP-00010: the exported file is not valid and the header verification fails. IMP-00000: Import failed Use a tool to open the dmp file. The first line has a version CEXPORT: V11.01.00 Then I change it CEXPORT: V10.0

Description of the new and enhanced RMAN functions in Oracle Database 11g• Configure an archiving log deletion policy • Use the Oracle network to copy active databases (No backups) • backing up large files in multiple parts • Creating archive backups for long-term storage • Managing and restoring directories, such as merging multiple directory versions • describi

Tags: Oracle Oracle InstallationI. Oracle pre-installation PreparationCheck the package and you must install it all:Binutils-2.20.51.0.2-5.43.el6.x86_64compat-libstdc++-296-2.96-144.el6.i686Compat-libstdc++-33-3.2.3-69.el6.x86_64Elfutils-libelf-0.161-3.el6.x86_64Elfutils-libelf-devel-0.161-3.el6.x86_64Gcc-4.4.7-16.el6.x86_64Gcc-c++-4.4.7-16.el6.x86_64Glibc-2.12-1

The environment is as follows: #注意是SLES1 cat /etc/suse-2 (x86_64)341 5 6 7 Linux.x64_11gr2_database_1of2. Zip 8 Linux.x64_11gr2_database_2of2. ZipA systematic article1. When installing the system, select1 "Oracle Server Base" 2 "Compiler and Tools"Then install a1 libstdc++2. Bind host Name1 VI /etc/hosts2127.0. 0.1 Yas #yas为主机名3.Oracle installation Basic conditions3.1 The

Oracle 11g has been installed in your Ubuntu environment. We hereby record the installation process and keep it as a memorandum. Prerequisites: 1. system update sudo Sudo apt-get updateSudo apt-get upgrade 2. packagesudo required for system installation Sudo su-Apt-get install build-essentialApt-get install libaio1Apt-get install libaio-devApt-get install unixODBCApt-get install unixODBC-devApt-get install

[[email protected] ~]# yum-y install \Binutils \Elfutils-libelf \Elfutils-libelf-devel \Elfutils-libelf-devel-static \GCC \gcc-c++ \GLIBC \Glibc-common \Glibc-devel \Glibc-headers \Ksh \Libaio \Libaio-devel \libstdc++ \Libstdc++-devel \Make \Sysstat \UnixODBC \Unixodbc-devel[Email protected] ~]# yum-y install compat-libstdc++*[[email protected] ~]# rpm-q--qf '%{name}-%{version}-%{release} (%{arch}) \ n ' binutils \Elfutils-libelf-devel \Elfutils-libelf-devel-static \GCC \gcc-c++ \GLIBC \Glibc-co

, searched a validwget http://mirror.centos.org/centos/5/os/i386/CentOS/pdksh-5.2.14-37.el5_8.1.i386.rpmFinish the installation: [[email protected] ~]# Yum install pdksh-5.2.14-37.el5_8.1.i386.rpmDependencies are found during installation, but the system is automatically downloaded and installed.Finally, I'll put libxp in the bag.2.3 Adding a user groupThis step has detailed requirements in the documentation for creating Required Operating System Groups and Users sectionThe following local opera