Skip to main content

when I try reconfigure IFS I have the error “Error when configuring PL/SQL Access Provider. “

i found the full error in the log:

 

/echo]: Configuring PL/SQL Access Provider
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 8, column 10:
PL/SQL: Statement ignored
ORA-06550: line 13, column 7:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 13, column 7:
PL/SQL: Statement ignored
ORA-06550: line 19, column 7:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 19, column 7:
PL/SQL: Statement ignored
ORA-06550: line 24, column 7:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 24, column 7:
PL/SQL: Statement ignored
ORA-06550: line 29, column 7:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
ORA-06550: line 29, column 7:
PL/SQL: Statement ignored)
Error in Ant-script: server\install_fndbas.xml
Reported error is: The following error occurred while executing this line:
D:\APPL\BUT\TST\IFSV10\IFS_HOME10\repository\server\install_fndbas.xml:307: Error when configuring PL/SQL Access Provider.
 

i connect in database with sys user and the DBMS_NETWORK_ACL_ADMIN was not created, i run dbmsnacl.sql in the database and DBMS_NETWORK_ACL_ADMIN was created, but i still have the error in IFS, i reconfigure IFS, delete IFS instance and re-create, run again prepare from build

Hi, 

Did you refer this knowledge article when trying to troubleshoot? 

 

You can start by testing the plsql ping with the following:

 

SELECT utl_http.request((SELECT value FROM PLSQLAP_ENVIRONMENT_TAB t WHERE t.name = 'CONN_STR') || '?test=true') FROM dual;

 

Thanks,

 


Hi,

the topic is blocked for me, when i run this select  its return that 

“sys.dbms_network_acl_admin does not exist”


Hi @Matheus.Avancera 

Please try granting EXECUTE privilege on DBMS_NETWORK_ACL_ADMIN to Application Owner and IFSSYS and then try again. 

 

You can use following query to see the users who already has the privilege:

SELECT grantee, privilege
FROM sys.dba_tab_privs
WHERE owner = 'SYS'
AND table_name = 'DBMS_NETWORK_ACL_ADMIN'
AND privilege = 'EXECUTE';

Thanks,


 @Matheus.Avancera - Please run the following grants

 

grant execute on sys.DBMS_NETWORK_ACL_ADMIN to IFSAPP;

 grant execute on sys.DBMS_NETWORK_ACL_ADMIN to IFSSYS;

 grant execute on sys.DBMS_NETWORK_ACL_UTILITY to IFSAPP;

 grant execute on sys.DBMS_NETWORK_ACL_UTILITY to IFSSYS;


Hi,

i executed de permissions for IFSAPP and IFSSYS, run the select and the permissions are OK fot both users, but i have de the same error.


Try the below steps:

 

  • Run Prepare as SYS 
EXEC Prepare_SYS.Dbagrant('&APPOWNER’);
  • Run as App-Owner 
exec Installation_SYS.Grant_Ifssys(TRUE);   

exec Fndbas_Installation_API.Post_Installation_Data;  

 

  • Refresh Dictionary and security cache. 
  • Enable the below oracle queues within ‘Solution Manager>Monitoring>Oracle Queues>Oracle Queues’ screen.

BATCH_PROC_QUEUE_MAIN

BATCH_PROC_RESP_QUEUE

FND_TRK_LU_DMO_Q


Hi, eu runned out all steps, but still have problems, any more ideas?


Hi, eu runned out all steps, but still have problems, any more ideas?

You can reach-out to IFS through a case. It would be easier to troubleshoot in the environment itself. 


thank you


@Matheus.Avancera you can try below as well.

1. Run dbagrant.sql as SYS 
2. Deploy Installation.apy to Appowner 
3. Run grantifssys.sql as Appowner
4. Run installer for the extended server.