ora 02063

Resolved an error reporting ORA-01034 and ORA-27101 when connecting Oracle11g Resolving ORA-01034 and ORA-27101 errors when connecting to Oracle 11g My local database version installed is Oracle 11G R2, when using plsql connection, the following error is reported ora-12

Fault description: A two-node single-instance Linux + oracle11.2.0.3 + dataguard maximize availability environment was set up a few days ago. Perform the following steps to remove the dataguard environment on the master node: 1. Create a pfile SQL> Create pfile = '/opt/Oracle/initorcl. ora' from spfile; 2. Edit the initorcl. ora file and delete the configuration related to dataguard. 3. Start Database SQL>

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 ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on Thu Jul 24 11:28:52 2014 Copyright (c) 1982,200 5, Oracle. All rights res

ORA-24324 ORA-01041 reboot Database Error Yesterday, when the Oracle database was restarted, an error was reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem. 1. Prepare the environmentWe performed the test in Oracle 10g + Windows Server 2008. Note th

Fatal NI Connect error 12170. VERSION Information:TNS for 64-bit windows:version 11.2.0.1.0-productionOracle bequeath NT Protocol Adapter for 64-bit windows:version 11.2.0.1.0-productionWindows NT TCP/IP NT Protocol Adapter for 64-bit windows:version 11.2.0.1.0-productionTime:01-11 Month-2011 16:46:57Tracing not turned on.Tns error struct:NS Main ERR code:12535Tns-12535:tns: Operation timeoutNS Secondary Err code:12606NT Main ERR code:0NT Secondary Err code:0NT OS Err code:0Client Address: (add

record two errors that are easily encountered when merging partitions: ORA-14274, ORA-14275 First, the merged partitions must be contiguous. Otherwise, the following error will occur:Ora-14274:partitions being merged are not adjacent Second, only the lower range of partitions can be merged into a high range of partitions. Otherwise, the following error will occur:Ora-14275:cannot reuse Lower-bound partiti

CreatematerializedviewBBBrefreshcompleteondemandasselecta. vbillcode, B. invname, del. exchdate Create materialized view BBBrefresh complete on demandasselect a. vbillcode, B. invname, del. exchdate An error is returned when the following materialized view is created.Create materialized view BBBRefresh complete on demandAsSelect a. vbillcode,B. invname,Del. exchdateFrom AA @ AAInner join BB @ BB B on a. id = B. idLeft join CC @ CC del on a. id = del. idWhere a. dbilldae> = '2017-06-15 'and

The first reason for this error is that the session and process connections are full. view the number of sessions and processes at www.2cto.com: select count (1) from v $ session; select count (1) from v $ process; display the maximum value of session and process: show paramater session; show parameter process; you must have the dba permission to set the session and process. alter system set processes = 200 scope = spfile; session is a derived value, which is determined by process and automatica

Today, I checked the alter _ Sat Sep 14 14:49:42 CST 2013Error 2068 trapped in 2 PC on transaction 47.12.104933. Cleaning up.Error stack returned to user:ORA-02068ORA-03135 ERPSALES indicates that this is related to another system. After checking the entire log, it is found that this error occurs almost every month in the past. On the Network looked at the ORA-02068, ORA-03135 related errors, more simil

ORA-01810 format code appears twice solution, ora-01810 Solution When you make a query page this morning, you need to query the spans of two time ranges. Use the TO_DATE function and write it at the beginningSQL codeTO_DATE ('2017-08-04 00:00:00 ', 'yyyy-MM-DD HH: mm: ss ') The result reported that the ORA-01810 format code had two errors. After the query, it wa

[Err] ORA-00923: FROM keyword not found where expected and rownum, ora-00923rownumAbout oracle's nownum If I want to query all the table information and add the row number in front of it, the SQL statement is as follows:Select ROWNUM, * from tableA The following error is reported.[Err] ORA-00923: FROM keyword not found where expected Alias must be adde

ORA-12541: TNS: no listeners, ora-12541tnsAfter I reinstall Oracle yesterday, ORA-12541: TNS: no listening program error occurs when I connect oracle with PL/SQL Developer, for example: With the help of Brother Wang Peng, I found that the oracle listener was not started and the connection was successful after the listener was restarted. I would like to share wit

ORA-12547: TNS: lost contact error handling, ora-12547tns Nothing left to worry about. Configure the oracle database to automatically restart with the system. Check the information and find that you need to configure/etc/oratab and rc. local. The $ ORACLE_HOME/bin/dbstart file is used to configure oracle to start with the system. Paste the content of dbstart for easy viewing. #!/bin/sh## $Id: dbstart.sh 22

About ORA-03113: End of communication channel, ora-03113 Channel Author: iamlaosong A SQL query statement, successful execution or error, irrelevant to the statement, but related to the value in the condition, the error is the ORA-03113: The end of the communication channel file, is not very strange, the statement is as follows: select * from tb_evt_dlv a, tb_jg

ORA-19870 and ORA-19573 errors, such: RMAN> restore database; Starting restore at 11-DEC-12Using channel ORA_DISK_1 Channel ORA_DISK_1: starting datafile backupset restoreChannel ORA_DISK_1: specifying datafile (s) to restore from backup setRestoring datafile 00001 to/u02/oradata/orcl/system01.dbfRestoring datafile 00002 to/u02/oradata/orcl/undotbs01.dbfRestoring datafile 00003 to/u02/oradata/orcl/sysaux01.

Today, I encountered a headache in the project,Oracle Database reports: ORA-00911 errors. The problem is as follows: But I am running it in PL/SQL developer !!! Where is the problem ??? After a long time, I found that the problem was after the SQL statement.The semicolon ";",Delete the semicolon to solve the problem ~ The problem is solved here, But LZ is a kindProgramEmployee, what should I do if I encounter other errors? I searched the interne

The following error message is displayed when you export data from the Oracle10g Data Pump: ORA-31693: Table Data Object "smartgps2006". "mcc_asyn_pos": "mcc_asyn_pos201409" failed to load/unload and is being skipped due to error:ORA-29913: Error in executing odciexttablepopulate calloutORA-01555: Snapshot too old: rollback segment number 21 with name "_ syssmu21 $" too small The solution is as follows: Show parameter undo_retention; view the value o

Exp/imp encounter two problems (ORA-00904 and the objects were exported by ABC not by you), ora-00904exported Recently, I was responsible for setting up the user environment of a system, which involved importing data from the test environment. due to objective constraints, the table space transfer method cannot be used for synchronization, therefore, the imp/exp or Data Pump method is required. Here imp/exp

During the national day, when the database stored procedure calls the stored procedure through the Dblink cross-Library, the Ora-12560:tns: Exception Log for the protocol adapter error is logged in the error log.Occasionally when connecting to a database with PL/SQL, you are frequently prompted:Ora-12154:tns: Unable to resolve the specified connection identifierThen, Baidu a lot, tried a lot of methods, no answer to indicate is because the number of c

work from the partition perspective. Export partitions and import them by partition. The impdp command used is as follows and the remap_schema has been implemented. However, the following error will be thrown no matter how you try it. In fact, this partition exists. Impdp mig_test/mig_test directory = memo_dir dumpfile = parw.mow.memo.dmp logfile = partition tables = partition: P9_A0_E5 TABLE_EXISTS_ACTION = append REMAP_SCHEMA = prdappo: MIG_TEST DATA_OPTIONS = Partition With the Partitioning,