RE: sqlplus core dump for one database

You might try the settings in this note to generate more diagnostic information to help determine root cause.  

Understanding OCI-21500, OCI-24550, Application Crashes and the Client Side Automatic Diagnostic Repository (ADR) (Doc ID 2249921.1)  

What version of sqlplus are you using on the windows client side?  

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Jeffrey Beckstrom
Sent: Friday, February 22, 2019 5:41 AM
To: niall.litchfield_at_gmail.com
Cc: oracle-l-freelist <oracle-l_at_freelists.org> Subject: Re: sqlplus core dump for one database  

But logon succeeds - we get the sql plus prompt.

Can execute sql if we want with no problems.

Just when exit, get the trace dump.

>>> <niall.litchfield_at_gmail.com <mailto:niall.litchfield_at_gmail.com> >
2/22/19 8:38 AM >>>

Log on trigger?  

On Fri, Feb 22, 2019 at 1:34 PM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org <mailto:jbeckstrom_at_gcrta.org> > 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] $        

-- 

 

Niall Litchfield
Oracle DBA
http://www.orawin.info

 

  _____  

This email has been scanned for spam and viruses. Click here
<https://attseg.proofpointessentials.com/index01.php?mod_id=11&mod_option=lo
gitem&mail_id=1550842749-dOVFgkLBPCaF&r_address=jbeckstrom%40gcrta.org&repor
t=1>  to report this email as spam.



--
http://www.freelists.org/webpage/oracle-l