Database Administrator

Installing Oracle software using NFS Yesterday, I used openfiler to create a nas storage system and install the Oracle software. Everything went well before that. A ora error was reported when I created a database. When I used nfs to install the

Whether the maximum number of connections is set in Oracle or an error is returned There are 1100 data records to be updated, and an error is reported during connection. ORA-12518, TNS: listener cocould not hand off client connection According to

Install MariaDB database using yum in CentOS Because there is no MariaDB repository on CentOS by default, you need to install rep first.Step 1. Generate a repo File(1) create a new repo File# Nano/etc/yum. repos. d/MariaDB. repo(2) Add

Notes on common Oracle commands and common oracle commands Login without a password: sys as sysdba View all current databases: select */name from v $ database; View the current database connection user: show user View All Tables of the

C # -- Integrated Security = SSPI in Web. config,Problem cause In the past, the configuration file was used to access the database when the charging system of the IDC room was restructured. For example: string="server=localhost;database=pubs;uid=

The weblogic service is inexplicably shut down and reports a segment error. weblogic is inexplicably Four weblogic nodes were released on site. the weblogic version was 10.3 and the jdk version was 1.6.0 _ 24. Services were inexplicably stopped at

Solution for extracting "Chinese character" strings from ORACLE strings: oracle string In actual work, I often use the function of removing special characters, especially the data inserted into the database. To ensure the quality of the data, we

Oracle Auto-incremental ID implementation, Oracle incremental ID implementation First, create a table: Create table test (id number (32) not null primary key, name varchar2 (32 )); Then, customize a sequence) Create sequence

Brief summary of the isolation level of database transactions, Database Transaction Level There are four transaction isolation levels in the database: Read uncommitted, Read committed, Repeatable read, and Serializable. These four levels can solve

ORA-38760: This database instance failed to turn on flashback database article 3, ora-38760flashback ORA-38760: This database instance failed to turn on flashback database Article 3   Article 1 Article 2 Symptom:The following information is

Oracle Database Connection and Oracle Database Connection Modeled http://blog.csdn.net/makenothing/article/details/17080069 1. Create an Oracle connection. Add a database connection in VS2010. Obtain the connection string Data Source = server1;

JDBC is used to read Oracle's US7ASCII Encoded chinese garbled characters and the bytes occupied by Chinese Characters in different encodings. Database Version: Oracle 10g Character Set: SIMPLIFIED CHINESE_CHINA.US7ASCII JDK: 1.6.0 _ 45 Oracle

Mysql advanced master-slave replication, mysql master-slave Master-slave replication is more than multiple servers !, One change changes the other, and the content is actually the same! Principle: Operations on the database will generate a file,

PuTTY connection to Linux Server frequent disconnection solution, puttylinux After remotely connecting to the server, PuTTY often prompts "Software caused connection abort" when disconnected, and often loses the connection in a short time. The

The document number generated by the oracle trigger and the oracle triggerCreate or replace trigger TRG_KC_SPRK_ IBefore insert on KC_SPRKFOR EACH ROWDECLAREVSCBH varchar2 (40 );ICount NUMBER;IFor number;BEGINSelect t. bhqz into vSCBH from xt_djbhgz

Basic Hibernate ing and hibernate ing Before talking about Hibernate ing, let's first take a look at object link ORM ing ORM. The implementation idea of ORM is to map the data of tables in relational databases into objects and present them as

Oracle Primary Key usage explanation, oracleprimary Oracle/PLSQL: Primary Key Usage1 goal The example shows how to create, delete, disable, and enable a primary key. 2 preface-what is a primary key? In Oracle, a primary key indicates a single data

Redis source code analysis () --- create and release a redisObject object, redisredisobject Today's learning efficiency is relatively high. After analyzing Rio, I learned the RedisObject file, which is about converting and creating RedisObject. Most

NBU7.0 RMAN recovery from different machines not found in NetBackup catalog, rmannetbackup   Problem description: RMAN> run {2> allocate channel t1 type 'sbt _ tape ';3> send 'nb _ ORA_SERV = netbackup, NB_ORA_CLIENT = hz1 ';4> restore controlfile

[MongoDB] The Access control of mongodb, mongodbaccess In this blog we mainly talk about the access control including limitation of ip, setting listen port and usage of username and password. in the official document, mongodb server start without