11gRAC local data file migration to ASM

Environment related: OS: CentOS release 6.6 RAC: 11.2.0.4.0 dual node ASM Library 1. Cause of failure Today, four data files are added in batches. add datafile '+ DATADG' in the second to fourth data file add SQL misses' + '. After oracle successfully adds the first data file, it is found that the second data fil ...

Added by grahamb314 on Fri, 01 May 2020 22:00:41 +0300

Learning: simple programming of plsql for Oracle Database

Tools: CMD sqlplus Content: basic table operation, plsql programming (branch structure, loop, judgment, etc.) Account: scott preparation in advance Tips for using cmd Because the author uses sqlplus and enters in the cmd environment. It's not easy to edit the text in cmd environment, so I'll give you some tips. A ...

Added by ianitm on Mon, 30 Mar 2020 19:37:27 +0300

Ubuntu 16.04 build oracle environment for golang development

Mirror version Search oracle on docker hub and find a xe 11 image. docker pull deepdiver/docker-oracle-xe-11g The image size is about 1G, and it is about 2.7GB after decompression. Function docker run -d -p 1522:22 -p 1521:1521 --name oracle deepdiver/docker-oracle-xe-11g Use the above command to run oracle. Wait about 1 minute, use ssh root ...

Added by greip on Fri, 08 Nov 2019 19:23:14 +0200

Oracle Backup and Recovery expdp/impdp Data Pump Remote Import and Export

Links to the original text: https://blog.csdn.net/imliuqun123/article/details/78624587 Oracle Backup and Recovery expdp/impdp Data Pump Remote Import and Export   Oracle has a very useful export tool expdp (data pump) at 10g. However, ...

Added by jamiefoxx on Thu, 01 Aug 2019 08:52:41 +0300

Summary of Oracle Operating Users and Tablespaces

1. Operation flow of Oracle databaseFirst, we need to understand the whole process of the Oracle database, as shown in the following figure.  Following is an introduction to tablespaces and user actions based on the following three steps:Step 1: Use the cmd command to open the DOS window.Step 2: Enter the command sqlplus/nolog to ente ...

Added by datafan on Fri, 05 Jul 2019 19:35:34 +0300

Modify Oracle 11gR2 RAC SCAN listening and local listening ports

Modify the port SCAN listens on Modify the port SCAN listens on to 3521, and the port local listens on remains the same, at 1521: [root@web1 ~]# srvctl modify scan_listener -p 3521 1 View the listening status after modification: [grid@web2 ~]$ lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 06-May-2 ...

Added by shinstar on Sat, 25 May 2019 22:58:12 +0300

Java project generates oracle database dump file

Oracle database client has an sqlplus component that allows us to perform some database operations on the command line. In order to improve the efficiency of dump file writing, we try to use sqlplus command to generate dump file. sqlplus can specify running scripts, such as: sqlplus admin/pwd@//127.0.0.1:1526/orcl@./tmp_sql/N ...

Added by jonasr on Thu, 16 May 2019 06:48:26 +0300