OS: CentOS release 6.6
RAC: 220.127.116.11.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
Tools: CMD sqlplus
Content: basic table operation, plsql programming (branch structure, loop, judgment, etc.)
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.
Added by ianitm on Mon, 30 Mar 2020 19:37:27 +0300
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.
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
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.
Added by jamiefoxx on Thu, 01 Aug 2019 08:52:41 +0300
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 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
View the listening status after modification:
[grid@web2 ~]$ lsnrctl status LISTENER_SCAN1
LSNRCTL for Linux: Version 18.104.22.168.0 - Production on 06-May-2 ...
Added by shinstar on Sat, 25 May 2019 22:58:12 +0300
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