NAV: SLTechnology News&Howtos > Database >

• 

  Solve the error Connected of oracle12 under Linux

  The green background is the input, the white background is the output and the yellow background is the error prompt in the output. Problem description: [root@oracle ~] # su-oracleLast login: Tue Sep 17 23:40:50 CST 2019 on

  2022-06-01 09:55:46 Views: 216
• 

  Implementing rols Management with MySQL5.7-proxy

  1. Background * the concept of roles manages database access. Depending on the settings of the role itself, a role can be thought of as a database user, or a group of database users. Roles can have database objects (for example, tables) and can grant permissions on those objects to other roles

  2022-06-01 09:55:46 Views: 271
• 

  Oracle 11g rac process start and stop

  For the process of unknown, add the process name to crs_stop-f and then startcrs startup failed crs_start-all CRS-0184: Cannot communicate with the CRS

  2022-06-01 09:55:37 Views: 260
• 

  Aggregator assists in inter-table association of MongoDB

  MongoDB does not support join. The unityjdbc recommended on its official website can take the data out for secondary calculation to achieve join operation, but this feature is only available in the paid version. Other free jdbc drive can only support the most basic SQL statements, not joi

  2022-06-01 09:55:37 Views: 294
• 

  Detailed explanation of Chinese installation of JIRA, a project and transaction tracking tool under Linux

  1. Install java environment [check java environment installation] 2, install database and add jira database and user authorization [check mysql installation for MySql environment installation] mysql > create database jir

  2022-06-01 09:55:25 Views: 280
• 

  SQL Learning uses commands to create, delete, and modify relational tables

  First of all, we first introduce the creation, deletion and modification of relational tables by command. (1). Create the basic format of the table: create table table name (column name data type column level integrity constraint, column name data type column level integrity constraint (if there are multiple columns, be careful to use English amusement

  2022-06-01 09:55:25 Views: 298
• 

  JavaWeb SQL commonly used languages (add, delete, change and search)

  1. SQL commonly used parenthesis INSERT (plus) 1.1 inserting character type data    needs to use single quotation marks'to enclose the string. If there are single quotes in the value to be inserted, you need to use two single quotation marks''to escape, as shown in the following figure to insert the name value into the student table:

  2022-06-01 09:54:56 Views: 273
• 

  Source code installs LAMP environment + yii2 framework

  When some new software versions appear and you want to try it, but local installation with yum does not meet your needs, then my friend, you need to use source code installation as I do to achieve your goal. Because my colleagues in the developer want an Apache 2.4.25 +

  2022-06-01 09:54:47 Views: 230
• 

  MySQL master-slave replication

  MySQL master-slave replication master-slave replication type: asynchronous mode: general MySQL replication, master server is only responsible for sending binary logs, not check from whether to complete semi-synchronous mode: in a heap, the master can only guarantee that one of them returns synchronization. If it times out, it will be automatically downgraded to

  2022-06-01 09:54:35 Views: 253
• 

  Simple getting started with oracle

  1. What is the primary key? Answer: a combination of data columns and rows that can be uniquely and fully identified in a data table can only have one and cannot be empty. 2. What are foreign keys? Answer: there is a foreign key for another table in one table. 3. The difference between stored procedures and triggers A: triggers and stored procedures are very similar, triggers

  2022-06-01 09:54:34 Views: 214
• 

  ORACLE ADF:EO primary key unique, candidate key unique

  When developing ADF applications, the system default primary key is unique, but the error message provided by the system is too ugly, so we can customize the error where the primary key is not unique. In addition to the unique primary key, sometimes we need to make it unique through a combination of other fields, such as a combination of time, place, and people.

  2022-06-01 09:54:10 Views: 251
• 

  WITH (UPDLOCK,HOLDLOCK) hint and different table types

  WITH (UPDLOCK,HOLDLOCK) Tips for different table types Let's first look at the concepts of UPDLOCK and HOLDLOCK. UPDLOCK specifies that update locks are taken and held until the transaction is completed. UPDLOCK is only for row-level or page-level

  2022-06-01 09:53:40 Views: 222
• 

  Mongodb master-slave replication

  Server architecture: role ip address port master server 192.168.8.81 27017 slave server 192.16

  2022-06-01 09:53:34 Views: 237
• 

  Oracle audit table AUD$ migrate tablespace and create cleanup job

  Versions of Oracle 10.2.0.5 and above can use DBMS_AUDIT_MGMT to clean up audit1 and see if audit has SQL > show parameter audit_trailNAME TYP open.

  2022-06-01 09:53:34 Views: 223
• 

  MYSQL Enterprise applications (3) basic Management

  3.1 Database connection management login database system logs in to the mysql database management system on the command line, where the "- h" parameter refers to the hostname of the connection, and since this is the local connection, the following content is the localhost; "- u" parameter indicating the user name, and the user name here is

  2022-06-01 09:53:31 Views: 271
• 

  Redis (1): getting to know Redis in-memory database and persistence

  What is an Redis in-memory database? Redis is essentially an in-memory database of KEY-VALUE type. The whole database is loaded and operated in memory, and the database data is saved to the hard disk regularly through asynchronous operation. So it's a pure memory operation.

  2022-06-01 09:53:30 Views: 212
• 

  SaltStack (1)

  SaltStack introduces saltstack as an open source batch distribution management tool with a very powerful management function that can manage tens of thousands of servers at the same time. Written in the python language and providing API.saltstack, there are four ways to run it: Local

  2022-06-01 09:53:30 Views: 220
• 

  Oracle 12170 error

  Check the database and find that the database connection will be automatically disconnected after a while. Need to listener.ora sqlnet under / u01/app/oracle/product/11R2/db_1/network/admin/samples

  2022-06-01 09:53:17 Views: 271
• 

  Oracle 11g R2 Management Control Fil

  Oracle database control file is a very important file. It is a binary file automatically generated when the database is created, which records the status information of the database. It mainly includes the following contents: the name of the database. A control file can only belong to one database, the creation time of the database.

  2022-06-01 09:53:17 Views: 277
• 

  RMAN cannot delete archive log

  Today, my colleague asked a question that his 11g database could not delete old archives using RMAN, resulting in high disk utilization. To log in to ip, it is true that the oldest archive log is from May 16. Oracle@ps251n2s: [/ opt/

  2022-06-01 09:53:16 Views: 209