Alibabacloud.com offers a wide variety of articles about oca 11g, easily find your oca 11g information here online.
Installed Ubuntu 12.04 64bit, want to install Oracle 11GR2 on the above, find a lot of documents on the Internet did not succeed, and finally fully reference the Mordicusetcubitus article.Key points for a successful installation: Install additional packages, which handles the wrong method during link.Original: Http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bitsBefore startingSince Release 11.10 It is mo
Tags: system sys AST download data BSP Enterprise Database large Web siteOracle Database 11g Release 2 standard Edition and Enterprise Edition software DownloadsOracle Database 11g 2nd Edition Standard Edition,Software download for Enterprise EditionMicrosoft Windows (32-bit) Disc 1, Disc 2 (2GB) 1Microsoft Windows (x64) CD 1, Disc 2 (2GB) 2Linux x86 Disc 1, Disc 2 (2GB) 3Linux x86-64 Disc 1, Disc 2 (2GB) 3
The ORA-00845 is prompted when the database is started: MEMORY_TARGETnotsupportedonthissystem (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle11g The ORA-00845 is prompted when you start the database: MEMORY_TARGET not supported on this system (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle 11g 1. The ORA-00845: MEMORY_TARGET not supported on this system is prompted when the database is start
In the use of Oracle databases, Backup recovery is the most critical. When the database fails, it can be restored in a timely manner to reduce unnecessary losses. Next I will briefly introduce the import and export of databases, solutions, tables, and the role of things in the Process of use.1. Export data tables[Oracle @ CentOS ~] $ Exp scott/system tables = t file = '/home/oracle/t. dump 'Log = '/home/oracle/t. log'; -- export t table data in scott (tables = can write multiple tables, full = y
How to handle EM key garbled characters in Oracle 11g Today, I used a Mac to connect to the VMware Fusion virtual machine database. I suddenly wanted to use EM and suddenly found that the buttons were garbled. For example: Analysis: To solve the problem, find the correct font. Solution: 1. Find a font file such as simsun. ttc on Windows machine c: \ windows \ fonts. 2. Create a folder named fallback in the $ Oracle_home/jdk/jre/lib/fonts directory. [
Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (64-bit) http://download.oracle.com/otn/nt/ Oracle11g/112010/win64_11gr2_database_1of2.ziphttp://download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_ database_2of2.ziphttp://download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_client.ziphttp:// Download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_grid.ziporacle Database 11g Release 2
Tags: Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (64-bit) http://download.oracle.com/otn/nt/ Oracle11g/112010/win64_11gr2_database_1of2.ziphttp://download.oracle.com/otn/nt/oracle11g/112010/win64_ 11gr2_database_2of2.ziphttp://download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_client.zip Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_grid.zipOracle Database 11g Re
An overviewTwo-SQL planning baseline Plan Baseline architectureThree-load SQL plan baselinesFour Evolutionary SQL plan baselinesFive important baseline SQL plan propertiesSix-SQL Plan selectionSeven possible SQL plan manageability ScenariosEight SQL performance analyzers and SQL plan baseline scenariosNine automatically load SQL plan baseline scenariosTen clear SQL Management library policiesA OverviewThere may be a performance risk when a SQL statement's SQL execution plan changes.There are man
Create a dblink in oracle9i or 10g to point to an oracle11g database. After the user name and password are configured, the test will throw the following error code:ORA-01017: invalid username/password; logon deniedORA-02063: preceding line from Then I was overwhelmed. I searched the internet and found an English explanation, as shown below:CauseThe following Bug 6738104 was logged for this issue which was closed as not a bug saying the cause being introduction of password case sensitivity featur
A home, a carrier phone to, create dblink error ora-02063ora-01017 on this BUG, encountered not once, ORACLE for the BUG description below Bug6738104: ORA-01017ORA-02063WHILECONNECTINGFROM10GTO11GVIAPUBLICDBLINKCauseThefollowingBug6738104wasloggedf A home, a carrier phone to, create dblink error ora-02063/ora-01017 on this BUG, encountered not once, ORACLE for the BUG description is as follows Bug 6738104: ORA-01017 ORA-02063 while connecting FROM10G TO 11g
This article introduces the usage of different subquery brackets in oracle for 9i and 10g and 11g. if you need this, refer to the following. This article introduces the usage of different subquery brackets in oracle for 9i and 10g and 11g. if you need this, refer to the following. This article introduces the usage of different subquery brackets in oracle for 9i and 10g and
Path of the trace file under the ADR Management in 11g A 11G development library, intends to open the trace of sqlplus, check the connection information of sqlplus login, but configure sqlnet. ora did not find the trace file, and one day it was found that the disk space was insufficient. After the query, it was found that there were thousands of files in the following path, occupying G space: /u01/app/oracl
After migrating the data of a test system from Oracle 10 Gb to 11 GB, I heard the developers say that they failed to execute an SQL statement to create an index, but it can be executed normally in 10 Gb. This index is a function index with duplicate columns. It may be incorrect and this index is not useful. Therefore, you have never paid attention to this index. I felt quite interesting, so I tried it myself: 1. First, let's look at the 11g situation:
Oracle 11g's dependence judgment reaches the field level, oracle11g In Oracle 10 Gb, the dependency only reaches the object level. That is to say, once the object accessed by the Stored Procedure changes, Oracle sets the stored procedure to INVALID. Therefore, after you perform DDL operations on the table, you need to re-compile the stored procedure. In Oracle 11g, the dependency judgment is more detailed and the field level is determined. Although su
Routine maintenance and troubleshooting of Oracle 11G R2 slave uard 1. About the Forced Logging ModeSome DDL statements can avoid writing redo logs by specifying the NOLOGGING clause (the purpose is to increase the speed, which is indeed valid in some cases). After specifying the database as the force logging mode, the database records all operations except the temporary tablespace or temporary rollback segment and ignores specified parameters such as
11g ASM Single Instance dbca error prcr-1006 crs-0259 prcr-1071 11g ASM dbca error prcr-1006 crs-0259 prcr-1071When creating a single instance DB Using ASM, it appears when running DBCAPRCR-1006: Failed to add resource ora. orcl. db for orclPRCR-1071: Failed to register or update resource ora. orcl. dbPRCR-1001: Resource ora. orcl. db does not existAfter viewing the DBCA log, the following error is reported
Solution to ORA-01417 under Oracle 11g Today there is customer feedback, there is a SQL on 12C no problem, on Oracle 11g, the error is reported, the error content is ORA-01417: The table can be externally connected to at most one other table. This section analyzes the SQL statements and abstracts them into the following examples. No problem in 12c: SQL> select * from v $ version; BANNER CON_ID--------------
Silent Installation of Oracle 11g R2 in CentOS 5.10 I found many articles about installing Oracle 11g R2 silently in Linux on the Internet, which are messy and varied! Come to the literacy class! Install Oracle 11g R2 in CentOS 5.10 ************************************1. System Part************************************ ------ 1. Install the system -- ApplicationsG
The architecture of 11g is basically unchanged. It is composed of four parts, namely agent, OMS, console, and repository, which only deploy the console to the WebLogic Server. I thought that the console interface should be completely redone to create a style like middleware em, but I found that it only integrated middleware em into Em GC. The original things have not changed, such as database management. After WebLogic domain is selected, it bec
How to export an empty table in Oracle 11g Because of the new features created by the delay segment of Oracle 11g, Oracle does not allocate data segments when there is no data insertion, leading to exp being unable to export the empty table of the 11g database. Of course, there is no such problem with EXPDP. EXPDP hr/hr schemas=hr dumpfile=expdp.dmp directory=
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
