oracle 11g dba tutorial

Lab environment, Oracle 11gR2 standalone test data software and database upgrade, operating system Linux6.3Oracle version 11.2.0.1 upgrade package 11.2.0.3After the database software and database are upgraded successfully, the following error is always prompted when you test the export full database experiment of expdp: [Oracle @ linuxtest ~] $ Expdp oracle/

Operating system: Red Hat Enterprise Linux Server Release 6.2 x86_64Oracle version: Oracle Database 11g Release 2 Oracle Official Download Address:File1:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_1of2.zipFile2:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_2of2.zip ORACLE11GR2 Official document Address

# cp Fontconfig. REDHAT.6.BFC FONTCONFIG.BFC #使用系统的字体配置5. Execute the following command # groupadd oinstall #建立安装组合管理组 groupadd dba useradd-g oinstall-G DBA Oracle #创建运行用户, belongs to Oninstall Group, affiliated DBA Group # passwd Oracle #创建密码 mkd

/security/limits.conforacle soft Nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard Nofile 655362) Modify the/etc/pam.d/login file, enter the command: Vi/etc/pam.d/login, press the I key to enter the editing mode, the following content to join the file.Vi/etc/pam.d/loginsession Required Pam_limits.so3) Modify the Linux kernel, modify the/etc/sysctl.conf file, enter the command: vi/etc/sysctl.conf, press the I key to enter the editing mode, add the following content to the file#v

process unknown ospid (17662) as a result of ORA-28 Tue Sep 13 17:58:06 2011 Opidcl aborting process unknown ospid (9702) as a result of ORA-604 Ii. Problem Analysis: 2.1 opiodr aborting process unknown ospid (924) as a resultof ORA-28 In Oracle 11.1.0.6 and 11.1.0.7, there is a bug: 6377339. It will display the following information in Alert Log: ORA-28: opiodr aborting process unknown ospid (21016_3086862016) This prompt information may cause

/orainventory//inventory Directory (The default value is not filled in, this example needs to be modified, because the individual creates the installation directory.SELECTED_LANGUAGES=EN,ZH_CN//Select languageOracle_home=/u01/app/oracle/product/11.2.0/db_1//Oracle_home Path Modify This example installation path according to the directory situation/u01/app/oracleOracle_base=/u01/app/oracle//Oracle_base Note

Tags: Linux oracle 11gOracle 11g installation on Linux Create the required users and Groups 1Create the required directory 1Install the required installation package 2Modify the Hosts file/etc/hosts 3Modify/etc/sysctl.conf 3Configuring resource Limits for Oracle users 3modifying profile files 3modifying user environment variables (operating under

PS: The following are the most common basic management commands for Oracle 11g, including creating users, table spaces, permission assignments, and so on. The following commands I have verified the operation, and added my summary and instructions.1. Start the Oracle database:Switch from root to Oracle user access:su -

Tags: Oracle 11g grid InstallationOracle 11g Grid Installation1. Create Oracle users and user groupsGroupadd OinstallGroupadd dbaUSERADD-G oinstall-g dba-m OracleTo set the password for an Oracle User:passwd OracleI'm set up here

Oracle 11g InstallationFirst, the Environment preparation Dividing area /15000M/tmp 4096M/boot 100MSwap 4096M/u01 remaining space2. Change host name, IP address3. Install the PackageThen the Linux system needs to prepare the environment for Oralce to end here, the following is installed after the system installation of Oracle4. Turn off SendMail to speed up system startup5. Modify the Host tab

First, IntroductionThe importance of Oracle databases in system operations is self-evident, and the knowledge of operating systems and databases is deepened through familiarity with the installation of Oracle. The environment for this installation test is as follows:Operating system: CentOS 6.5 X64Database: Oracledatabase 11g Release 2 (11.2.0.1.0) for Linux x86-

1. Start the Oracle database:Switch from root to Oracle user access:Su-oracleEntering the Sqlplus environment, the Nolog parameter indicates no login:Sqlplus/nologLog in in Administrator mode:Sqlplus/as SYSDBAStart the databasestartup;Stopping the databaseShutdown ImmediateRemote Connection DatabaseSqlplus/nologConn Sys/[email Protected]:1521/orainstance as SysdbaYou can also run directly:Dbstart# Start the

------------------------------------------------------- ----------------------db_recovery_file_dest string/data/app/oracle/recovery_areadb_recovery_file_dest_size Big in Teger 2GTo view usage status:Sql> select Name,space_limit,space_used,number_of_files from V$recovery_file_dest;NAME--------------------------------------------------------------------------------Space_limit space_used Number_of_files------------------------------------/data/app/

Organize the previous documents and put them on the blog to find them directly.Environment: Oracle Linux release 6.3 x86_84, Oracle 11gR2First, the host environment configuration1.1 GCC InstallationIn the ISO file packages can find the corresponding RPM file, compare can quickly install, if the source code compiled installation, it is more troublesome (need to install early version of the rpm of the GCC, an

by the system after the user's operation, so there is no need to adjust the temporary table space, but when the concurrent users are very much and the operation is more complex, There may be a shortage of temporary table space. At this point, the database administrator can add temporary files to increase the temporary table space.If you need to add temporary files, you can use the Add tempfile clause.If you need to modify the size of the temporary file, you can use the Resize keyword.You can al

= 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576编辑完成后按Esc键，输入“:wq”存盘退出5) Edit/etc/profile, enter command: Vi/etc/profile, press I to enter edit mode, add the following content to the fileif [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fi fiPress ESC when editing is complete and enter ": Wq" to eject6) Create related users and groupsGrou

Support group. To create an Oracle user and password, enter the command: useradd-g oinstall -g dba -m oracle passwdoracleThen will let you enter the password, the password any input 2 times, but must be consistent, enter the confirmation. 2) Create database software directory and data file directory, directory location, according to their own situation, pay att

~] # Umount/dev/SHM Umount:/dev/SHM: device is busy. (In some cases useful info about processes that use The device is found by lsof (8) or Fuser (1 )) How to handle device is busy reported by Linux umount Http://blog.csdn.net/tianlesoftware/article/details/6194295 -- The device is busy. Use Fuser to handle it: [Root @ Rac1 ~] # Fuser-km/dev/SHM /Dev/SHM: 1805 m [Root @ Rac1 ~] # Umount/dev/SHM [Root @ Rac1 ~] # Mount/dev/SHM [Root @ Rac1 ~] # DF-lH Filesystem size used avail use % mounted on

Tags: Oracle 11gInstallation of Oracle 11g database1. Install the virtual machine, use VMware or VirtualBox, run the memory configuration to 4G, the hard disk expands automatically. (CPU virtualization does not need to be turned on)2. Install the operating system and now install the OS version of Oracle Enterprise Linu