Deploy Oracle

[Brian P]

Hi,

 

I need to deploy Oracle database client 11 g to some of our already installed client devices and thou OSD deployment. I did some research how other did it but couldn't find a way which matched out company.

 

I read that is should work to install it as a task sequence with only one command, but I was not able to make it work. So I made a good old fashion batch-file.

@echo offnet use /delete N:
net use N: "\\Server\windows\Oracle\Oracle 11gR2\x86\client" /USER:domain\cm_jd xxxxxx
N:

REM Set TMP=C:\TEMP\Oracle
REM Set TEMP=C:\TEMP\Oracle

setup.exe -silent -nowelcome -responseFile "N:/response/NetListner.rsp"

echo Installing Oracle 11g with NetListner please wait..
Timeout /t 60 /NOBREAK > NUL
echo Copy tnsnames\tnsnames.ora to C:\Oracle\11.2.0\NETWORK\ADMIN\
Timeout /t 5 /NOBREAK > NUL
copy tnsnames\tnsnames.ora C:\Oracle\11.2.0\NETWORK\ADMIN
C:
net use /delete N: /y
echo Installation completed..
Timeout /t 5 /NOBREAK > NUL

It works but there must be a better way?

 

Best regards,

Brian Pedersen

[Peter van der Woude]

Why wouldn't you put the response file in your package?

[Brian P]

Hi Peter,

 

Sorry for my late reply, I have been struggling with my image.

 

If I create it as a application, with the commandline below it installs correct. But returns as installed failed long before the installation is completed.

setup.exe -silent -nowelcome -noconfig -responseFile "\\server\Oracle 11gR2\x86\client\response\NetListner.rsp" or

setup.exe -silent -nowelcome -noconfig -nowait -responseFile "\\server\Oracle\Oracle 11gR2\x86\client\response\NetListner.rsp"

[Peter33]

Check out the client installation log file to see what's going on.

[oxyle]

Did you check out the maximum run-time of the created application? You can check it by going to the Deployment Type of the specific application and go to the tab "User Experience".

 

[Brian P]

HI Kevin and Peter

 

I used the default setup (120 min) for the deployment.

 

I think I found the problem in the AppEnforce.log. When the setup complets it look for the software and fails to find it.

Because its a script installation I'm forced to have a detection method. I Made this setting:

 

Setting Type: File System

Type: File

Path: C:\Oracle\11.2.0\NETWORK\ADMIN

File or folder name: sqlnet.ora

 

If I look at the client where I deployed Oracle sqlnet.ora is located in the correct folder.

 

 

AppEnforce.log:

<![LOG[    App enforcement environment: 
Context: Machine
Command line: setup.exe -silent -nowelcome -noconfig -nowait -responseFile "\\Server\windows\Oracle\Oracle 11gR2\x86\client\response\NetListner.rsp"
Allow user interaction: No
UI mode: 1
User token: null
Session Id: 2
Content path: C:\WINDOWS\ccmcache\3q
Working directory: ]LOG]!><time="21:09:43.843-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appcontext.cpp:85">
<![LOG[    Prepared working directory: C:\WINDOWS\ccmcache\3q]LOG]!><time="21:09:43.844-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appcontext.cpp:189">
<![LOG[    Prepared command line: "C:\WINDOWS\ccmcache\3q\setup.exe" -silent -nowelcome -noconfig -nowait -responseFile "\\Server\windows\Oracle\Oracle 11gR2\x86\client\response\NetListner.rsp"]LOG]!><time="21:09:43.847-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appcontext.cpp:338">
<![LOG[    Executing Command line: "C:\WINDOWS\ccmcache\3q\setup.exe" -silent -nowelcome -noconfig -nowait -responseFile "\\Server\windows\Oracle\Oracle 11gR2\x86\client\response\NetListner.rsp" with user context]LOG]!><time="21:09:43.847-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appexcnlib.cpp:201">
<![LOG[    Working directory C:\WINDOWS\ccmcache\3q]LOG]!><time="21:09:43.847-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appexcnlib.cpp:215">
<![LOG[    Post install behavior is BasedOnExitCode]LOG]!><time="21:09:44.278-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appcommon.cpp:1094">
<![LOG[    Waiting for process 3840 to finish.  Timeout = 120 minutes.]LOG]!><time="21:09:44.286-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appexcnlib.cpp:1958">
<![LOG[    Process 3840 terminated with exitcode: 0]LOG]!><time="21:10:03.203-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appexcnlib.cpp:1967">
<![LOG[    Looking for exit code 0 in exit codes table...]LOG]!><time="21:10:03.204-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appexcnlib.cpp:505">
<![LOG[    Matched exit code 0 to a Success entry in exit codes table.]LOG]!><time="21:10:03.204-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appexcnlib.cpp:584">
<![LOG[    Performing detection of app deployment type 11 g(ScopeId_C558CBE6-72DB-4551-8F57-B64B2C9D4A84/DeploymentType_7448ba01-0b97-47e7-98d5-aad826ec185b, revision 8) for system.]LOG]!><time="21:10:03.215-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appprovider.cpp:2148">
<![LOG[+++ Application not discovered. [AppDT Id: ScopeId_C558CBE6-72DB-4551-8F57-B64B2C9D4A84/DeploymentType_7448ba01-0b97-47e7-98d5-aad826ec185b, Revision: 8]]LOG]!><time="21:10:03.245-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="localapphandler.cpp:291">
<![LOG[++++++ App enforcement completed (19 seconds) for App DT "11 g" [ScopeId_C558CBE6-72DB-4551-8F57-B64B2C9D4A84/DeploymentType_7448ba01-0b97-47e7-98d5-aad826ec185b], Revision: 8, User SID: ] ++++++]LOG]!><time="21:10:03.246-120" date="06-25-2014" component="AppEnforce" context="" type="1" thread="3652" file="appprovider.cpp:2448">

[Peter33]

<![LOG[++++++ App enforcement completed (19 seconds) for App DT "11 g"

Well, you can't expect the file to be present after 19 seconds.

 

Best way to deploy the client is to create a Batch file and call the setup from there.

Also put the response file in the source directory.

pushd %~dp0
start /wait setup.exe -silent -nowelcome -nowait -responseFile "%~dp0NetListner.rsp"
popd

Edit:

 

OK, i just checked our current command line

this should do the trick

pushd %~dp0
setup.exe -silent -nowelcome -responseFile "%~dp0NetListner.rsp" -force -waitforcompletion -nowait -noconsole
popd

[Brian P]

Hi Peter

 

Sorry for my late reply. I've been on vacation for some time, which was very good for me and the office, cause I really have been struggling with this! :-)

 

I found out if I try to deploy it as an application using script it fails but if I deploy it good old fashioned way as a package it works.

 

Thanks for your help.

 

Best regards

Brian P.

[fishburn26]

Hi, Brain, could you document the steps you talk to deploy this application because you mentioned on 22 July, That you got it working. ;0)

 

Screenshots would be great

thanksin advance

 

Paul