NAV: SLTechnology News&Howtos > Database >

• 

  ORA-16018 solution

  Because the default path of 11g archive log is: the DB_RECOVERY_FILE_DEST space size is 2G to cause the log to be full, the database hang has modified the archive log and reported an ORA-16018 error: first create the archive log storage directory: orahost:

  2022-06-01 12:05:03 Views: 301
• 

  ORA-29783: GPnP attribute SET

  It takes a lot of effort to deploy RAC these days. It took more than three days to get things done in one day. The night before yesterday, I found that bond was not done in the business IP and heartbeat IP computer room, and there were still problems with multipath mapping. Executing start_udev always disconnects the machine.

  2022-06-01 12:05:03 Views: 220
• 

  Oracle Study-DataGuard maximum protected Mode failure (ORA-16198)

  Oracle Study-- DataGuard maximum protected Mode failure (ORA-16198) system Environment: operating system: RedHat EL5Oracle: Oracle 11gR2 (11.2.0.1.0) failure occurs

  2022-06-01 12:05:03 Views: 247
• 

  Mongodb3.2+ performance monitoring

  I am in replication set mode, and add an authentication parameter-- authenticationDatabasemongostat-- port 20012-uadmin-paired replication xxxxxx'--authenticationDat.

  2022-06-01 12:05:02 Views: 203
• 

  Zabbix monitors SQL Server database

  Principle: connect to SQL Server through ODBC and send the data queried by SQL statement to zabbix server for analysis. Brief description of configuration steps: 1. Install Freetds, unixODBC, unixODB on zabbix server

  2022-06-01 12:04:52 Views: 308
• 

  A minor problem was encountered when installing oracle11g on rhel6

  [oracle@cfylinux database] $. / runInstallerStarting Oracle Universal Installer...Checking Temp space:

  2022-06-01 12:04:52 Views: 272
• 

  SQL trigger

  Look at the blog, found that there is no trigger instructions, now make up. Two special tables when the trigger is triggered: insert table (instered table): the data of Inserted table is inserted or modified data delete table (deleted table): the number of deleted table

  2022-06-01 12:04:49 Views: 248
• 

  The practice of optimal configuration of MySQL production Environment

  Operating system environment configuration (production environment optimal configuration) 4.1 hostsecho "192.168.1.51 db1" > / etc/hostscat / etc/hosts4.2 configuration English environment echo "

  2022-06-01 12:04:49 Views: 252
• 

  A trigger saved to another table while the record of one table is deleted in oracle

  Create or replace trigger delete_SXCLGC_triafter delete on winf_sv_ex_hybs_sxclgcfor each rowDECLARE

  2022-06-01 12:04:48 Views: 268
• 

  Partial usage of oracle date function

  Attach ORACLE date time function Daquan date and character conversion function usage (to_date,to_char) select to_char (sysdate,'yyyy-mm-dd hh34:mi:ss') as nowT

  2022-06-01 12:04:48 Views: 297
• 

  Mysql Foundation (6) mysql transaction

  Mysql transaction: a separate unit of work transaction must pass the ACID test: atomicity (Atomicity): all operations of a transaction are either performed successfully or all fail and roll back consistency (Consistency): data

  2022-06-01 12:04:48 Views: 283
• 

  Redis geohash study notes

  People nearby: the location data of map elements are represented by two-dimensional longitude and latitude, longitude range (- 180,180), latitude range (- 90,90], latitude positive and negative by equator, north plus or minus south, longitude plus or minus prime meridian (Greenwich Observatory, UK) as boundary, east positive.

  2022-06-01 12:04:48 Views: 292
• 

  Mysql exception ERROR 1055 (42000) description

  The specific exception information is as follows: ERROR 1055 (42000): Expression # 1 of SELECT list is not in GROUP BY clause and contains non

  2022-06-01 12:04:48 Views: 214
• 

  What are the differences between MyISAM and InnoDB?

  Differences: 1. InnoDB supports transactions, but MyISAM does not. For InnoDB, each SQL language is encapsulated as a transaction by default and automatically committed, which will affect the speed, so it is best to put multiple SQL languages between begin and commit to form a transaction.

  2022-06-01 12:04:47 Views: 294
• 

  Mongodb simple operation

  1. After performing mongod.exe server startup, you can follow the parameters to describe the database and logs that are started. Eg:mongod.exe-- bind_ip 127.0.0.1-- logpath "F:\ data\ dbConf\ m

  2022-06-01 12:04:47 Views: 222
• 

  PostgreSQL logical backup recovery-- pg_dump Export and psql Import cases

  Database import and export is one of the most commonly used functions. PostgreSQL backup tools can use pg_dump and pg_dumpall. You can get its usage through pg_dump-- help. It is not introduced too much here. It mainly introduces the use of p

  2022-06-01 12:04:47 Views: 252
• 

  SqlServer series notes-data types

  Number according to type description storage space 1. Character data type Char (n) N is 1 "8000 characters between n bytes Nchar (n) N is 1" 4000 Unicode characters (2n bytes) + 2 bytes extra overhead Ntext most

  2022-06-01 12:04:47 Views: 210
• 

  Cloudstack4.6 + xenserver architecture cloud environment deployment

  Cloudstack4.6+xenserver architecture cloud environment deployment 1, provide simple similar cloudstack architecture as follows (for simple reference only): 2. Install cloudstack4.6+xenserver6.5 system environment: ce

  2022-06-01 12:04:28 Views: 241
• 

  Some of Oracle's personal records

  1. After installing the database, create a monitor and execute the $netca startup configuration interface. (the system I installed comes with the desktop version, which opens bash to start listening.) when you are finished, execute the command $lsnrctl start to start the listening service. Create a database instance and hold the

  2022-06-01 12:04:14 Views: 300
• 

  Ubuntu16.04 server installs MySQL with docker

  1. Look for the mysql image sudo docker search mysql2 on Docker Hub. Pull the official image sudo docker pull mysql3. View image related information sudo docker i

  2022-06-01 12:04:14 Views: 247