sqlplus free(): invalid pointer hatası

Leave a Comment / Hatalar, Oracle / By /

Merhaba,
Sqlplus’a bağlandıktan sonra çıkış yaparken aşağıdaki gibi bir hata alıyorduk.

[oracle@dbhost ~]$ sqlplus sys/password as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 24 13:08:59 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
*** Error in `sqlplus': free(): invalid pointer: 0x000000000118b6b8 ***
======= Backtrace: =========
/lib64/libc.so.6(+0x81489)[0x7f607ffc7489]
/oracle/12.2.0/db_1/lib/libdspl.so(+0xc3b70)[0x7f60864ceb70]
/lib64/ld-linux-x86-64.so.2(+0xffca)[0x7f6086806fca]
/lib64/libc.so.6(+0x39b69)[0x7f607ff7fb69]
/lib64/libc.so.6(+0x39bb7)[0x7f607ff7fbb7]
/oracle/12.2.0/db_1/lib/libsqlplus.so(+0xadc18)[0x7f60861c6c18]
/oracle/12.2.0/db_1/lib/libsqlplus.so(+0x3e088)[0x7f6086157088]
/oracle/12.2.0/db_1/lib/libsqlplus.so(+0x6bf1e)[0x7f6086184f1e]
/oracle/12.2.0/db_1/lib/libsqlplus.so(+0x40a32)[0x7f6086159a32]
/oracle/12.2.0/db_1/lib/libsqlplus.so(+0x3f46d)[0x7f608615846d]
/oracle/12.2.0/db_1/lib/libsqlplus.so(+0x3de67)[0x7f6086156e67]
/oracle/12.2.0/db_1/lib/libsqlplus.so(afidrv+0x173e)[0x7f6086183ebe]
sqlplus[0x400cc9]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f607ff683d5]
sqlplus[0x400b89]
======= Memory map: ========
00400000-00403000 r-xp 00000000 fd:50 218473473                          /oracle/12.2.0/db_1/bin/sqlplus
00603000-00604000 r--p 00003000 fd:50 218473473                          /oracle/12.2.0/db_1/bin/sqlplus
00604000-00605000 rw-p 00004000 fd:50 218473473                          /oracle/12.2.0/db_1/bin/sqlplus
01064000-011c8000 rw-p 00000000 00:00 0                                  [heap]
7f6078000000-7f6078022000 rw-p 00000000 00:00 0
7f6078022000-7f607c000000 ---p 00000000 00:00 0
7f607ee3f000-7f607ee4b000 r-xp 00000000 fd:50 120287792                  /oracle/12.2.0/db_1/lib/libnque12.so
7f607ee4b000-7f607f04b000 ---p 0000c000 fd:50 120287792                  /oracle/12.2.0/db_1/lib/libnque12.so
7f607f04b000-7f607f04c000 rw-p 0000c000 fd:50 120287792                  /oracle/12.2.0/db_1/lib/libnque12.so
7f607f04c000-7f607f056000 r-xp 00000000 fd:00 50350611                   /usr/lib64/libnuma.so.1
7f607f056000-7f607f256000 ---p 0000a000 fd:00 50350611                   /usr/lib64/libnuma.so.1
7f607f256000-7f607f257000 r--p 0000a000 fd:00 50350611                   /usr/lib64/libnuma.so.1
7f607f257000-7f607f258000 rw-p 0000b000 fd:00 50350611                   /usr/lib64/libnuma.so.1
7f607f258000-7f607f264000 r-xp 00000000 fd:00 50342438                   /usr/lib64/libnss_files-2.17.so
7f607f264000-7f607f463000 ---p 0000c000 fd:00 50342438                   /usr/lib64/libnss_files-2.17.so
7f607f463000-7f607f464000 r--p 0000b000 fd:00 50342438                   /usr/lib64/libnss_files-2.17.so
7f607f464000-7f607f465000 rw-p 0000c000 fd:00 50342438                   /usr/lib64/libnss_files-2.17.so
7f607f465000-7f607f46b000 rw-p 00000000 00:00 0
7f607f46b000-7f607f480000 r-xp 00000000 fd:00 50350105                   /usr/lib64/libz.so.1.2.7
7f607f480000-7f607f67f000 ---p 00015000 fd:00 50350105                   /usr/lib64/libz.so.1.2.7
7f607f67f000-7f607f680000 r--p 00014000 fd:00 50350105                   /usr/lib64/libz.so.1.2.7
7f607f680000-7f607f681000 rw-p 00015000 fd:00 50350105                   /usr/lib64/libz.so.1.2.7
7f607f681000-7f607f696000 r-xp 00000000 fd:00 51708934                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f607f696000-7f607f895000 ---p 00015000 fd:00 51708934                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f607f895000-7f607f896000 r--p 00014000 fd:00 51708934                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f607f896000-7f607f897000 rw-p 00015000 fd:00 51708934                   /usr/lib64/libgcc_s-4.8.5-20150702.so.1
7f607f897000-7f607f8e3000 r-xp 00000000 fd:50 119582219                  /oracle/12.2.0/db_1/lib/libons.so
7f607f8e3000-7f607fae3000 ---p 0004c000 fd:50 119582219                  /oracle/12.2.0/db_1/lib/libons.so
7f607fae3000-7f607fae5000 rw-p 0004c000 fd:50 119582219                  /oracle/12.2.0/db_1/lib/libons.so
7f607fae5000-7f607fd19000 r-xp 00000000 fd:00 50436127                   /usr/lib64/libcrypto.so.1.0.2k
7f607fd19000-7f607ff19000 ---p 00234000 fd:00 50436127                   /usr/lib64/libcrypto.so.1.0.2k
7f607ff19000-7f607ff35000 r--p 00234000 fd:00 50436127                   /usr/lib64/libcrypto.so.1.0.2k
7f607ff35000-7f607ff42000 rw-p 00250000 fd:00 50436127                   /usr/lib64/libcrypto.so.1.0.2k
7f607ff42000-7f607ff46000 rw-p 00000000 00:00 0
7f607ff46000-7f6080108000 r-xp 00000000 fd:00 50342419                   /usr/lib64/libc-2.17.so
7f6080108000-7f6080308000 ---p 001c2000 fd:00 50342419                   /usr/lib64/libc-2.17.so
7f6080308000-7f608030c000 r--p 001c2000 fd:00 50342419                   /usr/lib64/libc-2.17.so
7f608030c000-7f608030e000 rw-p 001c6000 fd:00 50342419                   /usr/lib64/libc-2.17.so
7f608030e000-7f6080313000 rw-p 00000000 00:00 0
7f6080313000-7f6080329000 r-xp 00000000 fd:00 50342454                   /usr/lib64/libresolv-2.17.so
7f6080329000-7f6080528000 ---p 00016000 fd:00 50342454                   /usr/lib64/libresolv-2.17.so
7f6080528000-7f6080529000 r--p 00015000 fd:00 50342454                   /usr/lib64/libresolv-2.17.so
7f6080529000-7f608052a000 rw-p 00016000 fd:00 50342454                   /usr/lib64/libresolv-2.17.so
7f608052a000-7f608052c000 rw-p 00000000 00:00 0
7f608052c000-7f608052d000 r-xp 00000000 fd:00 50367600                   /usr/lib64/libaio.so.1.0.1
7f608052d000-7f608072c000 ---p 00001000 fd:00 50367600                   /usr/lib64/libaio.so.1.0.1
7f608072c000-7f608072d000 r--p 00000000 fd:00 50367600                   /usr/lib64/libaio.so.1.0.1
7f608072d000-7f608072e000 rw-p 00001000 fd:00 50367600                   /usr/lib64/libaio.so.1.0.1
7f608072e000-7f6080735000 r-xp 00000000 fd:00 50342456                   /usr/lib64/librt-2.17.so
7f6080735000-7f6080934000 ---p 00007000 fd:00 50342456                   /usr/lib64/librt-2.17.so
7f6080934000-7f6080935000 r--p 00006000 fd:00 50342456                   /usr/lib64/librt-2.17.so
7f6080935000-7f6080936000 rw-p 00007000 fd:00 50342456                   /usr/lib64/librt-2.17.so
7f6080936000-7f608094c000 r-xp 00000000 fd:00 50342429                   /usr/lib64/libnsl-2.17.so
7f608094c000-7f6080b4c000 ---p 00016000 fd:00 50342429                   /usr/lib64/libnsl-2.17.so
7f6080b4c000-7f6080b4d000 r--p 00016000 fd:00 50342429                   /usr/lib64/libnsl-2.17.so
7f6080b4d000-7f6080b4e000 rw-p 00017000 fd:00 50342429                   /usr/lib64/libnsl-2.17.so
7f6080b4e000-7f6080b50000 rw-p 00000000 00:00 0
7f6080b50000-7f6080b67000 r-xp 00000000 fd:00 50342447                   /usr/lib64/libpthread-2.17.so
7f6080b67000-7f6080d66000 ---p 00017000 fd:00 50342447                   /usr/lib64/libpthread-2.17.so
7f6080d66000-7f6080d67000 r--p 00016000 fd:00 50342447                   /usr/lib64/libpthread-2.17.so
7f6080d67000-7f6080d68000 rw-p 00017000 fd:00 50342447                   /usr/lib64/libpthread-2.17.so
7f6080d68000-7f6080d6c000 rw-p 00000000 00:00 0

Çözüm için oracle user’ının .bash_profile dosyasına aşağıdaki parametreyi ekleyebilirsiniz.

export MALLOC_CHECK_=0

Tekrar login olduktan sonra veya .bash_profile’ı elle çalıştırdıktan sonra

[oracle@dbhost ~]$ sqlplus sys/password as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 24 13:08:55 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@dbhost ~]$

Kolay gelsin.

Oracle 11.2.0.3 to 12.2.0.1 upgrade failed with ORA-01403 ORA-06512

Leave a Comment / Hatalar, Oracle / By /

Selamlar,

Hata

DBUA ile 11.2.0.3’den 12.2.0.1’e upgrade yaparken aşağıdaki gibi bir hata aldık.

Ortam Bilgileri

RDBMS versiyonları: 11.2.0.3.15 -> 12.2.0.1.190716

Çözüm

Aşağıdaki adımlar uygulandı ve DBUA üzerinden retry butonuna basıldı. Upgrade başarılı tamamlandı. 

create user anonymous identified by "anonymous" default tablespace sysaux; 
grant create session to anonymous;
alter user anonymous account lock; 
BEGIN
dbms_registry.update_schema_list('XDB',dbms_registry.schema_list_t('ANONYMOUS'));
END;
/

ORA-1403 when Revoking Default Grant of INHERIT PRIVILEGES on XDB and ANONYMOUS (Doc ID 2289675.1)

Exadata Cisco Switch change telnet password

1 Comment / Exadata / By /

Merhaba,
Oracle Exadata makinelerinde Cisco switch’lerin telnet password’ünü aşağıdaki adımları izleyerek değiştirebilirsiniz.

telnet 172.16.0.30
enable
configure terminal
line vty 0 4
password <new_passwd>
login
end
show run
copy run start

Kaynak:
Steps for Changing the Telnet Password for CISCO Switch Included on Exadata Database Machine (Doc ID 1454873.1)

Exadata power on/off steps

Leave a Comment / Exadata, Oracle / By /

Selamlar,
aşağıdaki adımları izleyerek exadata’nızı tutarlı bir şekilde kapatıp açabilirsiniz.

CHECKS

1. check all cell nodes (MS, RS & CELLSRV services must be running) 

cd /opt/oracle.SupportTools/onecommand
cat dbs_group
cat cell_group

dcli -g cell_group -l root "su - celladmin -c \"cellcli -e list cell detail \""

dcli -g cell_group -l root "su - celladmin -c \"cellcli -e LIST GRIDDISK WHERE STATUS = 'inactive' \""
(more…)

Oracle RAC add node to existing cluster

Leave a Comment / Oracle, RAC / By /

Merhabalar,

bir müşterimiz yanlışlıkla Oracle RAC ortamında 2. node üzerindeki Oracle Home’u sildi. Sadece RDBMS home silindiği için cluster ayakta ve sorunsuz çalışıyor. Aşağıdaki adımları izleyerek 2. node’u kesintisiz olarak tekrar cluster’a ekledik.

  1. Update node’list komutu ile ikinci node inventory’den çıkartılmış olur. Oracle user’ı  ile çalıştırılır. 
[oracle@dbnode1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1 "CLUSTER_NODES=dbnode1"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 24574 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
(more…)