Handle irregular Oracle listening exceptions

The operating system is SunOS5.10 database version: OracleRAC11.2.0.3.0. This host has two databases, and one node of RAC is located on it. There is another database. The operating system is SunOS 5.10 database version: Oracle RAC 11.2.0.3.0. This

Oracle11gR2grid cluster resource settings automatically start with the cluster

Some resources in the Oracle11gR2grid cluster are not automatically started and need to be manually started, such as srvctl and crs_start. Some resources in the Oracle 11gR2 grid cluster will not be automatically started by the cluster and need to

Oracle data backup and recovery

Oracle data export: Write the Creation Path file: create_dir.sqlcreateorreplacedirectorydmpdiras Oracle export data: Write the Creation Path file: create_dir. SQL create or replace directory dmpdir Homepage → Database

ORA-25153 temporary tablespace is empty

In the morning, the boss said that the temporary tablespace is empty. Let me see it. I see the ORA-25153, it must be because the logical name of the temporary tablespace is still there, but the temporary file cannot be found. In the morning, the

Remove temporary table reported ORA-14452 error Solution

Run the stored procedure, which contains a temporary table. After running, I plan to delete the temporary table report ORA-14452: Anattemptwasmadetocreate, alterordropanindexonte Run the stored procedure, which contains a temporary table. After

Zabbix automatically detects and monitors remote MongoDB instances based on host and port lists

In some cases, you can only use a remote MongoDB instance instead of logging on to the server where the MongoDB instance is located. In this case, you can maintain the host and port list of a remote MongoDB instance on one server, then use z In some

OracleGoldenGate learning-Monitoring of GoldenGate

OracleGoldenGate learning-GoldenGate monitoring 1. Use GGSCI command monitoring (1) to enter the GoldenGate installation directory, run GGSCI, and then use infoall to view the overall running status GGSCI (aix212) 1inf OracleGoldenGate

Solution to Oracle 10g installation error on CentOS6.3

When Oracle10G is installed on CentOS6.3, the following error occurs: ldquo; libi?libawt. so: libXp. so.6: cannotopen=dobjectfile: Nosuchfil. When Oracle 10 Gb is installed on CentOS 6.3, the following error occurs: ldquo;/lib/i386/libawt. so: libXp.

ORA-01652: unabletoextendtempsegmentby8192...

The latest error message "unabletoextendtempsegmentby8192intablespace..." was prompted during rebuildindex. This is a common error. Index in The latest error message "unable to extend temp segment by 8192 in tablespace..." was prompted during

Upgrade OracleRAC10.2.0.1 to 10.2.0.4 operation notes

Upgrade OracleRAC10.2.0.1 to 10.2.0.4 operation notes Oracle RAC 10.2.0.1 upgrade to 10.2.0.4 operation notes ========================================================== ================================Oracle®Database 10g Release 2 (10.2.0) RAC

Enabling MySQL scheduled tasks

A special feature ndash has been added since MySQL5.1.0. The event scheduler (EventScheduler) can be used to regularly execute certain tasks (such as deleting records ). An ndash feature has been added since MySQL5.1.0. The Event sched can be used

New features that add columns and default values to Oracle11g

Before Oracle11g, if you want to add a column in a large table and set the default value, it will be a very tragic thing. Sometimes you have to choose the online redefinition function to implement it. Before Oracle 11g, if you want to add a column

OracleDataGuard _ renaming data files in the master database

When you rename one or more data files in the master database, the slave database will not change accordingly. Therefore, if you want to rename the same data file in the slave database, you must manually When you rename one or more data files in the

Two scripts for shell monitoring MySQL Master/Slave status

This article is from yijiu.blog.51cto.com. You should know whether the master-slave replication is normal and whether the master-slave replication is working. The content is my summary. If you are not welcome, click here. The content is a summary

Oracle10gRACInstaller fault-Oracle software installation cannot discover Cluster

Oracle10gRACInstaller fault-Oracle software installation cannot find cluster system environment: Operating System: AIX5300-08 cluster software: CRS10.2.0.1 Database: Oracle10.2.0.1 I. Fault Phenomenon in the installation of CRS Oracle10gRACInstaller

Be careful when using with in Oracle -- predicate cannot be promoted

Today, we can see that a SQL statement uses with in large quantities. For logic clarity, developers cache some result sets first with, and there are many places to use this result set later. The original Today, we can see that a SQL statement uses

Solution to an error caused by the vip gateway in OracleRAC

After installing the OracleRAC on the virtual machine, restart the system. Restart all oracle services. All services are normal at the beginning. But after a while, the vi of Node 2 After installing Oracle RAC on the virtual machine, restart the

Important parameter log_slave_updates for MySQL master-slave Synchronization

MySQL cluster environment has been deployed recently. For details, M01 and M02 are master-master replication, while M01 and R01 are master-slave replication. The following problems are found during the test: master/Master recovery of M01 and

MySQL database startup and Shutdown

MySQL database server usually refers to mysqld, while command line mysql is a mysql client program. These two concepts are often confusing. Generally, the mysql server is started MySQL database server usually refers to mysqld, while command line

Oraclebug solution example: ORA-20446 Error

I downloaded an Oracle11g and want to see what new functions are available. After the installation, enable EM and find that the feature is excellent. It is used to import data from another database. Set From I downloaded an Oracle 11g and want to

Total Pages: 12780 1 .... 4561 4562 4563 4564 4565 .... 12780 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.