ora 03114 not connected to oracle solution

ERROR prompt: ERROR: ORA-12514: TNS: Listener solution: Code as follows 1. Open the networkadminlistener. ora file, find: SID_LIST_LISTENER (SID_LIST (SID_DESC (SID_NAMEPLSExtProc) (ORACLE _ ERROR message: ERROR: ORA-12514: TNS: listener cocould not resolve SERVICE_NAME give

The Oracle adapter is not connected to the solution Author: Vashon Oracle's developer connection is not reported incorrectly: listener does not currently know of SID given in Connect descriptor solution: In D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN find the Listener.ora file, the modified file in the

Today's newly installed Oracle 12.2.0.1 database, via local sqlplus telnet 12c database error ora-28040, as follows:Ora-28040:no Matching authentication protocolSolution (pro-test feasible):Into the $oracle_home/network/admin, Edit the Sqlnet.ora file (if it does not exist, create one, or go to the Samples directory to copy one), add the following line at the end, do not need to restart the database and lis

Hibernate when you manipulate the database,When adding operations times Oracle Operation ORA-02289: sequence does not existHibernate description FileWhen inserting operations on the Apply tableWill go to the database to query your sequence of the next nextval do the primary key value to insert.Workaround no sequence is created first--Create sequence Create sequence Seq_idminvalue 2000maxvalue 9999999999star

Oracle through DBLink access to the remote database LOB field reporting ORA-22992 solution recently in a photo collection function, photo collection is outside the network library, while the Internet after the photo collection, the Intranet will read the photos in the Internet library (the photo field is BLOB type), if the Intranet directly through the select sta

Not long ago, a friend from encountered a problem, in the database startup process appear ora-7445, and then database CRASH, environment 11.1.0.7 windows version, temporarily disabled the smon tx recovery open database, no more tracking. Record it here.# DB ALERTAlter database openBeginning crash recovery of 1 threadsParallel recovery started with 15 processesStarted redo scanCompleted redo scan503 redo blocks read, 54 data blocks need recoveryStarted

Fault symptom Oracle Database 11g Database common user login prompt ORA-28002: the password will expire within 7 days[11: 01: 00oracle @ dvd db_1] $ sqlplus wang/oracleSQL * Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012Copyright (c) 1982,200 9, Oracle. All rights reserved.ERROR:ORA-28002: the password will expire within 7 daysConnected:Oracle Da

Database Oracle10202, memory 4G, adjust the database sga_target, initially sga_target is 160 M, ready to adjust it to 2147483648, the results of the error ORA-27102, after multiple experiments, it is found that the database is started when sga_target is equal to MB.1. Generate pfile and modify pfile[Oracle @ CCN-BJ-4-573 dbs] $ vi initorcl. oraOrcl. _ db_cache_size = 50331648Orcl. _ Java _pool_size = 419430

$wherelocal_tran_id='''||r.local_tran_id||''';'); dbms_output.put_line('deletefrompending_sub_sessions$wherelocal_tran_id='''||r.local_tran_id||''';'); endloop; dbms_output.put_line('commit;'); end; 4. execution failed. In another case, you can try to restart the Oracle service. In this case, I encountered a problem. After the restart, the lock is automatically removed because I am worried about deleting the data dictionary, therefore,

started. Total System Global area 171966464 bytes Fixed size 787988 bytes Variable Size 145488364 b Ytes database buffers 25165824 bytes Redo buffers 524288 Database bytes.ALTER Database Open Statesql> ALTER DATABASE open; ALTER DATABASE open * ERROR at line 1:ora-01147:system tablespace file 1 is offline Ora-01110:data file 1: ' d:/oracle/p Roduct/10.1.0/oradat

A ORA-01000 error occurred when a colleague was importing data in batches from excel the day before. This is a similar phenomenon that occurs on Google. It is Java.CodeWhen accessing Oracle, we use C # for the same reason. The Java scenario is as follows (pseudocode description ): 1. Create a connection and a transaction 2. Create statement cyclically, attach SQL statements, and execute statement.

Customer Database Exception (ORA-600 kcbz_check_objd_typ_1), let us remotely to analysis processingORA-600 Kcbz_check_objd_typ_1 exceptionMon Aug 8 12:19:28 2016Completed:alter DATABASE OPENMon Aug 8 12:19:29 2016Db_recovery_file_dest_size of 20480 MB is 0.00% used. This is aUser-specified limit on the amount of spaces that'll be used by thisDatabase for recovery-related files, and does not reflect the amount ofSpaces available in the underlying files

When using PLSQL developer, the ORA-12154:TNS: Unable to parse the specified connection identifier "a solution to the problem plsqldeveloper version 7.1 today suddenly needs to change a project a long time ago, that project uses Oracle9iStart PLSQL developer, prompt to enter the user name and password and database, enter, press enter, prompt: ORA-12154:TNS: the s

Oracle error -- ORA-03113: file end solution for communication channel Origin Today as usual, login PL/SQL, indeed login failed, there is an error "ORA-01034" and "ORA-27101" Then I log on to Oracle through the command prompt, to

A customer said a set of databases due to abnormal shutdown after the data export found error, EXPDP can not work correctly, after the error directly exit: Working with Object Types Schema_export/job. . The "STATS" was exported. T_report_month_temps "988.2 MB 1292221 LinesORA-39014: One or more worker processes have exited prematurely.Ora-39029:worker Process 1 (Process name "DW01") prematurely terminatedOra-31672:worker process DW01 stopped unexpectedly.Job "SYS". Sys_export_schema_04 "stopped

Some errors such as "ora-03113 communication channel ended" were reported in exp to guide a user's data, and a lot of information was not solved on the Internet After careful observation, it is found that the error is returned every time the large table is reached. Because the table is a log table that can be deleted, try truncate it, The prompt "ORA-00054 resources are busy, asked to specify Nowait, di

Solution for ORA-01417 under Oracle 11g, 11gora-01417 Today there is a brother feedback, there is a SQL on 12C no problem, on 11G on the error, the error content is ORA-01417: The table can be externally connected to at most one other table. This section analyzes the SQL sta

Database versionOracle-> 11g @xifenfei:/home/oracle$sqlplus/as sysdbaSql*plus:release 11.2.0.4.0 Production on Tue Sep 30 10:28:30 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit ProductionWith the partitioning, real application clusters, OLAP, Data Miningand real Application testing optionsSql> select * from V$version;BA

An error occurred after Oracle 10201 was upgraded to 10204. SQL> startup ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forced Alert Errors in file/oracle/admin/mydb2/udump/mydb2_ora_5811.trc:ORA-00704: bootstrap process failure.ORA-39700: database must be opened with UPGRADE optionMon Mar 2 0

Oracle startup error ORA-00845: MEMORY_TARGETnotsupportedonthissystem Solution Oracle start error ORA-00845: MEMORY_TARGET not supported on this system Possible cause: the ORACLE MEMORY_TARGET parameter exceeds the memory of the