Tag: oracle

The back-end

Install Oracle database from scratch! This section describes how to install and use the Oracle database

January 5, 2024

by Badal Saran

No Comments

1. Database installation 1.1 Download Based on your operating system bit, download the oracle official website (oracle 11g is used as an example) and decompress...

Read More

The back-end

Sql Optimization

January 5, 2024

by Gabriela Miller

No Comments

SQL optimization one. Single-table Access Single-table access generally involves scanning all tables or indexes. 1. If an SQL query returns a large amount of data...

Read More

The back-end

Oracle 11G Password complexity verification enabled or disabled

January 5, 2024

by Wendy Thomas-Wade

No Comments

For security, Oracle 11g adds password complexity verification. By default, when you need to change the password, a message is displayed indicating that the password...

Read More

reading

Centos 7.6 Silently Installing Oracle 11G

January 5, 2024

by 王婷婷

No Comments

1. Disable the firewall 2. Install dependency packages 3. Decompress the Oracle database installation package. 5. Modify the OS configuration. Add the following configuration items...

Read More

The back-end

Oracle stored procedure template

January 5, 2024

by Eric Miller

No Comments

This article has participated in the call for good writing activities, click to view: back end, big front end double track submission, 20,000 yuan prize...

Read More

The back-end

Oracle error ORA – 01653

January 4, 2024

by Cynthia Smith

No Comments

After Oracle is deployed in the production environment, if the parameters are not optimized and there is no dedicated person to perform daily operation and...

Read More

The code of life

Visual Studio reported a resolution to the error “MSDAORA” provider not registered on the local computer

January 4, 2024

by David Myers

No Comments

Method 1: the site project properties →Web→ server from the default IIS Express to IIS, and set "enable 32-bit applications". Method 2: Use other drivers,...

Read More

android

8.8 billion! Java infringement case reversed, Google cried, heaven and earth with sorrow

January 1, 2024

by Nakul Mammen

No Comments

The Java copyright dispute between Google and Oracle is almost settled, with Google paying Oracle $8.8 billion for using Oracle's Java copyright code on its...

Read More

The back-end

Ogg12.3 + MMSQL configuration writes kafka

January 1, 2024

by Kevin Rodriguez

No Comments

Sqlserver environment variables are configured before, after decompressing, you want to install OracleGold. Sqlserver environment variables are configured before

Read More

The code of life

2021 ocd Gospel CentOS7 zero warning install Oracle11g

December 31, 2023

by Valerie Bishop

No Comments

I wrote an article called "full record of Oracle11g installed on CentOS7 in 2021". Since I wrote it as I went along, it might seem...

Read More

The back-end

Oracle environment configuration is a mountain of 18 curves

December 31, 2023

by Beth Robinson

No Comments

Unable to check whether the specified location is located on CFS, searching the network for Oracle configuration error solutions, and finally finding their own way!

Read More

reading

MySQL statistics by day, week, month, quarter, year

December 31, 2023

by 孫飛

No Comments

In Oracle database, the to_char() function is used to manipulate date variables, while in MySQL, date_format() function is used to count date-related cycles. The date_format()...

Read More

The back-end

Weblogic CVE-2021-2394 analysis

December 31, 2023

by 李淑娟

No Comments

Introduction On July 21, 2021, Oracle officially released a series of security updates. 342 vulnerabilities involving its products (Weblogic Server, Database Server, Java SE, MySQL,...

Read More

The back-end

Ora-01031: Insufficient Privileges is used for Windows 10 Home edition

December 30, 2023

by Todd Payne

No Comments

Windows 10 Home edition error: Use the Oracle Administration Assistant for Windows. The home Windows operating system cannot find users and groups. You need to...

Read More

The back-end

Oracle System Overview

December 27, 2023

by 丁怡安

No Comments

Data analysis Oracle watermark View full view of specified users and tables. Blocks = All allocated blocks, empty_blocks = Unused blocks View the data blocks...

Read More

The back-end

[Oracle Database] RMAN backup and restoration script sharing, with SQL real-time check progress

December 26, 2023

by Bradley Norman

No Comments

When rMAN is used for backup and restoration, the client execution record cannot be directly displayed. You can use SQL to query the progress. The...

Read More

The back-end

Oracle archive path Settings

December 26, 2023

by William Forrest

No Comments

The default directory for storing Oracle archive logs is the flashback area. The default size is 2G.

Read More

The back-end

Oracle12c deployment, allowing remote access

December 26, 2023

by David Patterson

No Comments

The host of an Oracle database is set to localhost. The host of an Oracle database is set to localhost for remote access. D:\app\orcl\product\12.1.tns...

Read More

The back-end

Oracle 11.2.0.4 Deployment for Windows | More challenges in August

December 26, 2023

by David Myers

No Comments

Installation and deployment of the Oracle standalone database on the Windows platform in the production environment. The parameters can support the stable running of small...

Read More

The back-end

The Oracle database connection times out and cannot be connected

December 25, 2023

by James Tucker

No Comments

The Oracle database connection on Windows timed out, failed to connect, and no error was reported in the log......

Read More

The back-end

Oracle quickly creates a table with the same fields as an existing table

December 24, 2023

by Courtney Wilson

No Comments

Create table BBB as select * from AAA where 1= 0 create table BBB as select * from AAA where 1= 0

Read More

The back-end

Oracle 11g application architecture

December 23, 2023

by Hrishita Koshy

No Comments

The Oracle 11G database must be installed and deployed based on the hardware platform and operating system. 1. Independent host structure of multiple databases This...

Read More

The back-end

Oracle automatically generates primary keys for IDS by calling sequence in XML with Mybatis

December 23, 2023

by Ryan Frank

No Comments

SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL

Read More

The back-end

The pit that Oracle stepped on

December 23, 2023

by 白俊宏

No Comments

Add fields to the existing table (with a large amount of data) with default values method 1 Method 2 Method 1, 2 compare to describe...

Read More

The back-end

Oracle: wM_concat and IN query sorting problem

December 23, 2023

by Michael Hester

No Comments

Oracle uses listAGg to solve the wM_concat sorting problem (and in sorting problem) : Oracle uses default sorting when we run queries using IN. The...

Read More

The back-end

Oracle Database Basics

December 23, 2023

by Kevin Mendoza

No Comments

This article is best read with MySQL foundation. Oracle is very powerful database software. Default port: 1521. Unlike MySQL, the concept of Oracle database is...

Read More

The code of life

Oracle implements insert or update if data does not exist

December 23, 2023

by Thomas Henry

No Comments

To_date (to_char(statdate, 'YYYY /mm/dd'),' YYYY /mm/dd'); to_char(statdate, 'YYYY /mm/dd'),' YYYY /mm/dd')

Read More

The back-end

Oracle SQL Tuning series methods for Locating production performance Problems

December 22, 2023

by 楊冠霖

No Comments

1, AWR overall analysis scenario: recently encountered an emergency production problem, because the database lock table leads to the normal use of service functions, for...

Read More

The back-end

Problem resolved: ORA-04030 private memory exceeded

December 22, 2023

by Brett O'Connor

No Comments

Ora-04030 error was reported in database during inspection today. How to solve the problem? Key words: ORA-04030, (PGA heap, KGH stack), (KXS-heap-c, KPRbalo Temp memory

Read More

The back-end

Linux environment deploys Rman backup

December 22, 2023

by James Moore

No Comments

Linux environment, Rman periodic backup deployment, this article introduces the weekly full plus incremental deployment mode. Backup policies and retention policies can be flexibly adjusted...

Read More