ssh using secure file method

Setting SSH on a machine using security file for direct ssh

Client:- The system from which the ssh session will be started via the ssh command

Server:- The system that the ssh session connects to

Steps to taken on the client :

On the client run the following commands:

1. $ mkdir -p $HOME/.ssh
2. $ chmod 0700 $HOME/.ssh (set the security on .ssh folder)
3. $ ssh-keygen -t rsa -This should result in two files, $HOME/.ssh/id_rsa (private key) and $HOME/.ssh/id_rsa.pub (public key).
4. Copy $HOME/.ssh/id_rsa.pub to the server.
5. On the server run the following commands: $ cat id_rsa.pub >> $HOME/.ssh/authorized_keys2
   $chmod 0600 $HOME/.ssh/authorized_keys2
   Depending on the version of OpenSSH the following commands may also be required:

$ cat id_rsa.pub >> $HOME/.ssh/authorized_keys

$ chmod 0600 $HOME/.ssh/authorized_keys

An alternative is to create a link from authorized_keys2 to authorized_keys:

$ cd $HOME/.ssh && ln -s authorized_keys2 authorized_keys

On the client test the results by ssh'ing to the server

$ ssh -i $HOME/.ssh/id_rsa server

(Optional) Add the following $HOME/.ssh/config on the client:

Host server

IdentityFile ~/.ssh/id_rsa

This allows ssh access to the server without having to specify the path to the id_rsa file as an argument to ssh each time.

Including custom tablespace name

Many times we include custom tablespaces for spcecific purposes.

To be able to view them in application designer , run setspace.sqr

or

Check PSTBLSPCCAT table.

Change pia service name under services

Edit pshome\webserv\peoplesoft\bin\installntservicepia.cmd file

:installSvc

"%WL_HOME%\server\bin\beasvc" -remove -svcname:"Peoplesoft-nul

if [%ENABLE_VERBOSE_WL%] == [false] (goto defineSvc)

:defineSvc

"%WL_HOME%\server\bin\beasvc" -install -svcname:"Peoplesoft-name of ur choice" %DEPEND% %

SQRDIR env variable not set

Many times we face the issue that sqrdir environment variable is not set. 

Just do the following

copy pssqr.ini from $PS_HOME/SQR to windows or winnt directory as sqr.ini 

Your issue should be resolved.

PeopleSoft Compare Report Setting for HTML

This to check before you want the compare report to generate browser reports.

1. regedit - hkey current user - software - peoplesoft - pside - DWORD - UpgHtmlOutput=1 (if 0, no html output will be generate).

2. Even if the above is set ..compare viewer.html and other root htmls will not be generated if

PS_HOME/setup/upgCompViewer directory does not have appropriate files under the report files and project files folder.

3. if you get out of memory error set the buffer size under tools - options to 10. did not help me with 5.

Report Unable to post over SSL

We are not able to post the reports using SSL.
This was jre keystore did not have he appropriate keys.
Keytool in %PS_HOME%/jre/bin
Followig command
keytool -import -trustcacerts -alias -file /tmp/ -keystore /apps/pshome/jre/lib/security/cacerts
Once this was done SSL was stated posting reports.

Configure Change Assistant to Apply Patches

1. Configure PSEMHub
2. Configure PSEMAgent
3. Configure Change Assistant
4. Validate the environment
a. through change assistant
b. through PSEMViewer
5. Upload your environment
6. Download the patches / bundles suggested
7. Apply the downloaded bundles/patches.

Configure PSEMHub
PSEMHub gets configured when you build your PIA
Start you PIA and you PSEMHub will be accessible
:/PSEMHub">http://:/PSEMHub

Configure PSEMAgent
1. Configure configuration.properties
\PSEMAgent\envmetadata\config\configuration.properties
2. change the hub url and port and directories to crawl
#hubURL= this is the host and port the agents talk to
hubURL=http://Site:port>/PSEMHUB/hub
agentport=5283
#ping interval in milliseconds for the peer to contact the hub for new
#messages pinginterval=10000
#Windows directories need to use the forward slash ('/') character.
#For multiple directories, use a '' character as separator
windowsdrivestocrawl=d:
Start the Agent : \PSEMAgent\startagent.bat recrawl -- recrawl the dir's
\PSEMAgent\startagent.bat --start the agent
Configure Change Assistant
1. Open Change Assitant - Tools - Options
2.
a.Apply Application Updates
b.Directory to download updates
c.PSHome
d.Staging and output directory
e.Enivronment Management Hub -

Upload the environment
1. Give metalink connection details and follow the screens.
checking the environment
1. Validate the environment from the change assistant - Tools -> Validate
2. PSEMViewer - \PSEMViewer\geteninfo.bat
3. Supply the http port to the web port and detailed
4. under the \PSEMViewer\envmetadata\data directory viewer.html
will be generated
Important things to note.
1. Configure GUID
For fresh installation - PSOPTIONS.Guid field is going to be blank so configure and boot
the application server or process scheduler and guid column will be updated.
For a cloned database update psoptions set guid = ' ';
reboot the application server or process scheduler.
2. Clearing cache:
PSEMHUB/envmetadata/Scratchpad
PSEMHUB/envmetadata/PersistentStorage
PSEMHUB/envmetadata/transactions (if it exists)
PSEMHUB/envmetadata/data/*.* (files and directories. Don't delete the data directory itself)
DO NOT DELETE THE MATCHERS.XML

Change Package for Migrating Customization

Using Change Assistant to Migrate Customization between PeopleSoft Environments

Following are the basic steps involved
1. Create a new Project in PeopleSoft Application Designer
2. Navigate to Project Properties and specify the project to be Change Project.
3. Add all the necessary object to the project, include he file reference if any
4. Use Change Packager to generate Change assistant template
5. Finalize the change package using finalise change package option which generates a zip file

What to expect when you run the change packager?
1. Manifest – xml document that contains information about the package.
2. Manifest would have information about update id included in the package, pre-requisites if any, user information , manual steps , definition type wise count of objects
3. All with this it would create folders for
o Change Assistant Template
o Documentationo File References
o Project Folder
o 8.44 project folder
What to expect when we finalize the change project.
1. Zip file in the staging directory in the following format
Package

Step by Step document to follow. . . .

Exporting Projects definition from datamover

Following tables are used to extract projects definition . We need to add the appropriate where clause.

1 PSPROJECTDEFN 
2 PSPROJECTITEM 
3 PSPROJDEFNLANG 
4 PROJECTNAME
5 PSPROJECTDEP
6 PSPROJECTINC
7 PSPROJECTMSG
8 PSPROJECTSEC

UpgCount

set serverout on size 1000000
DECLARE
CURSOR C1 IS
SELECT RECNAME, SQLTABLENAME FROM PSRECDEFN WHERE RECTYPE = 0 ORDER BY RECNAME;

VAR_COUNT NUMBER;
VAR_REC_COUNT NUMBER :=0;
VAR_SQLTEXT VARCHAR2(32000);
VAR_RECNAME VARCHAR2(64);
VAR_PAD VARCHAR2(100);
VAR_DATE DATE;

BEGIN

SELECT SYSDATE
INTO VAR_DATE
FROM DUAL;

DBMS_OUTPUT.PUT_LINE('Report for Record Rowcount');
DBMS_OUTPUT.PUT_LINE('START DATE AND TIME:'TO_CHAR(VAR_DATE,'MM/DD/YYYY HH24:MI:SS'));

DBMS_OUTPUT.PUT_LINE('RECNAME Row Count');
DBMS_OUTPUT.PUT_LINE('============================== =========');

FOR CUR_REC IN C1
LOOP


--VAR_PAD := RPAD(' ',31 - LENGTH(CUR_REC.RECNAME));
IF SUBSTR(CUR_REC.SQLTABLENAME,1,2) = 'PS' THEN
VAR_RECNAME := CUR_REC.RECNAME;
ELSE
VAR_RECNAME := 'PS_'CUR_REC.RECNAME;
END IF;

--IF NVL(LENGTH(RTRIM(CUR_REC.SQLTABLENAME)),0) = 0 THEN
-- VAR_RECNAME := 'PS_'CUR_REC.RECNAME;
--END IF;

VAR_REC_COUNT := VAR_REC_COUNT + 1;

BEGIN

VAR_SQLTEXT := 'SELECT COUNT(*) FROM 'VAR_RECNAME;
EXECUTE IMMEDIATE VAR_SQLTEXT INTO VAR_COUNT;

DBMS_OUTPUT.PUT_LINE(CUR_REC.RECNAME' 'VAR_PADVAR_COUNT);

EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(CUR_REC.RECNAMEVAR_PAD'ERROR - 'SQLERRM);

END;
END LOOP;

DBMS_OUTPUT.PUT_LINE('============================== =========');
DBMS_OUTPUT.PUT_LINE(' ');
DBMS_OUTPUT.PUT_LINE('Total Number of Tables = 'VAR_REC_COUNT);

SELECT SYSDATE
INTO VAR_DATE
FROM DUAL;

DBMS_OUTPUT.PUT_LINE('END DATE AND TIME:'TO_CHAR(VAR_DATE,'MM/DD/YYYY HH24:MI:SS'));
END;