Skip to main content
Solved

IFS Cloud 22R2 installation issue (ORA-28009: connection as SYS should be as SYSDBA or SYSOPER)

  • January 6, 2023
  • 4 replies
  • 294 views

Forum|alt.badge.img+4

Hi 

When I try to execute the CMD of IFS Cloud 22R2 DB installation, a connection error was shown as below. I have completed the pre-installation (eg. Oracle installation).  Did I miss something.

CMD: .\installer.cmd --set action=dbinstaller --values ifscloud-values.yaml --values solutionset.yaml --set dbInstaller.sysPassword=******

Error:  ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

 

 

Thanks & Best regards

Best answer by Shirantha Herath

Hi @peak0610 ,

Please append the below installation parameters to the command.

--dbInstaller.sysPassword=****  --set dbInstaller.connectRole=SYSDBA

4 replies

william.klotz
Superhero (Customer)
Forum|alt.badge.img+21
  • Superhero (Customer)
  • 479 replies
  • January 6, 2023

Hi @peak0610 ,

 

I've not installed IFS Cloud yet but the error indicates you need to login as SYS but elevate the user to SYSDBA.  When I have to login as SYS and elevate to SYSDBA I login using SYS as SYSDBA where I specify the username then enter my password.   So I suspect you need to use SYS as SYSDBA wherever you put the user SYS.

 

Regards,

William Klotz


Forum|alt.badge.img+4
  • Author
  • Do Gooder
  • 7 replies
  • January 6, 2023

Hi @william.klotz 

Thanks for your kind reply.

In order to elevate to SYSDBA, I tried to modify the CMD as below, it’s successful. Thanks so much!

CMD: .\installer.cmd --set action=dbinstaller --values ifscloud-values.yaml --values solutionset.yaml --set dbInstaller.sysPassword=******  --set dbInstaller.connectRole=SYSDBA
 

Thanks & Best regards


Forum|alt.badge.img+7
  • Hero (Employee)
  • 40 replies
  • Answer
  • January 6, 2023

Hi @peak0610 ,

Please append the below installation parameters to the command.

--dbInstaller.sysPassword=****  --set dbInstaller.connectRole=SYSDBA


Forum|alt.badge.img+13
  • Hero (Partner)
  • 135 replies
  • January 6, 2023

--set dbInstaller.connectRole=SYSDBA should work in this case but just wondering if you try to connect to the database from SYS user outside the DB server from sqlplus or plsql developer are you getting the same issue?