after trying out a lot of advices I finally turn to this community and hope to get some guidance.

I try to send emails from within PL/SQL and have set up an 18c XE instance on RHL 7.2; fresh install, nothing additionally installed.

If followed all instructions to create a wallet and orapki can read it without any problem.

orapki wallet display -wallet /opt/oracle/product/18c/dbhomeXE/owm/wallets/root

Oracle PKI Tool Release 18.0.0.0.0 - Production

18.1.0.0.0 : Version {1}

Copyright (c) 2004, 2017, Oracle und/oder der verbundenen Unternehmen. All rights reserved. Alle Rechte vorbehalten.

Requested Certificates:

Subject: xxxxxxxxxxxxxxxxxxxxxxxxx

User Certificates:

Trusted Certificates:

Subject: CN=accounts.google.com,O=Google LLC,L=Mountain View,ST=California,C=US

Subject: CN=GlobalSign,O=GlobalSign,OU=GlobalSign Root CA - R2

Subject: CN=Google Internet Authority G3,O=Google Trust Services,C=US

From within oracle I get the message :

ORA-28759: Fehler beim Öffnen von Datei (error opening file)

ORA-06512: in "SYS.UTL_TCP", Zeile 63

ORA-06512: in "SYS.UTL_TCP", Zeile 314

ORA-06512: in "SYS.UTL_SMTP", Zeile 177

ORA-06512: in "SYS.UTL_SMTP", Zeile 201

ORA-06512: in "xxxxxxxxx.QM_SEND_MAIL", Zeile 14 (my procedure at line 14)

my Stored procedure looks like this:

create or replace PROCEDURE qm_send_mail (

    p_from      VARCHAR2,



    p_to        VARCHAR2,



    p_subject   VARCHAR2,



    p_body      VARCHAR2



) IS











    objconnection    utl_smtp.connection;



    vrdata           VARCHAR2(32000);



    v_plain_string   VARCHAR2(32000);



    v_username_b64   VARCHAR2(32000);



    v_password_b64   VARCHAR2(32000);



BEGIN



    objconnection := utl_smtp.open_connection(  host => 'smtp.googlemail.com',



                                                port => 587,--global.g_smtp_port_ssl,



                                                wallet_path => 'file:/opt/oracle/product/18c/dbhomeXE/owm/wallets/root',



                                                --wallet_password => 'xxxxxxxxx',



                                                secure_connection_before_smtp => true);











                    utl_smtp.ehlo(objconnection, 'fritzquinum.dnsalias.com');    -- Must use EHLO  vs HELO



    utl_smtp.starttls(objconnection);











    utl_smtp.auth(objconnection, 'mygooglemailaccount', 'mygooglemailpassword', utl_smtp.all_schemes);











    utl_smtp.mail(objconnection, p_from);



    utl_smtp.rcpt(objconnection, p_to);



    utl_smtp.open_data(objconnection);

/* ** Sending the header information */

    utl_smtp.write_data(objconnection, 'From: '



                                       || p_from



                                       || utl_tcp.crlf);



    utl_smtp.write_data(objconnection, 'To: '



                                       || p_to



                                       || utl_tcp.crlf);



    utl_smtp.write_data(objconnection, 'p_subjectject: '



                                       || p_subject



                                       || utl_tcp.crlf);



    utl_smtp.write_data(objconnection, 'MIME-Version: '



                                       || '1.0'



                                       || utl_tcp.crlf);



    utl_smtp.write_data(objconnection, 'Content-Type: ' || 'text/html;');



    utl_smtp.write_data(objconnection, 'Content-Transfer-Encoding: '



                                       || '"8Bit"'



                                       || utl_tcp.crlf);



    utl_smtp.write_data(objconnection, utl_tcp.crlf);



    utl_smtp.write_data(objconnection, utl_tcp.crlf || '');



    utl_smtp.write_data(objconnection, utl_tcp.crlf || '');



    utl_smtp.write_data(objconnection, utl_tcp.crlf



                                       || '<span style="color: black; font-family: Courier New;">'



                                       || p_body



                                       || '</span>');











    utl_smtp.write_data(objconnection, utl_tcp.crlf || '');



    utl_smtp.write_data(objconnection, utl_tcp.crlf || '');



    utl_smtp.close_data(objconnection);



    utl_smtp.quit(objconnection);

-- EXCEPTION

    WHEN utl_smtp.transient_error OR utl_smtp.permanent_error THEN



        utl_smtp.quit(objconnection);



        dbms_output.put_line(sqlerrm);



    WHEN OTHERS THEN



        utl_smtp.quit(objconnection);



        dbms_output.put_line(sqlerrm);



END qm_send_mail;

As someone pointed out, that the rights on the folder need to be set I changed to test that the file permissions and ownership to this:

[root@core wallets]# ls -la

insgesamt 12

drwx------. 3 root root 79 2. Jan 15:20 .

drwxr-xr-x. 5 oracle oinstall 48 2. Jan 14:42 ..

drwxrwxrwx. 2 root oinstall 90 2. Jan 15:05 root

[root@core wallets]# cd root

[root@core root]# ls -la

insgesamt 16

drwxrwxrwx. 2 root oinstall 90 2. Jan 15:05 .

drwx------. 3 root root 79 2. Jan 15:20 ..

-rwxrwxrwx. 1 root oinstall 5893 2. Jan 15:38 cwallet.sso

-rwxrwxrwx. 1 root oinstall 0 2. Jan 15:05 cwallet.sso.lck

-rwxrwxrwx. 1 root oinstall 5848 2. Jan 15:38 ewallet.p12

-rwxrwxrwx. 1 root oinstall 0 2. Jan 14:48 ewallet.p12.lck

all files are owned by oinstall as recommended; still oracle can't read the wallet.

The wallet has been created with Auto-Login; so I tried with parameter wallet_password set and not set; no difference.

Network connection to googlemail is fine.

Any Ideas, please ?

Kind regards and thanks for any help here...

Klaus