| SQL Developer Loosing Connect [message #671938] |
Tue, 25 September 2018 04:54  |
Gogetter
Messages: 39
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  |
Gogetter
Messages: 39
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
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
