Bobby Durrett's DBA Blog
I did a quick survey of the latest PeopleSoft manuals to find a set of links to pass on to a couple of coworkers of mine that are interested in doing PeopleSoft DBA work so I thought I’d include the links in a post. This might give a new PeopleSoft DBA some highlights without having to read the entire manual set.
This page has a nice picture of how the environments connect:
This is the top level URL for the PeopleTools 8.53 documentation:
Another nice architecture diagram:
Nice overview of application development using app designer:
Yet another architecture diagram:
More in depth view of app server and its processes:
Web server with discussion of servlets and jolt:
Nice overview of datamover commands:
Nice explanation of Oracle connections from PeopleSoft:
Good to know but not very clear explanation:
Important to know but not very clear:
PS_HOME versus PS_CFG_HOME
Nice run down of config files:
App server menu:
process scheduler menu:
web server menu – I don’t think I’ve ever used this:
I’m still studying for my Oracle 12c OCP exam and I was trying to run a simple example of using SQL*Loader Express and the first thing I did blew up and I think it is a bug. When I load a table with one or two columns it works fine, but when I load a table with 3 or 4 columns the last column is not loaded. Tell me this isn’t a special feature!
First I create the table with four columns:
create table test (a varchar2(20), b varchar2(20), c varchar2(20), d varchar2(20));
Then I create a comma separated values file named test.dat with four values per line:
[oracle@ora12c dpsl]$ cat test.dat a,b,c,d f,g,h,i j,k,l,m
Then I run sql*loader in express mode:
[oracle@ora12c dpsl]$ sqlldr system/xxxxxx table=test SQL*Loader: Release 22.214.171.124.0 - Production on Mon Apr 21 07:32:43 2014 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. Express Mode Load, Table: TEST Path used: External Table, DEGREE_OF_PARALLELISM=AUTO Table TEST: 3 Rows successfully loaded. Check the log files: test.log test_%p.log_xt for more information about the load.
Then I query the newly loaded table:
ORCL:CDB$ROOT:SYSTEM>select * from test; A B D -------------------- -------------------- -------------------- a b d f g i j k m
Queue the mysterious music. Actually, now that I look at it really it is the third column that is missing. Maybe it doesn’t work with a column named C.
Sure enough, here it is with column C replaced with column X:
A B X D -------------------- -------------------- -------------------- -------------------- a b c d f g h i j k l m
So, I guess SQL*Loader Express doesn’t work with columns named C? Odd.
Update on 05/16/2014:
As you probably can expect, this was user error on my part. My standard header for sqlplus scripts has this code:
column u new_value us noprint; column n new_value ns noprint; column c new_value cs noprint; select name n from v$database; select user u from dual; SELECT SYS_CONTEXT('USERENV', 'CON_NAME') c FROM DUAL;
I use this code to build a prompt that will tell me which container I’m in like this:
set sqlprompt &ns:&cs:&us>
But, this means I can’t use columns named n, u, or c, but in my sql*loader test I was using c. So, not a bug, just a user error!
I was trying to recreate the scenario where a 12c container database is flashed back to a SCN before the point that I recovered a pluggable database to using point in time recovery.
I got this ugly ORA-00600:
RMAN> recover pluggable database pdborcl; Starting recover at 16-APR-14 using channel ORA_DISK_1 starting media recovery media recovery failed RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 04/16/2014 06:07:40 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed datafile 32 , 33 , 34 , 35 ORA-00283: recovery session canceled due to errors ORA-00600: internal error code, arguments: , , , , , , , , , , , 
I think the above error message stems from this bug:
Bug 14536110 ORA-600 [ktfaput: wrong pdb] / crash using PDB and FDA
There may have been some clever way to recover from this but I ended up just deleting and recreating the CDB through DBCA which was good experience playing with DBCA in Oracle 12c. I’m trying to learn 12c but I have a feeling that I have hit a bug that keeps me from testing this flashback database, point in time recovery of a pluggable database scenario. I wonder if I should patch? I think that Oracle has included a patch for this bug in a patch set. It could be good 12c experience to apply a patch set.
I got the newly available Kaplan test prep software for the Oracle 12c OCP upgrade exam.
I took the test in certification mode when I was tired at the end of the day some day last week and got 44% right – fail! I usually wait until I get all the questions right before taking the real test so I have a ways to go.
The practice test software has been useful in terms of showing me things I didn’t study very well or at all. I’m expecting to significantly improve my correct answer percentage on my next pass.
I’m a little nervous though because it seems that the real test involves some questions that are generic database questions and I don’t think that the test prep software includes that section. If you look at the list of topics they have a section called “Key DBA Skills”. I’d hope that after 19 years as an Oracle DBA I’d have some skills, but there are plenty of things I don’t do every day, such as setting up ASM. I guess I’ll just have to bone up on the key areas of pre-12c that I don’t use all the time and hope I’m not surprised.
Anyway, I’m at 44% but hoping to make some strides in the new few weeks.