ora 00942

Listen for configuration independent of the database server, solve ORA-12520 and ORA-12545 errors 1. Environment: 1. linux host ocm (192.168.217.130) as Database sys @ OCM> select * from v $ version; BANNER monitoring Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production 2. linux host ocp (192.168.217.large) as an independent remote listener sys @ OCP> select * from v $ version; BANNER monito

1.1.1. ORA-19502, ORA-27072 Date: Environment: Testing Machine [Error code] $ Oerr ora 1, 19502 19502,000 00, "write error on file \" % s \ ", block number % s (block size = % s )" // * Cause: write error on output file // * Action: check the file $ Oerr ora 1, 27072 27072,000 00, "File I/O error" // * Cause: read/writ

Oracle ora-00054: resource busy and acquire with nowait specified solution, ora-00054nowait When a database user inserts, updates, or deletes data from a table in a database, or adds a table's primary key, or the table's index, a ora-00054 often occurs: resource busy and acquire with nowait specified errors. It is mainly because a transaction is being executed (o

When tablespace in the database is deleted today, it is found that it cannot be deleted, the error message is: quot; ora-00604, ora-02429: Unable to delete the index used to force a unique primary key. Quot; most When tablespace in the database is deleted today, it is found that it cannot be deleted all the time, the error message is: quot; ora-00604,

OS Version: RHEL5.6-x86-64DB version: Oracle11.2.0.1 today when using dbca to create a database, an error occurred at the place where the progress bar is 61%, an XML file parsing error occurs OS Version: RHEL5.6-x86-64DB version: Oracle 11.2.0.1 today when using dbca to create a database, an error occurred in the progress bar of 61%, an XML file parsing error OS Version: RHEL5.6-x86-64 DB version: Oracle 11.2.0.1 When I used dbca to create a database today, an error occurred in the progress

Data is recovered from the main library to the standby repository; An exception was found while opening the repository sql> ALTER DATABASE open;ALTER DATABASE Open*ERROR at line 1:Ora-10458:standby database requires recoveryOra-01152:file 1 was wasn't restored from a sufficiently old backupOra-01110:data file 1: '/U01/APP/ORADATA/ORCL/SYSTEM01.DBF ' View alarm log with tail-200 Alert_orcl.log view

(Cweolb) started logmergerprocesssunaug0221:58:342015managedstandbyrecovery startingRealTimeApplySunAug0221:58:342015Errorsin file/oracle/orabase/admin/cweolb/diag/rdbms/cweolb/cweolb/trace/cweolb_dbw0_9896432.trc:ora-01186:file 483failedverificationtestsora-01157:cannotidentify/lockdatafile 483-seedbwrtracefileora-01111:namefordatafile 483isunknown-renametocorrectfileora-01110:datafile 483: '/oracle/orabase/ora11gr2/dbs/unnamed00483 ' file483notverifieddue toerrorora-01157mrp0:backgroundmediar

ORA-02097, ORA-00837 (a small problem encountered when modifying memory_target) ORA-02097, ORA-00837 (a small problem encountered when modifying memory_target) Today I saw a little questions about ocp, I did a small experiment, encountered two errors of ORA-02097 and

Resolution ORA-28000: the account is locked, ora-28000locked In oracle, if the account fails to log on for ten consecutive attempts, the account will be locked ). When you log on with a locked account, the system reports an error: ORA-28000: the account is locked. This article describes how to solve the secondary error. 1. Log On with the system or sys

ORA-27090 fault case and ora-27090 fault case The recent alert Log encountered an error message for the ORA-27090 with the error prompt Unable to reserve kernel resources for asynchronous disk I/O. According to this prompt, It is a kernel parameter problem related to asynchronous I/O. The following describes and solves the problem. 1. Fault error informationWed

Two forms of ORA-01502 oracle database index, ora-01502oracle In the current project, when we run the batch, there is an SP always reports the error "ORA-01502: index 'wbill _ 102. PK_A_NOTWEB_ACT_PROVINCE_M 'or partition of such index is in unusable state ". The solution is to re-create the INDEX and ALTER index IN_AA REBUILD; However, after the solution is comp

Error encountered while Alter/drop table space Ora-38301,ora-00604,purge Dba_recyclebin notSuitable for:Oracle database-enterprise edition-version 10.2.0.1 and laterInformation in this document applies to any platform.Symptoms:When you try to drop an empty tablespace, you encounter RecycleBin-related errorsSql> drop tablespace Test_tbs including contents and datafiles; Drop tablespace Test_tbs including con

Reference documents:ORA-01033: WorkaroundSolution of ORA-01172 disk bad block after database power-down--attempt to connect to database PrjdbC:\Documents andSettings\Administrator>Sqlplus test/Test@prjdbSQL*Plus:release11.2.0.1.0Production onMon June9 -: at: , theCopyright (c)1982, ., Oracle. Allrights reserved.--Error ORA01033Error:ora-01033: ORACLE???????? Process ID:0Session ID:0Serial Number:0--find out what the root cause of

Sql> alter DiskGroup DATA add failgroup data_0000 disk '/dev/raw/raw12 ';Alter DiskGroup DATA add failgroup data_0000 disk '/dev/raw/raw12 '*ERROR at line 1:Ora-15032:not all alterations performedOra-15033:disk '/dev/raw/raw12 ' belongs to DiskGroup "DATA"?Because/DEV/RAW/RAW12 this disk was previously part of the data disk group, the previous operation closed 2, which later caused the/DEV/RAW/RAW12 disk to be unable to display its name in the V$asm_d

The new company to work the next day, received a task: the data on the production library to the development of the library, when I am ready to use EXPDP export data, the following internal error, no wonder before the DBA placed EXPDP/IMPDP this sharp weapon does not have to use the old exp/ Imp, it turns out, is plagued by this problem. Ora-39006:internal error ora-39065:unexpected Master process exce

Environment Linux 5.8 10.2.0.5 RAC, two nodes can only mount a node, if you try to mount another node on the report ORA-01105 and ORA-01606 errorDatabase version The code is as follows Copy Code Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64biPl/sql Release 10.2.0.5.0

Tags: style blog http use file dataJuly 8, 2014, I regained Oracle, the computer was previously installed Oracle10, because to import the 11 version of the DMP table file, it is suggested that the version of the low Oracle can not import, only the version of the Oracle import version of the low-level table file, Helpless can only unload Oracle10 installed oracle11g, someone gave the oracle11xe version, that is the simple version, the first time the installation is smooth, but the use of the inst

I. Problem phenomena and troubleshooting processAfter the database server restarts, the app does not start properly, prompting that the database cannot be connected. It appears that the problem may be on the database server, so check the database server first:1. After logging into the database server, open the cmd command prompt and enter the command/ as SysdbaConnect to the native database, enter the Sqlplus program context, and enter the commandSelect from V$instance;After execution, it is i

Phenomenonsql> ALTER DATABASE open resetlogs;ALTER DATABASE open Resetlogs*ERROR at line 1:Ora-00392:log 4 of Thread 1 is being cleared, operation not allowedOra-00312:online Log 4 Thread 1: '/mnt/data/pbf/db/proddata/redo04a.log 'Ora-00312:online Log 4 Thread 1: '/mnt/data/pbf/db/proddata/redo04b.log '"Official explanation"Clearing_current-current log is being cleared of a closed thread. The log can stay i

Tags: parsing data through Access database HTTP LOB ges logs minor issuesProblem Description: Export from Access via ODBC to Oracle ora-24801 illegal value error and Ora-01401 value too large errorProblem Analysis: The field type in Access is "Memo", and importing to Oracle automatically turns into a CLOB type, and there may be some strange errorsWorkaround: Change the field type to "Memo" to "text" and the