Alibabacloud.com offers a wide variety of articles about oracle 11g dba tutorial, easily find your oracle 11g dba tutorial information here online.
Tags: Oracle 11gTest environment: Win7 64-bit flagship +JDK7 (64-bit) Installed software: Oracle 11g R2 64-bit Follow the online general tutorial installation completed database, found a bunch of problems, close up this note. 1, using SQL Developer login, error: Because the system is prompted to find Sqldeveloper.bat
Nls_lang=american_america. ZHS16GBK #设置Oracle客户端字符集 must be consistent with the CharSet set at Oracle installation, such as: ZHS16GBK, otherwise the data import and export Chinese garbled problemRunSOURCE ~/.ZSHRC(Bash User: source ~/.BASHRC)Make settings effective immediately4. Create the Oracle 11g Software Installa
Tags: Modify OCA res scope control File View 11g routed iOS1. Understanding Backup and Recovery issuesThree indicators related to backup recovery are: MTBF average trouble-free timeMTTR mean failure recovery time.Data loss: How much to lose the book data.There are three advanced options for Oracle RAC Steam and DG that have an impact on performance (good bad)2. Type of failure1) Statement failure: DML state
Problems encountered during installation:1. When creating an Oracle user, it is best to specify the home directory, the general is/opt/oracle, the default/home/oracle is also possible.2. In the "Add host name and IP address corresponding" step, be sure to configure the IP, or "Oracle Net configuration assisant failed"
;Sql> alter tablespace OGG_TBS add datafile ' d:\app\administrator\oradata\hwprod\ogg_tbs02.dbf ' size 1024m;Sql> alter tablespace OGG_TBS add datafile ' d:\app\administrator\oradata\hwprod\ogg_tbs03.dbf ' size 1024m;Sql>create user ogg identified by Oracle default Tablespace OGG_TBS quota unlimited on OGG_TBS;Sql>grant DBA to Ogg; ( for DDL replication, you need to grant
Oracle Installation on Linux has become a nightmare for many engineers due to its tedious process and high error rate. Some time ago, due to work needs, we installed oracle several times on HP's PC servers and minicomputers. The process was as bad as it was, and it was almost killing people ~ If you don't have a complete installation process, and you only need to go to Baidu on a temporary basis, I think an
Tags: iat sele list Delete start map down Shu exitOne, close Oracle services and background processes1. Review the installation's home directory and environment variables: Echo $ORACLE _home env | grep ORA 2. View the instance Name Sqlplus/as SYSDBA Select instance_name from V$instance; 3. View the Oracle background process sta
Tags: orcale11g rac ora00257 dealing with insufficient ASM disk space issuesOra-00257archiver Error Resolution1. Previous processing of single-machine over Oracle 11.2.0.4 archive log disk space is insufficient, but there is no problem with insufficient archive log disk space for Oracle RACSo there is no expectation that ASM disk space is out of the questionOracle database is the most commonly used large da
1. Oracle 11g R2 Installation Manual (graphics tutorial) for Windows Before installation, you need to confirm the following points: Your memory is not a problem (this is important, if your machine often blue screen then don't pretend, or you cry) Your system is activated. The computer is already installed. NETFramework 4.0, or the first step will have a pop-u
Oracle 11g remote export database 1. Create a TNS string: zqxt = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 132.97.172.186)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora11g) )) 2. query the tablespace SQL of remote data: 1 ), select distinct 'select dbms_metadata.get_ddl(''TABLESPACE'','''||tablespace_name||''') from dual;' from dba_tables;Obtain the query
Tags: silent installation of Oracle 11g database under LiunxSed-i ' $a fs.aio-max-nr = 1048576 '/etc/sysctl.confSed-i ' $a fs.file-max = 6815744 '/etc/sysctl.confSed-i ' $a kernel.shmall = 2097152 '/etc/sysctl.confSed-i ' $a kernel.shmmax = 536870912 '/etc/sysctl.confSed-i ' $a kernel.shmmni = 4096 '/etc/sysctl.confSed-i ' $a kernel.sem = 32000 '/etc/sysctl.confSed-i ' $a net.ipv4.ip_local_port_range = 9000
SetWholeKingdeeEAS DatabaseMove to another environment for development and testing: BackupOracle Database: (you can also PL-SQL through external tools) [Oracle @ rcno8 ~] $Sqlplus SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010 Copyright (c) 1982,200 9, Oracle. All rights reserved. Enter user-name:Conn/as sysdba Enter password: Connected: Oracle
Label:Before BI creates (data) analysis, dashboards, and reports, you need to model the data, called Creating a "repository" in Oracle BIEE-the file suffix RPD, so it's commonly referred to as creating a RPD file.Steps:1 . From the Windows Start menu, find "BI management" such as:2, click on the first button of the toolbar "create" A (offline/offline) RPD file, here we named SCOTT.RPD, while note good password, such as Admin1233. Select a data source
Tags: OracleOracle.install.responsefileversion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 Oracle.install.option=install_db_swonly decline_security_updates=true unix_group_name=oinstall Inventory_location=/u01/app/oracle/orainventory selected_languages=en,zh_cn,zh_tw ORACLE_HOME=/u01/app /oracle/product/11.2.0 oracle_base=/u01/app/
BKJIA exclusive Translation] Suspended statistics In previous database versions, new optimizer statistics are automatically published when collected. In 11g, this is still the default action, but you have another option, you can suspend the latest statistics until they are manually published. Run the DBMS_STATS.GET_PREFS function to check the "PUBLISH" attribute and check whether the statistics have been automatically published. By default, the return
A.granted_role=b.granteeUnionSelect Grantee,privilege,owner,table_name from Dba_tab_privs) dwhere exists ((select 1 from dba_users C where d.username=c.username))Order by;4. How do I see who has a DBA role? general practice is to directly query the Dba_role_privs view. The query statements are as follows:Select Grantee,granted_role from Dba_role_privs where granted_role= ' DBA '; //This will miss the usert
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操作的过程。oracle自动维护与表相关联的索引、触发器、约束等。In order to use the database Flashback feature, the following conditions must be metThe user has Falshbackany table system permiss
":" ' {print '} ' oracle[[email protected] ~]# groups Orac Leoracle:oinstall dba Oper asmadmin asmdba[[email protected] ~]#Related toolkits and development kits:Physical Memory Size:[Email protected] ~]# cat/proc/meminfo |grep-i memmemtotal:3974196 kbmemfree:2037892 kbshmem: 3920 KBSwap partition size:[Email protected] ~]# cat/proc/meminfo |grep-i swapswapcached:0 kbswaptotal:4112380 kbswapfree: 4112380 KB
• Describes the options for restoring data faults • use the new RMAN data repair command to perform the following operations: -List faults-receive repair suggestions-repair faults • Perform preventive fault checks • query the data recovery guidance View Data fault repair • Data Guard provides failover to the standby database so that the operation is not affected by the downtime. • Data Recovery guide is a new feature of Oracle Database
Label:Recording Head (record header) format: typedefstructrh0 {uint32_t recordlen; uint8_t VLD; //directly determines the entire record head size uint8_t Unknown0; uint16_t Rhscnwrapper; uint32_t rhscnbase; uint16_t SUBSCN; }redo_rh0; typedefstructRh1 {uint8_t unknown1[Ten]; }redo_rh24; //VLD = 0x01, total size 24byte typedefstructRh5 {uint8_t unknown0[ -]; uint32_t Rhscntime; }redo_rh68; //VLD = 0x05, total size 68byte Redo_rh0 The record header is long
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
