First look at the slave_exec_mod official description Command-LineFormat -- slave-exec-modemodeOption-FileFormatslave_exec_modeSystem
First take a look at the official description of slave_exec_mod Command-Line Format -- slave-exec-mode = mode
We can make the USERS tablespace offline in SQLPlus. Remember to do the following before going offline. Because we have backups in RMAN, we can
We can make the USERS tablespace offline in SQL Plus. Remember to do the following before going offline.
SHUTDOWN: waitingforactivecallstocomplete processing. A latchfree problem occurs. kill the current session and report that the session sid does not exist.
SHUTDOWN: waiting for active callto complete processing. A latch free problem occurs. kill the
ORA-03113: end-of-fileoncommunicationchannel
ORA-03113: end-of-file on communication channel
1. An error is reported when Oracle is started.
SQL> startup
Error:
ORA-03113: end-of-file on communication channel
View the alert. log File and
Java JDBC uses the configuration file to connect to the database: Creates a file with the suffix ". properties". The file content includes: Database driver, connected database address, user name, and password.
Java JDBC uses the configuration file
Process demonstration of switchover Master/Slave database on Oracle10gr2
Demonstration of switch over Master/Slave database process on Oracle 10g r2
The current status is dg1 as the master database, and the slave database is dg2.First check the
Reset the MySQL password: Stop the MySQL service and start it with the skip-grant-tables parameter.
Reset the MySQL password: Stop the MySQL service and start it with the skip-grant-tables parameter.
Reset the MySQL password:
Stop the MySQL
1. Copy the table structure and data: createtabletable_name_newasselect * fromtable_name_old2. Only copy the table structure: createtabletable
1. Copy the table structure and data: create table table_name_new as select * from table_name_old 2. Only
Oracle11glinux32-bit version of the client configuration first attached to their own integrated client download link: Oracle11g client Linux-32bit to Linux community 1 FTP download :--
Oracle 11g linux 32-bit version of the client configuration
ExpdpORA-39070: Unabletoopenthelogfile
Expdp ORA-39070: Unable to open the log file
In Oracle, when executing expdp or impdp, sometimes an error occurs:
ORA-39002: invalid operation.
ORA-39070: Unable to open the log file.
ORA-29283:
When creating a database, you should consider the database name, and after the database is created, the database name should not be modified, even if you want to modify it will be very troublesome. Because the database name is also written
When
Suspected BUG in GoldenGate: Unable to view extract in infoall
GoldenGate suspected BUG: info all cannot view extract
GoldenGate suspected BUG: info all cannot view extract
Symptom:Info all cannot view extract ext2, but info ext2 can display
Because you do not want to use the background code, you want to use the Oracle trigger for Operation updates. However, because the trigger updates the base table, deadlock occurs.
Because you do not want to use the background code, you want to use
It is easy to create a database manually in DB2. Create an example Database: 1. Generate a database storage directory and an archive directory mkdir-pdemosamplemkdir-p
It is easy to create a database manually in DB2. Create an example Database: 1.
In PLSQL, The UTL_FILE package provides the interaction between input and output of text files. That is to say, we can use this package to achieve file read input or
In PL/SQL, The UTL_FILE package provides the interaction between input and output
Oracle often used trigger often appears ora-04091 variant table problem, here bring two kinds of processing methods for your reference.
Oracle often used trigger often appears ora-04091 variant table problem, here bring two kinds of processing
The biggest problem with ARCH process transmission is that PrimaryDatabase sends logs to StandbyDatabase only when an archive occurs. If PrimaryDatabase is abnormal
The biggest problem with using the ARCH process is that the Primary Database sends
Error 1: [INS-06101] IPaddressoflocalhostcouldnotbedetermined figure: solution: Because your host name and IP address are different
Error 1: [INS-06101] IP address of localhost cocould not be determined figure: solution: Because your host name and
The configuration process of the Oracle11g client on the Linux system is a little difficult, but as long as we configure it step by step, there is nothing. This article introduces
The configuration process of the Oracle 11g client on the Linux
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service