Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Local/Intranet Mail server Configuration ORA error

M.broDec 6 2021 — edited Dec 6 2021

Dear Team,
Oracle Apex Version: 20.1
Oracle DB : 12.1
I am trying to configure and send emails from apex applications like interactive reports send email icons. i trying to send
I checked the apex_mail_queue table mail_send_error: ORA-24250: No supported authentication scheme found. I referred to many blogs but I can't able to successfully send an email.
Please help me to solve the issue. I am sending local mail server not Gmail and offline system internal mail I need to sent (intranet mail only)
Thanks
This post has been answered by Billy Verreynne on Dec 7 2021
Jump to Answer

Comments

Can you try with latest version of 1.8 java

Java SE Development Kit 8 - Downloads

user11980779

#echo $JAVA_HOME

/u01/orabin/system/sqlcl/jdk_8u162/jdk1.8.0_162

#which java

/u01/orabin/system/sqlcl/jdk_8u162/jdk1.8.0_162/bin/java

#java -version

java version "1.8.0_162"

Java(TM) SE Runtime Environment (build 1.8.0_162-b12)

Java HotSpot(TM) 64-Bit Server VM (build 25.162-b12, mixed mode)

#/u01/orabin/system/sqlcl/dbtools-sqlcl-18.1.0/bin/sql

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:42)

        at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)

        at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:429)

user11980779

I do not get the "Access is denied"

Steve S.

I'm getting the same issue with sql 18.1.1 and java 1.8.0.72.

sql     

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:42)

        at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)

        at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:429)

java version "1.8.0_172"

Java(TM) SE Runtime Environment (build 1.8.0_172-b11)

Java HotSpot(TM) 64-Bit Server VM (build 25.172-b11, mixed mode)

Steve

user11980779

I´ve opened a SR and the engineer confirmed that there is an issue with jline.jar in 18.1 version.

Workaround: replace jline.jar from 18.1 by the one provided by 17.4

user11980779

The bug number is 28086841: SQLCL COMMAND FAILS TO START WITH ERROR JANSI (NOT FOUND IN JAVA.LIBRARY.PATH)

According to the engineer this bug should be fixed in upcoming 18.2 release

user11980779

issue not fixed in 18.2

bug note is now public and it says fixed in 18.3

user11980779

issue not fixed in 18.3 either

onedbguru

Yep, same problem in 18.3.0.259.2029

(Solaris 10)

unsupported major.minor version 52.0

OR

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:42)

        at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)

        at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:429)

java version "1.8.0_172"

Java(TM) SE Runtime Environment (build 1.8.0_172-b25)

Java HotSpot(TM) 64-Bit Server VM (build 25.172-b25, mixed mode)

1 - 10

Post Details

Added on Dec 6 2021
#apex, #apex-discussions, #apex20-2, #email, #oracle
6 comments
597 views
2 mentions