Oracle

-- Generate the credentialstore File [Oracle @ db12c ggs] $ ggsciOracle GoldenGate Command Interpreter for OracleVersion 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBOLinux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54

1. Create groups and users In linux, open the terminal and log on as the root user. Enter the following command: Groupadd dba // Add the dba group useradd-g dba-m oracle // Add the username as oracle and add the user to the dba group passwd oracle //

If you do not use the Custom Data Type of ODAC, you can also use several built-in SQL functions of Oracle Spatial to perform operations on the SDO_Geometry object. This method requires that all data be converted at the Database End (whether in

I. Start the listener and database 1. Start the listener: [root@JTWF oracle]# su oraclebash-4.1$ lsnrctl start If the result is as follows, the startup is successful: LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014

Today is 2014-04-03. Let's take a look at a problem today. Environment Introduction: Gi version: 11.2.0.4.0 Database version: 11.2.0.4.0 Oracle linux: Linux Server release 6.4 RAC dual-node ASM + restart-alone ASM Problem description: When you start

Today, an online database (version 11.2.0.1) cannot establish a new connection, but the original connection is not affected. alert. log reports the following error: Opiodr aborting process unknown ospid (22997) as a resultORA-609 However, the

Select logid, userid, logtime, url, description, (case operatetype when operatetype = 0 then' add 'when operatetype = 1 then' modify 'else' Delete 'end case) from log ???? 1. case Select logid, userid, logtime, url, description ,( Case When

Returns the string to the left. Lpad (field name, fill length, fill character) Lpad (,) dual; Rpad (,) dual; () Dual; () Dual; Uppercase letters Initcap () dual; Length () dual; Substr (,) dual; Instr (,) dual; () Dual; CONCAT (,)

First of all, this need to use ODAC, that is, Oracle. DataAccess. dll, the new managed Oracle. ManagedDataAccess. dll does not support Object Type, can not use ODAC reference: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.htmlODAC

1. insert into t1 values (...)Should be: insert into t1 (...) values (...)2. to_char (sysdate, 'yyyymmddhhmms ')Changed:To_char (sysdate, 'yyyymmddhh24mis ')3. select count (*) into v_count from t1 where c1 = ?;No_data_found error will never be

View Current Database name V$ SYS_CONTEXT(,) dual; Username, default_tablespace user_users; Check the default tablespace of the current user. User_sys_privs; View permissions of the current user Username, default_tablespace user_users; View the

When using ORACLE databases, sequence + triggers are often used to set auto-increment fields for a table. However, when you need to import and export databases, the sequence is prone to problems. When you export the database and import it to

1.1. ORA-00845 ORA-00845: MEMORY_TARGET not supported onthis system 00845,000 00, "MEMORY_TARGET notsupported on this system" // * Cause: The MEMORY_TARGET parameter wasnot supported on this operating system or/dev/shm was not sized correctly

Symptom: Expdp reports the following error ORA-39006: internal errorORA-39213: Metadata processing is not available reference metalink: Ora-39213 Using Data Pump Export (Document ID 402242.1), execute the following statement: SQL> execute sys. dbms_

1. Install oracle11g. The installation diagram is as follows: 1. decompress the win32_11gr2_database_1of2.zipand win32_11gr2_database5of2.zip files. Note: extract the two files to the same directory, that is, merge the Components directories

8.3.5 Adding or Dropping Online Redo Log Files 8.3.5 add or delete the current redo log file Changing the size and number of the online redo log files is sometimes done to tune the database. you can add or drop online redo log file groups or members

8.3.3 Using Transportable Tablespaces with a Physical Standby Database 8.3.3 use of the transmitted tablespace in the physical standby Database You can use the Oracle transportable tablespaces feature to move a subset of an Oracle database and plug

Environment: Oracle Linux 6 (64 bit) Download mysql: http://dev.mysql.com/downloads/mysql/5.1.html version: 5.5.36 platform: Source Code Generic Linux (Architecture Independent), Compressed TAR archive(mysql-5.36.tar.gz) to download this package of

Common commands in Oracle 1. Create a userCreate user Username identified by passwordNote: The username and password should be in English.For example, create user sms identified by sms; 2. Create a tablespaceCreate tablespace name datafile 'Storage

Symptom: Reporting PRVF-5646 when installing Oracle grid 11.2.0.3/4: The DNS response time for an unreachable node exceeded "15000" MS on following nodes Solution: ? 1. Modify the/etc/named. conf file of the DNS server and add the fil "/dev/null";