ora 03114

313 ' was flood controlled (0x1) (no incident)ORA-00313: Unable to open member of Log Group 1 (for thread)ORA-00312: Online log 1 thread 1: ' C:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01. LOG 'ORA-00313: Unable to open member of Log Group 1 (for thread)ORA-00312: Online log 1 thread 1: ' C:\APP\ADMINISTRATOR\ORADATA\ORCL\

Oracledata database objects are ineffective, through the plsqldev.exe program for package compilation; Reporting ORA-03114: connection data Database Failure error .plsqldev.exe program and Oracle Database CDC power Oracledata database objects are ineffective, through the plsqldev.exe program for package compilation; Reporting ORA-

Problem description: The following error is reported when you log on to the database today because the notebook is often disabled and directly covered: 1. Using PLSQL login, error: ora-12514 error, TNS could not recognize service name 2. Log on to the Apsara stack console with the following error: Enter the User name: SYSEnter the password:Error:A ORA-01034: Oracle not availableORA-27101: Shared Memory rea

Oracle remove tablespace data file ora-00604 ora-01426, ora-00604ora-01426Zookeeper Project Background: Database Management in the previous development environment is messy. When the tablespace is insufficient, only data files are added. After the test, the data has been deleted, but the space occupied by the tablespace in the database cannot be recycled, as a re

greater than the undersized retention parameter following the steps from note:563470 .1Sql> ALTER TABLE Applsys. Fnd_lobs Modify LOB (File_data) (pctversion 5);Table altered.Sql> ALTER TABLE Applsys. Fnd_lobs Modify LOB (File_data) (retention);Table altered.3. Query the LOB retention again to verify, the change have taken hold:Sql> Select Column_name,securefile,pctversion,retention from Dba_lobs where Owner=upper (' owner ') and TABLE_ Name=upper (' table_name ');column_name SEC pctversion RETE

= ' AUTO 'standbyfilemanagement = ' AUTO 'Archivelagtarget = ' 0 'logarchivemaxprocesses = ' 4 'Logarchiveminsucceeddest = ' 1 'Dbfilenameconvert = ' 'Logfilenameconvert = ' 'Faststartfailovertarget = ' 'Inconsistentproperties = ' (monitor) 'Inconsistentlogxptprops = ' (monitor) 'Sendqentries = ' (monitor) 'Logxptstatus = ' (monitor) 'Recvqentries = ' (monitor) 'Applylagthreshold = ' 0 'Transportlagthreshold = ' 0 'Transportdisconnectedthreshold = ' 30 'Sidname = ' Queuedb 'Staticconnectidentif

ORACLE database space bare device is out of the problem, startOracle failure, workaroundProblem phenomenon:StartOracle reported the following error:Database mounted.Ora-01122:database File 6 failed verification checkOra-01110:data file 6: '/dev/raw/rlv_cbs_user_dat 'Ora-01203:wrong incarnation of this file-wrong creation SCNProblem solving:There is a problem with this database space, you need to delete the database space and then add it againThe corre

Example of ORA-19527 and ORA-00312 error resolution in 10gDG In the past few days, we have set up a 10g DG Windows 2008 R2 testing environment, mainly to re-build a production database DG for a customer tomorrow. Some problems have been found, so I would like to record it. Because it is to be deployed to the production environment, we need to consider the online build of DG solution, that is, when the datab

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

the production database wants to build the DG without stopping the database, it is necessary to use the original db_unique_name, which is usually the same name as db_name. After modifying the spfile, use it to create a pfile for the standby database. Create pfile from spfile; 3. Create standby redo logfile in the master database, and alter database add standby logfile group # datafile ('xxxx') size 50 M. xxxx specifies the path and file name. 4. Create listener.

Environment: AIX 11.2.0.3 RACSymptom: Node 1 operating system cannot connect, Node 2 shows RAC service status OK, 15 minutes after connection recoveryDB logOra-27300:os system dependent Operation:fork failed with Status:12Ora-27301:os Failure Message:not enough spaceOra-27302:failure occurred at:skgpspawn3OS Log650) this.width=650; "src=" http://s2.51cto.com/wyfs02/M00/80/F2/wKioL1dFV2CBdfHEAAHpVYWcRog031.jpg "title=" Img_ 20160522_233726.jpg "alt=" Wkiol1dfv2cbdfheaahpvywcrog031.jpg "/>Check fo

Although deleteinput is configured in the script to delete the archive after the archive is backed up, to reduce the disk space occupied by the archive, you can see in the backup log of the RMAN script, from January 1, August 3 Although the archive is deleted using delete input after the archive is backed up in the script to reduce the disk space occupied by the archive, you can see in the backup log of the RMAN script, from January 1, August 3 So I decided to re-build the DG, shut down the

Perform replica uard. After the standby database RMAN is synchronized, alterdatabaseopenreadonly cannot start. There is no error in the rman process. When the standby database is started, there is a heap of E in alter. log. Perform replica uard. After the standby database RMAN is synchronized, the alter database open read only command cannot start. There is no error in the rman process. When the standby database is started, there is a heap of E in alter. log. SQL> alter database open read o