Re: sqlplus core dump for one database

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 23 Feb 2019 12:00:16 -0500

BTW, I can't reproduce your problem:

[oracle@ora122 ~]$ sqlplus system/qwerty

SQL*Plus: Release 12.2.0.1.0 Production on Sat Feb 23 11:54:43 2019

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

Last Successful login time: Sat Feb 23 2019 11:54:23 -05:00

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

SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@ora122 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.6 (Maipo)
[oracle@ora122 ~]$ cat /etc/oracle-release
Oracle Linux Server release 7.6
[oracle@ora122 ~]$

What kind  of Linux, what is the patch level? Can you try with "sql", not "sqlplus"?


On 2/22/19 8:32 AM, Jeffrey Beckstrom wrote:

Cloned a 12.2 non-multitenant database. If log on to sqlplus and immediately exit, sqlplus does the below. All other databases running out of the SAME Oracle Home function normally. If connect to this database from a Windows client, sqlplus operates normally. Problem only occurs if connect with sqlplus on the Linux server to this ONE database.

Any ideas?

++++++++++++++++++++++++++++++++++++++++++++++
Error accessing PRODUCT_USER_PROFILE
Warning:  Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Last Successful login time: Fri Feb 22 2019 07:52:42 -05:00

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

SQL> exit
Errors in file :
OCI-21500: internal error code, arguments: [17114], [0x001965860], [], [], [], [], [], []


----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skgudmp()+188        call     kgdsdst()            000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kgeriv_int()+199     call     skgudmp()            000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kgeric1()+142        call     kgeriv_int()         000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kgherror()+368       call     kgeric1()            000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kghfrmrg()+2702      call     kgherror()           000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kghfre()+837         call     kghfrmrg()           000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kpuhhfre()+257       call     kghfre()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kputac()+2453        call     kpuhhfre()           000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
afisesend()+104      call     kputac()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
aficntdis()+62       call     afisesend()          000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
afilof()+78          call     aficntdis()          000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
aficex()+340         call     afilof()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
afiexi()+1086        call     aficex()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
aficmd()+2914        call     afiexi()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
aficfd()+3053        call     aficmd()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
aficdr()+151         call     aficfd()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
afidrv()+5950        call     aficdr()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
main()+105           call     afidrv()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
__libc_start_main()  call     main()               000000000 ? 000000000 ?
+245                                               000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?

Call stack signature: 0x1246f539b36d881



call stack performance statistics:
total                  : 0.010000 sec
setup                  : 0.000000 sec
stack unwind           : 0.000000 sec
symbol translation     : 0.000000 sec
printing the call stack: 0.010000 sec
printing frame data    : 0.000000 sec
printing argument data : 0.000000 sec


----- End of Call Stack Trace -----

Segmentation fault (core dumped)
[dbsorat08:~:tismask] $


--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Other related posts: