Question

Error when configuring PL/SQL Access Provider.

M
Rank
Userlevel 2
Badge +6

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
[configureplsqlap]: Error when configuring PL/SQL Access Provider: ifs.fnd.base.SystemException: Failed executing statement (ORA-06550: line 8, column 10:
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

This topic has been closed for comments

10 replies

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

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,

 

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
M
Rank
Userlevel 2
Badge +6

Hi,

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

“sys.dbms_network_acl_admin does not exist”

Charith Epitawatta
Rank
Userlevel 7
Badge +31

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,

Charith - https://charith.xyz
Chathuranga Samarakoon
Rank
Userlevel 6
Badge +12

 @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;

Chathuranga Samarakoon
M
Rank
Userlevel 2
Badge +6

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.

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

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

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
M
Rank
Userlevel 2
Badge +6

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

Kasun Balasooriya
Rank
Userlevel 7
Badge +20

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. 

Kasun B - https://www.linkedin.com/in/kasunbalasooriya/
M
Rank
Userlevel 2
Badge +6

thank you

Chathuranga Samarakoon
Rank
Userlevel 6
Badge +12

@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.

Chathuranga Samarakoon
Terms & ConditionsCookie settings