create database link oracle 11g

Deptno drag and drop under the "area" (the location of the reference)14. Then click "Finish"15, at this time, a slider appears above the chart, and the data source of the slider is the value of Deptno, the following figure shows the Deptno=20 "Payroll Summary" bar chart16, you can drag the slider to the 30 position, where the bar chart will automatically switch to deptno=30 payroll (believe me, in the actual operation of the effect is better, because the actual operation, the transition effect

This article describes the process of installing Oracle 11g on RHEL 6.3. You can download RHEL from many image sites, such as Oracle 11g, note that the version 11.2.0.3 is used in this article. Currently, this version is not available for download only for paid accounts, if you need this version, you can contact me by

I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and delete the old user! Next we will introduce this new feature in the 11g r

variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Down

The following error occurred while starting the Oracle 11g RAC database, only one of the nodes could be started, and the other node could not start, possibly due to a previous modification of the Cluster_database parameter. This parameter must be set to true in the Oralc RAC schema. Error message: ora-01102:cannot Mount

Oracle Database 11g Release 2 installation on CentOS 6.6 (x64 platform)(note:the Current user is "tdtc100")1. Down Install files(1) Linux.x64_11gR2_database_1of2.zip(2) Linux.x64_11gR2_database_2of2.zip2. Unzip files(1) $> unzip Linux.x64_11gR2_database_1of2.zip(2) $> unzip Linux.x64_11gR2_database_2of2.zip3. Install Dependencies (manually)Optionally,

Oracle 11g manually create a database in windows 1. Create a required directory www.2cto.com D: \ app \ Administrator \ admin \ jxg12_20104350121 2. create a database file storage direc

Oracle 11g RAC remote database login time and OS time difference 16 hours solution Help colleagues install the RAC database of Oracle 11.2.0.4 for project stress testing. The operating system is red flag server 3. Today, my colleague suddenly called to say that the

; Dbms_output.put_line ('time is:'| | Mnttime); --Set Serveroutput on/off turns on or off the screen display dbms_output.put_line ('ok, im fine' ); end; /You can save the statement to a file and then call it with the "@/path/filename.sql".Substitution variables:SELECT empno, ename from EMP WHERE deptno= Department number;If the replacement variable provides data for a numeric column, you can drink it directly, or if you provide data for a character type or a date type, you ne

Because of the row link can only increase db_block_size to clear, and db_block_size after the creation of the database can not be changed, so there is no more than the purge of the row link, mainly for the row migration to talk about in the actual production system how to clear. The removal of row migrations is generally divided into two steps: The first step is

ORACLE 11g R2 database installation hardware environment requirements, 11gr2 Physical memory requirements: Minimum 1 GB, minimum 2 GB for windows7, windows8, and windows8.1. Virtual Memory (or paging space) capacity requirements: Available RAM Swap Space Required Between 2 GB and 16 GB Equal to the size of RAM More than 16 GB

Oracle Database 11g performance optimization strategy-optimizing Table PerformanceIntroduction 1-1 Create a database with optimal performance problem description www.2cto.com you realize that when you first create a

Connect to the oracle (11g) database using python, python11gPreparation: 1. Download the corresponding version of oracle-instantclient (I am here 11.2.0.1.0) http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html2. Installation rpm -ivh

: Database version is 11g Operation user must have SYSDBA permission Database parameter timed_statistics must be true IO must be allowed asynchronously, but with the file system, you can set the Filesystemio_options parameter to SetAll Ensure that the data file allows asynchronous IO, which can be confirmed by the following SQL statement

Oracle 11g Database Software Installation1. Modify the Oracle User environment variablesSu-oracleVI. bash_profileExport PATHExport ORACLE_SID=ORCLExport Oracle_base=/u01/app/oracleExport Oracle_home= $ORACLE _base/product/11.2.0/db_1Export path= $

Oracle 11g database security reinforcement considerations, oracle11g In database security configuration, security reinforcement is required. To ensure database security, however, sometimes, after improper operations or database bu

=xxg;# #rac operate one setStart the database:ALTER DATABASE Open # #rac above 2 machines to doAfter that, you can connect to the database, but what needs to be done now is to clear the archive log of the database, because now only increases the db_recovery space, we need to clean up the unnecessary archive log, to obtain space.Clear the Archive log script:#!/bin

should now is able to test the forward and reverse lookups using the "nslookup" command. The output below shows the forward and reverse lookups of the SCAN address.# nslookup Rac-scan.localdomainserver:192.168.0.4address:192.168.0.4#53Name:rac-scan.localdomainaddress:192.168.0.121Name:rac-scan.localdomainaddress:192.168.0.122Name:rac-scan.localdomainAddress:192.168.0.123# nslookup 192.168.0.121server:192.168.0.4address:192.168.0.4#53121.0.168.192.in-addr.arpa name = Rac-scan.localdomain.# nsloo

Database Installation After Oracle cluster installation, the next is the most important database installation, the entire database installation is not very difficult, the user as an Oracle user login RAC1 master node, the extracted file installation. After the main node ins

Error codes and explanations: Prompt to install Oracle 11G R2 64-bit version on Windows Server 2008 64-bit operating system: Unable to create item on Windows Start menu or desktop Workaround: This is because Windows Server 2008 uses the language in English by default, and when Oracle is installed, the correspondi