Hi Vivek,
Thanks for your response.
I have checked with our DBAs and have confirmed that the parameters have
been set as per BMC recommendation.
Tried setting use_zero_copy_io=false but it did not solve the problem as
well.
I tried going into silent install mode and got this error:
(Oct 17 2014 10:48:02.271 AM
-0500),SEVERE,com.bmc.install.product.bsm.arsuitekit.tasks.ARServerOracl
eManageDatabaseTask,
LOG EVENT {Description=[Error while exporting the
tablespace],Detail=[Failed to import the tablespace[Exception running
command: Cannot run program "\bin\imp" (in directory
"C:\Users\myuser\AppData\Local\Temp\Utilities\rik"): CreateProcess
error=3, The system cannot find the path specified
]]}
I have set ORACLE_HOME to D:\Oracle\product\11.2.0\client_1\bin (also
tried D:\Oracle\product\11.2.0\client_1) but both didn't work. PATH
also contains the path to the oracle client's bin directory as well so
not sure why it's not able see imp.exe in there.
Regards,
Aedrian
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Patil, Vivek
Sent: Thursday, October 16, 2014 11:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Stuck at Executing SQLs in 8.1 Stack Installer
**
Hi Aedrian,
Can you please refer
https://docs.bmc.com/docs/display/public/itsm81/Configuring+Oracle+datab
ases
And
https://docs.bmc.com/docs/display/public/itsm81/Installing+the+BMC+Remed
y+ITSM+Suite+Preconfigured+Stack
In your case we would recommend you to review Oracle Configuration as
provided by BMC. Let us know the results.
NOTE :
#For 8.1 ITSM and Oracle 11g we observed installer hanging once. #ORACLE
Bug ID is: 13017584
The workaround for hang issue is to make use of Special Oracle
parameters for "_use_zero_copy_io=false".
Define this parameter in init.ora file for the instance and restart DB.
(You can find this file under <DB HOME>\database directory. Generally
this file is named as "init<ORACLE_SID>.ora".)
Thanks,
Vivek
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Aedrian Escultura
Sent: Thursday, October 16, 2014 8:25 PM
To: arslist@ARSLIST.ORG
Subject: Stuck at Executing SQLs in 8.1 Stack Installer
**
Hi ARSList,
Has anyone ever encountered an issue running the 8.1 stack installer -
particularly at the Execute SQLs part? (Screenshot attached)
I can see that it was able to create only the ACTLINK table, nothing
after that. DB sessions are all inactive.
Even the C:\Users\myuser\AppData\Local\Temp\ARSystemDBImport.log does
not contain anything.
Appreciate any help you can provide.
Windows Server 2008
Oracle 11g R2
Thanks,
Aedrian
This email, including any attachments, is confidential. If you are not
the intended recipient, you must not disclose, distribute or use the
information in this email in any way. If you received this email in
error, please notify the sender immediately by return email and delete
the message. Unless expressly stated otherwise, the information in this
email should not be regarded as an offer to sell or as a solicitation of
an offer to buy any financial product or service, an official
confirmation of any transaction, or as an official statement of the
entity sending this message. Neither Macquarie Group Limited, nor any of
its subsidiaries, guarantee the integrity of any emails or attached
files and are not responsible for any changes made to them by any other
person.
_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
