Discover ora 02063, include the articles, news, trends, analysis and practical advice about ora 02063 on alibabacloud.com
Recently, my colleagues reported that the database could not perform some data dictionary queries. An error occurs even when you query dba_users. From the error log, all are some error information of the data dictionary, and the user data is OK. Google a moment, looked at metalink, need to re-build the data dictionary. Run catalog. SQL. Dizzy, even if you execute this SQL statement, an error is reported! Data is not backed up. Khan !!! If you cannot successfully execute catalog. SQL, go to the n
When Oracle 9i Database is logged on, A ORA-01003 ORA-01110 message is prompted, which probably means that the data file storage media is corrupt. Startup nomount, normal; Alter database mount, also normal; Alter database open: Alter database open*ERROR is located in row 1st:ORA-01113 :?? 1 ??????ORA-01110 :???? 1: 'e: \ ORACLE \ ORADATA \ JSDSB \ system01.dbf'
the production database wants to build the DG without stopping the database, it is necessary to use the original db_unique_name, which is usually the same name as db_name. After modifying the spfile, use it to create a pfile for the standby database. Create pfile from spfile; 3. Create standby redo logfile in the master database, and alter database add standby logfile group # datafile ('xxxx') size 50 M. xxxx specifies the path and file name. 4. Create listener.
1.1.1.ORA-19502, ORA-27072 Date: 2014-05-Environment: Tester [error code] $ oerrora1950219502, 00000, writeerroron 1.1.1. ORA-19502, ORA-27072 Date: Environment: Tester [error code] $ oerr ora 19502 19502,000 00, write error on 1.1.1.
This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh. This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh. This article summarizes the ORA
Recently encountered a ORA-17629, ORA-17627, ORA-12154 error during cloning from the active database, initially thought it was a bug. Oracle bug is too much, and it has become a habit of thinking. Khan! The error message is that you cannot connect to the remote database, and the connection string cannot be parsed. Listener, configured tnsnames from auxiliary dB t
ORA-01092 ORA-12432: LBAC error: zllegnp: OCIStmtExecute fault case recently due to the database hang live, helpless directly killed the pmon process, once again started received the ORA-01092: ORACLE instance terminated. disconnection forced and ORA-12432: LBAC error: zllegnp: OCIStmtExecute. Well, it's an error that
1.1. ORA-16664, ORA-16625, TNS-12537 Master database: 16664,000 0, "unable to receive theresult from a database" // * Cause: During execution of a command, a databasein the Data Guard // Broker configuration failed to return a result. // * Action: Check Data Guard broker logsfor the details of the failure. // Ensure network communication is working properly amongst // Members of the configuration. Fix any p
The local Oracle database version is 10 Gb, and the remote database version is 11 GB. An error occurred while executing the test query statement after the local database connection was created. The local Oracle database version is 10 Gb, and the remote database version is 11 GB. An error occurred while executing the test query statement after the local database connection was created. The local Oracle database version is 10 Gb, and the remote database version is 11 GB. An error occurred whi
Recently because of the database hang live, helpless directly killed the pmon process, again when the startup received the ORA-01092: ORACLE instance terminated. Disconnection forced and ORA-12432: LBAC error: zllegnp: OCIStmtExecute. Well, it's an error that has never been encountered. The following describes and solves this error. 1. fault description idle> startupORACLE instance started. total System Glo
The ORA-01187 ORA-01110 error was encountered during data import, the most recent data import (IMP), because the database was restored using hot standby and the recovery was successful, because the database can be opened successfully, what are the omissions? If you have a similar problem, let's look at it. 1. Fault symptom [SQL] IMP-00003: ORACLE error 1187 encountered
Expdp ora-31640, ora-19505Oracle @ db01:/oraapp/oracle/backup> impdp \ '/as sysdba \' directory = DB_BACKUP dumpfile = newdb.20140918.dmp logfile = newdb_0919.log parallel = 4 c>Import: Release 11.2.0.3.0-Production on Fri Sep 19 11:27:12 2014Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWit
Oracle input Account Login error ORA-12154: TNS: unable to resolve the specified connection identifier issue resolved, ora-12154tns TNS-03505: unable to resolve Name: Recently, after Oracle Developer Suite has been installed, you cannot log on to the system, enter an account logon error: ORA-12154: TNS: failed to parse the specified connection identifier. Gen
OracleASM errors-ORA-15031, ORA-15014 Oracle ASM errors-ORA-15031, ORA-15014 Oracle ASM errors-ORA-15031, ORA-15014 System Environment: Operating System: AIX 5.3.8 Oracle: Oracle 10gR2 Fault symptom: [Oracle @ aix213 ~] $ Sql
ORA-28002ORA-28000 to solve the problem of locking the user after the password expires and wrong password -- modify defaultprofile ORA-28002/ORA-28000 address 11g password expiration, password wrong lock user problems-Modify default profile A ORA-28002: the password will expire within 7 days In the 11G, the defaul
Export Export encountered ORA-19206 EXP-56 While Taking export, ora-19206exp-56Applies to: Oracle Database-Enterprise Edition-Version 9.2.0.1 to 9.2.0.8 [Release 9.2]Information in this document applies to any platform.*** Checked for relevance on 11-Apr-2013 ***Symptoms During export you receive the following errors:EXP-00056: ORACLE error 19206 encountered ORA-
ORA-00600 [kqlInvObj: user] processing, ora-00600kqlinvobj Today, our brother called us to say that after I installed 11.2.0.1.0 on the Development Database (win7 64bit), I had a problem with the Data Pump derivative, which was hard to solve. Then I ran the SQL statement and reported an error, if a simple SQL statement does not report an error, as long as several tables are associated, an error will be repo
In Oracle databases, how does one restrict IP address access through the SQLNET. ora file ?, Oraclesqlnet. ora In the Oracle database, we can use the SQLNET. ora file to implement address access restrictions. Set the following parameters in the SQLNET. ora file to implement IP access restrictions: Tcp. validnode_check
test2 using 'xe '; Database link created. now we will create a procedure which will first do a successful dml, after that a dml that fails due to the incorrect trigger: create or replace procedure p isbegin -- first do a statement that executes OK update test2_tab @ test2 set n = 2; -- next statement will fail because of the invalid trigger insert into test2_tab @ test2 values (1); end;/Procedure created. call the procedure, it will fail: SQL> exec pBEGIN p; END; * ERROR at line 1:
(+) = i.stt_state_type_idand oi.ctps_insttn_id = i.inst_insttn_idand I.inst_modifd_dt = trunc (sysdate)and (NVL (Oi.inst_state_txt, ' x ') and (NVL (oi.inst_phone_txt) The same query fails when both local and remote databases is 10g R2 with following errors:ERROR at line 2:ORA-00904: "OI". " Inst_state_txt ": Invalid identifierOra-02063:preceding Line from CTPS3ChangesCauseOuter join query over Dblink can
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
