1. Install multiple discovery on the same machine there is always a problem, so it is recommended to find a machine that does not have Oracle installed gateways2. Download the Oracle gateways and unzip it, see the website for details. Download the
I. Classification of databasesI. Classification of databases1. Small database: Access, Foxbase2. Medium database: Informix, SQL Server, MySQL3. Large database: Sybase, DB2, OracleSecond, how to reasonably use the database in the project, can be
1. Understanding Backup and Recovery issuesThree indicators related to backup recovery are: MTBF average trouble-free timeMTTR mean failure recovery time.Data loss: How much to lose the book data.There are three advanced options for Oracle RAC Steam
1. Understand Oracle tablespace and data files.Oracle storage model. Table spaces, segments, intervals, Oracle blocks, data files, and the corresponding relationships of operating system blocks.Select Segment _type, COUNT (1) from Dba_segments Group
Windows Sever 2012 Oracle 12c Installation Configuration Method graphic TutorialThe Oracle 12c installation configuration method and graphics tutorial, specific content as follows 1, we open the virtual machine2. Windows Sever 2012 startup.3. See
Because Oracle 12c uses the CDB-PDB architecture, similar to Docker, multiple pluggable-db can be loaded within the CONTAINER-DB, so additional configuration is required after installation to be used.First, modify the Listener.ora, Tnsnames.ora# #
Oracle client: 11.0.2 (64-bit, official website)Plsql:plsqldev1104.zip is a Baidu looking for the installation packageReference Tutorial:A:http://jingyan.baidu.com/article/fb48e8be4c7c206e622e1491.htmlB:https://jingyan.baidu.com/album/49ad8bce4f934e5
Reprint Please specify source: http://blog.csdn.net/dongdong9223/article/details/50728536This article is from "I'm a fish-hook blog."
Connect Oracle using the PL/SQL Developer tool and error when logging in:ORA-12154:TNS:couldnot resolve the
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=
To describe how multiple transactions executed concurrently can achieve data consistency, the database researchers defined theA transaction isolation model called serialization Processing (serializability) (Transaction isolationModel). when all
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
In 12c, Oracle introduced the History command, which is much like the history in the Shell, reducing the knock-down of SQL and bringing a lot of convenience.1. View the history HelpSql> HelpHistory-------Stores, lists, executes, edits of the
There are two main log operation modes in the Oracle Data database: Non-archive mode and archive mode. By default, the database adopts the non-archive mode. As a qualified database administrator, you should have an in-depth understanding of the
The so-called job is better than job. It is about the new features of oracle after 10 Gb.Scheduler. In10gIn the environment, we recommend that you use scheduler to replace common jobs.ManagementTask execution. In fact, it is too one-sided to
The Oracle to_char (datetime, FMT) function converts datetime values to a string in the format specified by the FMT option.
MySQL has the date_format function that allows datetime values converting to a string in the specified format.
Sqlways
If the database uses the ASM file system for management, it may be difficult to download and upload files. Even if the asmcmd tool is used, there is no command similar to CP to copy files, oracle provides FTP to manage a series of ASM files. Using
@ Echo off
Rem ####################################### ####################Rem # Windows Server 2003 Oracle Database automatic backup batch processing scriptRem ####################################### ####################
Rem obtains the current
In Oracle 10 Gb, the flash back family is divided into the following members:Flashback DatabaseFlashback dropFlashback tableFlashback query (flashback query, flashback version query, and flashback transaction query)The following describes flashback
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