oracle data integrator 11g

Kernel.shmmax = 2147483648 Kernel.shmmni = 4096 Kernel.sem = 32000 Net.ipv4.ip_local_port_range = 9000 65500 Net.core.rmem_default = 4194304 Net.core.rmem_max = 4194304 Net.core.wmem_default = 262144 Net.core.wmem_max = 1048576 5) Edit/etc/profile, enter the command: Vi/etc/profile, Press the I key to enter the editing mode, the following content to join the file. if [$USER = "Oracle"]; The

in the Oracle 11g , open Archive Log mode, the default archive directory is db_recovery_file_dest specified. This parameter can be specified in Pfile/spfile:Show Parameter Db_recovery_file_destdb_recovery_file_dest= /oracle/11g/flash_recovery_areaChange Archive modeneed to be MountState, change the archive mode. sql>

"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

system (for example, OCFS2 or ACFS), and adding new nodes to the cluster is simplified because the software does not need to be reinstalled on the new node. Patching is also simplified-only one Oracle home directory needs to be patched. But patches cannot be installed in rolling, so downtime is unavoidable. During the installation, Oracle Universal installer will alert the administrator to install or upgra

sensitive. In SQL * Plus, each SQL statement must end with a semicolon. If the statement is long, You can distribute the statement text to multiple rows and end with a semicolon. 2.1 common Oracle 11g Data Types Character Type CHAR type CHAR indicates a fixed-length string. If the length is insufficient, spaces are used to supplement the string. Up to 2000 byt

-productionCORE 11.2.0.1.0 ProductionTNS for Linux:version 11.2.0.1.0-productionNlsrtl Version 11.2.0.1.0-productionsql> drop table test purge;Sql> CREATE TABLE Test as SELECT * from Dba_objects;sql> INSERT INTO Test select * from Dba_objects;Sql> commit;Sql> Select COUNT (*) from test;COUNT (*)----------149012Sql> Set Timing onSql> ALTER TABLE test add col1 char () DEFAULT ' LARGE COLUMN ' not null;Time used: 00:00:00.07sql> SELECT SUM (BYTES)/1024/1024 | | ' M ' from user_segments WHERE segmen

database to local, error is as follows:Encountering errors in Export logfileExp-00008:oracle Error # encounteredora-01455:converting column overflows integer datatype2, in 11g environment with EXP will export data, and then through IMP user/[email protected] remote way to import, error is as follows:IMP-00015: Because an object already existsDescription: Before

With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer: Oracle RMAN compatibility and FAQs between different versions and different platforms This article demonstrates an example of restoring 10 Gb to 11 GB in linux. Target end: OS: Ora