Adding a Tablespace to a PUM

Somehow I misplaced or mistyped the SYS password on the last PUM install that I did. I learned a few things as a result…

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

Adding the PeopleTools Breadcrumbs Back

In these recent PUMs, one of the things that I miss is the breadcrumbs navigation at the top. It has many advantages over the new navigation. For example:

  • Taking a screenshot documents the navigation to the page
  • Navigation is quicker for nearby pages
  • Reloading the page is quicker by clicking the link in the navigation rather than reloading the whole browser page

I found the breadcrumbs are easy to turn back on. Simply, navigate to PeopleTools > Portal > Branding > Define Headers and Footers. In the search, open up “DEFAULT_HEADER_FLUID”.

At the bottom of the page, in the “Style Definitions” field, paste the following CSS:

.desktopFluidHdr .ptdropdownmenu {
    display: block;
}

Finally, save the page with the button near the top. After you logout and back in, you will see the breadcrumbs.

Resources

OpenCOBOL Try 2

Cobol has been a thorn in my side for a long time. Working for software vendors, it’s not a given that Cobol is installed because they don’t always need to run payroll and don’t have production instances.

It’s been a while since I have played with OpenCOBOL. It’s been so long that they have renamed it to GnuCobol instead.

I’ve gotten closer so far, but I still can’t get past the database connection. Here’s my notes.

Read More

Pardon the Dust: Transition in Progress

Things might look a little different on the blog if you haven’t been back in a while.  And, things might not be working quite up to par for a bit.  Please pardon the dust.  I’m trying to get things back in order as quickly as my schedule allows.

So, here’s what’s going on: I am moving my website to a VPS.  My term at Hostgator expired, and I decided that this next year, I want to include SSL on my site and take it to the next level.  Doing so at Hostgator was not cost effective in the least.

So, I am rebuilding everything on my own VPS.  It’s exciting but things may be a bit rough for a few weeks.  I hoping to pull together a new theme on the blog, SSL for securit/SEO, and tie it all together on a multi-site WordPress installation.

Please keep checking back and see how it goes!