당신은 주제를 찾고 있습니까 “ora-24248 xml db extensible security not installed – Sửa lỗi Anti Cheat Is Not Installed 9d Cửu Long Tranh Bá – DzoGame – NooAnhHuy hỗ trợ Fan.“? 다음 카테고리의 웹사이트 https://ppa.charoenmotorcycles.com 에서 귀하의 모든 질문에 답변해 드립니다: ppa.charoenmotorcycles.com/blog. 바로 아래에서 답을 찾을 수 있습니다. 작성자 Noo Anh Huy 이(가) 작성한 기사에는 조회수 2,394회 및 좋아요 32개 개의 좋아요가 있습니다.
ora-24248 xml db extensible security not installed 주제에 대한 동영상 보기
여기에서 이 주제에 대한 비디오를 시청하십시오. 주의 깊게 살펴보고 읽고 있는 내용에 대한 피드백을 제공하세요!
d여기에서 Sửa lỗi Anti Cheat Is Not Installed 9d Cửu Long Tranh Bá – DzoGame – NooAnhHuy hỗ trợ Fan. – ora-24248 xml db extensible security not installed 주제에 대한 세부정보를 참조하세요
Chào mừng các bạn đã đến với kênh chanel của Noo Anh Huy.
Nhớ like và subcribe kênh để ủng họ mình nhé.
Ấn vào cái chuông kế bên để khi mình ra video youtube sẽ thông báo cho các bạn biết nhé.
FaceBook cá nhân:
https://www.facebook.com/AnhHuy9x93/
FaceBook nhóm thảo luận:
https://www.facebook.com/groups/2541179216184869
FaceBook cá nhân:
https://www.facebook.com/AnhHuy9x93/
Link down file sửa lỗi: https://bom.to/7fz2jbHGNHST3
Trường hợp link bị hư vui lòng để lại bình luận hoặc nhắn cho fanpage Cửu Long ^^
ora-24248 xml db extensible security not installed 주제에 대한 자세한 내용은 여기를 참조하세요.
ORA-24248: XML DB extensible security not installed
If you or your DBA d not install the Oracle XML database, you will receive this error message. A default installation of Oracle will …
Source: knowledge.broadcom.com
Date Published: 6/18/2021
View: 1884
ORA-24248: XML DB extensible security not installed
ORA-24248: XML DB extensible security not installed *Cause: XML DB extensible security necessary for this operation has not been installed.
Source: www.orafaq.com
Date Published: 3/29/2022
View: 3067
ORA-24248: XML DB extensible security not installed |
ORA-24248: XML DB extensible security not installed … sysaux temp YES — xdb is the password for XML Database repository schema — sysaux …
Source: anargodjaev.wordpress.com
Date Published: 4/1/2021
View: 969
Oracle 11gR2 ORA-24248 XML DB extensible security not …
Oracle Database Error Code ORA-24248 Description … Cause: XML DB extensible security necessary for this operation has not been installed. Action: Ensure that …
Source: www.oraexcel.com
Date Published: 9/7/2022
View: 2766
ORA-24248 Problem Solution : Oracle Database 11.2
What is the content and solution of the code ORA-24248? This code means that XML DB extensible security not installed. XML DB extensible security necessary …
Source: www.errbay.com
Date Published: 8/2/2021
View: 584
ORA-24248: XML DB extensible security not installed
Oracle® Database Error ORA-24248775/17 … Cause: XML DB extensible security necessary for this operation has not been installed. Action: Ensure that XML DB has …
Source: ora11g.de
Date Published: 6/18/2022
View: 4410
ORA-24248 XMLDB extensible security not installed
ORA-24248 XMLDB extensible security not installed. A few days ago I ran into this problem. We upgraded one of our development database from …
Source: kmidba.blogspot.com
Date Published: 9/7/2021
View: 422
ORA-24248 XMLDB extensible security not installed-白红宇
ORA-24248 XMLDB extensible security not installed. Oracle 11g introduces more secure and fine grained access on network packages like …
Source: xzyagz.baihongyu.com
Date Published: 8/6/2021
View: 5648
주제와 관련된 이미지 ora-24248 xml db extensible security not installed
주제와 관련된 더 많은 사진을 참조하십시오 Sửa lỗi Anti Cheat Is Not Installed 9d Cửu Long Tranh Bá – DzoGame – NooAnhHuy hỗ trợ Fan.. 댓글에서 더 많은 관련 이미지를 보거나 필요한 경우 더 많은 관련 기사를 볼 수 있습니다.
주제에 대한 기사 평가 ora-24248 xml db extensible security not installed
- Author: Noo Anh Huy
- Views: 조회수 2,394회
- Likes: 좋아요 32개
- Date Published: 2021. 8. 11.
- Video Url link: https://www.youtube.com/watch?v=h6XWdE7HjeI
ORA-24248: XML DB extensible security not installed
Resolution
To resolve this issue, please reach out to your database administrator (DBA) and they will be able to work with you to find the root cause.
You will either need to install the XML DB or have the restrictions lifted in your environment.
If you have an Oracle Support account, you can sign in and use the resolution from this knowledge document: https://support.oracle.com/knowledge/Oracle%20Database%20Products/825075_1.html
If you do not have an Oracle support account, this document also reviews how to resolve this: http://oracleflash.com/40/ORA-24248-XMLDB-extensible-security-not-installed.html
OraFAQ Forum: SQL & PL/SQL » ORA-24248: XML DB extensible security not installed
I tried to execute the commands you gave in database ( which resides in different servers)
but did not get the output i expected.
In Server1
———-
SQL> SQL> select global_name from global_name; GLOBAL_NAME ———————————————— JACK.WORLD SQL> show parameter unique_name ORA-00942: table or view does not exist SQL> select dbid from v$database; select dbid from v$database * ERROR at line 1: ORA-00942: table or view does not exist
In server 2
————–
SQL> select global_name from global_name; GLOBAL_NAME ———————————————— JACK.WORLD SQL> SQL> show parameter unique_name NAME TYPE ———————————— ———– VALUE —————————— db_unique_name string webcaps SQL> SQL> set lines 1000 SQL> / GLOBAL_NAME ———————————————— JACK.WORLD SQL> select dbid from v$database; DBID ———- 2205711133
I am scared if i do something wrong in database which i am not suppose to do in particular database.
Regards,
Michel,I tried to execute the commands you gave in database ( which resides in different servers)but did not get the output i expected.In Server1———-In server 2————–I am scared if i do something wrong in database which i am not suppose to do in particular database.Regards, Report message to a moderator
ORA-24248: XML DB extensible security not installed
bash-4.1$ cd $ORACLE_HOME/rdbms/admin bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> SQL> spool install_xml_db.log SQL> @catqm xdb sysaux temp YES — xdb is the password for XML Database repository schema — sysaux is the default tablespace for XML Database repository schema. — temp is the default temporary tablespace for XML Database repository schema. — YES is for using secure files for xdb$resource . . . [output trimmed] . . . SQL> declare 2 suf varchar2(26); 3 stmt varchar2(2000); 4 begin 5 select toksuf into suf from xdb.xdb$ttset where flags = 0; 6 stmt := ‘grant all on XDB.X$PT’ || suf || ‘ to DBA’; 7 execute immediate stmt; 8 stmt := ‘grant all on XDB.X$PT’ || suf || ‘ to SYSTEM WITH GRANT OPTION’; 9 execute immediate stmt; 10 end; 11 / PL/SQL procedure successfully completed. SQL>spool off SQL> set linesize 1000 SQL> set pagesize 100 SQL> SQL> select comp_name , status from dba_registry; COMP_NAME STATUS ————————————————————————————————————————————————————————————————————————————————————— ——————————————– Oracle XML Database VALID Oracle Workspace Manager VALID Oracle Database Catalog Views VALID Oracle Database Packages and Types VALID Oracle Real Application Clusters VALID
Oracle 11gR2 ORA-24248 XML DB extensible security not installed
Database: 11g Release 2
Error code: ORA-24248
Description: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
Database: 11g Release 1
Error code: ORA-24248
Description: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
Database: 12c Release 1
Error code: ORA-24248
Description: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
Database: 12c Release 2
Error code: ORA-24248
Description: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
Database: 12c Release 2
Error code: ORA-24248
Description: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
Database: 18c Release 1
Error code: ORA-24248
Description: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
Database: 18c Release 1
Error code: ORA-24248
Description: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
ORA-24248 Problem Solution : Oracle Database 11.2
ORA-24248
Company
Product
Version
11.2
Description
ORA-24248: XML DB extensible security not installed
Cause
XML DB extensible security necessary for this operation has not been installed.
Action
Ensure that XML DB has been installed.
Source
Oracle Database 11.2 Document
Newest
Oracle® Database Error Code ORA-24248: XML DB extensible security not installed
Oracle® Database Error ORA-24248 775/17
ORA-24248: XML DB extensible security not installed
Cause: XML DB extensible security necessary for this operation has not been installed.
Action: Ensure that XML DB has been installed.
Error Type: ORA
ORA-24248 XMLDB extensible security not installed-白红宇
ORA-24248 XMLDB extensible security not installed
本文共 7274 字，大约阅读时间需要 24 分钟。
ORA-24248 XMLDB extensible security not installed
Oracle 11g introduces more secure and fine grained access on network packages like UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP and UTL_INADDR, i.e. an execute privilege on these packages is not enough to access an external network resource using these packages. You have to configure ACL (Access Control List), assign the network host and port to it and grant connect privilege to the users through this ACL .
Please see:
These ACLs are XML files which are stored in the XML Database repository inside the database itself, which means that XML Database must be installed in the database to use the network PL/SQL packages. XML Database is installed automatically when you create a database using DBCA with default options. However, if you unselect/uncheck the XML Database option in DBCA while creating the database, XML Database won’t installed.
A few days ago I ran into this problem. We upgraded one of our development database from oracle 10gR2 to 11gR1 recently. After the upgrade the application was broken very badly. Any user trying to login to the application was getting the error below:
ORA-24248: XMLDB extensible security not installed
ORA-06512: at “SYS.UTL_INADDR”, line 19
ORA-06512: at “SYS.UTL_INADDR”, line 40
ORA-06512: at line 1
After I investigated, I found that that in one of Java classes in the application, where a connection was being established to the databases, a query was being executed like this.
SELECT global_name,utl_inaddr.get_host_address FROM global_name;
When I saw UTL_INADDR being called, I realized instantly that we need an ACL for this call and ACL needs XML Database. The error above is quite self explanatory. I went ahead and verified the existence of Oracle XML Database and found the following:
SQL> select comp_name from dba_registry;COMP_NAME—————————————-OWBOracle Application ExpressOracle Enterprise ManagerOLAP CatalogSpatialOracle MultimediaOracle TextOracle Expression FilterOracle Rules ManagerOracle Workspace ManagerOracle Database Catalog ViewsOracle Database Packages and TypesJServer JAVA Virtual MachineOracle XDKOracle Database Java PackagesOLAP Analytic WorkspaceOracle OLAP API17 rows selected.
As can be seen from the output of the above query, we were missing Oracle XML Database. I was able to reproduce the problem in sqlplus.
SQL> conn scott/tigerConnected.SQL> select global_name,utl_inaddr.get_host_address from global_name;select global_name,utl_inaddr.get_host_address from global_name
*ERROR at line 1:ORA-24248: XML DB extensible security not installedORA-06512: at “SYS.UTL_INADDR”, line 19ORA-06512: at “SYS.UTL_INADDR”, line 40ORA-06512: at line 1SQL>
Install XML Database: Oracle 11g Enterprise Edition
$ cd $ORACLE_HOME/rdbms/admin$ sqlplus / as sysdbaConnected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> spool install_xml_db.logSQL> @catqm xdb sysaux temp YES– xdb is the password for XML Database repository schema– sysaux is the default tablespace for XML Database repository schema.– temp is the default temporary tablespace for XML Database repository schema.– YES is for using secure files for xdb$resource…[output trimmed]…SQL> declare 2
suf varchar2(26); 3
stmt varchar2(2000); 4 begin 5
select toksuf into suf from xdb.xdb$ttset where flags = 0; 6
stmt := ‘grant all on XDB.X$PT’ || suf || ‘ to DBA’; 7
execute immediate stmt; 8
stmt := ‘grant all on XDB.X$PT’ || suf || ‘ to SYSTEM WITH GRANT OPTION’; 9
execute immediate stmt; 10 end; 11 /PL/SQL procedure successfully completed.SQL>spool off
The XML Database installation is complete. I opened the install_xml_db.log and didn’t find any significant errors in it. Then I verified from dba_registry again to see the status of XML Database installed.
SQL> select comp_name , status from dba_registry;COMP_NAME
STATUS—————————————- ——————————————–Oracle XML Database
VALIDOWB
VALIDOracle Application Express
VALIDOracle Enterprise Manager
VALIDOLAP Catalog
VALIDSpatial
VALIDOracle Multimedia
VALIDOracle Text
VALIDOracle Expression Filter
VALIDOracle Rules Manager
VALIDOracle Workspace Manager
VALIDOracle Database Catalog Views
VALIDOracle Database Packages and Types
VALIDJServer JAVA Virtual Machine
VALIDOracle XDK
VALIDOracle Database Java Packages
VALIDOLAP Analytic Workspace
VALIDOracle OLAP API
VALID18 rows selected.SQL>
The status should be VALID to indicate that the installation was successfull. Then I tested the UTL_INADDR again.
SQL> conn scott/tigerConnected.SQL> select global_name,utl_inaddr.get_host_address from global_name;select global_name,utl_inaddr.get_host_address from global_name
*ERROR at line 1:ORA-24247: network access denied by access control list (ACL)ORA-06512: at “SYS.UTL_INADDR”, line 19ORA-06512: at “SYS.UTL_INADDR”, line 40ORA-06512: at line 1
As you see now the ORA-24248 is gone because we have XML Database installed. Now we are seeing ORA-24247, which means we can’t access any network host using UTL_INADDR unless we allow access to this host via ACL.
SQL> conn / as sysdbaConnected.BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl
=>’my_application_acl.xml’,
description => ‘ACL for users of my application.’,
principal
=> ‘SCOTT’,
is_grant
=> TRUE,
privilege
=> ‘resolve’,
start_date => null,
end_date
=> null
);END;/PL/SQL procedure successfully completed./* All that UTL_INADDR.get_host_address does is resolve the host and return the IP Address. DBMS_NETWORK_ACL_ADMIN.CREATE_ACL creates an ACL and grant privilege to a user or role to that ACL. For the sake of this article I am using SCOTT as the grantee of the privilege resolve but in my application I granted this privilege to a role which was assigned to all the application users. So through that role all the users were granted resole privilege to this ACL.*/BEGIN DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl
=>’my_application_acl.xml’,
host
=> ‘localhost’,
lower_port => null,
upper_port => null
);END;/PL/SQL procedure successfully completed./* When UTL_INADDR.get_host_address is invoked without a host name specified with it, it sends the request to localhost. So we need to assign our ACL to the host “localhost”.*/commit;SQL> conn scott/tigerConnected.SQL> set lines 10000SQL> column global_name format a20SQL> column get_host_address format a15SQL> select global_name,utl_inaddr.get_host_address from global_name;GLOBAL_NAME
GET_HOST_ADDRES——————– —————ORA11G.HOME.COM
127.0.0.1SQL>
As you can see above, SCOTT is now able to get server’s IP Adress using utl_inaddr.get_host_address. And this solves our problem with the application.
Uninstall XML Database: Oracle 11g Enterprise Edition
$ cd $ORACLE_HOME/rdbms/admin$ sqlplus / as sysdbaConnected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> @catnoqm.sql– This will uninstall the Oracle XML Database.
See also:
From http://oracleflash.com/40/ORA-24248-XMLDB-extensible-security-not-installed.html
and Thanks Zahid Karim
转载地址：http://xzyagz.baihongyu.com/
키워드에 대한 정보 ora-24248 xml db extensible security not installed
다음은 Bing에서 ora-24248 xml db extensible security not installed 주제에 대한 검색 결과입니다. 필요한 경우 더 읽을 수 있습니다.
이 기사는 인터넷의 다양한 출처에서 편집되었습니다. 이 기사가 유용했기를 바랍니다. 이 기사가 유용하다고 생각되면 공유하십시오. 매우 감사합니다!
사람들이 주제에 대해 자주 검색하는 키워드 Sửa lỗi Anti Cheat Is Not Installed 9d Cửu Long Tranh Bá – DzoGame – NooAnhHuy hỗ trợ Fan.
- 동영상
- 공유
- 카메라폰
- 동영상폰
- 무료
- 올리기
Sửa #lỗi #Anti #Cheat #Is #Not #Installed #9d #Cửu #Long #Tranh #Bá #- #DzoGame #- #NooAnhHuy #hỗ #trợ #Fan.
YouTube에서 ora-24248 xml db extensible security not installed 주제의 다른 동영상 보기
주제에 대한 기사를 시청해 주셔서 감사합니다 Sửa lỗi Anti Cheat Is Not Installed 9d Cửu Long Tranh Bá – DzoGame – NooAnhHuy hỗ trợ Fan. | ora-24248 xml db extensible security not installed, 이 기사가 유용하다고 생각되면 공유하십시오, 매우 감사합니다.
