NAV: SLTechnology News&Howtos > Database >

• 

  Oracl Rac srvctl crappy pen

  SRVCTL is an ORACLE RAC cluster configuration management tool that can manage Database, Instance, ASM, Service, Listener and Node Application,Node Applicat

  2022-06-01 16:20:30 Views: 202
• 

  Query function of powershell

  1. Use PowerShell query to specify the creation time of all accounts in OU\ SID\ time of last password modification\ last login time: Get-ADuser-searchbase 'OU=LL,DC=LL,DC=COM'-f

  2022-06-01 16:20:30 Views: 260
• 

  Navicat usage tutorial: working with Navicat snippets

  Download the latest version of Navicat Premium Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases in a single program at the same time.

  2022-06-01 16:20:30 Views: 221
• 

  Oracle exports result sets to xml format files

  From oracle to xml1. Start sqlplus execution > (1) get all the fields of the exported table: replace the TABLE_NAME,OWNER in the statement with the name of the table to be exported and the user name of the table, and execute it in sqlplus after modifying the statement.

  2022-06-01 16:20:24 Views: 249
• 

  Definition of MySQL trigger and its advantages and disadvantages

  SQL trigger is a special type of stored procedure. This is special because it is not called directly like a stored procedure. The main difference between a trigger and a stored procedure is that when a data modification event is performed on a table, the trigger is automatically called, while the stored procedure must be explicitly called.

  2022-06-01 16:20:24 Views: 269
• 

  Mysql restores data through backup and binlog

  The simulation database is × ×, resulting in the recovery operation after the database is deleted. 1. Let's start with a full list: mysqldump-uroot-pgq266566-A-master-data=2 > all.sql2. Simulate the online production environment.

  2022-06-01 16:20:24 Views: 269
• 

  ORA-15025 ORA-27041

  1. NOTE: Loaded library: SystemORA-15025: could not open disk "/ dev/asm-diske" ORA-27041: unable to

  2022-06-01 16:20:20 Views: 250
• 

  Mysql basic three triggers

  Product list-- Table "goods" DDL:CREATE TABLE goods (gid int (11) NOT NULL,name varchar (20) DEFAULT NULL,num s

  2022-06-01 16:20:20 Views: 271
• 

  Mysql creates stored procedures to insert test data

  Do the project encountered the need to insert orderly test data, do not want to write php cycle, online to find a way to review the stored procedure . SQL statements are referenced from https://stackoverflow.com/questions/269819

  2022-06-01 16:20:19 Views: 202
• 

  Oracle AWR Collection Command-- Basics

  # # how to collect AWR? 1. Generate a single instance AWR report: @ $ORACLE_HOME/rdbms/admin/awrrpt.sql2. Generate Oracle RAC AWR report: @ $ORACLE_HOME/rd

  2022-06-01 16:20:16 Views: 300
• 

  MariaDB encryption replication test

  Environment: 192.168.205.37: as master server192.168.205.47: as middle server192.168.205.57: as slave server version

  2022-06-01 16:20:16 Views: 292
• 

  Oracle instance creation script

  When I first joined the job, a server hung up, so I had the opportunity to learn in the "crisis". In the dead of night, I want to recall the creation of Oracle instances. One approach, DBCA, graphical interface, but relies on software such as xming or xmanager; the other

  2022-06-01 16:20:15 Views: 202
• 

  A double table association update on the self-growth of Rack ()

  Table A (tb_abc): table AB1aa02002bb03003cc05004dd18005ee22006ff3300B (tb_abcc): AB1aa (0201) 2aa (0202) 3bb (0301) 4bb (

  2022-06-01 16:20:14 Views: 230
• 

  Installation and basic Operation of MySQL-5.7 based on CentOS7

  CentOS7-based MySQL-5.7 installation and basic Operation introduction Database (Database) is a warehouse that organizes, stores and manages data according to data structure. It came into being more than 60 years ago, with the development of information technology and market, especially in the 1990s.

  2022-06-01 16:20:13 Views: 220
• 

  Automatically send email to detect the existence of a process under CentOS

  Objective: to use the shell script to detect whether the database is running every hour and send an email alarm when it is detected that the database is down. 1. Check to see if sendmail is running and service sendmail status is not running and then start or install. If it's linux,

  2022-06-01 16:20:12 Views: 232
• 

  Oracle Study-- AIX install RAC running root.sh (PRKR-1062) error

  Oracle Study-- AIX install RAC runs root.sh (PRKR-1062) error environment: operating system: AIX 5300-09 Cluster Software: CRS 10.2.0.1 Database: Oracl

  2022-06-01 16:20:12 Views: 244
• 

  MySQL concurrent replication Series II: multithreaded replication

  Concurrent replication (Parallel Replication) series 2: Enhanced Multi-threaded Slaves author: Ma Pengfei, MySQL database engineer of Worldwide Technology, first combs the traditional MySQL/Mar.

  2022-06-01 16:19:57 Views: 211
• 

  CentOS6.8 (Linux) installation Oracle11gR2 pit filling guide

  Preparation before installation: Oracle11gR2 installation media; sufficient disk space and memory for linux system; fixed ip;Xmanager5 for linux system (required for graphical installation); dependency package can be installed through yum (requires networked environment); zip package

  2022-06-01 16:19:27 Views: 291
• 

  JD.com MySQL database master-slave switching automation

  1. Background with the rapid growth of JD.com 's business, the importance of data to JD.com is self-evident. In the information age, data has more power than people, and the value of the database is evident. The existence of the database provides people with faster queries, so in order to better achieve the database.

  2022-06-01 16:19:16 Views: 258
• 

  Oracle transport tablespace

  The biggest advantage of transferable tablespaces (and a set) is that they are much faster than export/import or unload/load. Because transferable tablespaces mainly copy data files to the destination path, and then use export/import or Da

  2022-06-01 16:19:16 Views: 300