sql主题的文章列表，还有sql的技术要点_第2页

mysql主从--主库故障，从库切主库

主库故障，从库切主库的几种情况：1、完全同步的状态，直接将完全同步的从库切成主库2、不同步状态，a、服务器宕机，直接将从库切成主库，可能存在数据不一致；b、数据库宕机，把从库没有应用完的主库binlog，传至从库中应用后再切但过程大概一致，略有不同。以完全同步的情况为例：环境：一主两从，在同一服务器上，多个实例（多实例...

开发笔记·2023-08-10

MySQL主从切换（详解MySQL主从切换步骤和注意事项）

一、什么是MySQL主从切换MySQL主从切换是指当主数据库宕机或不可用时，自动或手动将从数据库切换为主数据库，以保证数据的可用性和一致性。MySQL主从切换可以通过多种方式实现，例如使用MySQL自带的复制功能、使用第三方工具如MHA等。二、MySQL主从切换步骤1.确认主数据库宕机或不可用，需要进行主从切换。2.将...

开发笔记·2023-08-10

ORA-31181: PL/SQL DOM handle accesses node that is no longer available

文档解释ORA-31181:PL/SQLDOMhandleaccessesnodethatisnolongeravailableCause:Thespecifiedpl/sqlhandleisreferencinganodeinaDOMDocumentthatisnolongeravailable.Action:Ens...

IT技术学习·2023-07-28

ORA-30357: this PL/SQL function cannot be supported for query rewrite

文档解释ORA-30357:thisPL/SQLfunctioncannotbesupportedforqueryrewriteCause:ThestatementreferencedaPL/SQLfunctionthatisnotmarkedDETERMINISTIC.Action:Performoneofthefo...

IT技术学习·2023-07-28

ORA-32162: Read/Write SQL method not registered

文档解释ORA-32162:Read/WriteSQLmethodnotregisteredCause:readSQL/writeSQLmethodwasNULLorwasnotregisteredAction:RegisterreadSQL/writeSQLbycallingputmethodinMapORA-321...

IT技术学习·2023-07-28

ORA-26052: Unsupported type number for SQL expression on column string.

文档解释ORA-26052:UnsupportedtypenumberforSQLexpressiononcolumnstring.Cause:ThedirectpathapidoesnotsupportaSQLexpressiononacolumnofthattype.Action:Makesurethetypesa...

IT技术学习·2023-07-28

ORA-13604: The specified parameter string cannot be fetched as a SQL table.

文档解释ORA-13604:ThespecifiedparameterstringcannotbefetchedasaSQLtable.Cause:Theuserattemptedtoretrieveanon-tableparameterasatablename.Action:Checkthedatatypeforth...

IT技术学习·2023-07-28

ORA-30444: rewrite terminated by the sql analyzer

文档解释ORA-30444:rewriteterminatedbythesqlanalyzerCause:ThesqlanalyzerterminatestherewriteprocessAction:Thisisaninternalerror.NotifyORACLEtechnicalsupportORA-30444...

IT技术学习·2023-07-28

ORA-31642: the following SQL statement fails: string

文档解释ORA-31642:thefollowingSQLstatementfails:stringCause:AninternalerrorwasgeneratedfrompackageDBMS_METADATA.Action:ContactOracleCustomerSupportandreporttheerror...

IT技术学习·2023-07-28

ORA-13054: recursive SQL parse error

文档解释ORA-13054:recursiveSQLparseerrorCause:Thisisaninternalerror.Action:ContactOracleSupportServices.ORA-13054错误指明Oracle数据库解析指令中的存在循环，而在解析时检测到这种循环会抛出这个错误。比如，假定表A...

IT技术学习·2023-07-28

ORA-31214: DBMS_LDAP: PL/SQL – Invalid LDAP mod type.

文档解释ORA-31214:DBMS_LDAP:PL/SQL–InvalidLDAPmodtype.Cause:TherehasbeenanerrorintheDBMS_LDAPpopulate_mod_arrayoperation.Action:PleasechecktheLDAPmodtypethaty...

IT技术学习·2023-07-27

ORA-29472: DBMS_SQL.OPEN_CURSOR failed. security_level is outside the valid range of 0 to 2

文档解释ORA-29472:DBMS_SQL.OPEN_CURSORfailed.security_levelisoutsidethevalidrangeof0to2Cause:Aninvalidsecurity_levelvaluewasspecified.Action:Specifyavalidrangeof0to...

IT技术学习·2023-07-27

ORA-31219: DBMS_LDAP: PL/SQL – Invalid LDAP notypes.

文档解释ORA-31219:DBMS_LDAP:PL/SQL–InvalidLDAPnotypes.Cause:TherehasbeenanerrorintheDBMS_LDAPexplode_dnorexplode_rdnoperation.Action:PleasechecktheLDAPnotypes...

IT技术学习·2023-07-27

ORA-31220: DBMS_LDAP: PL/SQL – Invalid LDAP SSL wallet location.

文档解释ORA-31220:DBMS_LDAP:PL/SQL–InvalidLDAPSSLwalletlocation.Cause:TherehasbeenanerrorintheDBMS_LDAPoperation.Action:PleasechecktheLDAPsslwrlvaluethatyouus...

IT技术学习·2023-07-27

ORA-16954: SQL parse error.

文档解释ORA-16954:SQLparseerror.Cause:ThespecifiedSQLstatementfailedtobeparsed.Action:Checkifsyntaxiscorrectandensurethatthisstatementcanbeparsedbythespecifiedusern...

IT技术学习·2023-07-27