WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL Look for the ACL currently assigned to 'localhost' and give APEX_030200 This example would enable indexing the Oracle Application Express Online Help and could possibly enable email and PDF printing if those servers were also on the local host. The following example demonstrates how to provide less privileged access to local network resources. 'ACL that lets power users to connect to everywhere',ĭBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*') IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_030200',ĭBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,ĭBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml', WHERE extractValue(P.RES, '/Resource/XMLRef') = REF(A) AND SELECT SYS_OP_R2O(extractValue(P.RES, '/Resource/XMLRef')) INTO ACL_ID ORA-44416: Invalid ACL: Unresolved principal 'APEX_030200' If it does, the following exception will be raised: (for example, does not contain stale references to dropped users). Before checking the privilege, ensure that the ACL is valid WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS the "connect" privilege if APEX_030200 does not have the privilege yet. Look for the ACL currently assigned to '*' and give APEX_030200 This example assumes you connected to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. The following example demonstrates how to grant connect privileges to any host for the APEX_030200 database user. The default port number is 8080.Įnter the following statement to unlock the ANONYMOUS account: ALTER USER ANONYMOUS ACCOUNT UNLOCK When prompted, enter the port for the Oracle XML DB HTTP server. You will use this password to log in to Oracle Application Express Administration Services. Run apxconf.sql as shown in the following example: prompted, enter a password for the Application Express Admin account.īe sure to make a note of the password you enter. On Windows: SYSTEM_DRIVE:\ sqlplus /nolog Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. To run the apxconf.sql configuration script:Ĭhange your working directory to ORACLE_BASE\ORACLE_HOME \apex or whatever convention used to indicate the Oracle home. If you are upgrading and have previously configured the embedded PL/SQL gateway, skip this section and go to "Enable Network Services in Oracle Database 11 g". You can use Oracle Database Recovery Manager, which is included the Oracle Database installation, to perform the backup. Oracle recommends that you create a backup of the current installation of Oracle Database installation before you install Oracle Application Express. Right-click the name of the service and from the menu, choose Stop.īack up the Oracle Database installation. In addition, shut down the OracleCSService service, which ASM uses. The Oracle ASM service is named OracleASMService+ASM. Names of Oracle databases are preceded with OracleService. You can use the Windows Services utility, located either in the Windows Control Panel or from the Administrative Tools menu (under Start and then Programs), to shut down Oracle Database and ASM instances. If Automatic Storage Management (ASM) is running, shut down all databases that use ASM except for the database where you will install Oracle Application Express, and then shut down the ASM instance. On Oracle Real Application Clusters (Oracle RAC) systems, shut down all instances on each node. Shut down any existing Oracle Database instances with normal or immediate priority, except for the database where you plan to install the Oracle Application Express schemas. Shut down any existing Oracle Database instances as well as Oracle-related processes. See "Oracle Application Express Installation Requirements". Review and satisfy all Oracle Application Express installation requirements. Before installing Oracle Application Express, Oracle recommends that you complete the following steps:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |