Quick tutorial on SQL * LoaderText/Fan ShengSQL * loader is a data loading tool for Oracle. It is usually used to migrate operating system files to Oracle databases. SQL * loader is large dataRepository selection method, because it provides the fastest way (direct, parallel ). Now, let's leave aside its theory and use instances to makeYou can quickly learn how to use SQL * loader.First, let's get to know SQL * loader.In NT, the SQL * loader command is sqlldr, and in UNIX it is generally sqlldr/s
Raphael Savir, main developer, ls development configurationraphael Savir is the main developer of LS Development Corporation (http://www.lsdevelopment.com) and has been committed to developing notes/Domino applications since the beginning of 1990s
Program And analyze application performance issues. He gave speeches on these topics at lotusphere and several other conferences.
Introduction:Read quick search in IBM Lotus Notes and DominoCode11 tips.
The Client Version is 10.2.0.1.0 32-bit, and the server is 9.2.0.4.0 64-bit. Client Connection server reported ORA-28547: Connection server failed, may be an Oracle Net management error.The status is as follows:
C: \> sqlplus "sys/Oracle @ vm9i as sysdba"SQL * Plus: Release 10.2.0.1.0-production on Thursday January 7 13:41:20 2010Copyright (c) 1982,200 5, Oracle. All rights reserved.Error:ORA-28547: failed to connect to the server, possibly an Oracle Net management error
Enter the User Name:Erro
the port currently in use by dbcontrol. The default port is the http port of dbcontrol.1158, The agent port is 3938. To reconfigure the port, run the following command:
Emca-reconfig ports-dbcontrol_http_port 1159
Emca-reconfig ports-agent_port 3939
Use the command line toolEmctlCan start/stopConsoleService, view service status, etc.
D:> emctl start dbconsoleOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright (c) 1996,200 6 Oracle Cor
1. Oracle Installation
Please refer to the following link for more information: http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html.
2. Use the command line sqlplus to connect to Oracle
(1) Check the listening status
C: \> LSNRCTL status
LSNRCTL for 32-bit windows: Version 9.2.0.1.0-production on 2005 11:01:01
Copyright (c) 1991,200 2, Oracle Corporation. All rights reserved.
Connecting to (description = (address = (Protocol = TCP) (host = oyez)
> Format 'C:/Oracle/RMAN/DB _ % d _ % S _ % P _ % T ';5> release channel D1;6>}
1. Check the dbid of the target database:C:/> sqlplus RMAN/RMAN @ RMAN
SQL * Plus: Release 9.2.0.1.0-production on Thursday April 7 14:26:57 2005
Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
Connect:Oracle9i Enterprise Edition Release 9.2.0.1.0-ProductionWith the partitioning, OLAP and Oracle Data Mining optionsJserver release 9.2.0.1.0-Production
SQL
Server. After all the configurations are complete, click Next to complete the installation.
If everything is normal, OUI will see The Installation Of Oracle9i Database Was successful. this indicates that your Oracle9i Database is properly installed. If you want to Install other content, press the Next Install button to Install other content. Otherwise, press Exit to Exit the installation.
Use Oracle 9i Database
After the installation is complete, the Oracle database will be automatically star
1 Huawei Technology Ltd. 6223602 ZTE Corporation 6013313 Hisense Group Co., Ltd. 4486414 ut Starcom Communications Ltd. 3867635 Haier Group Company 3336646. Digital China Ltd. 3118627 Zhejiang Zhe dawang New Technology Co., Ltd. 2887818. pandatv Group Co., Ltd. 2335729 inspur Group Co., Ltd. 18104610 Neusoft Group Co., Ltd. 17419611 Beijing Peking University Founder Group 17171112 Microsoft (China) Ltd. 16331313 Chaohua Technology (Group) Co., Ltd. 15
After installing the OEM grid control 11g, reinstall the agent on a monitoring server and the agent will not be able to work. The error "EMD upload error: uploadXMLFiles skipped" will be reported during the emctl upload check ". As follows:
[Oracle @ codb2 ~] $ Emctl upload
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996,201 0 Oracle Corporation. All rights reserved.
--------------------------------------------------
ERROR-Agent is blocked. Blocked reason is: Agent is out-of-sync with repository, mavenrepository
[oracle@node2-prod1 bin]$ ./emctl status agentOracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0 Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.---------------------------------------------------------------Agent Version : 11.1.0.1.0OMS Version : 11.1.0.1.0Protocol Version : 11.1.0.0.0Agent Home : /u01/app
OPatch reports Prerequisite check "CheckActiveFilesAndExecutables" failed, opatch
Prerequisite check "CheckActiveFilesAndExecutables" failed
Problem background:When we patch the Optatch database, the system suddenly reports the error CheckActiveFilesAndExecutables, which causes the patch to fail to be applied.
Symptom:
[oracle@db01 18522509]$ /home/oracle/OPatch/opatch applyOracle Interim Patch Installer version 11.2.0.3.6Copyright (c) 2013, Oracle Corporati
[Windows] _ [elementary] _ [use the command line tool dumpbin to analyze the file] and command line dumpbin
Dumpbin (vs built-in)
1. Export the function symbol (symbols) of the lib File)
Dumpbin/exports zlib1.lib
Microsoft (R) COFF/PE Dumper Version 10.00.40219.01Copyright (C) Microsoft Corporation. All rights reserved.Dump of file zlib1.libFile Type: LIBRARY Exports ordinal name 1 _adler32@12 140 _adler32_co
My Fujitsu s7211 laptop screen is not as bright as Ubuntu 10.04 in Vista, and I always thought it was a driver problem. Later, I found from my blog that the brightness can be adjusted. Two methods: 1. Adjust the GAMMA value of the screen contrast Parameter > Xgamma-Gamma. 75 If not, try to change. 75 to 0.5 ~ Test between 1.0. After I use 1.0, I feel that the brightness is the same as that under Vista. This command does not require administrator privileges. 2. Adjust the backlight brightness
Remote Sensing Satellite 6
At 10:55 A.M. on July 26, China sent the "China Remote Sensing Satellite 6" to space using the "changzheng 2 C" carrier rocket at the Taiyuan Satellite Launch Center.
The launch of "China Remote Sensing Satellite 6" was developed and produced by the Shanghai Institute of aerospace technology, affiliated to China Aerospace Science and Technology Corporation. Satellites are mainly used in land and resources exploration, enviro
, East District, Zhongshan, China 528400
361012 Wang Kun, Room 601, No. 34, longchangli, five village, Lianhua city, Xiamen City, Fujian ProvinceWang KunRoom 601, No. 34 long Chang Li, Xiamen, Fuji, China 361012
361004 Xiamen Public Transport Corporation promises to run Wang KunMr. Wang KunCheng Nuo Ban, Gong Jiao Zong Gong si Xiamen, Fuji, China 361004
266042 Jia wangkun, Unit 2, building 1, dormitory 2, No. 53 Kaiping Road, Qingdao City, Shandong Pr
Document directory
Microsoft C #
Potential future functions
Generate the latest generic class
Create and use generic
Advantages of generics
Generic support in other languages
Released on: 4/30/2003 | updated on: 6/25/2004
Prashant sridharan
Microsoft Corporation
Applicable to: Microsoft Visual C # (TM)
Summary: Microsoft Corporation is developing the next major version of C. This article introduces
The target database version is oracle8.1.7, the directory database version is oracle9.2.0, and all data files (including control files and On-line log files) are lost. Examples of using RMAN for backup and recovery are as follows:
Tutorial steps:
1. Create a tablespace in the directory database to restore the directory:
SQL> Create tablespace rmants datafile '/opt/Oracle/DB02/oradata/orcl/rmants. dbf' size 100 m autoextend on next 1 m maxsize unlimited;
Tablespace created.
2. Create and authori
dbcontrol http port1158, The agent port is 3938. To reconfigure the port, run the following command:
Emca-reconfig ports-dbcontrol_http_port 1159
Emca-reconfig ports-agent_port 3939
Use the command line toolEmctlCan start/stopConsoleService, view service status, etc.
D:> emctl start dbconsoleOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright (c) 1996,200 6 Oracle Corporation. All rights reserved.Http: // hostname: 1158/EM/co
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.