hardware and software configuration support, its operation efficiency will be greatly reduced.
Hardware configuration:
Application:
This article mainly introduces the application and implementation of Oracle Database in the network, taking into account the knowledge structure andArticleAccording to the different access methods in database setup and operation, the author divides the application of network databases into two general modes: one
OUI: Oracle Universal Installer (for details about OUI, refer to google)My system: RedHat enterprise server 6.0My oracle: 10g. 2.1
Graphical installation process using OUI:1) confirm the disk size: u01 5G; swap 400 m;Du-sh/tmp/Df-h
2) install related dependency packages (query the official installation guide documents based on the System Version)I do not recommend that you check whether the package is insta
Oracle Database Backup and upgrade, oracle Database Backup
Log on to the server where the database is located as an oracle user. For example, the home directory is/home./oracle. Run the following command to back up the database.
Sqlplus/nolog
Connect/as sysdba
SQL> createdirectory dump_bx as 'specify a directory for s
How to deal with the rapid growth of oracle archive logs, oracle archive logs
Oracle archive logs are generally generated by dml statements, so the increase speed should be too frequent by dml.
First, query the generation of the following daily archives:
Select trunc (FIRST_TIME) "TIME ",SUM (BLOCK_SIZE * BLOCKS)/1024/1024/1024 "SIZE (GB )"From v $ ARCHIVED_LOGGr
EXP-00008: encountered Oracle error 904 ORA-00904: "maxsize": Invalid identifier
Cause: the Oracle version is different.
Run
C:/> exp PLX/PLX @ orcl file = C:/PLX. dmp tables = (S, SC, c)
Result Error
Export: Release 11.1.0.6.0-production on Sunday July 26 12:42:19 2009
Copyright (c) 1982,200 7, Oracle. All rights reserved.Connect to:
First, install DockerLinux system can be directly used for Docker installation;Win7 system Installation Dokcer is actually implemented through Boot2docker installation of a virtualbox under Windows;Boot2docker support for WIN10 systems is not very friendly, the good news is that there is now a dedicated Docker installation package for WIN10: Docker-tollbox;Docker-tollbox:https://www.docker.com/products/docker-tollboxDockerToolbox.exe after the download is complete, click Install package to insta
The Oracle database is powerful and performance-rich, and while creating these benefits, Oracle accounts for more memory. In response to this question, how do we take its essence to its dross?Solution: We can install a large Oracle database on a server within the LAN, install an Oracle client on the developer's PC, and
Tags: Oracle training Oracle Tutorial Oracle video Oracle Video tutorial Oracle Database tutorial Oracle Video tutorial goals Oracle Video tutorial, wind Brother this set of
Oracle String FunctionsRecently changed the new company, and back to the Oracle database, a lot of things have forgotten, just have an impression, these two nights smoked a bit of time, the oracle of the string of some processing functions to do a bit, for later review.Normally we use Oracle to have two main types of s
Tags: oracle-11g navicat win7-64bitNavicat for Oracle Connect Oracle 11G operation Flow 1 Changing the Oracle configuration file After you install Oracle 11g, you need to change the Listener.ora and Tnsnames.ora two files under the C:\Or
The official documents are described as follows:3 Installing Oracle Grid Infrastructure and Oracle Real application ClustersCaution:After installation are complete, does not remove manually or run cron jobs that remove/tmp/.oracle or/var/tmp/.oracle Direc Tories or their files while
Summary of Common commands for executing scripts in Oracle databases and common commands in oracle
1. Execute an SQL script file
Copy codeThe Code is as follows:Sqlplus user/pass @ servicename
Or
Copy codeThe Code is as follows:SQL> start file_names
Or
Copy codeThe Code is as follows:SQL> @ file_name
We can save multiple SQL statements in a text file, so that when we want to execute all the SQL statements
This article mainly discusses the following sections: How to view query Oracle character set, modify settings character set, and common Oracle UTF8 character set and Oracle exp character set issues.
One, what is the Oracle character set
An Oracle character set is a collectio
)(service_name = * *)))Note: The red part of the figure changes according to your needs.
Configuration PL/SQL Developer to connect:
in tools/preference oracle-connection option configuration oracle home and oci library :
Oracle Home : E:\ProgramFile\instantclient
OCI Library : E:\ProgramFile\instantclient\oci.dll
co
About OracleOracle Database, also known as Oracle RDBMS, or Oracle. is a relational database management system of Oracle Corporation. It is a leading product in the field of database. It can be said that Oracle database system is currently the world's popular relational database management system, System portability, e
Navicat for Oracle connection to Oracle 11G operation process, navicat11g
Procedure for connecting Navicat for Oracle to Oracle at 11 GB
1. Change the Oracle configuration file
After installing Oracle 11g, you need to change the
Common Methods for viewing Oracle execution plans-Series 1: oracle execution plans
The SQL Execution Plan actually represents the specific execution steps of the target SQL in the Oracle database, only by knowing whether the execution plan selected by the optimizer is the optimal execution plan in the current situation can you know the next step.
Execution Plan
Failure phenomenon:How do I make a cold backup of an Oracle database in case of an emergency, without opening the Oracle log archive?Solution:
A cold backup of the Oracle database, sorted as follows:
When do I have to use cold backup?
1. Database mode is not archive mode
2. For field protection
The process of cold backup:
1. First view the location of the b
1, Redo Log Buffer
Redo Log Buffer is a cache of database modification information stored in the SGA. This information is stored in the Redo entry (Redo Entry). The redo entry contains the necessary information to rearrange or redo the database because of modifications made by insert, UPDATE, DELETE, CREATE, Alter, or drop. When necessary, redo entries can also be used for database recovery.
The redo entry is a copy of the Oracle database process fr
Tags: ROM editor development targe data Common password color sizeBrief introduction:It is also quite common that we often encounter the need to connect to an Oracle database when we develop our application scenarios. So so. NET environment is connected to an Oracle database and can be tns/sql.net through a configuration file, and TNS must be an Oracle client.Sce
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.