Others

[Root @ Rac1 admin] # tnsping rac2 TNS Ping utility for Linux: Version 11.2.0.3.0-production on 19-jul-2013 20:40: 45 Copyright (c) 1997,201 1, Oracle. All rights reserved. Used parameter files:/U01/APP/GRID/11.2.0/Network/admin/sqlnet. ora

Sometimes, we will find that the status of the replicat process is running, but the report shows that no record is updated. There are four main reasons for this phenomenon:1. The replicat process is reading the wrong trail record.2. The replicat

SQL> select Sal from Scott. EMP where job = 'manager '; Sal---------2975.002850.002450.00 Any: SQL> select EMP. empno, EMP. ename, EMP. job, EMP. sal from Scott. EMP where SAL> Any (select Sal from Scott. EMP where job = 'manager '); Empno ename job

Last night, goldengate ctor found that the extract process on most databases in the production environment often automatically abended, and then restarted normally like nothing in a few minutes. Analysis of ggserr. Log found: 06:05:15 error OGG-01028

Today, my colleague reported the following error when starting an Ogg replicat process in a new stress test environment: 16:37:41 error OGG-00665 OCI error executing single row select (status = 1502-ora-01502: Index 'ggs. sys_c00188744 'or partition

If you use data pump in Oracle Automatic Storage Management (Oracle ASM) storage to import or export data, you must useThe Oracle ASM disk group name (rather than the operating system directory path name) defines the directory object used to store

1. I won't let her go without a fight! I won't let her go. 2. It cocould happen to anyone./It happens to anybody./That happens. This may happen to anyone. 3. I'm a laundry virgin) 4. I hear you. I know what you want to say. /I understand what you

EXP-00056: Oracle error 12154 encountered ORA-12154: TNS: cocould not resolve service name EXP-00000: Export terminated unsuccessfully Cause: the import or export cannot find the net service name to connect to the database. import and Export

  [Oracle @ rac2 ~] $ Crs_stat-TCRS-0184: cannot communicate with the CRS daemon.   [Oracle @ rac2 cssd] $ tail-200f ocssd. Log[Cssd] 17:28:46. 605 [3020250016]> trace: clssnmrcfgmgrthread: Local join[Cssd] 17:28:46. 605 [3020250016]> warning:

Select T. instoreitemid, II. textattr12, T. binbin2id from binbin1 T, binbin2 II where II. textattr11 = '0' and T. binbin2id = II. binbin2id;No rows selected Elapsed: 00:04:14. 28 Execution Plan--------------------------------------------------------

In the morning, goldengate r44xib1 abbended. Ggsci (yjportfrt001) 1> Program Status group lag time since chkpt   Manager running Replicat abended r44xib1 00:00:06     Ggsci (yjportfrt001) 2> Error: replicat r44xib1 not currently running. No special

CD/u01/Oracle/product/10.2.0/Network/admin [Oracle @ test admin] $ VI listener. ora Sid_list_listener =(Sid_list =(Sid_desc =(Sid_name = plsextproc)(ORACLE_HOME =/u01/Oracle/product/10.2.0)(Program = EXTPROC)) ) Listener =(Description_list

Count the number of files in a folderLs-L | grep "^-" | WC-lCount the number of directories in a folderLs-L | grep "^ d" | WC-lCount the number of files in the folder, includingLs-LR | grep "^-" | WC-lFor example, to count all JS files under

Database Version SQL> select * from V $ version;   Banner Slave -------------------------------------------------------------------------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

When installing Oracle 10.2.0.1 on Oracle Linux 6.1 and creating an instance in dbca: ORA-27125: Unable to create shared memory segment Installation interrupted Rac2:/u02> oerr ora 27125 27125,000 00, "unable to create sharedmemory segment" // *

Exercise: 1. display the lines starting with "S" of the/proc/meminfo file with no size difference; Grep-I s/proc/meninfo 2. display the rows ending with nologin in/etc/passwd; Grep nologin $/etc/passwd 3. the/etc/inittab starts with #, followed by

Principle of DNS Server Domain Name SystemIt is a TCP/UPD-based service that listens to port 53 on both TCP and UPD. At the beginning, when the network was just born, there were only a few computers connected to the network. With the development of

From: http://blog.csdn.net/nsj820/article/details/6744842   SQL * loader is an oracle high-speed Batch Data Loading tool. This is a very useful tool that can be used to load data from multiple flat file formats to Oracle databases. Sqlldr can load a

From: http://blog.chinaunix.net/u/19573/showart_1854571.html 4.2.1. printk # Include Printk (kern_crit "error % s, % I" ,__ file __,__ line __); Note: 1) The priority can be specified in the printk function. If the printk does not specify a

The DOM method directly loads all XML files to the memory and creates a DOM tree. Features: readable and writable, supports XPath, but it is very slow and occupies 10 multiples of XML memory, cannot process large files.The sax method is the event