Execution of marker_setup. SQL hang during DDL replication configuration of OGG

Note the problem of executing marker_setup. SQL hang during ogg ddl replication configuration: this is a record. During the ogg experiment, configuring DDL replication and running the marker_setup. SQL script hang is not a pure technical problem, the following is a short story: Prerequisites: After the dml replication configuration is successful, you need to enable ddl replication for individual schemas of the database and stop the extra, datapump, and replicat processes on the source end, when you run markder_setup. SQL and input the ggschema user, the user encounters a session hang and starts to think that the script is running. After about 10 minutes, the user still does not end the script, I don't want to create a few tables or view a status. It took so long and it was abnormal. So I checked the output log and found that no other scripts were found and I knew where the problem was. [Plain] SQL> connect ogg/ogg Connected. SQL> @/u01/app/ogg/marker_setup. SQL; Marker setup script You will be prompted for the name of a schema for the GoldenGate database objects. NOTE: The schema must be created prior to running this script. NOTE: Stop all DDL replication before starting this installation. enter GoldenGate schema name: ogg is still not over after 15 minutes ...... This is not scientific .... Intermediate troubleshooting process: 1. after the script is stopped, directly run the dump of the 10046 event (don't forget to open SQL _trace) and check the result (if it is not nice, format it with tkpref). 2. for the first time, I did not think of non-pure technical problems. I restarted the database. Haha, I am still using hang. This is really unscientific. (Because the method is the same as the previous one) 3. I reflected on whether the operation method and other non-technical problems were encountered. I first thought of the path problem... If it is scientific, run it directly in the directory. Then, try: [plain] # cd/u01/app/ogg SQL> connect ogg/ogg Connected. SQL> @ marker_setup. SQL; Marker setup script You will be prompted for the name of a schema for the GoldenGate database objects. NOTE: The schema must be created prior to running this script. NOTE: Stop all DDL replication before starting this installation. enter GoldenGate schema name: ogg Marker setup table script com Plete, running verification script... please enter the name of a schema for the GoldenGate database objects: Setting schema name to ogg marker table --------------------------------- OK marker sequence ------------------------------- OK Script complete. SQL> This will be scientific. Let's review this story. Follow-up: this is a joke for a friend. As long as you have a problem, someone on the Earth must have appeared. go unless he is not on Earth --!