Data Guard provides the following three kinds of protection mode, the following is a detailed analysis of the three protection modes, the need for friends can refer to the next
The data guard provides the following three kinds of protection modes:
ORA-12560 resolution Method
Today, when performing Oracle data imp/exp, we suddenly find that the exp input scott/tiger is prompted after CMD:
EXP-00056: ORACLE Error 12560 encountered
ORA-12560:TNS: Protocol Adapter error
EXP-00000: Export
Stateless of HTTP protocol
1. The advantages and disadvantages of stateless in the HTTP protocol
A The HTTP interaction is stateless
Stateless means that when the browser sends a request to the server, the server responds, but the same browser
oracle| Firewall
The Oracle9i database has been installed on the Windows XP platform as a test for your work needs recently, and everything is fine. But when the client connects to the server and always times out, I first think of the firewall, and
Oracle
71. Application of kernel parameters
Shmmax
Implication: This setting does not determine how much of the memory the Oracle data library or operating system uses, but only the maximum number of memory that can be used. This setting also does
?
Class Db_sql {
var $Debug = false;
var $Home = "/u01/app/oracle/product/8.0.4";
var $Remote = 1;
/* This Query is sent directly after the ' the '
Example:
var $ConnectQuery = "ALTER session SET Nls_date_language=german nls_date_format= ' DD." Mm.
oracle| Script
In a longer period of interaction with Oracle, each DBA, especially some heroes have a variety of scripting tools to complete a variety of purposes, so very convenient and quick to complete the day-to-day work, the following part of
oracle| Object | data | Database integrity constraints
Integrity constraints are used to enhance data integrity, Oracle provides 5 kinds of integrity constraints:
Check
Not NULL
Unique
Primary
Foreign Key
Integrity constraints are a rule that
Oracle Environment Preparation 1, system resources
Ü/tmp or can be used to do temporary space disk to have more than MB of space
View Method:
$DF-k/tmp
ü256 MB of physical memory of physical RAM memory
View Method:
$/usr/sbin/lsattr-e-L sys0-a
asp.net|oracle| Stored Procedures | paging
Package Definition:
Create or Replace package materialmanage isTYPE T_cursor is REF CURSOR;Procedure Per_quickpage(Tbname in Varchar2,--table nameFieldstr in Varchar2,--field setRowFilter in
After many times I have verified. Finally, we found a way to query the database structure in Sybase.Before that, I was very puzzled about how this Sybase database is not as easy as Oracle and MySQL.DESC table name;After the online query, get a
Prerequisites: Maintenance of statutory festivals (T_FDJR) in the official holiday calendar including Saturday Sunday/** * Function Description: Gets the days of the day after this date based on the date entered and the number of days * Input
The connection URL of the database is configured as jdbc:oracle:thin:@ (description= (address_list= (address= (protocol=tcp) (HOST=VIP1)) (port=1521) ( Address= (PROTOCOL=TCP) (HOST=VIP2) (port=1521)) (Load_balance=yes) (Failover=on)) (Connect_data=
Recent database experiments with VMware virtual machines for Oracle. As we all know on Windows, I was able to go to the delete program to take the initiative to delete all of the installed applications. However, there is no such service on Linux
1, to the SYS login, build table to give permission to prepare test table Z2[Email protected] ~]$ Rlwrap sqlplus/ asSysdbasql*plus:release11.2.0.4.0Production onTue May - -: -: - .Copyright (c)1982, -, Oracle. All rights reserved. Connected to:
First of all: I refer to the online use of the SYSDBA mode (normal) landing, the other model can not be built by the user (the individual does not make other modes of table space attempt, such as someone trying to welcome the supplement,
Oracle Gateway use share 1, background notesThe company has been encountering heterogeneous database connectivity issues, such as Oracle needs Dblink As400,dblink DB2, if the database version is older, the Linux 64-bit environment to configure the
1:java data type and MySQL data type comparison table
Type name
Display length
Database type
Java type
JDBC Type index (int)
VARCHAR
L+n
VARCHAR
Java.lang.String
12
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service