$ cd $ORACLE_HOME/rdbms/admin; sqlplus
SQL> conn system Enter password: Connected. SQL> @epgstat +--------------------------------------+ | XDB protocol ports: | | XDB is listening for the protocol | | when the protocol port is non-zero. | +--------------------------------------+ HTTP Port FTP Port --------- -------- 8080 2100 1 row selected. +---------------------------+ | DAD virtual-path mappings | +---------------------------+ Virtual Path DAD Name -------------------------------- -------------------------------- /apex/* APEX 1 row selected. +----------------+ | DAD attributes | +----------------+ DAD Name DAD Param DAD Value ------------ ------------------------ ---------------------------------------- APEX database-username ANONYMOUS default-page apex document-table-name wwv_flow_file_objects$ request-validation-funct wwv_flow_epg_include_modules.authorize ion document-procedure wwv_flow_file_mgr.process_download nls-language american_america.al32utf8 document-path docs 7 rows selected. +---------------------------------------------------+ | DAD authorization: | | To use static authentication of a user in a DAD, | | the DAD must be authorized for the user. | +---------------------------------------------------+ no rows selected +----------------------------+ | DAD authentication schemes | +----------------------------+ DAD Name User Name Auth Scheme -------------------- -------------------------------- ------------------ APEX ANONYMOUS Anonymous 1 row selected. +--------------------------------------------------------+ | ANONYMOUS user status: | | To use static or anonymous authentication in any DAD, | | the ANONYMOUS account must be unlocked. | +--------------------------------------------------------+ Database User Status --------------- -------------------- ANONYMOUS OPEN 1 row selected. +-------------------------------------------------------------------+ | ANONYMOUS access to XDB repository: | | To allow public access to XDB repository without authentication, | | ANONYMOUS access to the repository must be allowed. | +-------------------------------------------------------------------+ Allow repository anonymous access? ---------------------------------- true 1 row selected.
Этот скрипт показывает массу полезной информации: HTTP- и FTP-порты, которые слушает XDB; настройки DAD; состояние пользователя ANONYMOUS; разрешение анонимного доступа к репозиторию XDB. Проанализировав вывод, существующую проблему будет решать намного проще.
PS: Кроме того, советую показывать эту информацию на форумах и в обсуждениях. Это значительно упростит поиск причин Ваших проблем. ;)
Читать далее