ora 02063

Tags: ora-01031 ora-12162 sp2-0667 sp2-0750 ora-01034Chen Kozhan-Welcome reprint, Reproduced Please indicate, thank you!=====================Newly installed oracle11g R2 data, this want to use Sql*plus test test, did not expect to appear the above picture problem:Cause: There is no configuration environment variable (oracle_home=oracle install the home directory,

Tags: inux alter ble ARC job x86 error instance proc Environment Description: Source database environment:Operating system: Windows SERVER 2008R2 Database version: single Instance ORACLE 11.2.0.1target-side database environment:Operating system: Redhat Linux 6.5 x86 64bit database version: ORACLE 11g RAC 11.2.0.4Fault Description:Export the data from the source database EXPDP and then impdp the import to the target database: ora-02374:conversion Error

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

ORA-29538, ORA-29532, ORA-29913 Problem Solving ORA-29538, ORA-29532, ORA-29913 Problem Solving Question 1:ERROR at line 1: ORA-29538: Java not installedSolution1. Check whether JA

Impdp experience ORA-39001, ORA-39000, ORA-39142 Expdp/impdp because the source data version is higher than the target database version, encounter ORA-39001, ORA-39000, ORA-39142, solve only need to expdp export with the target da

"Failure Phenomenon"February 8, 2015, oracle10.2.0.4 Single instance database, suddenly crash, but into the reboot run recovery. Check Alert.log log found the following "ORA-00600, ORA-27091, ORA-27072" error message.Errors in FILE/HOME/DB/ORACLE/ADMIN/DB1/BDUMP/DB1_MMON_22544442.TRC:Ora-00600:internal error code, arguments: [kmgs_parameter_update_timeout_1], [27

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

Tags: style code tar ext color CNative IP Address: 192.168.1.163[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.2.0-production on Sun 4 19:32:13 2014Copyright (c) 1982, 2005, Oracle. All rights Reserved.@>conn sys/oracleerror:ora-01034:oracle not availableora-27101:shared memory realms does not existlinux Error:2: No s Uch file or directoryORA-01034 and ORA-27101 are generated because the database does not start and requires a SYSDBA to ent

ORA-39126 ORA-00904 ORA-06512 Solution Process Expdp test/123456 dumpfile = B. dmp directory = DUMP_DLSPThe following error occurs when using data mercury. According to the parameters I used, no advanced parameters are used, which are the most common parameters. Check the MOS. No error message similar to me is found. No valuable error information was found throug

The error is as follows:Search a lot of methods, but there is no way to solve, but eventually found a good solution,Thanks to the man's blog, "http://blog.itpub.net/519536/viewspace-689469."The content is purely reproduced, suggest to the original blog to see the detailsProcessing methodsNow that you know what caused the user to fail to delete, the table sdo_geom_metadata_table was not found. The way to deal with it is to find it.We can consider using the Catmd.sql script to re-initialize the ta

1. The following error occurred: Ora-12541:tns:no Listener, as shown in:The reason for the error is that we do not have the Listener listener service open and the workaround is to open the service in the service as shown in.2. The following error occurred: Ora-12514:tns: The listener is not currently aware of the service requested in the link descriptor. As shown in the following:The workaround is to open t

When a database server executes shutdown immediate, it encounters the following Ora error, as follows: $ sqlplus/as SYSDBA Sql*plus:release 10.2.0.4.0-production on Fri 5 10:56:24 2016 Copyright (c) 1982, Oracle. All rights Reserved. Connected to: Oracle Database 10g Release 10.2.0.4.0-64bit Production sql> shutdown immediate; End-of-file on communication channel Sql> exit Check the alarm log and find that it has been stuck in "Job q