We finally figured out that the problem was a custom property on the Web Profile. The property is called “DisableFluid”. Navigation: PeopleTools > Web Profile > Web Profile Configuration

The fix is to just simply delete the custom property row. Don’t forget to restart the web server. Changes don’t take effect until you restart.

The problem was that in certain environments, that URL went to production. It should have gone to the test environment where we were validating the new development.

What was the fix? Here are my notes…

Generating the URL

First, let me walk you through what I used to generate the links.

Here is the code that I have for generating the URL:

Local string &url = GenerateComponentPortalURL(%Portal, %Node, MenuName.MY_MENU, "GBL", Component.MY_COMPONENT, Page.MY_PAGE, "U");

Method: GenerateComponentPortalURL()

Here are the parameters.

• Portal — Just use %Portal for the portal where your code is current running
• Node — Just use %Node for the current node
• Menu — the menu where your component is registered
• Market — the market of your component (normally GBL)
• Component — the component name you want to point to
• Page — the page in the component
• Action/Mode — U for update; C for correct history; A for Add

Now, %Portal and %Node work great when you are running your code online in the PIA. But, it’s a different story in an App Engine running on the Process Scheduler. In that case, you technically aren’t in a portal. Therefore, %portal will generate an error. Instead, you can select the portal from the target content reference and you can get the default node from the database.

Local string &portalName, &nodeName;
SQLExec("SELECT MSGNODENAME FROM PSMSGNODEDEFN WHERE LOCALDEFAULTFLG = 'Y'", &nodeName);
SQLExec("SELECT PORTAL_NAME FROM PSPRSMDEFN WHERE PORTAL_URI_SEG1 = :1 AND PORTAL_URI_SEG2 = 'MY_COMPONENT' AND PORTAL_CREF_USGT = 'TARG'", &menuName, &portalName);

Fixing the URL

So, what happens when the URL it generates is wrong? You need to fix the setting on the Portal Node.

First, search for your local node. Go to Integration Broker > Integration Setup > Node Definitions. You can limit it to Node Type of PeopleSoft if you want to reduce your list a little.

Locate the row where the default local node is “Y”. This is the one that you want to edit or check. For me, that’s PSFT_HR. If you are in Campus, it will probably be the SA node.

For that node, go to the Portal tab. You will want to check the Content URI Text and the Portal URI text. These URLs have to be correct.

The URL has to match the URL that you are using to access your PeopleSoft instance. I have “ps” for the site, but many people have the instance name such dev, tst, etc. The problem I was seeing was that after a refresh, this wasn’t updated, and this URL was still pointing to production.

   AddStyleSheet(StyleSheet.<stylesheet name>);
   Local PT_PAGE_UTILS:Utils &oPageUtils = create PT_PAGE_UTILS:Utils();
   &oPageUtils.SetDefaultViewport();

Maybe this warrants some explanation. First, I always have some CSS styling I want to add. So, I have to add the stylesheet. File > New and create a freeform stylesheet.

Then, I attach it to the component with the AddStyleSheet() method.

   AddStyleSheet(StyleSheet.<stylesheet name>);

The next part makes the page truly fluid. Otherwise, it doesn’t adjust properly to mobile. Of course, you’ll have to import the page.

import PT_PAGE_UTILS:Utils;

Then, just add these lines setting the default view port.

 Local PT_PAGE_UTILS:Utils &oPageUtils = create PT_PAGE_UTILS:Utils();
 &oPageUtils.SetDefaultViewport();

If you want to go above and beyond, there’s also a method to set the favicon.

&oPageUtils.SetFavIcon(Image.<image name>);

So, I worked through telling my browser to trust the certificate. Here are my notes…

Downloading the Certificate from Firefox

Before we can get the browser to trust the certificate, we need to get access to the certificate. So, here’s the easy way assuming you are in a Firefox browser. I’ll try from

First, click on the lock by the URL and then click on the “Connection not secure” message in the menu.

Now, click the View More Information option to open the properties window.

This opens a window open with details about the site. So, click on the View Certificate button.

This opens a new web page / tab with all kinds of details about the certificate. If you scroll down to the Miscellaneous section, you can find a download link. That will download a PEM file with the certificate in it.

Installing the Certificate in Oracle Linux

First, I found the Firefox certificate database:

$ find ~/ -name "cert8.db"
$ find ~/ -name "cert9.db"
/home/PS/.mozilla/firefox/6n8rm3sx.default-default/cert9.db

As I understand it, this command should import the certificate. The command works, but Firefox still complains.

certutil -d sql:/home/PS/.mozilla/firefox/6n8rm3sx.default-default -A -t P -n "My PS Cert" -i $HOME/Downloads/tr46-digitaleagle-net.pem

So, the fix was to use the -t C option. P is for “trusted peer” and C is for “trusted CA to issue server certs”.

certutil -d sql:/home/PS/.mozilla/firefox/6n8rm3sx.default-default -A -t C -n "My PS Cert" -i $HOME/Downloads/tr46-digitaleagle-net.pem

Just for thoroughness, certutil came pre-installed in the PUM where I was working. But, if you don’t have it, I found it is part of the nss-tools package.

$ which certutil
/usr/bin/certutil
$ rpm -q --whatprovides /usr/bin/certutil
nss-tools-3.79.0-5.el7_9.x86_64

Downloading the Certificate from Chrome

So, what if you have Chrome. Or, in my case, I currently have Chromium. The process is basically the same. Click on the “Not Sure” warning by the URL, then click on the “Certificate is not valid” message.

This should open a dialog with information about the certificate. Go to the Details tab and click on Export. That should allow you to save the file.

I saved the file as a .crt file in my Downloads folder. The File type was set to Base64-encoded ASCII, single certificate.

Installing the Certificate in Ubuntu

First, my Ubuntu installation didn’t already have certutil installed. So, I installed the libnss3-tools package.

sudo apt install libnss3-tools

For Chrome, the database folder should be in .pki/nssdb directory. But, I ran both commands and it didn’t make a difference.

certutil -d sql:$HOME/.pki/nssdb -A -t P -n "tr46-digitaleagle-net" -i $HOME/Downloads/tr46.digitaleagle.net.crt
certutil -d sql:$HOME/.pki/nssdb -A -t C -n "tr46-digitaleagle-net" -i $HOME/Downloads/tr46.digitaleagle.net.crt

So, I ran my find command:

find ~/ -name "cert9.db"

That pointed out to me that my Chromium is actually installed as a snap. So, I need to use the nssdb folder inside the snap. So, this did the trick:

certutil -d sql:$HOME/snap/chromium/2572/.pki/nssdb -A -t P -n "tr46-digitaleagle-net" -i $HOME/Downloads/tr46.digitaleagle.net.crt

Resources

• PeopleSoft SA Blog: Administering a Peoplesoft System
• Adding self trusted SSL certificate for localhost on Ubuntu(NGINX)
• SuperUser: Add permanent SSL certificate exception in Chrome (Linux)

Starting

To start, I extracted the OVA file out of the first zip file. Double clicking on it, opens it in Virtualbox to get it imported. The only thing I changed was the name so that I remembered what was in this PeopleSoft instance. (Note: I’m finding that for Campus the OVA file is in the first zip file, but for HR and Finance, the OVA is in the last zip file.)

Machine Settings

At first, there were some invalid settings. They aren’t anything major, but they have to be corrected to get it running on my laptop.

I fixed that easily by changing the video memory to 33MB and the controller to VMSVGA. (Note: I bumped it up to 128MB later for the GUI setup.)

Next, I added a Shared Folder so that I would be able to point the install process to the PUM files. Note that this folder needs to have the PUM zip files directly in it, not in a sub folder. It also needs to be the only shared folder through the install process.

Finally, I set the network interface to bridged. That’s good for when the machine will stay on the same network all the time. If you are going to carry it around on a laptop, you need to have two interfaces: one host only and one NAT.

Booting the Machine

Now, it’s time to start up the machine. After starting a few services, it gets to the first series of questions starting with a new root password. This first boot will actually walk us through the whole install process.

Questions:

• New Root Password
• Do you want to enable dynamic IP configuration (DHCP)? Yes
• Do you want to manually configure the hostname? Yes
• Enter hostname
• Are you happy with your answers? Yes

At this point, it copies and extracts the PUM zip files.

If you run into issues, here are two log files to check:

• /opt/oracle/psft/dpk/setup/psft_dpk_setup.log
• /var/log/psft_setup.log

More questions

• Enter the PeopleSoft installation (PUM or FRESH): PUM
• Enter a new PeopleSoft database name. default: CS92U028
• Enter the Peoplesoft database listener port default: 1521
• Enter a new PeopleSoft database admin users [SYS/SYSTEM] password. I picked one that was at least 15 characters and had uppercase, lowercase, numbers and a symbol
• Enter a new PeopleSoft database Connect ID. default: people
• Enter a new PeopleSoft database Connect ID password. default: peop1e
• Enter a new PeopleSoft database Access ID [SYSADM] password. I used the same as SYS
• Enter a new PeopleSoft database Operator ID [PS] password. I used the standard PS
• Enter a new Application Server Domain connection password. I used the same as SYS
• Enter a new WebLogic Server Admin user [system] password. I used the same as SYS
• Enter a new PeopleSoft Web Profile user [PTWEBSERVER] password. I used the same as SYS
• Enter the PeopleSoft Integration Gateway user. default: administrator
• Enter the PeopleSoft Integration Gateway user password. I used the same as SYS
• Enter the PeopleSoft Integration Gateway Keystore password. I used the same as SYS
• Are you happy with your answers? YES!
• After some processing … “Do you want to continue with the default initialization process? Yes

First Steps

So, this is using Oracle Linux 7.9.

[root@localhost ~]# cat /etc/oracle-release 
Oracle Linux Server release 7.9

You can double check your IP Address with:

ip a

You can get into psadmin from root with

su - psadm2
psadmin

You can get into the database with:

su - oracle2
sqlplus SYSADM@CS92U028

Database Error

The login page would come up, but then the page would go blank. When I tried to use SQL Plus to get into the database, it would timeout:

ORA-12170: TNS:Connect timeout occurred

When I checked the listener status, the host was blank.

$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 13-JUL-2023 03:36:38

Copyright (c) 1991, 2022, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

I checked the configuration in TNS Names. It’s using the host name that I had picked before.

vi $ORACLE_HOME/network/admin/tnsnames.ora

When I tried to ping that host name, it failed. I noticed it was using the wrong IP address from when I had the network interface set wrong.

$ ping cs28.digitaleagle.net
PING cs28.digitaleagle.net (192.168.56.104) 56(84) bytes of data.
^C
--- cs28.digitaleagle.net ping statistics ---
107 packets transmitted, 0 received, 100% packet loss, time 108638ms

The fix was to edit the /etc/hosts and put in the correct IP address. I’m going to try 127.0.0.1 for here so it doesn’t matter what IP address the machine is given.

Updating

I installed all of the updates from YUM. As root, I ran:

yum update

Here’s the packages that it had available for me:

Install   4 Packages
Upgrade  84 Packages

Total download size: 588 M
Is this ok [y/d/N]: y

Installing a GUI

I used this command to install a GUI:

 yum groupinstall "Server with GUI"

Then, I created a regular user to use with the GUI interface:

adduser PS
passwd PS
usermod -a -G vboxsf PS

Then, I logged in as PS and started the GUI to make sure it worked:

startx

There was a little wizard to walk through, and I walked through that quickly to set my language and such.

Finally, back under root, I ran this command to make it boot into the graphical by default:

systemctl set-default graphical.target

Note, that you can switch it back to text with:

sudo systemctl set-default multi-user.target

To make it login automatically, I added these two lines under [daemon] in the /etc/gdm/custom.conf file.

# GDM configuration storage

[daemon]
AutomaticLoginEnable=true
AutomaticLogin=PS

I had an issue with the screen blanking out, so I tried a timed login instead:

[daemon]
TimedLoginEnable=true
TimedLogin=PS
TimedLoginDelay=30

I went to the Gateway Configuration page at PeopleTools > Integration Broker > Configuration > Gateways. Then, I clicked on Gateway Setup Properties.

I did have to know the Gateway password. That was definitely in the PUM configuration script, and I wrote that down.

Then, I went to the advanced properties page. You could actually go to the integration.properties file on the server as well.

Now, that I am at the config file, I searched for “secureFileKeystorePasswd”. This has the encrypted password in it. For me, it was “{V2.1}buJpVt5IOuj4UXvfMY7D0pJtTwUP+GWr”.

Now, to decrypt the password. I dropped this PeopleCode into a button on one of my pages:

   Local string &encPassword = "{V2.1}buJpVt5IOuj4UXvfMY7D0pJtTwUP+GWr";
   Local JavaObject &psCYPHER = CreateJavaObject("psft.pt8.pshttp.PSCipher");
   Local string &DecPwd = &psCYPHER.decodePassword(&encPassword);
   MessageBox(0, "", 0, 0, "&DecPwd " | &DecPwd);

That showed me that my password that was saved was actually just “password”.

Resources

• PeopleSoft Blog: Encrypt Decrypt Password

Finding the Grids

First, I need to find grids. The FIELDTYPE field in the PSPNLFIELD table contains the type of controls on the page. Field Type #19 is a grid.

Next, I wanted to look for grids setup with the “Div Grid Layout” grid style. That’s configured on the Use tab of the page-field properties:

That setting is stored in the database in the table PSPNLCNTRLDATA, field PTGRDLAYOUT. Here are the 12 different options:

So, to put that all together, here’s some SQL that will find all of the Div Grid Layouts:

SELECT A.PNLNAME, B.PNLFLDID, 
      C.PNLTYPE, C.DESCR, 
      D.PNLNAME, E.PNLGRPNAME, F.DESCR, 
      G.PORTAL_LABEL, G.PORTAL_URI_SEG1 || '.' || G.PORTAL_URI_SEG2 || '.' || G.PORTAL_URI_SEG3
FROM PSPNLCNTRLDATA A
JOIN PSPNLFIELD B
  ON A.PNLNAME = B.PNLNAME
  AND A.PNLFLDID = B.PNLFLDID
JOIN PSPNLDEFN C
  ON A.PNLNAME = C.PNLNAME
LEFT OUTER JOIN PSPNLFIELD D
  ON C.PNLNAME = D.SUBPNLNAME
LEFT OUTER JOIN PSPNLGROUP E
  ON C.PNLNAME = E.PNLNAME
  OR D.PNLNAME = E.PNLNAME
LEFT OUTER JOIN PSPNLGRPDEFN F
  ON E.PNLGRPNAME = F.PNLGRPNAME
LEFT OUTER JOIN PSPRSMDEFN G
  ON G.PORTAL_URI_SEG2 = F.PNLGRPNAME
WHERE A.PTGRDLAYOUT = 4
AND B.FIELDTYPE = 19

Fluid versus Classic

Not all of the types work with fluid. Now, that doesn’t mean you’ll get an error if you use a classic type on a fluid page. The fields just won’t work on the fluid page.

Div Grid Layout

The Div Grid Layout style turns everything into a <div> tag. Then, you need to use CSS styles to make the layout look the way you want. Here are the styles at the different levels:

• ps_grid-div ps_grid-body
  • ps_grid-row
    • ps_grid-cell

Example: Benefits

The page BEN_SUMM_GRID_FL, component BEN_SUMM_GRID_FL has a grid that uses the Div Grid Layout. At first, I thought it was the “Benefit Plans” grid, but that uses Flex Grid Layout. It’s the two areas on the right: Contact Information and Resource Information. It has no search page, so you can just go directly to the URL.

URL: EMPLOYEE/HRMS/c/EF_BENEFITS_FL.BEN_SUMM_GRID_FL.GBL

You can navigate there by going to the employee self-service home page and then clicking on the “Benefit Details” tile. Notice the contact details on the right.

This example is unique because different fields are showing on each row. A total of three rows are displaying. From the HTML, you can see the first row/ps_grid-row is highlighted, and it’s only highlighting the phone number.

I do notice the last column (email address) uses the psc_wrap style.

Example: Element Browser Filter

Another example is the filter for the Element Browser. It’s the subpage GPSC_ELM_FLTR_SCF on the page GPSC_ELM_BRW_LFL, component GPSC_ELM_BRW_FL. You can get there with this URL.

URL: EMPLOYEE/HRMS/c/DEFINE_PAYROLL_RULES_(GBL).GPSC_ELM_BRW_FL.GBL

Navigation: Set Up HCM > Product Related > Global Payroll & Absence Mgmt > Elements > Element Browser

The checkbox is interesting. It’s added as a control in app designer:

The checkbox column uses the styles: psc_width-15em psc_padding-left2em

The description column uses the styles: psc_width-15em psc_padding-left2em

Installing Wine

First, I installed wine. I just used the latest from the repositories. I didn’t install the wine HQ repository, and I just installed Ubuntu’s version of winetricks.

sudo apt install --install-recommends wine
sudo apt install winetricks

Things sure have changed since I last wrote about this. We are all the way to version 5.

$ wine --version
wine-5.0 (Ubuntu 5.0-3ubuntu1)

While we are at setting up the system, make sure that the machine’s IP address is in /etc/hosts. You’ll need to connect to the machine via hostname for certain things in the PIA, so you may as well set it up.

Preparing the Wineprefix

I created a special directory/wineprefix for each PeopleTools version that I use.

export WINEPREFIX="$HOME/.local/share/wineprefixes/pt8_57_08"
mkdir -p $HOME/.local/share/wineprefixes
winecfg

Before, it asked me about installed Mono and such. This time, it just opened the Wine Configuration dialog, which I simply closed.

Next, I used winetricks to install the dependencies:

winetricks vcrun2005 dotnet40 vcrun2015

A number of dialogs popped up for installing the different libraries. I just accepted the agreements and clicked through to install.

Installing PeopleTools Client

I got the PeopleTools client install from the PUM itself. I opened the file browser, pressed Ctrl+L and entered: smb://TR32/tools_client (TR32 is the hostname of the PUM image machine). I copied the client-857 directory to my machine’s Download directory.

I installed the client onto the C:\ drive of the wineprefix:

cd ~/Downloads/client-857/archives
mkdir $WINEPREFIX/drive_c/pt-toolsclient8.57.08
tar -xzvf pt-toolsclient8.57.08.tgz -C $WINEPREFIX/drive_c/pt-toolsclient8.57.08/
cd $WINEPREFIX/drive_c/pt-toolsclient8.57.08/bin/client/winx86
wine pscfg

I simply setup my connection defaults: Database Type (Oracle), Database Name, User ID, Connect ID, Connect Password. Then, I did an “Install Workstation” on the Client Setup tab.

Installing the Oracle Client

I got the Oracle database client install from the PUM itself. I opened the file browser, pressed Ctrl+L and entered: smb://TR32/tools_client . I copied the oracle-client directory to my machine’s Download directory.

cd ~/Downloads/oracle-client/archives/
mkdir $WINEPREFIX/drive_c/oracle
tar -xzvf pt-oracleclient-12.1.0.2.tgz -C $WINEPREFIX/drive_c/oracle

Next, I setup my tnsnames.ora file. I used notepad to write the file so that I would make sure and get it in the Windows format.

wine notepad 'c:\oracle\network\admin\tnsnames.ora'

This is what I put in it:

HR92U032 =
   (DESCRIPTION =
       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = TR32)(PORT = 1521))
       )
       (CONNECT_DATA =
           (SERVER = DEDICATED)
           (SERVICE_NAME = HR92U032)
       )
    )

Finally, I set the following registry settings:

wine regedit

• Added HKEY_LOCAL_MACHINE\Software\Oracle
• HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment\PATH — added path c:\oracle\bin
  (While I was at it, I also added c:\pt-toolsclient8.57.08\bin\client\winx86)
• HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\SessionManager\Environment\TNS_ADMIN — c:\oracle\network\admin
• HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\SessionManager\Environment\ORACLE_HOME — c:\oracle

Checking Database Connectivity

To make sure that I had the database connection working right, I did a tns ping and then tried to connect through SQL plus.

wine tnsping HR92U032
wine sqlplus people@HR92U032

Note: I did get the following error consistently, but it didn’t seem to keep anything from working:

0035:err:winediag:SECUR32_initNTLMSP ntlm_auth was not found or is outdated. Make sure that ntlm_auth >= 3.0.25 is in your path. Usually, you can find it in the winbind package of your distribution.

This is another error that I got:

Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-03505: Message 3505 not found; No message file for product=NETWORK, facility=TNS

This was because I forgot to set the ORACLE_HOME environment variable in the registry.

Finally, I mispelled the name of the TNS Name in tnsnames.ora. I left off an R on the name. I actually had to grep for the name in the file to notice it wasn’t finding it. I got the first message from tnsping and the second from sqlplus:

TNS-03505: Failed to resolve name
ORA-12154: TNS:could not resolve the connect identifier specified

Update: I ran into another error. I was trying to get a different instance working, and I got the following error when I would try to login.

Your security options are set improperly. Please contact your security administrator.

I though the problem was this ODBC driver error:

002c:err:winediag:ODBC32_SQLDrivers No ODBC drivers could be found. Check the settings for your libodbc provider.

It turns out the ODBC error is benign. It works fine even when it thows that error. The problem was my connect password. I retyped my connect user and password into Configuration Manager, and App Designer connected fine after that.

Resources

• PeopleTools Client with Wine (Old Post)
• Oracle Database Problem and Solutions: Resolving TNS – Message 3511 not found
• Burleson Consulting: TNS-03505: Failed to resolve name tips

Oracle is using Container Database technology. It made things a little challenging.

I should have been able to connect with:

sqlplus SYS@HR92U092 as sysdba

Inspecting the environment, it looks like the database name is CDHCM.

[oracle2@ps ~]$ ps -ef | grep pmon
oracle2   3691     1  0 Sep26 ?        00:00:40 ora_pmon_CDBHCM
oracle2  32310 23161  0 01:35 pts/0    00:00:00 grep pmon
[oracle2@ps ~]$ cat /proc/3691/environ | xargs -0 -n1 | grep ORACLE
ORACLE_SID=CDBHCM
ORACLE_HOME=/opt/oracle/psft/db/oracle-server/12.1.0.2
ORACLE_SPAWNED_PROCESS=1

So, I can log in using OS security:

su - oracle2
export ORACLE_SID=CDBHCM
sqlplus / as sysdba

I can see where all of the data files are located at this point:

select file#, name from v$datafile

I can see that all of the data files are located in the directory:
/opt/oracle/psft/db/oradata/HR92U027

At this point, if you create the tablespace, it will go into the root container instead of the PeopleSoft database. If you already did it, you’ll need to delete the tablespace first:

drop tablespace GTCAPP including contents and datafiles;

You can see the list of databases in the root container:

SELECT PDB_ID, PDB_NAME, STATUS, CON_ID FROM CDB_PDBS;

You have to switch over to the PeopleSoft database with an alter session command:

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container = HR92U027;    

Session altered.

SQL> show con_name;

CON_NAME
------------------------------
HR92U027

Here’s the tablespace that I am trying to create:

CREATE TABLESPACE GTCAPP DATAFILE '/opt/oracle/psft/db/oradata/HR92U027/gtcapp.dbf'
SIZE 50M
DEFAULT STORAGE (INITIAL 64K NEXT 128K MAXEXTENTS 110 PCTINCREASE 0)
/
ALTER DATABASE DATAFILE '/opt/oracle/psft/db/oradata/HR92U027/gtcapp.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;

Now that the tablespace is created from the Oracle Database point of view, I can move on to the PeopleSoft point of view. The tablespace needs to be added on the page: PeopleTools > Utilities > Administration > Tablespace Utilities

Resources

• DB Visit Blog: What’s going on? “Connected to an idle instance”, but database is running.
• Database Administrator’s Guide: Datafiles Data Dictionary Views
• Database Administrator’s Guide: 43 Viewing Information About CDBs and PDBs with SQL*Plus
• Database Administrator’s Guide: Tablespace Data Dictionary Views
• Oracle Base: Multitenant : Manage Tablespaces in a Container Database (CDB) and Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1)

Installing Wine

I installed Wine with these commands.

sudo apt-get install --install-recommends wine
sudo apt-add-repository 'https://dl.winehq.org/wine-builds/ubuntu/'
wget https://dl.winehq.org/wine-builds/Release.key && sudo apt-key add Release.key
sudo apt update && sudo apt install winehq-stable

This installed version 3.0.1 for me:

$ wine --version
wine-3.0.1

Next, I installed Winetricks to help with installing dependencies:

wget  https://raw.githubusercontent.com/Winetricks/winetricks/master/src/winetricks -P ~/bin/
chmod +x ~/bin/winetricks

Preparing the WinePrefix

I created the wineprefix to install into:

export WINEPREFIX="$HOME/.local/share/wineprefixes/peopletools"
mkdir -p $HOME/.local/share/wineprefixes
winecfg

The first question I got was: “Wine could not find a wine-mono package which is needed for .NET applications to work correctly.” I choose the “Install” button. Next, I got: “Wine could not find a Gecko package…”. Again, I choose “Install” (I had to do that twice for some reason).

That opened the Wine Configuration dialog when it was done. I didn’t make any changes and just clicked okay.

Finally, I used winetricks to install some libraries:

winetricks vcrun2005 dotnet40 vcrun2015

Installing App Designer

I browsed to the PUM share in my file browser. For me that was:
smb://192.168.56.101/tools_client/

Then, I copied the client-856 and oracle-client folders to by Downloads directory.

I was going to try to run SetupPTClient.bat, but that is a little heavier and requires Python. I just extracted the PT client archive.

cd ~/Downloads/client-856/archives
mkdir ~/bin/pt-toolsclient8.56.07
tar -xzvf pt-toolsclient8.56.07.tgz -C ~/bin/pt-toolsclient8.56.07/
cd ~/bin/pt-toolsclient8.56.07/bin/client/winx86
wine pscfg

I just did the workstation install and configured the login information. After that, it started fine.

wine pside

Oracle DB Client

cd ~/Downloads/oracle-client/archives/
mkdir $WINEPREFIX/drive_c/oracle
tar -xzvf pt-oracleclient-12.1.0.2.tgz -C $WINEPREFIX/drive_c/oracle

Then, I had to update some registry keys. I could open the registry editor with:

wine regedit

I created a new key:
HKEY_LOCAL_MACHINE\Software\Oracle

Then, I added c:\oracle\bin to the path in HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment\PATH

Finally, I added a new value, HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\SessionManager\Environment\TNS_ADMIN, and set it to c:\oracle\network\admin

Resources

• OTN Discussion: App Designer on Linux under Wine 
• GrayHeller: Application Designer on Linux
• Wine Forum: Using wine for Peoplesoft Development
• WineHQ: Installing WineHQ Packages
• OMG Ubuntu: Wine 2.0.1 Stable Released, Here’s How To Install it on Ubuntu