Jun 06

SQLcl not connecting as sysdba

SQLcl is the modern SQL Plus. It was developed my the same team who created the SQL Developer and is java based, with a lot of features that SQL Plus was lacking for years. One problem that I was having after a fresh installation was some error when trying to connect as sysdba: [oracle@myserver ~:orcl]$ …

Continue reading

May 16

EM agent start fails With ‘Target Interaction Manager failed at Startup’ and ‘java.lang.OutOfMemoryError: Java heap space’ reported on logs

In this article, I will show how to solve EM Agent failing to startup related to java memory problems. Those days, after applying some EM Agent patches and trying to restart them, I received the error below: [emc12@localhost ~]$ emctl start agent Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. …

Continue reading

Apr 29

“ORA-15040: diskgroup is incomplete” but diskgroup is mounted

Those days, I was creating a new database on a system and when I tried to create any file (spfile / pwfile / control file) on diskgroup, I started receiving the error below: ORA-15001: diskgroup “DATA” does not exist or is not mounted ORA-15040: diskgroup is incomplete Usually this error comes together with something like …

Continue reading

Apr 16

libasmclntsh12.so missing after OPatch failed in Oracle 12c

Those days, I was trying to apply the latest Oracle Grid Infrastructure PSU over my 12.1.0.2 Clusterware. During the apply phase, the OPatch failed because the gcc was not available for execution. Actually, someone gave chmod 700 to /usr/bin/gcc for protection. /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: /usr/bin/gcc: Permission denied /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: exec: /usr/bin/gcc: cannot execute: Permission denied make[2]: …

Continue reading

Mar 10

ORA-00600: internal error code, arguments: [kpdbSwitchPreRestore: txn] in Oracle Database 12c

On several Oracle DB in 12.1.0.2 version I started receiving some strange ORA-00600 and ORA-07445 errors in the alert file. In ORA-00600, the first parameter was “[kpdbSwitchPreRestore: txn]”: Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFAC8] [PC:0x7A1FA6E, qksanEndSession()+30] [flags: 0x0, count: 1] Errors in file /u02/diag/rdbms/cdbtim01/cdbtim01/trace/cdbtim01_j004_21773.trc (incident=57639): ORA-07445: exception encountered: core dump [qksanEndSession()+30] [SIGSEGV] [ADDR:0xFAC8] [PC:0x7A1FA6E] …

Continue reading