Recently encountered a ORA-17629, ORA-17627, ORA-12154 error during cloning from the active database, initially thought it was a bug. Oracle bug is too much, and it has become a habit of thinking. Khan! The error message is that you cannot connect to the remote database, and the connection string cannot be parsed. Listener, configured tnsnames from auxiliary dB t
Some customers storage exception power failure, resulting in database startup reported ORA-01172 error, resulting in the database cannot openDatabase startup reports ORA-01172 errorWed Mar 23 14:16:23 2016ALTER DATABASE OPENWed Mar 23 14:16:24 2016Beginning crash recovery of 1 threadsParallel recovery started with 15 processesWed Mar 23 14:16:24 2016Started redo scanWed Mar 23 14:16:25 2016Completed redo sc
A ORA-00119 and ORA-00132 error was received when the recent system was started, which is actually related to LISTENER, the usual solution is to dump spfile to pfile and then start from pfile
And generate a new spfile. However, this operation method is too costly and you need to restart the database. Another way is to directly modify the service name in tnsnames. ora
ORA-1157 and ORA-01110 error practices often encounter related ORA-1157OR1110 errors in the backup experiment, related error information, nothing more than data files, log files, and control files and a series of related file problems, in general, as long as we connect the relationship between various files, of course, we must also let the oracle system recognize
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
Recently, my colleagues reported that the database could not perform some data dictionary queries. An error occurs even when you query dba_users. From the error log, all are some error information of the data dictionary, and the user data is OK. Google a moment, looked at metalink, need to re-build the data dictionary. Run catalog. SQL. Dizzy, even if you execute this SQL statement, an error is reported! Data is not backed up. Khan !!! If you cannot successfully execute catalog. SQL, go to the n
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
The previous two days a colleague's database alert log has been brushing out the ora-600 [Ktbdchk1:bad DSCN] Error, which affects the INSERT statement on a table, which has failed recently, and has not found a similar case from a known bug. Environment 11.2.0.4 2nodes RAC, not configured with Data Guard, here is a simple recording of the process of the problem.
# ALERT Log
Tue 26 19:28:53 2016Thread 1 advanced to log sequence 83177 (LGWR switch)Curr
When Oracle 9i Database is logged on, A ORA-01003 ORA-01110 message is prompted, which probably means that the data file storage media is corrupt.
Startup nomount, normal;
Alter database mount, also normal;
Alter database open:
Alter database open*ERROR is located in row 1st:ORA-01113 :?? 1 ??????ORA-01110 :???? 1: 'e: \ ORACLE \ ORADATA \ JSDSB \ system01.dbf'
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
ORA-28002: thepasswordwillexpirewithinstringdays for example ERROR: ORA-28002: thepassw
ORA-28002: the password will expire within string days if ERROR: ORA-28002: the passw
Change the password of a Database User. When a user is not a dba-level user or a common user, you must use the replace clause to change the p
The following error was caused by the abnormal shutdown of the production library simulation test on Qhmes. Solution: Single-organ machine sequence shutdown immediate lsnrctl stop boot sequence lsnrctl start startupRAC environment: Sql> SELECT apply_name,apply_captured,status from dba_apply;Apply_name APP STATUS-------------------------------------------apply_mes_qh YES ENABLED apply_mes_qbj YES abortedSql> select Propagation_name,source_queue_name,queue_to_queue,error_message from Dba_propagat
Oracle error highlights: ORA-00119 ORA-00132
Sometimes, God is joking with you. Yesterday we had a hard time configuring Oracle, so we could use PL/SQL to log on and use it normally. Today we suddenly cannot. And the error is very strange, and no error code is prompted. Enter the user name and password. After clicking "Log on", the PL/SQL statement does not reflect the password.
I am so depressed that I do
[Oracle error highlights]: ORA-00119 ORA-00132, oracleora-00119
Sometimes, God is joking with you. Yesterday we had a hard time configuring Oracle, so we could use PL/SQL to log on and use it normally. Today we suddenly cannot. And the error is very strange, and no error code is prompted. Enter the user name and password. After clicking "Log on", the PL/SQL statement does not reflect the password.
I am s
This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh.
This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh.
This article summarizes the ORA
This article summarizes the ORA-01114, ORA-27067 error solution, there is a need to learn friends can refer to the next Oh.
Today a friend asked the following case, ORA-01114, ORA-27067 and OSD-04026 errors at the same time:
* ** Action name :() 09:31:00. 762* ** Module name :( JDBC Thin Client) 09:31:00. 762* ** Servi
ORA-16014 and ORA-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 thread 1: '/orabak/clog/orcl02.log'
Environment is a personal lab env
Object "h1 ". "trdx_fee_table" failed to load/unload and is being skipped due to error: ORA-31640: Unable to open dump file "/oraapp/Oracle/backup/newdb.20140918.dmp" for readORA-19505: failed to identify file "/oraapp/Oracle/backup/newdb.20140918.dmp" ORA-27037: unable to obtain file statusibm aix risc system/6000 error: 2: no such file or directoryadditional information: 3ora-000093: table Data Object "h
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.