ora 00942

Listener. ora adds the listening port and listener. ora listens. A simple listener. ora # Listener. ora Network Configuration File: d: \ app \ zyd \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ listener. ora # Generated by Oracle configuration tools. SID_LIST_LISTENER =

Error: ORA-16501: the Data Guard broker operation failed ORA-16625: cannot reach database solution Create configuration file DGMGRL> create configuration 'sharkdbbork' as primary database is 'sharkdb' connect identifier is sharkdb; Error: ORA-16501: the Data Guard broker operation failedError: ORA-16625: cannot reach d

Ora-27037: unabletoobtainfilestatusLinux-x86_64Error: 2: Nosuchfileordirectory why is there no archive? Who deleted it? Ora-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directory why is there No archive? Who deleted it? In the morning, I received an alert text message on the way to work. An error occurred while archiving an alert library. The content of the alert. log file

Local IP Address: 192.168.1.163[Oracle @ rtest ~] $ Sqlplus/nologSQL * Plus: Release 10.2.0.2.0-Production on Sun May 4 19:32:13 2014Copyright (c) 1982,200 5, Oracle. All Rights Reserved.@> Conn sys/oracle ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directoryThe ORA-01034 and

A friend in the group asked a question: the Oracle 9i database failed to execute the job, and the materialized view refresh reported an error. The error message is as follows: ORA-04068: existing state of packages has been discardedORA-04062: of has been changedORA-04062: Timestamp of package "SYS. dbms_snapshot_utl" has been changedORA-06512: At "SYS. dbms_snapshot", line 617ORA-06512: At "SYS. dbms_snapshot", line 674ORA-06512: At "SYS. dbms_snapsho

1. Configuration content: 1). listener. ora Sid_list_listener =(Sid_list =(Sid_desc =(Sid_name = plsextproc)(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)(Program = EXTPROC))(Sid_desc =(Sid_name = orcl)(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)(Global_dbname = orcl))(Sid_desc =(Sid_name = Practice)(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)(Global_dbname = Practice))(Sid_desc =(Sid_name = rcat)(ORACLE_HOME = D:/Oracle/product/10.1.0/db_1)(Global_d

Linux, the machine is Oracle 11g Database, import database for 10g, through expdp, impdp Data Pump import, at the beginning of the prompt ora-39001, found that the file directory is not found or the file name is not the same. According to the prompt, the version of the dump file is incorrect. Check whether the current library is located. SQL> show parameter compatible NAME TYPE VALUE -------------------------------------------------------------------

Environment: DB: 11.2.0.2 rac OS: RHEL 5.6 The following problems are encountered when upgrading a single machine to RAC under Oracle 11gR2 today. [Oracle @ 11rac5 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.2.0 Production on Tue Oct 9 19:06:51 2012 Copyright (c) 1982,201 0, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters

ORA-38760: This database instance failed to turn on flashback database, ora-38760flashbackORA-38760: This database instance failed to turn on flashback databaseProblem Background:Test the database to execute shutdown immediate, the log reports an error, the error message is: ORA-19815: WARNING: db_recovery_file_dest_size of 4322230272 bytes is 99.77% used, and ha

One ORA-00130: invalid listener address error, ora-00130listener Log on to the database. The following message is displayed: Ora11g> sqlplus dcsopen/dcsopen1SQL * Plus: Release 11.2.0.1.0 Production on Mon Jan 5 18:49:31 2015 Copyright (c) 1982,200 9, Oracle. All rights reserved. ERROR: A ORA-01034: ORACLE not availableORA-27101: shared memory realm does not exi

ORA-00392 ORA-00312 log clearing fault Recently encountered a ORA-00392 after restoring the Oracle database open: log 3 of thread 1 is being cleared, operation not allowed, its literal meaning is that the log file is being cleared, operation is not allowed. Generally, when we do not completely recover the log file, it needs to be cleared, and the log file is bein

One: Version informationOperating system version: AIX 61009Database version: 11.2.0.3.11 (RAC)Two: Error descriptionResearch and development reaction, many of their processes today reported "ORA-12801: Parallel Query Server p004,ora-08103: Object no longer exists" error. Check out their process specific error part foundAll are insert into test select/*+ Parallel (a,4) */* from test1 A similar statement of t

Ora-01034, ora-27101 troubleshooting Error cause: Solution: ora-27101 There may be 2 scenarios, which may lead you to encounter ORA-271011) Invalid ORACLE_HOME and ORACLE_SID (configured in environment variables)2) Database is down (check whether the instance has been started) Solution address: http://nimishgarg.

ORA-01034:, ORA-01078: And LRM-00109: SolutionEnvironment: Linux 5.4 Oracle 11.2.0.3 when connecting Oracle on Linux error: SQL> show parameter sgaORA-01034: ORACLE not availableProcess ID: 0 Session ID: 0 Serial number: 0 SQL> startupORA-01078: failure in processing system parametersLRM-00109: cocould not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorcal.

Tags: Files information man file processing Drop directory Add method sidBrief: When querying database data, prompt temporary table space exception, error ORA-01157 ORA-01110, after the data file processing, has resolved this fault. Environment: Oracle 11g RAC for Linux 6, library for Dataguard 1. Query the data times wrong, as follows: ERROR:Ora-01157:cannot identify/lock data file 226-see DBWR trace fil

, there is no corresponding configuration connection item.Log on to the SQLPlus command line and use the password set during installation to log on. The problem is very strange.The problem should still be considered in the client configuration. There is no problem with SQLPLUS logon, indicating that the service is normal. In the process of login error ORA-12514 and ORA-28547, online search is still the same

Ora-01722: Invalid Number, ora-01722 Invalid Number One of the reasons for this error: The types of fields associated with table A and table B are inconsistent, for example: The aid in Table A is the primary key, the bid in Table B is the aid foreign key, the aid uses the INT type, and the bid uses the Varchar type. (1) If the join operation is correct when the two tables are not empty, oracle can autom

Listening for configuration independent of database servers resolves ORA-12520 and ORA-12545 errors Listening for configuration independent of database servers resolves ORA-12520 and ORA-12545 errors I. Environment: 1. linux host ocm (192.168.217.130) as a databaseSys @ OCM> select * from v $ version; BANNER------

Oracle ORA-00988 missing or invalid password error, ora-00988invalid When setting the password for the database instance, be sure not to start with a number, otherwise you will encounter a ORA-00988 missing or invalid password (password missing or invalid) error. After Oracle 10g is installed, you can use the dbca command to create a new database instance or ma

ORA-00604: error occurred at recursive SQL level 1, ora-00604recursive When you use an account ESCMOWNER in the test environment to ALTER the database, the following error is always reported: ORA-00604: error occurred at recursive SQL level 1 ORA-20016: (ALTER) Action denied as it is a protected object!