Actual Chapter: Oracle remembers logged-in user IP without hiding it

Introduction to the Author Author: Lucifer Liu, member of the Chinese DBA Consortium (ACDU).Currently mainly engaged in Oracle DBA work, has been engaged in Oracle database development work, mainly serving the production and manufacturing, Automotive Finance and other industries.Now has Oracle OCP, OceanBase OBCA certification, good at Orac ...

Posted by DGaleDavid on Mon, 17 Jan 2022 21:31:59 +0100

Session session (super detailed)

1, What is a Session Session is an interface (HttpSession).A Session is a Session. It is a technology used to maintain an association between a client and a server.Each client has its own Session.In the Session session, we often use it to save the information after the user logs in. 2, How to create a Session and get (id number, new or not) H ...

Posted by buildakicker on Fri, 14 Jan 2022 21:32:03 +0100

Delete the database without running away, MySQL database recovery tutorial

In work, we delete data or database by mistake. Do we have to run away? I don't think so. Programmers must learn to save themselves and retrieve the data unconsciously. In MySQL database, we know that binlog logs record all our operations on the database, so binlog logs are a sharp tool for us to save ourselves. Today, taking MySQL databa ...

Posted by tunari on Tue, 11 Jan 2022 03:48:29 +0100

Restore MYSQL backup to the specified pos point

Tip: after the article is written, the directory can be generated automatically. Please refer to the help document on the right for how to generate it preface I saw it on the bus in the morning**_ The article on MySQL binlog written by yidianyu * * in Jiangnan is very detailed about the use of binlog to recover the database. I can under ...

Posted by cbolson on Fri, 31 Dec 2021 17:04:25 +0100

19c RAC+ADG online call opatch19 3 to 19.10

Please read carefully and refer to the README document for the latest steps, processes and related requirements for the overall upgrade of Oracle 19c rac cluster from 19.3 opatch to 19.10. 1, View the current database patch version col ACTION for a8 col status for a15 set line 999 col ACTION_TIME for a30 col DESCRIPTION for a50 SQL> selec ...

Posted by dianaqt on Thu, 30 Dec 2021 18:40:19 +0100

Creation of DBLINK from Dameng database DM to SOL SERVER

The DBLINK built this time is to access the SQL SERVER database on the Win side of the Damon database on the Linux side. By configuring ODBC to connect to the SQL SERVER database, DM creates an ODBC DBLINK connection to realize the DBLINK between DM and SQL SERVER. The following are the specific operation steps. DBLINK overview: DBLINK (Datab ...

Posted by Dustin013 on Thu, 23 Dec 2021 18:52:15 +0100

REHL8 detailed steps for installing Oracle19C database

1, Preparation before installation 1.1 create RAID5 disk array To view the number of hard disk devices, use the ll / dev/sd * command [root@TradeProbe ~]# ll /dev/sd* brw-rw----. 1 root disk 8, 0 8 May 15:36 /dev/sda brw-rw----. 1 root disk 8, 1 8 May 15:36 /dev/sda1 brw-rw----. 1 root disk 8, 2 8 May 15:36 /dev/sda2 brw-rw----. 1 root di ...

Posted by teo99 on Wed, 22 Dec 2021 18:12:25 +0100

PostgreSQL DBA most commonly used SQL

Create relevant views according to the data dictionary to facilitate query create schema dba; create view dba.ro_conflicts as select datname,pg_stat_get_db_conflict_all(oid) conflict_all,pg_stat_get_db_conflict_bufferpin(oid) conflict_bufferpin,pg_stat_get_db_conflict_lock(oid) conflict_lock,pg_stat_get_db_conflict_snapshot(oid) conflict_ ...

Posted by phpnoobie on Wed, 15 Dec 2021 17:25:57 +0100

Oracle database creation user, specifying default (create) tablespace, user permission assignment (empowerment) script (dba, ETL required)

Oracle database create user, specify default (create) tablespace, and grant permissions (dba, ETL are required) preface In the actual development process, creating users in the database, specifying tablespaces and assigning permissions to users are the basic operations. The script commands are introduced below. Tip: the following ...

Posted by zarp on Wed, 15 Dec 2021 16:18:13 +0100