SQL > ALTER USER ANONYMOUS IDENTIFIED BY anonymous;
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
SQL> ALTER USER XDB IDENTIFIED BY xdb;
SQL> ALTER USER XDB ACCOUNT UNLOCK;
************************************************
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('<allow-repository-anonymous-access xmlns="http://xmlns.oracle.com/xdb/xdbconfig.xsd">' ||
l_value ||
'</allow-repository-anonymous-access>'),
'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;
No. | Subject | Author | Date | Views |
---|---|---|---|---|
15 | 소프트웨어에 관련된 다섯 가지 의무 | admin | 2018.01.10 | 476 |
14 | Senior HCMS Solutions Analyst (Corporate) | admin | 2018.06.25 | 387 |
13 | IP ADDRESS of SITEs | admin | 2018.07.09 | 454 |
12 | Computer to Mobile | admin | 2018.08.03 | 360 |
11 | TCP/IP 주소 지정 및 서브넷 구성 기본 사항의 이해 | admin | 2018.08.04 | 518 |
10 | TCP/IP 주소 지정 및 서브넷 구성 기본 사항의 이해 | admin | 2018.08.04 | 373 |
9 | How to create a Windows Firewall Inbound Rule | admin | 2018.10.05 | 507 |
8 | netsh http add iplisten 127.0.0.1 | admin | 2018.10.07 | 540 |
7 | default XDB account | admin | 2018.10.07 | 1063 |
6 | Oracle APEX – XDB Authentication Popup dialog | admin | 2018.10.07 | 1536 |
» | Oracle APEX – XDB Authentication Popup dialog | admin | 2018.10.07 | 1364 |
4 | Upgrading to APEX 5 | admin | 2018.10.07 | 3587 |
3 | XDB error | admin | 2018.10.07 | 1035 |
2 | Elon Musk is reportedly planning an A.I. startup to compete with OpenAI, which he cofounded | admin | 2023.04.14 | 138 |
1 | ROUTER | admin | 2023.07.13 | 141 |