ora 00942

ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (document ID 1930964.1)From:ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (document ID 1930964.1)Suitable for:Oracle goldengate-version 11.1.1.0.0 and laterOracle database-enterprise edition-version 10.2.0.1 and laterInformation in this document applies to any platform.Symptoms:Below er

When I first arrived at the company today, a network friend sent an IP address and password to ask me to help you start the database. After going in, I found that the database was installed in a mess. When I started the database, I reported a 00201 error, I haven't touched on these installation things for a long time. I'm a little new. I 've been busy with some routine work, and I just got down and tested, so I started the database soon. [Oracle @ rdas3 log] $ sqlplus "/As sysdba" SQL * Plus: R

ORA-19706: invalid SCN, ora-19706scn Today's site dblink reported ORA-19706: invalid SCN, database versions are 11.2.0.4. After checking metalink, the two databases will synchronize the scn number when accessing through dblink. The result of SCN Headroom must be greater than the value of _ external_scn_rejection_threshold_hours. Dblink is used for interface probl

The database version installed on my local machine is Oracle 11G R2. When I connect to the database today, the following error is reported: Oracle not available ORA-01034 ORA-27101-shared memory realm does not exist I found several solutions online, saying yes.Oracle homeAndSidOr useNet Configuration AssistantRebuild the local network service name. After practice, it does not work. After summary, it is bet

More depressing than ORA-24777: do not allow the use of unportable database links, ora-24777 linksAn error is reported when the synchronization function is on site. The content is as follows: java. SQL. BatchUpdateException:ORA-24777: do not allow use of portable database linksAt oracle.jdbc.driver.OraclePreparedStatement.exe cuteBatch (OraclePreparedStatement. java: 10317) at least cuteBatch (OracleStateme

The operating system is Linux as5 and the database is 10 Gb. After the machine is restarted, @ connecct_string cannot be used to connect to the database. You can only use the user/password. Summary later: this problem occurs when two databases are created again after the existing data is deleted. If you have done similar operations, it is basically the same problem.The error is as follows: SQL> conn system/test @ orcl ERROR: A ORA-01034: Oracle not av

When you start ASM after manually writing the ASM parameter file, the following error occurs: ORA-29701: unable to connect to Cluster Manager Through the explanation of the online document, I learned the reason why the CSS service was not added, run the/u01/app/Oracle/product/10.2/db_1/bin/localconfig add command under the root user to add the CSS service! The problem solved, but the ORA-15110: nodiskgroups

, 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

down archive ProcessesArchiving is disabledArchive process shutdown avoided: 0 activeArch: archiving is disabledShutting down archive ProcessesArchiving is disabledArchive process shutdown avoided: 0 activeFri Oct 24 13:43:17 2008Starting Oracle instance (normal)License_max_session = 0License_sessions_warning = 0SCN scheme 2Using log_archive_dest parameter Default ValueLicense_max_users = 0Sys auditing is disabled From the code above, it is found that the red part of the formal error source, th

One: Problem description When you run the Build library script, an error occurs: CREATE DATABASE ORCL * ERROR at line 1: Ora-01501:create DATABASE failed Ora-01078:failure in processing system parameters Ora-16032:parameter log_archive_dest_1 Destination string cannot be translated Ora-01264:unable to create ar

ArcSDE10.2.2 using SQL Operations St_geometry times ORA-28579 or ORA-20006 errors1. Test Environment DescriptionARCSDE version: 10.2.2Oracle version: 12.1.0.1 and 11.2.0.1Windows version: Windows Server R2Test data: China 400W interface Data2. SQL Operation St_geometry TestThe test statement is very simple, just a simple query of the geometric coordinate point information in the layer, execute the SQL state

Label:The following error was encountered today when starting Oracle on the server: Sql> startup; ORA-00119:INVALID specification for system parameter Local_listenerOra-00132:syntax error or unresolved network name ' LISTENER_ORCL ' Then, I found some information on the internet to solve this problem. The solution is as follows (this is a talent solution on the Internet, I follow his steps to solve the problem, but decided to make a note): First st

There is a user's table to be imported into our system, the original table TM_WWM date is varchar (8) Type, the format is YYYYMMDD. Before importing to my system, we need to see if the date is legal SQL1 Select To_date (saledate, ' YYYYMMDD ') from TM_WWM b * ERROR at line 1:ora-01847:day of month must Being between 1 and last day of month from the tip you can see that character type dates have illegal characters, such as 00 days, or February 30.

The error prompts are as follows ORA-27101Shared memory realm does not exist Cause:unable to locate shared memory realm Action:verify that the realm is accessible ORA-27102Out of memory Cause:out of Memory Action:consult the trace file for details Today on the CENTOS6 found that Oracle Shutdownstartup are not up, before all good, reported the following error: The code is as follows

oracle11g after installation, cannot log on locally!Prerequisite: The service all opens, the monitoring also configures well! Win7 64-bit Oracle 11g Simple SQL command: log in to Sqlplus first: Sqlplus/nolog; Login database:connsystem/managerassysdba; then start the database:startup; Found ora-00119 "ora-00119 Invalid specification for system parameter" ora