Home » SQL & PL/SQL » Client Tools » SQL Developer Loosing Connect (SQL Developer 18.2 Orace 18c)
SQL Developer Loosing Connect [message #671938] Tue, 25 September 2018 04:54 Go to next message
Gogetter
Messages: 37
Registered: December 2009
Location: Cologne Germany
Member
Hello

we upgrated to Oracle 18c and moved from cloud server Amsterdam to Frankfurt.
Now i have trouble to get a connect via sqldeveloper to the pdbs.
The connection seemed to be done, but when trying to do any select i got an error that connection was reset and all transactopn are reset.

When connecting to the cdb everything is fine. And I can do any Select.
Older SQL developer versions - my collegue uses 4.x - working fine. He has no problem.

Did anyone have had the same trouble and a solution?


Thanks and regards
Rudi








Re: SQL Developer Loosing Connect [message #671947 is a reply to message #671938] Tue, 25 September 2018 08:27 Go to previous messageGo to next message
Gogetter
Messages: 37
Registered: December 2009
Location: Cologne Germany
Member
Additional:

When Connecting the following alert is generated

<msg time='2018-09-25T13:13:57.510+00:00' org_id='oracle' comp_id='rdbms'
 msg_id='813904310' type='INCIDENT_ERROR' group='Generic Internal Error'
 level='1' host_id='db-200' host_addr=''yyy.yy.yy.yy'
 pid='80646' prob_key='ORA 600 [kqlnrc_1]' downstream_comp='diag_dde'
 errid='32157' detail_path='/u01/app/oracle/diag/rdbms/db200_fra14j/db200/trace/db200_ora_80646.trc' con_uid='nnnnnnnnnnn'
 con_id='6' con_name='PDB5200'>
 <txt>Errors in file /u01/app/oracle/diag/rdbms/db200_fra14j/db200/trace/db200_ora_80646.trc  (incident=32157) (PDBNAME=PDB5200):
ORA-00600: Interner Fehlercode, Argumente: [kqlnrc_1], [0x06E51E870], [], [], [], [], [], [], [], [], [], []
 </txt>
 <arg name='PDBNAME' value='PDB5200'/>
</msg>
<msg time='2018-09-25T13:13:57.514+00:00' org_id='oracle' comp_id='rdbms'
 type='UNKNOWN' level='16' host_id='db-200'
 host_addr='yyy.yy.yy.yy' module='SQL Developer' pid='80646'
 con_uid='nnnnnnnnnnn' con_id='6' con_name='PDB5200'>
 <txt>Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
 </txt>
</msg>



The Trace File:



*** 2018-09-25T13:10:16.723330+00:00
*** SESSION ID:(349.29790) 2018-09-25T13:10:16.723367+00:00
*** CLIENT ID:() 2018-09-25T13:10:16.723374+00:00
*** SERVICE NAME:(pdb5300) 2018-09-25T13:10:16.723381+00:00
*** MODULE NAME:(SQL Developer) 2018-09-25T13:10:16.723388+00:00
*** ACTION NAME:() 2018-09-25T13:10:16.723393+00:00
*** CLIENT DRIVER:(jdbcthin : 12.2.0.1.0) 2018-09-25T13:10:16.723399+00:00
*** CONTAINER ID:(4) 2018-09-25T13:10:16.723405+00:00

DDE: Problem Key 'ORA 600 [kqlnrc_1]' was flood controlled (0x6) (incident: 29726)
ORA-00600: Interner Fehlercode, Argumente: [kqlnrc_1], [0x06E275E10], [], [], [], [], [], [], [], [], [], []

LibraryHandle:  Address=0x6e275e10 Hash=e3546b98 LockMode=S PinMode=S LoadLockMode=0 Status=INVL
  ObjectName:  Name=PDB5300.PUBLIC.USER_ORDS_REPOVERSIONS
    FullHashValue=be301ff40d734dfeb13ff9aae3546b98 Namespace=TABLE/PROCEDURE(01) Type=SYNONYM(05) ContainerId=4 ContainerUid=xxxxxxxxxxIdentifier=96389 OwnerIdn=1
  Statistics:  InvalidationCount=1 ExecutionCount=0 LoadCount=1 ActiveLocks=1 TotalLockCount=26 TotalPinCount=26
  Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=25 HandleInUse=25 HandleReferenceCount=0
  Concurrency:  DependencyMutex=0x6e275ec0(0, 19, 0, 0) Mutex=0x6e275f60(349, 1109, 0, 6)
  Flags=PIN/TIM/[00002801] Flags2=[0000]
  WaitersLists:
    Lock=0x6e275ea0[0x6e275ea0,0x6e275ea0]
    Pin=0x6e275e80[0x6e275e80,0x6e275e80]
    LoadLock=0x6e275ef8[0x6e275ef8,0x6e275ef8]
  Timestamp:  Current=11-17-2017 11:29:46
  HandleReference:  Address=0x6e275ff8 Handle=0xb9d50810 Flags=OWN[200]
  LibraryObject:  Address=0x6e274890 HeapMask=0000-0001-0001-0000 Flags=EXS/LOC[0004] Flags2=/MDL/DGL/CSC/OSO[44010100] Flags3=[0000] PublicFlags=[0000]
    DataBlocks:
      Block:  #='0' name=KGLH0^e3546b98 pins=0 Change=NONE
        Heap=0x6e275820 Pointer=0x6e274960 Extent=0x6e2747e8 Flags=I/-/P/A/-/-/-
        FreedLocation=0 Alloc=0.570312 Size=4.000000 LoadTime=8498631

Re: SQL Developer Loosing Connect [message #671948 is a reply to message #671947] Tue, 25 September 2018 08:30 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Re: SQL Developer Loosing Connect [message #671955 is a reply to message #671948] Tue, 25 September 2018 19:20 Go to previous messageGo to next message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

THIS!
Re: SQL Developer Loosing Connect [message #671956 is a reply to message #671955] Tue, 25 September 2018 23:04 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
thatjeffsmith wrote on Tue, 25 September 2018 17:20
THIS!

REALLY?
Re: SQL Developer Loosing Connect [message #671957 is a reply to message #671956] Wed, 26 September 2018 00:19 Go to previous message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

Yes, if you get a ora 600, you need to contact support.
Previous Topic: Generate DDL using Sql Developer
Next Topic: user had different system date extracted compared with oracle
Goto Forum:
  


Current Time: Fri Dec 13 21:01:02 CST 2019