Then unzipClick setup.exeI'm using the default installation D drive.The database password is Wangxiaofei.NextFirst, on your own Windows 7 flagship edition, Oracle 11g prompts you for errors when "product-specific prerequisite condition checks":In, we can see that when Oracle checks the operating system compatibility, it does not pass the check, at this time, we c
also the entire RAC (that is, the database level). In addition, some instructions (Directive) can be added to the ADDM to ignore information that you don't care about.
12, AWR Baseline (Awrbaselines)
The AWR baseline has been expanded. You can automatically create baselines for some other features that you use. The Dian Cun Zhang Line is created by default.
Second, Plsql part
1, result set cache (results set Caching)
This feature can greatly improve the performance of many programs. In som
/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc5.d/s99oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc0.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc1.d/k10oracle11Ln-s/etc/init.d/oracle11/etc/rc.d/rc6.d/k10oracle11Effect and execution Chkconfig--add Oracle11 is the same.Here, so the setup process is over, let's test it out:#cd/ETC/INIT.DSH oracle11 startAfter executing, look at the Oracle11log file in the/var/log directory, is there a script to start the branch output information?SH oracle11 s
Tags: open fast overwrite selected format finish home record Select1. Find the Repository control file path FirstFind the path to the control file on the repository first, as in the main library, but just in case, check is OK.
Sql> select name from V$controlfile;NAME--------------------------------------------------------------------------------/oracle/app/oracle/oradata/powerdes/control01.
/[emailprotected] /service Take bash for example, such as the above password [email protected] situation, at this time need to write:sqlplus username/\ "[email protected]\ ] because "itself is a meta-character in bash. To pass "itself as part of a reference to Sqlplus." It must be escaped. finally recommend a ORACLEDBA book, the book has a lot of Oracle terminology and principles of very clear, just a slightly rough translation, it is recommended to
Some ASP. NET + Oracle 11G systems write-and-learn essays, including referencing Oracle's official data provider and changing the date format of Oracle storage.
(8) Reference Oracle's official data provider
At the end of the last post "Oracle 11g Study Notes (3)", an ASP
1. Start Sqlplus2. Please enter your username: Sqlplus/as sysdba3. Enter Password: Direct enter4. Connect to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-productionWith the partitioning, OLAP, Data Mining and Real application testing optionsSql>alter User sys identified by admin;The user has changed.Sql> Conn Sys/admin as SYSDBA;is connected.sql> alter user system identified by Abc123123; (New
Oracle oinstall 30416896 Jan 22:05 temp01.dbf-rw-r-----1 Oracle Oinstall 110108672 Jan 24 22:05 UNDOTBS01.DBF-RW-R-----1 Oracle oinstall 26222592 Jan 22:05 users01.dbf[[emailprotected] prod]$ Exit[emailnbs p;protected]> ALTER DATABASE Open;alter database Open*error at line 1:ora-03113:end-of-file on communication channelpr Ocess id:2951session id:125 Serial Numb
Tags: url sage png virt same 9.png Nanjing e-Mail The October Nanjing Rainy Weather Library spent a little more about the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's shoes to improve the installation efficiency.Mutual convenience and common progress! Oracle Two files There is a need to
System.Data.OracleClient namespace is the. NET Framework Data Provider for Oracle.this types in System.Data.OracleClient is deprecated and would be removed in a future version of the. NET Framework . For more information, see Oracle and ADO. NET. The most important thing I've seen is that System.Data.OracleClient is deprecated and will not be visible in the future. NET Framework. So it's best to use odp.net. First to download odp.net, this to the
Tags: name error technology share replacement how to query Flash recovery free related informationOracle 11g R2 Rman BackupDefinition and classification of backup and recovery Definition and classification of backup: 备份就是把数据库复制到转储设备的过程。其中,转储设备是指用于放置数据库副本的磁带或磁盘。通常也将存放于转储设备中的数据库的副本称为原数据库的备份或转储。备份是一份数据副本,从不同的角度分类如下: From a physical and logical point of view: From physical and logical, backups can be divided into physical and logical backups. Physica
does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web
does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web
the command:Su–rootCd/home/oracle/app/oracle/product/11.2.0/dbhome_1SH root.shCd/home/oracle/app/orainventorySH orainstroot.sh
Iv. Creating a DatabaseSwitch to the Oracle account, enter DBCA in the terminal, and start the graphical creation.Select a custom databaseEnter the instance name and global database name
CentOS Installation Oracle 11g R2Lab Environment:Linux server operating system: CentOS 5.5 32-bit (note: Please separate partition/data for installation of Oracle database during system installation)Linux Server IP Address: 192.168.32.130Oracle Database version: Linux_11gr2_databaseWindows Client system: Windows XpSpecific operation:First, install X windowYum gro
Install Oracle 11G Release 2 (11.2) on Centos Linux 7This article presents what to install the Oracle 11G on Centos Linux 7.read following article How to install CentOS Linux 7:install CentOS Linux 7
(for comfort set 2G memory for your vsan before proceeding with Oracle
SQL> select * from v $ version;
BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 ProductionTNS for Linux: Version 11.2.0.1.0-ProductionNLSRTL Version 11.2.0.1.0-Production
Sometimes there is a background wait event: db file async I/O submit
This w
How to manually delete an Oracle 11g database in Linux
The following steps teach you how to manually delete an Oracle 11g Database in a Linux environment.
I installed the Oralce 11G database on CentOS 6.
Use SQLPlus or other command line tools you like to log on to the data
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.