ora 00942

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

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

ORA-19809/ORA-19809: limit exceeded for recovery files problem processing today encountered this problem, alert Log error information is as follows: in fact, the problem is very simple, put the archive fra space is full, as a result, the archive fails, and oracle suspends. Note that db_recovery_file_dest is only a logical limitation. The fra directory may have space left, but oracle will not be used. Pay mo

Encountered a ORA-01172, ORA-01151 error, asked about the storage failure caused the database to fail to start. Encountered a ORA-01172, ORA-01151 error, asked about the storage failure caused the database to fail to start. Encountered a ORA-01172,

RMAN backup failed: ORA-19502 ORA-27072: File I/O error, rmanora-19502 When checking an ORACLE database's RMAN backup email in the morning, it was found that there were errors such as ORA-27072: File I/O error, the details are as follows: channel ORA_DISK_1: starting piece 1 at 23-MAR-15 RMAN-00571: ===========================================================

Oracle10.2.0.5 an ORA-27468 error occurs in the Environment Alert Log. In the MOS document ORA-12012ORA-27468: SYS. PURGE_LOGisLockedbyAnotherProcess ORA-27468 error in Oracle 10.2.0.5 environment Alert Log. ORA-12012 ORA-27468 in MOS document: SYS. PURGE_LOG is Locked by An

A machine, the disk was found to scan, it is estimated that the shutdown encountered problems yesterday, Oracle appeared after ora-01172 ora-01151Hurry to find information to solve, and encountered a ORA-12514 error, the first solution to this error is as follows:Enter the following information in the listener. ora fil

The recent data import (IMP) encountered a ORA-01187 ORA-01110 error because the database was restored with hot standby, and the recovery was successful because the database was successfully open, so where are the omissions? If you have a similar problem, let's look at it. 1. Fault IMP-00003: ORACLE error 1187 encounteredORA-01187: cannot read from file 202 because it failed verification testsORA-01110: da

tip ora-28000:the the account is locked and hint ORA-00922: Option missing or invalid The domain itself has password requirements, Windows 7 also has password requirements, Oracle also has password requirements. And Oracle's requirements are the most specific. ORA-28000 and ORA-00922 errors when installing an instance

It's really unfamiliar with Oracle's various errors, documenting the final troubleshooting record of a long-troubled problem.First, the symptom description:Plsql Unable to connect to the database, prompting: "Ora-12154:tns: Unable to resolve the specified connection identifier"Second, the process of troubleshooting Tnsnames.ora fill in no errors The monitoring service has started: Management tools -Services,oracleoradb10g_home1tnslistener Servic

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

ORACLE 11 ORA-00119 startup exception throw error handling today unexpected server restart, resulting in oracle exceptions. Www.2cto.com SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'listener _ ORCL 'on another terminal enter www.2cto.com [root @ huang14 ~] # Su-oracle [oracle

Oracle-permission-ORA-04043-ORA-04043: object "SYS ". "V _ $ DATABASE" does not exist solves the problem of logging on to a new 10g DATABASE with a non-dba account (but with a DBA role). To see the version number, SQL> desc v $ instance; ERROR: ORA-04043: object "SYS ". "V _ $ INSTANCE" does not exist strange, there was a 9i library before, the same account can v