Oracle 12C hangs with while doing unattended installation

[Isha G]

Oracle 12C hangs while doing unattended installation.

setup.exe keeps on running and there is no progress with it on the Windows Server 2012.

the tasks that I am using is :

  - name: install oracle 12c database

    win_command: c:\database\setup.exe -silent -waitforcompletion '-responseFile c:\database\db_1.rsp'

    args:

      chdir: c:\database

Can someone let me know what the issue maybe?

[Jean-Yves LENHOF]

Try running it without ansible... There's probably a requirement which is not OK, so the installer ask for input but it is not possible in ansible

--
Envoyé de mon appareil Android avec Courriel K-9 Mail. Veuillez excuser ma brièveté.

[Isha G]

Works when run manually. 

Even with ansible, when we run the playbook the setup.exe is running but it's 0% CPU and

I am not sure typically how long it would take for the installation would complete but hours on end it's just running on ansible.

but locally it got completed within a few hours.

[Isha G]

Can someone please help? The system still gets stuck with setup.exe at 0 % CPU and keeps the installation of Oracle 12 c running.

but it's not moving forward at all.

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/3b67b59c-35e4-49f5-9332-06d2a8ddf0d5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Karl Auer]

Make sure that you have removed ALL Oracle-related environment variables and try it again manually. I reckon there is something that is NOT in the response file, but that is supplied via another channel such as an environment variable when you do it manually.

It definitely sounds as if the setup is waiting for manual input.

You need a logfile showing the process...

Regards, K.

On Mon, Sep 24, 2018 at 12:21 AM, Isha G <jee....@gmail.com> wrote:

Can someone please help? The system still gets stuck with setup.exe at 0 % CPU and keeps the installation of Oracle 12 c running.

but it's not moving forward at all.

On Fri, Sep 21, 2018 at 5:08 PM Isha G <jee....@gmail.com> wrote:

Works when run manually. 

Even with ansible, when we run the playbook the setup.exe is running but it's 0% CPU and

I am not sure typically how long it would take for the installation would complete but hours on end it's just running on ansible.

but locally it got completed within a few hours.

On Friday, September 21, 2018 at 4:44:17 PM UTC+5:30, Jean-Yves LENHOF wrote:

Try running it without ansible... There's probably a requirement which is not OK, so the installer ask for input but it is not possible in ansible

Le 21 septembre 2018 13:10:33 GMT+02:00, Isha G <jee....@gmail.com> a écrit :

Oracle 12C hangs while doing unattended installation.

setup.exe keeps on running and there is no progress with it on the Windows Server 2012.

the tasks that I am using is :

  - name: install oracle 12c database

    win_command: c:\database\setup.exe -silent -waitforcompletion '-responseFile c:\database\db_1.rsp'

    args:

      chdir: c:\database

Can someone let me know what the issue maybe?

--
Envoyé de mon appareil Android avec Courriel K-9 Mail. Veuillez excuser ma brièveté.

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.

To unsubscribe from this group and stop receiving emails from it, send an email to ansible-project+unsubscribe@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/3b67b59c-35e4-49f5-9332-06d2a8ddf0d5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "Ansible Project" group.

To unsubscribe from this group and stop receiving emails from it, send an email to ansible-project+unsubscribe@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAKvY8Ft3J56dB%3DOMa%2Bix5x6h7RXL4ujsK5O10XHgw%2BS_qcE%2BGg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Karl Auer

Email  : ka...@2pisoftware.com
Website: http://2pisoftware.com

GPG/PGP : F0AB 6C70 A49D 1927 6E05 81E7 AD95 268F 2AB6 40EA
Previous: 56DF D7B9 57B8 DC67 5070 75A6 2784 37B7 5F07 51F6

[Isha G]

I have tried it several times manually with proper cleanup and it has worked everyone with this answer file. What I see while installing through Ansible is it starts the setup.exe but the other screen of command line Oracle universal installer doesn't pop up during installation through Ansible. Is there anyway I can set this up for Ansible? I am new to Ansible, please help.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CA%2B%2BT08SjDhVVmbVSGxB7paeVo%3DfXb3jA0NnJwjnZ3A3Q0ppg%2BQ%40mail.gmail.com.

[Karl Auer]

What exactly are you expecting to see "pop up"?

Regards, K.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAKvY8FuJ5ssXuUesvsXF8%2BGh7AL_3u4rxjX7ocC1bSCQ%2Br3_NA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[Isha G]

Thanks for the quick reply. I see Oracle universal installer window open up when I run this manually through power shell or command line. I didn't see either anything popping up while installing through sensible nor is the installation moving forward. No app folder is created or setup.exe also does not use any CPUs i am using -waitforcompletion switch and -ignoreSysPrereqs switch as well apart from -silent and responsefile

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CA%2B%2BT08TkCuN1qdqEQ6cvEnz%3D8%3DsuvPLshRP%3DNRim24veEtNjpw%40mail.gmail.com.

[Isha G]

Anyone else online? Please help with this issue.

[Varun Chopra]

Can you install it remotely via invoke-command?

[Isha G]

I have just tried it locally and manually and it works every time. I just created a couple of new Windows servers and installing it with ansible hangs again so it does not seem to be a cleanup issue.                                              

On Sunday, September 23, 2018, Varun Chopra <ranch...@gmail.com> wrote:

Can you install it remotely via invoke-command?

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.

To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/9521693a-69d2-4cdb-a16b-cde2f135bd46%40googlegroups.com.

[Varun Chopra]

That wasn't my question though.

If you can run it remotely from another windows vm you should be able to see where it breaks side-by-side. Also, is there a reason you're not using win_package?

[Isha G]

For SQL we used win_command so I thought that should work for Oracle but it doesn't seem to work. Should I try through remote power shell ?

On Sunday, September 23, 2018, Varun Chopra <ranch...@gmail.com> wrote:

That wasn't my question though.

If you can run it remotely from another windows vm you should be able to see where it breaks side-by-side. Also, is there a reason you're not using win_package?

On Sunday, September 23, 2018 at 10:49:19 PM UTC+5:30, Isha G wrote:

I have just tried it locally and manually and it works every time. I just created a couple of new Windows servers and installing it with ansible hangs again so it does not seem to be a cleanup issue.                                              

On Sunday, September 23, 2018, Varun Chopra <ranch...@gmail.com> wrote:

Can you install it remotely via invoke-command?

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/9521693a-69d2-4cdb-a16b-cde2f135bd46%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.

To unsubscribe from this group and stop receiving emails from it, send an email to ansible-project+unsubscribe@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/c5241128-da63-4615-8780-3d3aff376e15%40googlegroups.com.

[Varun Chopra]

For msi and exe packages - use win_package as a rule of thumb. If you still have issues with these, you can report an issue here https://github.com/ansible/ansible/issues because the module's supported by the community.

win_command shouldn't be used for installations as it usually ends up in a hit or a miss situation. If win_package doesn't work for you, you can try putting your win_command arguments as a pwsh script, saving it on the target node, and running that script through a remote powershell session. If you don't know how to do that, you can look up invoke-command or new-pssession. Ansible uses winrm as well so any issues you have with ansible should be visible by running this script remotely.

On Sunday, September 23, 2018 at 11:07:17 PM UTC+5:30, Isha G wrote:

For SQL we used win_command so I thought that should work for Oracle but it doesn't seem to work. Should I try through remote power shell ?

On Sunday, September 23, 2018, Varun Chopra <ranch...@gmail.com> wrote:

That wasn't my question though.

If you can run it remotely from another windows vm you should be able to see where it breaks side-by-side. Also, is there a reason you're not using win_package?

On Sunday, September 23, 2018 at 10:49:19 PM UTC+5:30, Isha G wrote:

I have just tried it locally and manually and it works every time. I just created a couple of new Windows servers and installing it with ansible hangs again so it does not seem to be a cleanup issue.                                              

On Sunday, September 23, 2018, Varun Chopra <ranch...@gmail.com> wrote:

Can you install it remotely via invoke-command?

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/9521693a-69d2-4cdb-a16b-cde2f135bd46%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.

[Jordan Borean]

It's very hard for us to help you in this situation but basically it boils down to you running these checks and finding out what is causing the program to hang;

* Use something like procexp to see if the setup.exe process is spawning any child processes that are running in the background

* Ensure your quoting is not screwing up the install process, in your first example you have quoted the responseFile path arg but you don't need this quoted.

* Try and replicate this through another WinRM session like PowerShell's Invoke-Command or Enter-PSSession

* Use Ansible become on the task to escape the boundary of the WinRM logon and run through a psuedo-interactive process

* See if there is any logging you can enable on the Oracle installer, this could tell you the stage it is up to and what it may be waiting on

As for why you cannot see it when running through Ansible, Ansible uses a completely separate session to run your processes as any normal interactive logon. This is not unique to Ansible but how Windows treats things like network logons such as WinRM.

Thanks

Jordan

[Will McDonald]

In addition to Jordan's recommendations, have you created an oraInventory? I haven't automated the OUI on Windows but generally, on *nix platforms you need to manually create an empty OUI inventory with the appropriate ownerships and permissions. (You can work this out from a successful install but on a Linux-based host it would be similar to:

# Make an ORACLE_BASE
mkdir -p /u01/app/oracle/
chown -R oracle:oinstall /u01

# Create the Oracle Inventory
cat > /etc/oraInst.loc <<EOF
inventory_loc=/u01/app/oracle/oraInventory
inst_group=
EOF
chown oracle:oinstall /etc/oraInst.loc
chmod 664 /etc/oraInst.loc

Also, as you've been advised more than once, check the OUI logs. This is slightly older 11g documentation but the general gist still applies: https://docs.oracle.com/cd/B28359_01/em.111/b31207/b_oui_appendix.htm#CHDBDFIF1

Cheers,

Will.

--

You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/e2e0f876-862d-4b74-a045-93f0f74355fd%40googlegroups.com.

[Isha G]

Hi,

Thanks for the replies.

I have the same issues with the with remote powershell.

I still see 0% CPU utilization. I am not sure how to move forward. I am still seeing the same issues.

--

You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/e2e0f876-862d-4b74-a045-93f0f74355fd%40googlegroups.com.

[Isha G]

Hi,

Same thing happens with remote Powershell and I understand this may not be Ansible issue.

Any suggestions? From Oracle 12 c side

[Isha G]

I have found a blog actually and I am working on it.

Thanks a lot for all the suggestions.

[anonymus]

can you please share the blog link. (just for later reference in this thread)

[goforawalktwice]

See https://stackoverflow.com/questions/53244913/oracle-12c-client-install-hangs-silent-unattended