Programming VIP

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

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

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

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

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

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

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