create database link oracle 11g

In Oracle 11 g2, duplicating a database has two methods: 1. Active database duplication2. Backup-based duplication The advantages of using duplicate for a database are:Test backup and recovery proceduresTest an upgrade to a new release of Oracle DatabaseTest the effect of ap

Tags: database start-Stop1. Stop the databasesql> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.2. Start the databaseSql> startup;ORACLE instance started.Total System Global area 795127808 bytesFixed Size 1339456 bytesVariable Size 494931904 bytesDatabase buffers 293601280 bytesRedo buffers 5255168 bytesDatabase mounted.Database

In some cases, you need to associate different databases for Data Query and operations. In Oracle, database links are used to associate tables with different databases ). There are two ways to create a DB link: Creating an SQL statement and creating it on a visual interface (actually an executed SQL statement ). 1.

Oracle 11g installation causes the database to fail to automatically collect statistics, oracle11g Recently, it was found that some 11 GB databases could not automatically collect statistics. Some View query results are as follows: SQL> select client_name, status from dba_autotask_client where client_name = 'Auto optimizer stats collect ';CLIENT_NAME STATUS------

Oracle 11g export database does not export empty tables, oracle11g Oracle11g may encounter such a problem. When using exp to export the entire database, this problem occurs, and empty tables in the database cannot be exported. Select * from all_all_tables aa where aa. owne

Http://www.oracle.com/technetwork/database/windows/downloads/index-093848.html http://blog.csdn.net/robin_he/article/details/7345842 Oracle 11g R2 11.2.0.3 Patch set for Winnt 32bit Do not explain the need to hurry down AH 115 closed public-sharing services This is the updated address need to register 115 users to protect their own network disk and then dow

Label:ORACLE_11G has 32-bit and 64-bit two versions, 64-bit computers can be installed in 32-bit versions, but 32-bit computers can not be 64-bit, if you are 64-bit, it is recommended that you install a 64-bit version.Install package Download 32-bitHttp://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip ;Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2.zip ;64-bit http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip

1. View database Information Show parameter instance_name Show parameter Db_name Show Parameter Service_Name Select dbid from V$database; 2. Normal Shutdown database Sqlplus/as SYSDBA Sql>shutdown Immediate 3. Start database to mount mode Sql>startup Mount 4. Confirm that the listener is activated. Lsnrctl s

1. application scenarios:Environment:Host Name ip vip sid DiskGroupDb1 1.1.1.1 1.1.1.11 bkjia DATA1Db2 1.1.1.2 1.1.1.12 bkjiadb DATA2Expected results:Db1 and db2 can be backed up to each other. Here db1 is used as the master database, and db2 is used as the slave database to explain how to mount the disk groups DATA1, DATA2, and, all running instances bkjia and bkjiadb use virtual IP addresses as client acc

does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web

Label:There are 4 main architectures for Oracle databases: Physical storage structure Logical storage structure Memory structure Process structure I. Physical storage structureThe Oracle database is physically composed of system files stored on disk, which is the physical storage structure of Oracle.1.

/bp_oracle Directory=dump_dir dumpfile=bp_oracle.dmp version=10.2.0.1.0--Remove TablespaceDrop tablespace bp_oracle including CONTENTS and datafiles;--delete the user, and execute the statement carefully, the Cascade deletes all objects under that user.Drop user bp_oracle cascade;--Modify User passwordAlter user bp_oracle identified by bp_oracle; --Export database with no versionEXPDP bp_oracle/bp_oracle schemas=bp_oracle dumpfile=bp_oracle20120221

The establishment and use of Oracle database linkFirst, the establishment of the database link:1, the database link building syntax is generally: Create databases

the web for PL/SQL Deleloper 64-bit version. However the Discovery PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client. 2. Install Oracle ClinetFirst download an Oracle

Startup Alter system register; Then run the lsnrctl status Command to display the following information: LSNRCTL for Linux: Version 11.2.0.1.0-Production on 27-JUL-2012 14:53:28 Copyright (c) 1991,200 9, Oracle. All rights reserved. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521 ))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0-Production

problem analysis: According to the ORA-01017 prompt is connected to the other side of the user password error, and then directly using the configured user password (LSXY/LSXY) log in to the database to find a normal login, further review the established Dblink statement, where the user name converted to uppercase, This guesses whether the password is also converted to uppercase, which results in a bad password. According to speculation Baidu, there i