Hello all,
This days I found this in a client’s 12c Database when trying to create a Materialized View:
ORA-00600: internal error code, arguments: [qkswcWithQbcRefdByMain4]
A perfect match to MOS ORA-00600 [qkswcWithQbcRefdByMain4] when Create MV “WITH” clause (Doc ID 2232872.1).
The root cause is documented on BUG 22867413 – ORA-600 CALLING DBMS_ADVISOR.TUNE_MVIEW.
The given solution is to apply Patch 22867413.
After applying patch, issue solved. 🙂
Hello all,
Asking why to use this parameter? Why this is set in your environment? Or even how it can hep you? Here we go:
As per Oracle documentation, this parameter is used to avoid unused sessions to be kept open in database and locking resources.
It describe in minutes how much time a client/probe can be inactive before be ended.
I recently found an environment where this parameter was too low (1 minute), potentially causing some overhead in communication only for validations. By documentation, if it’s decided to enable it, Oracle recommends value “10”.
This way, after checking and no one be aware about this parameter reason to be there, I just suppressed him from SQLNET.ORA (going back to default “0”, which is equivalent to “disabled”), so we could even reduce the network workload.
However, now we are aware that in case we have abnormal closure of clients, we can have some unused connections opened consuming resources… Not a problem at this point… 🙂
Hello all!
Turns that a few days ago a client reached me because his CRSD was simply not starting. Like this:
[root@proddb proddb]$ ./crsctl start res ora.crsd -init CRS-2672: Attempting to start 'ora.crsd' on 'proddb' CRS-2676: Start of 'ora.crsd' on 'proddb' succeeded [root@proddb proddb]$ ps -ef |grep crsd root 19217 13424 0 11:53 pts/0 00:00:00 grep crsd
After some investigation, I found the following:
2017-01-24 14:00:06.859: [ CRSSEC][1690195712]{1:51052:2} Exception: OwnerEntry construction failed to retrieve user id by name with ACL string: owner:jacknobody:rwx and error: 1
2017-01-24 14:00:06.912: [ CRSSEC][1690195712]{1:51052:2} Exception: ACL entry creation failed for: owner:jacknobody:rwx
Hmmm, seems some CRS resources are owned by “Jack Nobody”… Turns that I this us was removed from OS:
[root@proddb proddb]$ cat /etc/passwd |grep jacknobody [root@proddb proddb]$
What to do now?
More“CRS Not Starting after Removing OS User: How to Workaround and How to Solve!”
Hello all,
I had faced some occourrences of this error in a 11.2.0.1 database recently.
ORA-07445: exception encountered: core dump [nstimexp()+45] [SIGSEGV] [ADDR:0x58] [PC:0x7F42ABB] [Address not mapped to object] []
After some investigation I found a match to Bug 3934729.
This issue is originally to matched to Bug 6918493, that is a reintroduction of Bug 2752985 but it’s fixed in 11.2.0.1.
However, on upgrading to 11.2.0.1 it’s a hit on Bug 3934729 which is fixed in 11.2.0.2.
Recommended actions are:
– Upgrade databases do 11.2.0.2 or higher. (best solution, but may require more efforts to validate the upgrade).
– Apply Patch 3934729: RANDOM ORA-07445 CORE DUMPS FROM DATABASE AND ORA-3113 FROM APPLICATION
– Set sqlnet.expire_time=0 (workaround)
– Ignore error.
After some research I decided to apply workaround, based on recommended usage of sqlnet.expire_time (Next weeks post is about this parameter :)).
This might be the root cause for the ORA-03135: connection lost contact and the actual value of this parameter on environment was 1, which is a very low value.
So, check which action is more suitable for your environment!
Hope it helps 🙂
Below some additional informations on my situation:
Hello all!
Having this error? Probably something like this:
ORA-00600: internal error code, arguments: [17147], [0x7F0315C53788], [], [], [], [], [], [], [], [], [], []
This is a known error. The best match on MOS is GoldenGate 12c IntRep Crash W/ ORA-600 [kghfrmrg:nxt] ;ORA-600[kghfrh:ds]; ORA 600 [17114]; [17147] (Doc ID 1666909.1)
These days, when trying to add dbms_scheduler notifications for different user I was getting this strange error:
BEGIN DBMS_SCHEDULER.add_job_email_notification ( job_name => 'APPOWNER.MYJOB', recipients => 'me@company.com', events => 'job_started, job_succeeded' ); END; / ORA-24093: AQ agent SCHED$_XXX not granted privileges of database user APPUSER ORA-06512: at "SYS.DBMS_ISCHED", line 8296 ORA-06512: at "SYS.DBMS_SCHEDULER", line 4353 ORA-06512: at line 3
The issue is that “secure queue access must be granted to an Oracle Database Advanced Queuing (AQ) agent explicitly for both enqueue and dequeue operations. You grant the agent these privileges using the ENABLE_DB_ACCESS procedure in the DBMS_AQADM package” (http://docs.oracle.com/database/121/STRMS/strms_trprop.htm#STRMS1046)
So, problem solved with this:
BEGIN
DBMS_AQADM.ENABLE_DB_ACCESS(
agent_name => 'SCHED$_XXX',
db_username => 'APPUSER');
END;
/
See you next week!
Hello all,
Had this ORA-600?
ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []
Investigating on issue:
More“ORA-00600: internal error code, arguments: [ktsapsblk-1]”
E aí Galera!
Já estão preparados para o GUOB Tech Day 2017 que vai acontecer no próximo dia 05 de Agosto?!
Presenças confirmadas: Arup Nanda, Mike Dietrich, Craig Shallahamer, Alex Gorbachev, Alex Zaballa, entre outros Oracle Rockstars. Chega lá e confere!
Serão 5 salas simultâneas, mais um Auditório. Este também será o GUOB com a maior quantidade de palestras feitas por brasileiros. Entre eles eu. 🙂
Minha palestra será na Sala 3, as 16:30. Anota aí. Vou falar sobre o Oracle Database Backup Service.
Ah! Se INSCREVE logo pois está mais barato até o final de Junho!
Abraço e até lá!
Hey everyone!
Are you ready for the GUOB Tech Day 2017 (OTN LA Tour) on next August 5th?!
Already Confirmed: Arup Nanda, Mike Dietrich, Craig Shallahamer, Alex Gorbachev, Alex Zaballa, and other Oracle Rockstars!
There will be 5 simultaneous rooms plus an Auditorium. This will be the GUOB with the largest amount of lectures made by Brazilians. And I’m among them. 🙂
My lecture will be in Room 3, at 4:30 p.m. (BRT) . I’ll be talking about Oracle Database Backup Service.
Ah! REGISTER soon! It’s cheaper until the end of June!
Check also:
Cheers and see you there!
Hi all,
Tricky question, right? It’s easier than you think…
Actually, we don’t commonly think on those situations in first place, but it’s pretty common, specialy if considering server consolidation situations.
The trick is to use clause util enableOnlinePatch insted of apply after first database applying.
In this example I’m applying on-off patch 14084247 in online mode. Check:
# First Database:
[oracle@PRODSERVER 14084247]$ opatch apply online -connectString ORA11:sys:: Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /opt/oracle/app/product/11.2.0/db_1 Central Inventory : /opt/oracle/oraInventory from : /opt/oracle/app/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /opt/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatch/14084247_Apr_03_2017_14_17_24/apply2017-04-03_14-17-24PM_1.log The patch should be applied/rolled back in '-all_nodes' mode only. Converting the RAC mode to '-all_nodes' mode. Applying interim patch '14084247' to OH '/opt/oracle/app/product/11.2.0/db_1' Verifying environment and performing prerequisite checks... All checks passed. Backing up files... Patching component oracle.rdbms, 11.2.0.4.0... Installing and enabling the online patch 'bug14084247.pch', on database 'ORA11'. Verifying the update... Patch 14084247 successfully applied Log file location: /opt/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatch/14084247_Apr_03_2017_14_17_24/apply2017-04-03_14-17-24PM_1.log OPatch succeeded.
All good, right?
Let’s see applying to second database with same command:
Second Database:
[oracle@PRODSERVER 14084247]$ opatch apply online -connectString OTHERORA11:sys::
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/app/product/11.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/app/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /opt/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatch/14084247_Apr_03_2017_14_17_45/apply2017-04-03_14-17-45PM_1.log
The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
Applying interim patch '14084247' to OH '/opt/oracle/app/product/11.2.0/db_1'
Verifying environment and performing prerequisite checks...
Log file location: /opt/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatch/14084247_Apr_03_2017_14_17_45/apply2017-04-03_14-17-45PM_1.log
Recommended actions: Please use 'opatch util applySql' for sql related patches or 'opatch util enableOnlinePatch' for online patches to add sids to already installed patch(es).
OPatch failed with error code 26
Beeep!
So, simply use clause util enableonlinepatch as per below.
Second Database (right way):
[oracle@PRODSERVER 14084247]$ opatch util enableonlinepatch -connectString OTHERORA11:sys:: -id 14084247
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/app/product/11.2.0/db_1
Central Inventory : /opt/oracle/oraInventory
from : /opt/oracle/app/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /opt/oracle/app/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-04-03_14-20-53PM_1.log
Invoking utility "enableonlinepatch"
Installing and enabling the online patch 'bug14084247.pch', on database 'OTHERORA11'.
OPatch succeeded.
[oracle@PRODSERVER 14084247]$
Ok, that’s it for today.
See you next week!
E aí Galera!
Este é um post atrasadíssimo, mas importantíssimo!
Agradeço a organização do DBA Brasil e aos colegas e amigos que comparecem no útimo DBA Brasil 2.0!
Foi uma honra participar do evento com uma sessão sobre o Oracle Cloud Backup Service.
A informar que os slides de todas as palestras estão disponíveis aqui: http://www.dbabr.com.br/dbabrasil2/material-das-palestras/
Forte abraço a até o próximo ano!
Hey everyone!
This is a very late but very important post!
I’d like to thank the DBA Brasil Committee, colleges and friends that were in last DBA Brasil 2.0!
It was an honor for me to participate on such event as speaker on Oracle Cloud Backup Service.
Please check for complete slides here: http://www.dbabr.com.br/dbabrasil2/material-das-palestras/
Cheers and see you next year!