Storing Parameter Key and its Value in a File

PeopleSoft allows you to store a parameter key and its value in a text file so that you need not enter passwords and configuration settings on the command line. System administrators must ensure that the file containing a parameter and its value is accessible to PSADMIN. When you enter a parameter and its value in a text file, you must follow the syntax that is applicable for the parameter value.

You can use the command line to read a file reference using the following syntax:

psadmin -c command -d domain -t template -@@ file path and file name

For example:

psadmin -c create -d NEWQ1 -t small -@@ D:\temp\key1.txt

The contents of the key1.txt file are as follows:

-s Q8588053/ORACLE/QEDMO/QEDMO/TESTSERV/D:\oracle\product\12.1.0\dbhome_1\BIN/people/password/_____/password

Note:

Use –@@ if you do not want the text file to be deleted after PSADMIN extracts the file’s contents. Use –@ if you want the text file to be deleted.

When you use –@ file references, consider the following:

  • A PSADMIN command can contain multiple –@[@] file references that contain a parameter key-value pair, and you can use a mix of –@@ and –@ within a single command.

    For example:

    psadmin -c create -d psftdomain -t psfttemplate -@@ D:\temp\set_file.txt[-@ D:\temp\pset_file.txt] [-@@ D:\temp\env_set.txt]

  • A PSADMIN command can contain nested –@[@] file references.

    For example:

    psadmin -@@ D:\edw\temp\file1.txt

    where the contents of file1.txt are as follows:

    -c create -d NEWQ1 -t small -@@ D:\edw\temp\file2.txt

    and the contents of file2.txt are as follows:

    -s Q8588053/ORACLE/QEDMO/QEDMO/TESTSERV/D:\oracle\product\12.1.0\dbhome_1\BIN/people/password/_____/password

  • When you have multiple –@ file references in a command, and if any of the –@ file reference fails, PSADMIN stops processing the command after an error is encountered.

    For example:

    psadmin -c -@@ D:\edw\temp\file3.txt

    Where the contents of file3.txt are as follows:

    create -@ D:\edw\temp\file4.txt -@ D:\edw\temp\file4.txt -@ D:\edw\temp\file5.txt

    PSADMIN displays the following error:

    Can't open file D:\edw\temp\file4.txt. Please Check the correct file name.

    In this example, PSADMIN reads the contents of file3.txt, When it encounters an error, it deletes file4.txt and subsequently stops processing the command. PSADMIN does not delete file5.txt if the file exists in the location.