Re: sqlplus core dump for one database
Date: Sat, 23 Feb 2019 12:00:16 -0500
Message-ID: <2981bfe3-2301-521f-2588-9a0199f2149f_at_gmail.com>
BTW, I can't reproduce your problem:
[oracle_at_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_at_ora122 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.6 (Maipo)
[oracle_at_ora122 ~]$ cat /etc/oracle-release
Oracle Linux Server release 7.6
[oracle_at_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 -- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 23 2019 - 18:00:16 CET