oca 11g

This article will share with you the Problems and Solutions encountered when installing Oracle 11g on Windows 7. First, on the Windows 7 flagship edition, the Oracle 11g prompts the following error when "product-specific precognition condition check: In the first image, we can see that the check fails when Oracle checks the operating system compatibility. At this time, we cannot install it when clicking "N

In Oracle 11g version, full-Table serial scan may use direct path read instead of db file scattered read used in earlier versions, obviously direct path read has more advantages:1. reduces the use of plug-ins and avoids possible use of plug-ins2. the size of physical IO no longer depends on the block in buffer_cache. Imagine that Block 1, 3, and 7 of an eight-block extent are in the cache, while Block 2, 4, and 6 are not cached, when reading this exte

Oracle 11g, when backing up a database with the exp command, if the table does not have a datagram EXP-00011 error, the corresponding table does not exist. As a result, the corresponding empty table cannot be backed up. Cause: by default, a segment is not allocated when a table is created at 11g, which is generated only when data is inserted (which can be forcibly allocated, of course) to save disk space. S

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application T

1. DB_BLOCK_CHECKSUM parameter description Before Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has two options: TRUE and FALSE. The default value is TRUE. In Oracle 10.2.0.3: DB_BLOCK_CHECKSUM has three options: OFF | TYPICAL | FULL. The default value is TYPICAL. In Oracle 11g: DB_BLOCK_CHECKSUM has five options: OFF | FALSE | TYPICAL | TRUE | FULL, the default value is TYPICAL. However, a new parameter DB_ULTRA_SAFE is added to Oracle

How to build an Oracle 11g license uard I. PreparationsI have read many tutorials when preparing to build a tracing uard. I followed the tutorials and encountered problems. Then I don't know how to proceed to the next step.Later, I went to the official document and sorted out my ideas. It was much easier.Taking one master database and one slave database as an example, the idea of building DG is as follows:Disable the firewall.Configure ssh mutual tru

Create a partition on the Oracle 11g virtual column, oracle11g On Oracle 11g, partitions can be performed on virtual columns. This feature is useful. Let's perform a test: SQL> select * from v $ version;BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

Welcome to the Oracle community forum and interact with 2 million technical staff. On Monday, Oracle announced the beta version of OracleDatabase11g at its user conference. during a keynote speech at the OracleOpenWorld conference, ChuckRozwat, executive vice president of Oracle server technology, said that the beta OracleDatabase11g contains a solution package Welcome to the Oracle community forum and interact with 2 million technical staff> on Monday, Oracle announced the beta version of Orac

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selected SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production With the Partitioning, OLAP, Data Mining and Real Applicati

1, download Oracle 11g R2 for Windows version Download Address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html This includes two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip 2, the two compressed packets to the same directory, that is, "database", and then click the Extract directory under the "setup.exe" file: 3. In the "Configure Security Updates" window that appears, ca

Tags: Oracle Enterprise Manager 11g Start-stop1. See if components are installedCol Comp_name for A40Select Comp_name,version,status from Dba_registry;Comp_name VERSION STATUS---------------------- --------------------------- -------------------------------OWB 11.2.0.4.0 VALIDOracle Application Express 3.2.1.00.12 VALIDOracle Enterprise Manager 11.2.0.4.0 VALIDOLAP Catalog 11.2.0.4.0 VALIDSpatial 11.2.0.4.0 VALIDOracle Multimedia 11.2.0.4.0 VALIDOracl

11g use one parameter to set the password case sensitivity, below to do an experiment:C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 17:54:19 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connect to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionWith the partitioning, OLAP, Data Mining and

textbook Oracle one-off RAC Survival Guide Oracle 11gR2 RAC Management and performance optimization Oracle Database 11g Release 2 RAC on Linux Using NFS Best Practices for installing Oracle Database 11g Release 2 RAC on Oracle Linux 5.7 using VirtualBox Oracle RAC Installation Configuration-nfs (i) Tnsnames.ora Monitoring configuration file (blog Park) Article Navigation

Problem description: the customer reports that the client cannot connect when it cannot log on to the application.Environment: AIX 5.3 + Oracle 11gR2Solution: remote Telnet to the Database Host, sqlplus/as sysdba after the connection operation is normal, indicating that the database server should be normal, and then in the client to connect to the database with sqlplus prompt Password Expiration error: ORA-28001: the password has expired. It turns out that the password has expired.Analysis: in O

After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle services, you can speed up your computer. So what should we do? After Oracle 11g R2 is successfully installed in Windows 64-bit environment, seven services are available: Oracle orcl vss Writer

Oracle 11g Alert Log location Oracle 11g Alert Log location 1. Obtain ADR-related information by querying the v $ diag_info View ADR(Automatic Diagnostic Repository)--> A a file-based hierarchical data store for managing diagnostic information, including network tracing and logging. Code: sys@ora11g>select * from v$diag_info;INST_ID NAME VALUE------- ---------------------- ----------------------------------

BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you are processing maintenance tasks at night and opening a maintenance window at night is not a good idea, you may want to change it all. 2. Basic management tasks are self-controlled. However, in addition to th

Deferred_segment_creation of the 11g Parameter Deferred_segment_creation Boolean The default value is true. This parameter is not found in 10gR2, and is available in 11g. It can also be seen from the literal meaning that when this parameter is set to true, when a table is created, no segment is assigned to it, that is, no space is allocated, segment is allocated only when the first data entry is inserted in

Strange query Problem and Solution for oracle 11g fields WITH resultTable AS (www.2cto.com SELECT B. stand_1__pri_id, B. PRODFAM_ID, B. PRODFAM_CODE, B. PRODUCT_LINE_ID, B. PRICE_LOOUP_TYPE, B. PRICE_LOOUP_CODE, B. stand_const, B. SALES_CHANNEL_TYPE, B. SALES_CHANNEL_CODE, B. PRICE, B. MATER_COST_PRICE, B. PRODU_COST_PRICE, B. UNITS, B. CURRENCY, B. CREATE_BY, B. ENABLE_FLAG, B. REGISTER_ID, TO_CHAR (B. CREATE_DATE, 'yyyy-MM-DD ') AS CREATE _ DATE, B.

The database of the Oracle 11g virtual column Acme contains a table named SALES, as shown in the preceding figure. The table structure is as follows: SALES_IDNUMBERCUST_IDNUMBERSALES_AMTNUMBER some users want to add a column named SALE_CATEGORY to identify the sales type based on the sales volume and the current customer: LOW, MEDIUM, HIGH, and ULTRA. This column will help them identify the corresponding action records and route the records to relevan