I have everthing installed and working on the VMs but now I want to use Application Designer but I must be doing something wrong.
I installed the Oracle client on windows and created tnsnames.ora. I can't connect to the database from windows to vm.
I have some questions which might help me fix this.
The directory that was mentioned to put tnsnames.ora in (C:\app\Mike\product\11.2.0\client_1\network\admin\) was not there so I had to create it. Was that what I was supposed to do or did the install go bad?
For the windows host file what should the ip addresses be? I used the IP Addresses of the eth1 network interface from both guests which I created.
As far as the PeopleTools on windows I used PT 8.52 but with no patch will that work even though the VMs are PT 8.52.06? So if I need the patch in order for App Designer to work how can I get the patch I think I need an account to do that. I think it mentions in the OVM doc that they are included somewhere so should I use those instead?
<strike>With virtualbox vm's I assume that you mean the OVM templates converted to virtualbox.</strike>
Didn't notice the OVM category :)
Which Oracle Client installer did your use?
You could use the following download from MOS for Database 11.2..02 (since Peoplesoft database is also delivered at 18.104.22.168) Patch 10098816: 22.214.171.124.0 PATCH SET FOR ORACLE DATABASE SERVER
From the patch set download only p10098816_112020_platform_4of7.zip, which is your database client. The rest you will not need to be able to use Application Designer and Datamover.
Once downloaded start the installer and choose option Runtime (do not choose Instant Client or Administrator).
Now that you have your connectivity, you can start the PIA-AppBatch vm.
switch to psadm2 user and go to $PS_HOME.
Here you will find two files
toolsclient.zip (PeopleTools 8.52, use client only)
toolspatchvcd.zip (PeopleTools patch 8.52.06, , use client only)
Copy these files to your windows workstation and install them in that order.
Copy the tnsnames from the Database vm to your oracle client install dir network\admin dir and you should be ready to start using Application Designer/Datamover.
For more detailed information see the post from Nicolas:
Try this [url https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10098816&aru=13246067&release=80112020&plat_lang=233P&patch_num_id=1294815&]link and login with your oracle account.
Or use [url http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html]Oracle Client 126.96.36.199