create database link oracle 11g

I see a lot of questions on shared file systems the can used when people move from single instance to Oracle RAC Datab ASE and Grid Infrastructure. The most common question are the following: "should I place archive logs in OCFS2 or ASM or ACFS of 11g?" I ' ll try to clarify this topic below.First we need to understand a separation between Oracle

------------------------------------------------------- ----------------------db_recovery_file_dest string/data/app/oracle/recovery_areadb_recovery_file_dest_size Big in Teger 2GTo view usage status:Sql> select Name,space_limit,space_used,number_of_files from V$recovery_file_dest;NAME--------------------------------------------------------------------------------Space_limit space_used Number_of_files------------------------------------/data/app/

directly; Begin Send_mail (' Test content '); End; / ORA-29278:SMTP Temporary error: 421 Service not available ORA-06512: in the SYS. Utl_smtp ", line ORA-06512: in the SYS. Utl_smtp ", line ORA-06512: in the SYS. Utl_smtp ", line 139 ORA-06512: In" SYS. Utl_mail ", line 405 ORA-06512: In" SYS. Utl_mail ", line 594 ORA-06512: In line 2 The first time I saw this error was very shocking, because the entire mail sent stored procedures are first used pl/sql directly test the code, then encapsu

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

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

Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oelr5u8-1.localdomain 2.6.32-300.10.1.el5uek #1 SMP

Tags: capacity www. Lib BST ksh opening an ace share pictureReference article:Http://www.cnblogs.com/lightnear/archive/2012/10/07/2714247.htmlHttp://www.cnblogs.com/xqzt/p/5456401.htmlHttp://www.cnblogs.com/anzerong2012/p/7528311.htmlFirst, installation environmentCentOS Linux release 7.2.1511 (Core)Oracle Database 11g Release 2 (11.2.0.4)Second, before the insta

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 is anim

can not fill in, just received some useless mail only). Cancel the following "I want to accept security update (W) via my Oracle support." As shown in figure: 5. Security options, directly select the default to create and configure a database (after installing the database management software, the system will au

Tags: character tab create file variable order default Max RIPCREATE Table Statement CREATE table [schema.] Table name (column datatype [DEFAULT expr][, ...]); Specify a default value for the column during the insertion ... hire_date date DEFAULT sysdate,... The default value must satisfy the data type definition of the column CREATE TABLE Hire_dates (ID number (

from the master database to the Standby DB:SQL> alter system set log_archive_dest_state_2 = defer;Re-enable log transmission after flashing back:SQL> alter system set log_archive_dest_state_2 = enable; Oracle 11g environment:The steps are simpler. The new features of Snapshot Standby Database are added to the

Tags: size reliable moderator large online benefits audit security soft High reliability. The ability to place server failures, site failures, and human errors wherever possible. High security information. Data security and compliance can be ensured with a comprehensive meeting of row-level security, fine-grained auditing, transparent data encryption, and data. Better data management. Easily manage the entire lifecycle of information for the largest

Tags: style blog color using file data sp div problemThe backup file was exported from 11g with the exp command, and the above error occurred with IMP Import under 10g, in the case of a lower version of the backup that does not support a higher version, so the use of 11g test, or the above problem.In fact, the size of the table space is not enough, the following is the answer on the Internet:Table space is

1. Create a TNS string:Zqxt =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 132.97.172.186) (PORT = 1521 )))(CONNECT_DATA =(SERVICE_NAME = ora11g)))2. query the tablespace SQL of remote data:1) select distinct 'select dbms_metadata.get_ddl (''tablespace '', ''' | tablespace_name | ''') from dual; 'from dba_tables; obtain the query SQL for each tablespace.2) run the SQL statement to find the tablespace.3.

security of the database, once lost, it is difficult to find back. Therefore, it is hoped that through the establishment of database clusters, the redundancy of the data set, the backup data to ensure security. Classification of database clusters Database cluster technology is a technology that combines multiple serve

available RAM and swap space, enter the following command: FreeAutomatic Memory Management Starting with Oracle Database 11g, the Automatic memory Management featurerequires more shared Memory (/DEV/SHM) A nd file descriptors. The size of the sharedmemory must is at least the greater of the Memory_max_target and Memory_targetparameters For each

systems, but since we have a grid, it can also be built on ASM disk groups. Vi. creation of ASM disk groupsWe go into the bin directory of the grid and execute the ASMCA command Then create an ASM disk group Specifying ASM Disks Change the path to our ASM disk to sit in the pathOur ASM disk is under this path The ASM disk is discovered when the modification is complete. We name the disk group data and the redundancy mode is external.Then

After the CentOS system is installed, you can start the installation of Oracle 11g. First, you must make some preparations. Use commands to create an Oracle account and corresponding user groups Create a folder and grant the Oracle