Programmer Think

After the server restarts, it is found that ORA-12514: TNS: the listener cannot recognize the service requested in the connection descriptor Problem: the Oracle main service and listener service have been started. You can connect normally with SQL Plus. You can connect with PL SQL Developer and report an error: ORA-12514: TNS: the listener can ...

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 ...

grid mutual trust configuration Mutual trust configuration: connect two virtual machines. Node 1 virtual machine can operate node 2 virtual machine by entering password. First, let's understand the difference between rsa and dsa? DSA signature is faster, but validation is slower. A DSA key of the same strength as RSA (1024 bits) generates a ...

An important basic work in data governance is to analyze the blood relationship of data in the organization. With complete data kinship, we can use it for data traceability, impact analysis of table and field changes, proof of data compliance, inspection of data quality, etc. The methods of analyzing blood relationship of data are mainly divid ...

Requirement description As an interface, the external system interacts with SAP through PI. Here are some useful knowledge points 1, Is the Target URL HPPT/HTTPS? If the other party's address is HTTP, the other party's URL address can be directly used in Integration Builder. Confirm with the other party's system personnel in adv ...

Installation environment Operating system: CentOS Linux release 7.5.1804 (Core)Database version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production Oracle installation package Link: https://pan.baidu.com/s/1AfUe0fuRJU7Epk3h56EPkQExtraction code: xumw Installation requirements Physical memory: 2GSwitching ...

Since this article is a summary written after the completion of the system, many operation results show the final results after the completion of the system, which will be different from the corresponding SQL execution results. 1, Introduction requirement: Complete a simple application system design and development. Background: In th ...

Preface Reference resources https://oracle-base.com/articles/21c/dbms_cloud-package Pressed for a long time, ready to start writing, found that someone has sent similar, https://blog.csdn.net/stevensxiao/article/details/118578785 But it's a bit different from what I do, so I'll write one. The title of this article was meant to be called [OR ...

1. Overview of Oracle ORACLE database system is a set of software products provided by ORACLE Corporation (Oracle) in the United States with distributed database as the core. It is currently the most popular client/server (CLIENT/SERVER) ORACLE database is one of the most widely used database management systems in the world. As a gene ...

1. Environmental preparation Main librarySpare databaseoperating systemLinuxLinuxServer nameprimarynodestandbynodeIP address planning192.168.186.130192.168.186.131------------------------------------------------------Database version11.2.0.411.2.0.4db_namesfxtsfxtdb_unique_namesfxt_bfsfxt_bfinstance_namesfxtsfxt_bfservice_namesfxtsfxtDatabase ...