Some time ago I started to learn some basic knowledge about oracle. To facilitate exercises and operations, I installed an Oracle 10 Gb. After the installation is complete, the current database is directly deprecated. The card is terrible. The card can only be used for surfing the Internet. At that time, I was too busy to do anything else, so I never care about it. Together with the last Internet cafe. Thes
Tags: Oracle CREATE DATABASE buffers new features1.Exadata is the hardware that combines the power of the database.Flash: Unlike database Flash, this is a cache of resident SGA buffers based on the file extension (similar to swap), providing a level two cache for the database. The file is used when the database is swapped out for the SGA.Storage index: Enables queries to run faster with minimum/maximum valu
Oracle BASICS (9) Oracle architecture and oracle infrastructure
1. Oracle Architecture Overview:
Oracle architecture refers to the composition, working process and principle of the database, as well as the organization and management mechanism of data in the database. To und
Oracle 10g AND Oracle 11g manual database creation case -- Oracle 11g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we
Method 1:
As we all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the Oracle client?
In fact, I always wanted to do this, because this client is so annoying !!! Not only will JDK be installed,
Label:Data Guard is a remote replication technology for Oracle, it has physical and logical points, but in general, it needs a separate system in a remote location, two sets of hardware configurations can be different systems, but the software structure of the two systems are consistent, including the software version, directory storage structure, and data synchronization (in fact, is not real-time synchronization), the two sets of systems as long as
Tags: file path off SQ server has a lock creat evo combo1.Oracle Default UserAccess to Oracle database only with a legitimate user accountOracle has several default database usersAll data dictionary tables and views in the database are stored in the SYS pattern. SYS users are primarily used to maintain system information and manage instances.Systems is the default system administrator who owns the internal
1.1DescribedGenerate a lot of "oracle_w000_9708.trc" and "ORACLE_W000_9708.TRM" under the "$ORACLE _base/diag/rdbms/$ORACLE _sid/$ORACLE _sid/trace" folder File.These files are generated too quickly. The Oracle root folder is running out of free space.1.2Possible causesThe possible reason for the "$
, graphic teaching skills. Be able to analyze very complex knowledge and difficulties like selling Chinese cabbage. To simplify and simplify, to be easy, to be fun, to be fun and to become a road. The instructor for the Oracle Employment program. 120 Oracle DBAs have been taught.Network Open Class not to go? Click the beginner's Guide graphic →http://www.51cto to remind you not to spam ads!/jishushalong/gon
Oracle Oracle Product Services and Technology level introduction
Many friends ask the genuine Oracle database products and pirated products are mainly different, in fact, from the product technology itself, the difference is not small, can download a database from the OTN website products, and then install the use of genuine and pirated the biggest difference i
1.1 symptom description authorized by common usersSysdbaFailed to log on to database with the permission. The system displays the following error message:% SqlplusAs sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Nov 26 14:28:11 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon deniedHowever
SysdbaIf you log on directly, the system prompts the following information:
% Sqlplus/as s
Disclaimer: This article transfers from the network article, reproduced this article only for the personal collection, shares the knowledge, if has the infringement, please contact the blogger to delete.Original LeshamiOriginal address: http://blog.csdn.net/leshami/article/details/5529239--========================================== --oracle Instances and Oracle Databases (
Oracle Cluster Concepts and principles (ii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review rev
Oracle 10g AND Oracle 11g manual database creation case -- Oracle 10g
System Environment:
Operating System: RedHat EL6
Oracle: Oracle 10g and Oracle 11g
Manual database creation is relatively easy to implement. In this case, we w
Oracle 10g
To download Oracle, you also need to register a user name for your convenience.
User: wangdetian168@gmail.com
Pass: qwe123qweThe password is normal. You don't need to retrieve it.Every change is troublesome.If necessary, you can view the required information on the right.
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition fo
How to connect toad to Oracle without installing the Oracle client
In the past, it was quite troublesome to install the Oracle client when connecting to Oracle. On the one hand, it was difficult to install such a large volume of data.
Oracle seems to have provided in
database are compressed in batch mode, rather than each operation that changes the data will lead to compression operations.When the reserved uncompressed data in the block reaches a limit, the compression operation in the block is triggered.When a transaction causes the data in the block to reach the Jue value, all the contents in the block will be compressed. Then, more data is added to the block, and the entire block is compressed again to reach the maximum compression level. This process wi
Based on Metalink 362496.1
From the document, the XML Publisher version is not directly available.
The most useful is to query its version from the generated report.The details are as follows,PDF output: open the file in Adobe Acrobat-> Menu file-> Document Properties-> Tab description-> Property 'pdf producer 'will show e.g. Oracle XML Publisher 5.6.2RTF output: open the file in MS word-> Menu file-> Properties-> Tab Summary-> Property 'comments' wi
--==========================================--oracle Instances and Oracle Databases (Oracle architecture)--==========================================/*For the first contact with Oracle database, two concepts that are easily confused are Oracle instances and
Oracle Silent Installation tutorial, oracle Silent Installation
In this article
>
Content
>
Indicates that the content is appended to the input file, which is part of the parameter required in the file.
Content
This means that the content is all in the current file. You can delete the file, create the file, and enter the content.
Installation environment, CentOS 6.8, VMware workstation PRO 12
Hardware en
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.