/build/static/layout/Breadcrumb_cap_w.png

Oracle 11g Instant Client - AppV 5 - How to get it working?

Hi.  I'm new to AppV 5 but fairly experienced with AppV 4.6.

I'm trying to sequence the Oracle 11g Instant client currently along with InfoMaker which runs a few reports (later when Oracle works, it will be a separate package with a connection group, but as it doesn't work, I don't want to introduce issues with connection groups for now).

If I expand this package on a sequencer, it works absolutely fine.  As soon as I publish the {insert obsentity} package, I have a lovely system error, telling me the program cannot start because PBVM105.dll is missing.  With AppV 4.6 there were environment variables which had to be added to the OSD.  I have checked the manifest.XML for this package, and the variables appear to be fine.  TNSnames is available and in the correct location I have run procmon to find out what's happening - the package is looking in the correct location for the DLL and the DLL is there. 

I tried changing the install directory as recommend by some article I read on the Internet - still no joy, same error.  I have not tried enabling the PVAD and sequencing to there yet. 

Is this something I need to do?  Does anyone have a recipe for this?  From the lack of information for AppV 5 and oracle on the internet I'm assuming others are not having the same issue.

Put me out of my misery please.


If this ends up in the wrong forum - I'm sorry :S  - I'm suffering temporary insanity


3 Comments   [ + ] Show comments
  • This sounds like a missing environment variable, have you added the TNS_Admin path? Also try using the Runtime Client rather than the Instant Client. - Druis 8 years ago
  • Sorry Druis - missed your comment. TNS_ADMIN was captured during monitoring and I later (after first failure) added ORACLE_HOME. These are my variables.

    <appv:Variable Name="TNS_ADMIN" Value="[{AppVPackageDrive}]\oracle\network\admin" />
    <appv:Variable Name="ORACLE_HOME" Value="[{AppVPackageDrive}]\Oracle" />
    <appv:Variable Name="PATH" Value="[{AppVPackageDrive}]\oracle;[{AppVPackageDrive}]\oracle\bin;[{ProgramFilesX86}]\Sybase\Shared\PowerBuilder;[{ProgramFilesX86}]\Sybase\Shared\DataDirect;%PATH%;[{AppVPackageDrive}]\oracle;[{AppVPackageDrive}]\oracle\bin;[{ProgramFilesX86}]\Sybase\Shared\PowerBuilder;[{ProgramFilesX86}]\Sybase\Shared\DataDirect" />
    </appv:Include> - Bexy 8 years ago
  • >TNS_ADMIN
    Erroneous. This just tells the Client where it can find TNSNAMES.ORA. - anonymous_9363 8 years ago

Answers (15)

Posted by: Peter_a 8 years ago
White Belt
0
I'm experience the exact same problem with Oracle and App-V 5.0, did you solve the issue?

Comments:
  • Hi

    Yes I did resolve the Oracle issues but I have not managed to sequence Infomaker successfully.

    I separated the packages as they should be. The oracle package I created really without issue. Used the oracle client 11g instant client. Copied my TNSnames etc as required.

    I didn't need to set any variables as with AppV 4.6.

    Whilst in the testing stage I created a shortcut on the desktop during seqencing, to a command prompt which launched Sqlplus.exe with some supplied credentials to a database. When launching the shortcut it would tell me whether I had a successful connection or not. The Shortcut Target parameters were these:-

    C:\Windows\System32\cmd.exe /k "sqlplus.exe {Insert username, password and database here}"

    I think one of my previous issues was not understanding connection groups fully and the fact there seems to be an order in which you need to connect the apps in the group.

    Coming from AppV4.6, connection groups were a new concept.

    In short, I didn't do anything special with Oracle to package it, just ensure you set up the connection group correctly with whatever apps you need to use it with.

    Hope that gives you some assistance.

    As for Infomaker, it's on my "to do" list still, but I needed a sanity check and more experience with APPV 5 before tackling that PITA again. - Bexy 8 years ago
Posted by: anonymous_9363 8 years ago
Red Belt
0
How on earth has a PowerBuilder runtime DLL ended up in your Oracle Client set-up?

I just searched my source for Instant Client and turned up nothing for 'pbvm*.dll'
Posted by: apptopack 8 years ago
Red Belt
0
Did you sequence in a clean machine? What App-V 5.0 version are you using?
Posted by: Bexy 8 years ago
Senior White Belt
0

Thanks for the replies.

 

VBScab.  The powerbuilder DLL comes from Infomaker which is currently being sequenced with Oracle as one package until I can make this work and separate them then use connection groups.  Interestingly I have packaged Infomaker on its own and it works fine, so I feel at this stage the Oracle aspect is at fault - but you might tell me different.  If I install these apps without trying to virtualise them, the Instant client and Infomaker work fine.

 

Vigneshwaran4264.  The version of Appv 5 I am using is 5.1. 

Posted by: anonymous_9363 8 years ago
Red Belt
0
> The powerbuilder DLL comes from Infomaker which is currently being sequenced with Oracle as one package
No, no, no, NO!

Install InfoMaker on your sequencing box first (I *really* hope you're using VMs!!) then sequence the Oracle part. Once that works, sequence InfoMaker and make sure *that* works. Only then should you try to get the combination working. Any other route will drive you further down the insanity route!!
Posted by: Bexy 8 years ago
Senior White Belt
0

VBScab - Lucky my ego can take a bashing ;)  LOL - yes I am using VMs (what self respecting packager wouldn't be ;)  ).  I understand what you are saying about the separate packages and originally I did this.  I did mention I was new to AppV5 -  when I used a connection group I was getting errors.  Not knowing whether this was my lack of knowledge with connection groups, I thought I would initially package them together (thereby by- passing one potential point of failure - the connection group).

Obviously when I did package them together, I was still getting errors, hence my post.

As an aside, I can replicate this error without packaging.  If I install Infomaker and run the reports without Oracle being installed on a machine, I get the same error - therefore I am certain that oracle is the problem.

Yesterday I tried another application which uses oracle and was getting errors with that as well, so again I'm convinced that the issue is with my oracle sequencing (which I never experienced under appv 4.6).


Setting aside your feelings towards my packaging & troubleshooting ability -  I guess I should reiterate again - can someone confirm to me whether there is anything special, any gotchas, anything at all that I need to be aware of when sequencing either the Oracle Instant Client or the full client?

 

Posted by: anonymous_9363 8 years ago
Red Belt
0
Firstly, let me apologise for giving the impression that I was slighting your skills in any way. I guess that's one of the problems with the written word - it's next to impossible to convey tone.

Secondly, surely you mean you *don't* get the error if you run the report without Oracle being installed? Otherwise, the exact opposite of your assertion that "Oracle is the problem" is true.

Thirdly, it's time to roll out the VBScab "ProcMon" response! :-)
Posted by: Bexy 8 years ago
Senior White Belt
0

No apologies required VBScab - I've worked in IT long enough to have supported windows for workgroups 3.11 and had to carry the tcp/ip protocol on a floppy disk to install it along with the driver for a network card.  Unfortunately longevity in IT does not always mean common sense and ability  increase along with service.  I have broad shoulders ;)

I do mean "do get the error". To confirm, if I install infomaker on a PC (no virtualising) and do NOT install Oracle I get the same error I am experiencing within the package, which suggests to me that Oracle is not being "seen" within the bubble.

I have indeed used the illustrious Procmon (next to VM's its a packagers godsend)  prior to posting (I should perhaps have said, my bad).  As you can see from this screen shot, the path is not found, however on checking within the bubble, I can navigate to at least one instance of the DLL being in one of these locations.



Posted by: anonymous_9363 8 years ago
Red Belt
0
>WfW 3.11
Me too! Those were the days...using QEMM to stuff drivers into extended memory...Daily releases of 3Com's TCP/IP stack for LAN Manager 1.1...
Compaq's unofficial/official "drop it from 1 metre on to the workbench" fix for their 40MB drives with 'stiction'...It was still fun then [sigh]

>install Infomaker [snip] and do NOT install Oracle
>Oracle is not being seen within the bubble
Confused...how could it be seen if it's not installed?

My path would be...before doing any sequencing, install then test Infomaker. Snapshot. Install Oracle. Does Infomaker still work?

Sequence Infomaker. Snapshot. Install (not sequence) Oracle. Does Infomaker still work? Does Oracle work?

Let us know the outcome of these scenarios.
Posted by: Bexy 8 years ago
Senior White Belt
0

Showing our age, maybe that's not such a good thing!  LAN Manager 1.1!!!  Don't suppose you started life as a computer operator as well did you? - good old IBM DOS/VSE.  It seems most "old IT dogs and dogettes" started life in Operations.

1.  Infomaker and Oracle installed natively - all works fine.

2.  Infomaker sequenced works fine on its own (aspects of infomaker do no require Oracle so it can be tested).

I haven't tried Infomaker sequenced with a local install of Oracle - so that's a good point.  Will try and get back to you.

I have a small batch script written which can test a connection to one of the Oracle databases.  I think I will sequence Oracle on its own with a shortcut to this script.  I should hopefully be able to test the Oracle aspect to see if it is actually connecting to any databases or if the issue is just when Infomaker is thrown into the mix. I don't think Infomaker is the culprit though, as I said before, I tried another application with Oracle and got DLL errors as well.

  AppV 4.6 never gave me this much hassle! 



Posted by: anonymous_9363 8 years ago
Red Belt
0
No, I was never an operator. I did get saddled with managing a VMS cluster once, though...great OS, that. Such a  shame that few of its attributes found their way into Windows, something which so many of us thought was inevitable when MS poached Dave Cutler.

>4.6
Really? I've found 5.0's hit-rate for successful sequences straight out of the box to be an order of magnitude greater.

BTW, you are using 5.0 SP3, right? And do you have both options on the 'Advanced' tab checked?
Posted by: Bexy 8 years ago
Senior White Belt
0

Well give it time.  It seems to me everything is cyclical.  Mainframes were downsized and now the technology is basically back with the ESX server and VM.

4.6 - I liked it.  I have only completed 3 packages with AppV 5 (told you I was new to this version), so I can't comment on the success rate compared to 4.6.  Pretty much every issue I hit with AppV 4.6 I managed to resolve by myself or with some good googling activity (what did we do before the internet???  Our companies paid a lot more rent on extra space required by manuals!  The racks containing our main frame manuals were colossal.  It was art form just finding the error message you wanted to lookup).


Version of App V is 5.0.10107.0 which I believe is Appv5 sp3. 


I am assuming when you say advanced tab its this one:-  and there are 3 and I don't have any of them ticked.



Posted by: anonymous_9363 8 years ago
Red Belt
0
Tick the first two and re-test.
Posted by: anonymous_9363 8 years ago
Red Belt
0
A thought...have you tried sequencing Oracle Client on a 32-bit Windows implementation?

>PATH NOT FOUND
...means exactly that - the file 'appointments.EXE' can't see those paths. I think checking those 2 'Advanced' options will yield a result.
Posted by: Bexy 8 years ago
Senior White Belt
0

There I was all hopeful - opened the package, ticked the boxes, made a fresh pot of tea, confident it was all going to work.

Unfortunately - same error.  I drank the pot of tea before another expletive left my lips (I think they call it shock).

Anyhow.  I'm going to separate the packages:  ensure Oracle is working (I have a batch script to test this).  Package Infomaker and get to grips with the connection group thing which I've not done yet.  This is the correct way to do this, I know that - so that's what I will do.

I Will report back - or maybe you should watch the news for the sudden death of an IT Packaging Engineer (I am only joking before anyone thinks I'm truly suicidal).








 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ