Question

Ifscloud remote deployment dbinstaller ora-errors

  • 5 September 2022
  • 4 replies
  • 455 views
R
Rank
Badge +5

Windows Management Server: Win 10

Middleware Server                      : Ubuntu 22.04 LTS Server edition in VM

Database                                        : Oracle 19c on Windows

 

Overview:

Explorative build on laptop to identify steps/procedures before On Premise/Cloud

Remote deployment of IFSCloud 22.1.4

 

Issue:

Ifscloud remote deployment dbinstaller ora-errors few resolved

Few remaining.

 

Steps:

Database created and configured per below guidelines

https://docs.ifs.com/techdocs/22r1/070_remote_deploy/010_installing_fresh_system/030_preparing_server/107_oracle19c_windows/

Run ifscloud database installation through below step

PS C:\ifs\buildlocal\ifsroot\deliveries\build-home\ifsinstaller> .\installer.cmd --set action=dbinstaller --values C:\ifs\buildlocal\ifsroot\config\ifscloud-values.yaml --set dbInstaller.sysPassword='Simple_12345' --set dbInstaller.ifsappPassword='Simple_12345'  --set ifscore.passwords.ifsiamPassword.data='Simple_12345'  --set ifscore.passwords.ifssysPassword.data='Simple_12345' --set ifscore.passwords.ifsmonPassword.data='Simple_12345' --debug --set dbInstaller.extLogging=Y

 

Output:

======================================================

Below errors did not appear after adding to the top of prepare.sql

alter session set "_ORACLE_SCRIPT"=true;

======================================================

!!!Error deploying file CreateIFSUserProfile.sql at 01-SEP-22 16:55:37

ORA-65140: invalid common profile name

 

!!!Error deploying file CreateIFSUsers.sql at 01-SEP-22 16:55:37

ORA-65096: invalid common user or role name

 

!!!Error deploying file EnableEditions.sql at 01-SEP-22 16:55:37

ORA-01918: user 'IFSINFO' does not exist

 

!!!Error deploying file InstallTem.cre at 01-SEP-22 16:55:37

ORA-01918: user 'IFSAPP' does not exist

 

!!!Error deploying file InstallTem.api at 01-SEP-22 16:55:37

!!!PACKAGE INSTALL_TEM_SYS created with compilation errors

ORA-01435: user does not exist

 

!!!Error deploying file InstallTem.apy at 01-SEP-22 16:55:37

!!!PACKAGE BODY INSTALL_TEM_SYS created with compilation errors

ORA-01435: user does not exist

 

!!!Error deploying file IalObjectSlave.api at 01-SEP-22 16:55:37

!!!PACKAGE IAL_OBJECT_SLAVE_API created with compilation errors

ORA-01435: user does not exist

 

!!!Error deploying file IalObjectSlave.apy at 01-SEP-22 16:55:37

!!!PACKAGE BODY IAL_OBJECT_SLAVE_API created with compilation errors

ORA-01435: user does not exist

 

!!!Error deploying file prepare.sql at 01-SEP-22 16:55:37

BEGIN

 IFSAPP.Install_Tem_SYS.Disable_Ial_Scheduler_Proc__;

END;

ORA-06550: line 2, column 2:

PLS-00201: identifier 'IFSAPP.INSTALL_TEM_SYS' must be declared

 

!!!Error deploying file IalGrant.sql at 01-SEP-22 16:55:37

ORA-04042: procedure, function, package, or package body does not exist

 

!!!Error deploying file prepare. SQL at 01-SEP-22 16:55:37

BEGIN

 IFSAPP.Install_Tem_SYS.Enable_Ial_Scheduler_Proc__;

END;

ORA-06550: line 2, column 2:

PLS-00201: identifier 'IFSAPP.INSTALL_TEM_SYS' must be declared

 

!!!Error deploying file CamundaInstall.api at 01-SEP-22 16:55:37

!!!PACKAGE CAMUNDA_INSTALL_SYS created with compilation errors

ORA-01435: user does not exist

 

!!!Error deploying file CamundaInstall.apy at 01-SEP-22 16:55:38

!!!PACKAGE BODY CAMUNDA_INSTALL_SYS created with compilation errors

ORA-01435: user does not exist

 

!!!Error deploying file IfsCamSysGrant.sql at 01-SEP-22 16:55:38

!!!Error occurred while executing Plsql Block

ORA-04042: procedure, function, package, or package body does not exist

 

!!!Error deploying file prepare.sql at 01-SEP-22 16:55:38

BEGIN

 IFSAPP.Install_Tem_SYS.Enable_All_Queues__;

END;

ORA-06550: line 2, column 2:

PLS-00201: identifier 'IFSAPP.INSTALL_TEM_SYS' must be declared

 

!!!Error deploying file prepare.sql at 01-SEP-22 16:55:38

BEGIN

 IFSAPP.Install_Tem_SYS.Create_Context__;

END;

ORA-06550: line 2, column 2:

PLS-00201: identifier 'IFSAPP.INSTALL_TEM_SYS' must be declared

 

=====================

Below errors still present

=====================

!!!Error deploying file EnableEditions.sql at 02-SEP-22 14:14:44

ORA-38813: editions not supported for schema IFSINFO

 

!!!Error deploying file rmpanl\security_exchange_sync_user.ins at 02-SEP-22 15:03:29

ORA-01917: user or role 'MASTER_SYNC_ROLE' does not exist

 

!!!Error deploying file rmpanl\security_exchange_sync_user.ins at 02-SEP-22 15:03:29

BEGIN

   Security_SYS.Grant_System_Privilege('IMPERSONATE USER', 'MASTER_SYNC_ROLE');

END;

ORA-20111: FndRole.FND_RECORD_NOT_EXIST: The  does not exist.

 

!!!Error deploying file rmpanl\POST_Rmpanl_SyncUser.sql at 02-SEP-22 15:55:06

ORA-20111: FndRole.FND_RECORD_NOT_EXIST: The Fnd Role does not exist.

3 Attachments

4 replies

Chandana Gunasekara
Rank
Userlevel 5
Badge +10

Hope this link will be helpful.

 

https://docs.ifs.com/techdocs/22r1/070_remote_deploy/010_installing_fresh_system/200_installing_ifs_cloud/050_deploy_db/020_file_and_database/

 

looks like the users were not created.check prepare.sql 

All or some of the parameters passed to the installer above can be stored in a values yaml file.
e.g. .\installer.cmd --values values.yaml --set dbInstaller.sysPassword= <password>

Chandana
R
Rank
Badge +5

Hope this link will be helpful.

 

https://docs.ifs.com/techdocs/22r1/070_remote_deploy/010_installing_fresh_system/200_installing_ifs_cloud/050_deploy_db/020_file_and_database/

 

looks like the users were not created.check prepare.sql 

All or some of the parameters passed to the installer above can be stored in a values yaml file.
e.g. .\installer.cmd --values values.yaml --set dbInstaller.sysPassword= <password>

 

Appreciate the reply.

 

Following Guidelines Deploying IFS Cloud.

 

Prepare sql was executed and it fails with ora errors specified above.

Tried with and without adding the values/config files 

ex:

.\installer.cmd --set action=dbinstaller --values C:\ifs\buildlocal\ifsroot\config\ifscloud-values.yaml  --logLevel=FINEST --debug --set dbInstaller.extLogging=Y --set logFileLocation= C:\ifs\buildlocal\ifsroot\logs

 

What is the issue ?

dbinstaller fails due to below ora error and entire database deployment fails

ORA-65140: invalid common profile name

 

What was done for dbinstaller to succeed/proceed ?

prepare.sql was modified and below was added in the beggining

alter session set "_ORACLE_SCRIPT"=true;

This is undocumented and is not a proper fix,

it  was undertaken to see if this resolves the issue temporarily for database deployment to continue.

The alter session, helps in dbinstaller to continue but still ora errors are present in the

final database deployment.

 

Attaching config files used during Deploying database.

 

Appreciate issue resolution.

 

 

2 Attachments
B
Rank
Badge +1

Did this issue get resolved? I get the same error when attempting to install IFS Cloud.

TecAnshuA
Rank
Userlevel 2
Badge +6

Hi,

I hope the issue is resolved till now but if not try to use PDB instead of CDB in the connection string,

 

Note: Even if it is possible, it is not allowed to install IFS Cloud in the CDB and there are no warnings in the IFS Installer Tool if you try to do this. You must always install IFS Cloud in the PDB.

Reply


Terms & ConditionsCookie settings