The listener. ora, sqlnet. ora, and tnsnames. ora configuration files are stored in the $ ORACLE_HOME \ network \ admin directory.1. sqlnet. ora ----- is similar to the nsswitch. conf file of linux or other unix. It is used to determine how to find a connection string that appears in the connection.For example, we ente
ORA-16014 and ORA-00312, ora-16014ora-00312
Scenario:
SQL> alter system archive log current;Alter system archive log current*Row 3 has an error:ORA-16014: log 2 sequence #34 Unarchived, no available destinationORA-00312: Online log 2 thread 1: '+ DATA_DG/orcl/onlinelog/group_2.258.885126161'ORA-00312: Online log 2 thre
1th:ORA-03113: End of file for communication channelProcess id:2592Session Id:5 Serial Number: 7sql> ALTER DATABASE Archivelog;ERROR:ORA-03114: Not connected to ORACLESql> select * from V$log;ERROR:ORA-03114: Not connected to ORACLESql> Conn Sys/sys as SysdbaConnected to the idle routine.Sql> select * from V$log;SELECT * FROM V$log*An error occurred on line 1th:Ora-01034:oracle Not availableProcess id:0Ses
ORA-00020, ORA-01304, ORA-27101 troubleshooting # ORA-00020 ProblemsDuring fixed-point maintenance, the "Next" mode is used for installation of the database by Windows software. All configuration parameter values are default values. But because the number of billing endpoints of the specified point is large, the number
A tablespace after offline alert Log reports ORA-01135 and ORA-01110 problems, ora-01135ora-01110
This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/44336789
In a recent case, alert logs continuously report errors after a tablespace is offline. The error was first reported in 11.2.0.2. Later
Received a friend recovery request, Aix 5.3,oracle 10.2.0.1 Platform, database startup ORA-01115 ORA-01110 ORA-27067 error, database failed to open, through analysis, is due to 10201 of the bugs on Aix caused, Through the skills to circumvent, the perfect solution to the problem, data 0 lostDatabase Error Alert LogMon Aug 10 13:25:22 2015ALTER DATABASE MOUNTMon A
, 0xab840000) tenured generation total 1408 K, used 544 K [0xabc90000, expires, expires) the space 1408 K, 38% used [0xabc90000, 0xabd18148, 0xabd18200, 0xabdf0000) compacting perm gen total 4096 K, used 3573 K [0xaf7b0000, 0xafbb0000, timeout) the space 4096 K, 87% used [0xaf7b0000, 0xafb2d678, 0xafb2d800, 0xafbb0000) local Time = Tue Oct 23 21:36:23 2007 Elapsed Time = 6 # The exception abve was detected in native code outside the VM # Java VM: java HotSpot Client VM (1.4.2 _ 08-b03 mixed mode
ORA-12801, ORA-08103, ora-12801ora-08103
I. Version Information
Operating system version: AIX 61009
Database Version: 11.2.0.3.11 (RAC)
Ii. Error description
R D response, today they report a lot of Process "ORA-12801: parallel query server P004, ORA-08103: Object no longer
Oracle ORA-00001: violation of unique constraints and ORA-00054: Resource busy error resolution, ora-00001ora-00054
Oracle databases may report errors for common errors. During the year of work, some errors have been encountered and some pitfalls have been encountered. Thanks to the questions and solutions shared by those predecessors, just as the Chinese New Ye
Have friends in the Library Alert log report ORA-27300 ORA-27301 ORA-27302 error, let help analyze the reason
ORA-27300 ORA-27301 ORA-27302Fri Oct 28 22:15:33 2016Process startup failed, error stack:Errors in file d:\app\diag\rdb
The database cannot be started (or crash immediately after startup), alert log error ora-00600[17182],ora-00600[25027],ora-00600[kghfrempty:ds], and so on
Tue June 23:36:06 2014 ALTER DATABASE openbeginning crash Recovery of 1 threads parallel recovery started with 32 Processes started redo Scan Completed redo scan read 1409 KB redo, 0 data blocks need recover
Label:Once a 12C RAC database is installed on rhel7.2, one of the DB instances is often automatically crash. Viewing the alert log found the following error message: Errors in FILE/D12/APP/ORACLE/DIAG/RDBMS/RAC12C/RAC12C2/TRACE/RAC12C2_J000_21047.TRC:
ora-27157:os post/wait Facility removed
Ora-27300:os system dependent Operation:semop failed with status:43
ora-2
For listeners that are not on the default port (1521), The pmon process does not register the service/instance to the listener, that is, dynamic registration is not implemented. Similar to a single instance, listeners with non-default RAC ports also set the local_listener parameter. In addition, you can remotely register an instance to achieve load balancing. This is achieved through the remote_listener parameter.
For more information about the basics and concepts of Oracle network configuratio
Oracle database-enterprise edition-version 8.1.7.4 and later information in this document applies to any platform. **checked for relevance 06-apr-2010 **checked for relevance 17-apr-2013 * * Checked for relevance on 16-nov-2011 * * *Purpose1.1 Abstract ============ This document provides guidelines for customers to doing an initial analysis of problems related to Internal errors (ORA-600) and core dumps (ORA
General steps for handling common undo exception errors, ORA-600 4193, ORA-600 4194, ORA-600 4137, etc.Applicable versionOracle Database-Enterprise Edition-Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]Information in this document applies to any platform.Error messageThe following error is occurring in the alert. log right before the database crashes.ORA-00600
1.1. ora-16664,ora-16625,tns-12537
Main Library:
16664, 0000, "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 the
Members of the configuration. Fix any possible netwo
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.