data sourceGo to Control Panel/Administrative Tools/Data source (ODBC)/System DSNClick Add, select MicroSoft ODBC for Oracle, and then pop up a dialog box to fill in the following.1, data source name: MYORACLESRC can be casually up, the client program will use it.2, Description: A description of the text, you can read it.3, User name: Mytestuser the user name recognized by the database that you end up need
"Introduction to this article"Recently, because of the needs of a project, from zero to learn from Oracle, now learn to share a record of things.The first is the installation, in the WIN8 installed 10G has failed, online various methods have tried, and finally have to give up, choose 11G.The installation of 11G is very simple, basically is "next"-"complete" mode, this article just describes which steps need
, Oracle. All rights reserved.Connect:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing optionsSQL> shutdown the immediate database has been disabled. The database has been detached.The ORACLE routine has been disabled.SQL> startupThe
1. directpath reads description
In versions earlier than Oracle 11g, if a full table scan is performed on a large table, the wait event is: DB file scattered read; in 11g, if a full table scan is performed on a large table, wait event is: direct path read; that is, in 11 GB, full table scan of large tables directly reads data blocks into the PGA region of the se
16384-n 16384
Fi
Fi
Iii. Install ORACLE software
[Root @ redhat ~] # Su-l oracle
[Oracle @ redhat ~] $ Cd database/
[Oracle @ redhat database] $./runInstaller
Select to install only the database software, and run as root during installation.
[Root @ redhat ~] #/Oracle/or
of the Oracle database is completed. Finally, the installation interface of Oracle is as follows:
Now we have completely completed the installation of Oracle 11g. At this time, we found the "password management" button. in Oracle 11g
);
END;
/
SQL> col OBJECT_NAME format a10;
SQL> col OBJECT_TYPE format a10;
SQL> col STATUS format a10;
SQL> SELECT OBJECT_NAME, OBJECT_TYPE, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'P _ test ';
OBJECT_NAM OBJECT_TYP STATUS
------------------------------
P_TEST PROCEDURE VALID
SQL> ALTER TABLE TEST ADD (NAME VARCHAR2 (30 ));
SQL> SELECT OBJECT_NAME, OBJECT_TYPE, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'P _ test ';
OBJECT_NAM OBJECT_TYP STAT
The mongoel DG technology uses redo log transmission and application to ensure consistent data on the standby end and the primary end. In this process, Redo Transport and Redo Apply are two core actions. Redo Transport transmits the Redo Log information to the Standby end and waits for the Apply operation. Redo Apply is to execute these log applications and chang
version value prior to Oracledatabase 11g in the first period of time (such as a quarter), and then the automatic SQL plan capture is used to perform your workload after the upgrade.During this initial period, the optimizer can replicate the plan for most SQL statements before Oracledatabase 11g due to the ofe parameter setting. Because automatic SQL plan captures are also initiated during this period, the
really want to add or delete online log files on the physical standby (for example, because of changes on the main library), you can also dynamically set this parameter to manual, perform DDL operations, and revert to auto value without restarting the repository. Summary of parameters and attributes After understanding all of the parameters and attributes above, you should have a deep understanding of their features and features and can be used correctly. I hope you don't get a headache with t
undertakes read operations. This architecture is suitable for read-intensive types of applications, and read performance can grow linearly by increasing the number of Slave DB. To avoid a single point of failure in Master DB, the cluster typically uses two Master db for dual-machine hot standby, so the entire cluster has very high levels of read and write availability. In addition to providing Active Standby functionality from 11g, mysql,
I. Problem Description
Install RAC of 11.2.0.1 on Oracle Linux 6.1 and run the root. Sh script when installing grid. The error is as follows:
[Root @ Rac1 bin] #/u01/APP/11.2.0/GRID/root. Sh
Running Oracle 11g root. Sh script...
The following environment variables are Setas:
Oracle_owner = Oracle
ORACLE_HOME =/u01/AP
file TNSNAMES. as an optional connection alias in ORA.
I started this load in my p + 0 database environment. After the execution, I went back to the EM Database Console to view the execution result, as shown in 2.2.1, click "Stop capture" to end the load capture.
Figure 2.2.1: Load Capture: Review capture task status
At this time, Oracle 11g
completes the Oracle 11g R2 database installation.Environment variable Configuration[Email protected] oracle]$ vi ~/. bash_profile# Add export oracle_base =/usr/oracle/appexport Oracle_ at the end of the file HOME= $ORACLE _base/
Label:The Oracle 11g database is installed on Windows 10 and appears many times: a prompt box pops up when the progress bar of the installation is nearing the end. As follows: "Java (TM) 2 Platform standard Edition binary has stopped working; a problem has occurred that causes the program to stop working properly. If a solution is available, Windows closes th
in the IP of the server650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/96/3C/wKiom1kecpHj5NQQAADdP9jKZ-Y886.png-wh_500x0-wm_ 3-wmp_4-s_1026585633.png "title=" Netca_12 "alt=" Wkiom1kecphj5nqqaaddp9jkz-y886.png-wh_50 "/>Here's the Yes test, and then the end of the same as before, to this Oracle installation deployment has been completed[[email protected] ~]$ lsnrctl start# Start monitoringUnder
about it, the version is not the same, in fact, has been installed.Finally finished, end, exit can.So far, in a breath, we've just installed the Oracle software, and we haven't installed the Oracle database and the monitoring listener.Complete the above steps and continue to do the following:#netca configuration monitoring, step by step, all by default.After com
restriction can be used only when there is no record in the table or the default value is specified.1.3 DescriptionThrough the above description, I have a certain understanding of add column. Before Oracle 11g, if we want to add a column that is not empty, we need to specify the default value. If the table is very large, after adding the column, update all records in the table and add new default values. T
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.