Here’s Part-2 of the installation guide – this one covers PeopleTools Setup, installing Application Designer and the Oracle 12c client, along with miscellaneous WinSCP and Putty installations.
PeopleTools_855_Installation_Guide_Part_2
Here’s Part-1!!
Hope this helps! 🙂
Hey Mani,
Great docs, thanks for sharing.
Got a couple of questions that you can probably help me with:
1. In point #9 of the second doc you mentioned to look for the tnsnames.ORA file in the Samba shared folder. Where is that? I just see a pi_home full of subfolders with no sense. In my case I just modified a previous tns entry, having an issue because the new database is not using SID but Service_name
2. How can you access trace/log/output files? I am running some processes in PUM but the payroll one is finishing in error. I just want to check the log files but it is always opening a new empty browser window. So wondering if is there a way to directly open the corresponding folders for ps_reports.
regards,
Rafa
Hi Rafa,
If your PeopleTools script had completed execution successfully, this is what you need to do:
1. Login to your Guest OS, in Linux as root and type the ifconfig command
2. Copy the IP address of your VM
3. In your host OS(Windows), Open the Run prompt and enter \\IP_Address
4. You should be able to see the ORA file most likely inside the oracle-client folder.
Please let me know, if you’re still unable to access the ORA file.
-Mani
Hey Rafa,
Missed couple of your questions:
1. Yes, the service_name is gonna be the way going forward, so I think you’re good with that. In case you need contents of the ORA file, please let me know, I can copy paste as a comment
2. If you check at the end of the second document, I’ve given steps to install WinSCP , which is a freeware. Works great if you’d need a GUI to access all files from your server.
Hope this helps!
Thanks Mani.
I have now used WinSCP and that allowed me to access the files.
Me again 🙂
Let me please ask you another couple of questions:
1- I have switched to classical mode instead of Fluid. When navigating to any page, it looks weird, like not correctly loading the stylesheet or something. Do you have that issue?
2- I am trying to run payroll but GPPDPRUN always runs to error with nothing on the log. Is like not doing anything. Support told me to Flush shared pool, but SYSADM user has no sysdba access. Any idea on the user to use with those priviledges?
thanks in advance,
Rafa
1 – nope, I don’t get that issue
2 – GPPDRUN is a cobol process, I presume? Sorry, have no experience with that. Please do let me know if you find a solution for that..
Thanks,
Mani
Hi Mani,
Thank you for the great work.
Quick question. Do you have any intention doing DPK installation on linux bare-metal. If you than a new document for that would be a Christmas treat.
Regards
Hi Mani,
Please share the documentation if you have done DPK installation on linux (bare-metal). That would be much appreciated as your other posts.
Thanks
Hi Saad,
Thanks for commenting!
I am actually planning on doing a DPK installation on both Linux and Windows – on spare laptops. But, with the slow internet I have, it is a herculean task – it would take atleast a month for me to download the entire set of zip files 🙂
Nevertheless, I would definitely be doing a post on a bare-metal install. Just that it would a while for me to be ready with the files required. 🙂
That’s a wonderful news … I can imagine how slow the download process could be but still a month wait is worth it… 🙂
Thanks once again for wonderful work.
Regards
Saad
Hi Mani,
Any update on documentation for DPK installation on linux.
Thanks
Hi Saad – not yet.. I had some issues with the downloaded files, so have started downloading again.. Will definitely do a post on them once I get the proper files.
Thank you so much.
No problem 🙂 What is the Linux version that you’ve been trying to get the DPK working? For playing around with the instance? Is that it?
the oracle certified VM VirtualBox 4.3.32
Saad – not the VirtualBox version.. I meant the Linux version.. Oracle Enterprise Linux you mean?
I am sorry for it. Linux 7.0 is the one .
Thank you
Saad
Hi Saad – the downloads are almost complete 🙂 The Linux variant you’re referring to is Oracle Enterprise Linux, correct?
Mani,
Yes
Regards
Hi Mani….
You have always been helpful…Thanks for that…I am a regular follower of your blog…
I am trying to install HR 9.2 image 18…I think its the same as 16…But I am not able to locate the Oracle Installation directory and the 8.55 Configuration manager & App Designer after running the SetupPTClient batch…Am I missing something??
Well…I found that but I get an error “missing or invalid sql library psora64” while accessing App Designer…Any ideas, how to resolve that…I googled that a bit but not convinced…
Hi Subh – Thanks a lot for your comments 🙂
Can you please check if the ORACLE_HOME and ORACLE_SID variables have been set?
for ORACLE_HOME it should be C:\oracle\product\12.1.0\client_1\ and for ORACLE_SID, it should be your database name – FS92U0016 or whatever database name you have provided.
Please do let me know if the issue still persists.
Hope this helps!
Thanks Mani…It worked… 🙂
But now the below I am getting the below Error:
File: SQL Access ManagerSQL error. Stmt #: 1 Error Position: 0 Return: -1
Any Solution….Thanks in Advance…
have you tried pinging your database from command prompt?
Run > cmd and type TNSPING HR92U016
and see if you get proper results. If you don’t, check if this post helps:
Might be an issue with the IP address being used.
Hope this helps! 🙂
Yup…Thanks Mani…I got it resolved by changing / adding some entries in tnsnames.ora…Till then I was not able to ping the DB and adding the ip in the Host file…I did that by googling…However, you have a simple doc (given link)….Thanks Mani for your help throughout the issue…
No problem at all 🙂 Happy to help! 🙂
Subh – alternatively, you can type the following from an administrator command prompt:
SET ORACLE_HOME=C:\oracle\product\12.1.0\client_1\
and the same for ORACLE_SID =
Hope this helps!
Mani,
Thanks a lot for your great documentation. Its really helpful.
regards
Norfaiza
Hi Norfaiza – happy to help 🙂
Hi Mani
Many thanks for the guides – they are fantastic.
One question – have you ever encountered Change Assistant saying there is already an instance running when you try to log in to it?
Hi Trudy – Happy to help! Are you running the Change Assistant executable as an Administrator?
Can you please run as an administrator and see if that helps?
Hi Mani
Yeap running as administrator fixed the message.
Many thanks
Happy to help! 🙂
Hi Mani,
This is one of those basic questions but one that has me perplexed (these questions are based around running the PUM images on VirtualBox on a windows laptop) – why do I need to install Putty and WinSCP. I sort of understand that you need WinSCP to do the file transfer (so to have a look at an application engine trace file – you can transfer it from the virtualbox process scheduler directory onto your laptop) but what does putty do – can you not just log into the virtualbox and navigate around and look at the admin/config files?
Many Many thanks for writing such fab posts.
Hi Trudy,
Thanks for commenting!
Your understanding on WinSCP and navigating around the VirtualBox folders is absolutely correct.
Putty isn’t essential at all – but, it comes in handy, when you’d like t o search contents of SQRs, scripts etc.,
Rather than use the actual Linux prompt, I like using Putty to navigate around folders, searching for code within the server, writing shell scripts etc.,
More of a personal preference, I would say, rather than an absolute necessity.
Hope this helps! 🙂
Hi Mani,
Thanks so much for that – thought I was missing something.