sudo sed -i 's/net.ipv6.bindv6only\ =\ 1/net.ipv6.bindv6only\ =\ 0/' \
/etc/sysctl.d/bindv6only.conf && sudo invoke-rc.d procps restart
Надеюсь, Вы ещё не меняли ничего от отчаяния в tnsnames.ora и listener.ora?..
Читать далее
sudo sed -i 's/net.ipv6.bindv6only\ =\ 1/net.ipv6.bindv6only\ =\ 0/' \
/etc/sysctl.d/bindv6only.conf && sudo invoke-rc.d procps restart
cd c:\tmp\apex sqlplus "sys/syspass as sysdba" @apexins SYSAUX SYSAUX TEMP /i/
sqlplus "sys/syspass as sysdba" @apxchpwd
@apex_epg_config c:\tmp
alter user anonymous account unlock;
EXEC DBMS_XDB.SETHTTPPORT(8080);
SET SERVEROUTPUT ON DECLARE l_configxml XMLTYPE; l_value VARCHAR2(5) := 'true'; -- (true/false) BEGIN l_configxml := DBMS_XDB.cfg_get(); IF l_configxml.existsNode('/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access') = 0 THEN -- Add missing element. SELECT insertChildXML ( l_configxml, '/xdbconfig/sysconfig/protocolconfig/httpconfig', 'allow-repository-anonymous-access', XMLType('' || l_value || ' '), 'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"' ) INTO l_configxml FROM dual; DBMS_OUTPUT.put_line('Element inserted.'); ELSE -- Update existing element. SELECT updateXML ( DBMS_XDB.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/allow-repository-anonymous-access/text()', l_value, 'xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd"' ) INTO l_configxml FROM dual; DBMS_OUTPUT.put_line('Element updated.'); END IF; DBMS_XDB.cfg_update(l_configxml); DBMS_XDB.cfg_refresh; END; / Element updated.
exec dbms_xdb.setListenerLocalAccess(l_access => FALSE);
Recently I was writing here about Oracle Database, Oracle APEX, Linux. Now I'm more interested in PostgreSQL and AWS, but Oracle will always be in my heart. :) suPPLer