Others

1. Create/var/ftp[Root @ aix210:/] # ls/var/ftp/Var/FTP not found[Root @ aix210:/] # mkdir/var/ftp 2. Create an FTP group ftpgrp[Root @ aix210:/] # mkgroup ftpgrp 3. Create a user FTP[Root @ aix210:/] # mkuser home =/var/FTP shell =/usr/bin/bsh su

Import: import data to the structure first. Import structure: IMP system/easydba @ epcdb file = gh_20130529.dmp log = gh_imp12.log fromuser = GH touser = GHRows = NIgnore = y statistics = none Import data:IMP system/easydba @ epcdb file = gh_20130

I have been internship in this company since July December and am now in the final process. I have never encountered any interpersonal problems. My colleagues are very good. Although I am not very familiar with everyone, I am still quite comfortable

Generally, our production database has a relatively high pressure on node 1 and a relatively low pressure on node 2. The observation of memory and CPU usage is also relatively low on node 2, therefore, indexes are created on node 2 and run

Author: skate Time: 2011-03-15 Beggars Marketing Theory     I took the Levi's I just bought out of maoye and stood at the door and waited for a friend. A professional beggar found me and was very professional and straight forward to me. This pause

Author: skateTime: 2011/08/22   Disk Performance Improvement bottleneck Linux memory file system: ramdisk, ramfs, tmpfs   Ramdisk: Is a block device. You must format it with the selected file system before using them. It is troublesome to adjust the

Author: skateTime: 2011/05/03   Waiting event: reliable message   The Metalink description is as follows:     When you send a message using the 'ksr' intra-instance BroadcastService, the message publisher waits on this wait-eventAll subscribers

  Author: skateTime: 2011/08/22   Basic test method for disk performance: Dd If =/dev/Zero of = tmp bs = 1 m COUNT = 10 // use the DD command to test the instant write capability Iozone-a-I 1-I 0-C-G 5 m-N 1 m // you can test disk performance in

Concepts and terminology of RMAN backup 1. Open backup2. Closed backup3. Complete backup4. Incremental Backup Cold backup: consistent backup, offline backup, and closed backupHot Backup: Non-consistent backup, hot backup, open backup Open backup can

C: \ Documents ents and Settings \ Administrator> impdp bosadmin/"mm" dumpfile = bosdata. Logs tables = T1 logfile = dump_dir.log directory = cxdump_dir flashback_scn = 26631739806 table_exists_action = replaceConnected to: Oracle Database 10g

Select File #, online_status "status", to_char (change #, '000000') "SCN", to_char (time, 'yyyy-mm-dd hh24: MI: ss ') "Time" from V $ recover_file; File # status SCN time-----------------------------------------------------2 offline 30989922666 18:06

Before leaving work today, I am going to add an ASM disk group to the clear-sharded AIX host because there is no operation document in hand. At that time, the hardware vendor was at the system levelAfter the shared disk is added, it is directly

These two days we found a strange problem, that is, when the source end inserts a piece of data, it will cause the target end to be inserted twice, and then the target end violates the uniqueness constraint, and the process is abended. The following

I found that the CPU usage of the master database continued to remain high at around 90% o'clock this morning, and the database should be idle at this point.Topas found that all the processes consuming CPU are ggsci processes. Topas monitor for host:

  V $ lock view the lock in the current system Column Datatype Description ADDR Raw (4 | 8) Address of Lock State object Kaddr Raw (4 | 8) Address of lock Sid Number Identifier for session

In many cases, we need to dump ORACLE data blocks for further research. To study the contents of these data blocks, Oracle provides a good way. The following example is a simple explanation: [Oracle @ jumper udump] $ sqlplus "/As sysdba"SQL * Plus:

Goldengate fault SummaryUser does not exist Problem description: 10:45:20 GGS error 2001 Oracle goldengate delivery for Oracle, rcrmheal. PRM: Fatal error executing DDL replication: Error [error code [1918], ORA-01918: User 'kingstar' does

C: \ Users \ Administrator> impdp u1/U1 dumpfile = tmp_1.dmp directory = dir tables = Scott. tm_out_b1 logfile = 1.Log Import: Release 11.2.0.1.0-production on Monday May 7 16:53:06 2012 Copyright (c) 1982,200 9, Oracle and/or its affiliates. All

C: \ Users \ Administrator> impdp boss/boss directory = dir dumpfile = out-% u. dmp remap_schema = BOSS: Boss remap_tablespace = nnc_data01: Users remap_tablespace = nnc_data02: UsersRemap_tablespace = nnc_data0 3: usersremap_tablespace = nnc_data04:

It is inconvenient to use sqlplus in Linux. The upper and lower keys and the backspace keys cannot be used, seriously reducing production efficiency. Rlwrap can solve this problem! Download rlwrap: http://download.csdn.net/detail/sharqueen/5433087 1