Re: sqlplus core dump for one database

From: Andy Sayer <andysayer_at_gmail.com>
Date: Fri, 22 Feb 2019 14:16:22 +0000
Message-ID: <CACj1VR4_KkwK_=Vd4+ef5mK-xYPRc7GGCiT1J1mDcASxs6prNw_at_mail.gmail.com>



“The functions further up on the steck begin afi* which, I think, are not Oracle server, but rather client functions:” afi is the advanced friendly interface, what sql*plus was supposedly initially called (hense afiedt.buf)

I suspect an old version of sql*plus running against a more recent DB server which no longer creates the table sql*plus uses to restrict usage of certain features. Client side security is obviously not the best of ideas.

Hope this helps,
Andy

On Fri, 22 Feb 2019 at 14:02, Noveljic Nenad <nenad.noveljic_at_vontobel.com> wrote:

> The error was thrown in kghfre which is "kernel generic heap manager free
> a chunk of memory" according to http://orafun.info/
>
>
>
> "Segmentation fault (core dumped)" probably tells us that a non-existent
> memory address was referenced during deallocation.
>
>
>
> The functions further up on the steck begin afi* which, I think, are not
> Oracle server, but rather client functions:
>
> nm sqlplus | grep afi
>
> [56] | 4197384| 0|FUNC |GLOB |0
> |UNDEF |afidrv
>
>
>
> This leads me to conclusion that it's a client side issue. Therefore it
> works from another client - you mentioned Windows, but it doesn't have
> anything to do with the OS. You can try to connect from another Linux
> machine to verify that.
>
>
>
> Please apologize the trivial question, but have you checked the
> environment variables of the sqlplus process, such as library path, nls etc
> and compare them with a working connection?
>
>
>
> You can also execute a utilitiy like pldd (available on Solaris) on the
> sqlplus process to check whether correct library versions are linked.
>
>
>
> Nenad
>
>
>
> http://nenadnoveljic.com/blog/
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Jeffrey Beckstrom
> *Sent:* Freitag, 22. Februar 2019 14:33
> *To:* oracle-l-freelist <oracle-l_at_freelists.org>
> *Subject:* sqlplus core dump for one database
>
>
>
> 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] $
>
>
>
>
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us which
> shall prevail in any case, we take it as your authorization to correspond
> with you by e-mail if you send us messages by e-mail. However, we reserve
> the right not to execute orders and instructions transmitted by e-mail at
> any time and without further explanation.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of
> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
> referred to as "Vontobel Group") for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version. Please note that all e-mail communications to and from the
> Vontobel Group are subject to electronic storage and review by Vontobel
> Group. Unless stated to the contrary and without prejudice to any
> contractual agreements between you and Vontobel Group which shall prevail
> in any case, e-mail-communication is for informational purposes only and is
> not intended as an offer or solicitation for the purchase or sale of any
> financial instrument or as an official confirmation of any transaction.
> The legal basis for the processing of your personal data is the legitimate
> interest to develop a commercial relationship with you, as well as your
> consent to forward you commercial communications. You can exercise, at any
> time and under the terms established under current regulation, your rights.
> If you prefer not to receive any further communications, please contact
> your client relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the affected group
> entity the corporate e-mail signature. For further information about data
> privacy at Vontobel Group please consult www.vontobel.com.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 22 2019 - 15:16:22 CET

Original text of this message