Database Administrator

Oracle 18C database creation prompt ORA-12754 error Solution In order to experience Oracle 18C, early in the morning on the https://edelivery.oracle.com/osdc/faces/SoftwareDelivery to install the media down. First test the database software

Regex usage in MongoDB Background Part1: Preface Anyone who uses MySQL or other relational databases knows that fuzzy queries are used in similar ways:SELECT * FROM products WHERE sku like "% 789 "; The regex in MongoDB described in this article

How to build an Oracle 11g license uard   I. PreparationsI have read many tutorials when preparing to build a tracing uard. I followed the tutorials and encountered problems. Then I don't know how to proceed to the next step.Later, I went to the

Pentaho Report Designer getting started tutorial (3), pentahodesigner Pentaho Report Designer getting started tutorial (3) Pentaho Report Designer5.1 is the latest version. I. Installation and introduction This section describes how to install jdk,

[Redis 1] Redis database learning and practices-installation and deployment, redis learning and practicesRedis database learning and practice-installation and deployment 1: Redis database introduction: Redis-Remote DictionaryServer can be directly

[Architecture, 13] oracle Character Set details, oracle Character Set1. A simple understanding of character sets: tables corresponding to characters and encodings. When the software has a character set, it uses its own character set. If the software

[Oracle11g, 8] data dictionary and Character Set, oracle11g Character SetI. Data Dictionary: oracle's data dictionary records the metadata of database management. It is a core file of life and death for databases. 1. Place the data dictionary in the

Chapter 1 Securing Your Server and Network (9): use Kerberos for authentication, securingkerberosSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

IP address cocould not be resolved: Temporary failure in name resolution, resolvedresolution Mysql logs were found to have the following warnings this morning: 140724 18:41:25 [Warning] IP address '192. 16.18.217 'cocould not be resolved: Temporary

(Han shunping) pl/SQL programming (2), shunping plI. pl/SQL advanced-control structurePl/SQL provides three conditional branch statements: if -- then, if -- then --- else, if --- then --- elsif --- else(1) simple condition judgment if-thenQuestion:

MyBatis framework Learning (III)-Mapper proxy development, mybatis-mapperIn the previous section, we learned the simple implementation of CRUD in MyBatis. In this process, we used the original Dao method for development. In this process, we found

The PXE method is used to batch push the Complete Oracle 11gR2 RAC environment from bare metal, and the Shell script is used to deploy 32 Oracle11gR2 RAC backup and recovery cases on the launched RAC nodes in batches. Consultant for ARP Project

Environment Introduction: Dual-host operating system: solaris 10 database version: oracle 11g R1 64bit current host name and IP: fly-db2 192.168.20.21 current slave host name and IP: fly-db1 192.168.20.20 Background: The physical memory of the

SQLite tutorial (5): Index and data analysis/cleanup, sqlite Data Analysis I. Create an index: In SQLite, the SQL syntax for index creation is basically the same as that of most other relational databases, because here is just an example usage: Copy

When you remotely connect to mysql, the message "is not allowed to connect to this MySQL server" is displayed. mysqlallowedERROR 1130: Host '192. 168.1.3 'is not allowed to connect to this MySQL server. this tells you that you are not authorized to

1. Prepared hostNode1: 172.16.133.11Node2: 172.16.133.12MySQL has been installed.MySQL installation see: http://5142926.blog.51cto.com/5132926/9356522. mysql master-slave ReplicationNode1: master serverNode2: slave server(1) node1:Enable binary log (

Requirements for installing oracle database 12c on RHEL7 or OL7, rhel7ol7 This article comes from: Requirements for Installing Oracle Database 12.1on RHEL7 or OL7 64-bit (x86-64) (Document ID 1961997.1)   This article is not translated and is only

We recommend that you read and understand the following articles: ◆ Use a partition in a Microsoft SQL Server 2000 data warehouse-http://msdn.microsoft.com/library/default.asp? URL =/library/techart/PartitionsInDW.htm◆ SQL Server 2000 step by step

MongoDB collection document creation, modification, deletion, and query command summary, mongodb modification and Deletion Install mongodb in windows. Start it. Previous Article: mongoDB Installation Details 1. log on to view the collection

Inconsistent recovery of data file headers and inconsistent recovery of Data Headers SYS@orcl11g>alter database datafile 6 online;alter database datafile 6 online*ERROR at line 1:ORA-01113: file 6 needs media recoveryORA-01110: data file 6: