Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Before the training/configuration session, please complete the following steps to ensure that all permissions/accounts/credentials are working properly. If any of these fail, it may mean that not everything was set up completely on the backend, so please contact Steven Lippmann if any of these steps do not work for you.

1) Log in to PACE

         Go to secure.citrix.duke.edu in a browser.

         Enter your Duke NetID credentials and multi-factor authentication (You will need your phone for this)

         Go to “Desktops” and then open the “FISMA - DPHS” or “FISMA - SENTINEL” machine.

Image Modified

     

       Image Modified

2) Check network drives on PACE machine

Open Windows Explorer > This PC

You should see these 4 network drives:

Image Modified

3) Mobaxterm

       Open MobaXterm                            


       Image Modified

         Establish a new SSH session:   Menu bar “Sessions” > “New Session”  


       Image Modified     

         Enter the following:

Remote host: plp-phsp01

Check “Specify username” box

 Enter your Duke NetID

Image Modified

     

   Enter your Duke NetID

  

         Click on “Advanced SSH settings” and change the “SSH-browser type” to “SCP (enhanced speed)


        Image Added

         Click “OK” to apply these settings and open a terminal session.

         You may get a prompt for a password. Use your main Duke NetID password.


4) SAS Studio

         Open browser and type in “https://plp-phsp01.dhe.duke.edu:8343/SASStudio/” and log in with your Duke NetID and password. The program should launch to your home directory. If this fails, try a different browser (Firefox, Chrome, Edge).

         If you get an error message when logging in, please contact Steven Lippmann.

5) SQL Plus for changing Oracle password (skip if not using Oracle data assets)

Open Windows Start Menu and locate “Oracle - OraClient12Home1” in the Programs list. Expand the folder and click on “SQL Plus”.

Image Added

At the prompt, enter your user name as:  netid@phsdbp01


Image Added


At the next prompt, enter your temporary Oracle password. Note that this is a different from your regular Duke NetID password.

Your temporary Oracle password would have be emailed by the DHTS database group (usually from Saritha Jandla, Beatrice Bih, or Lawrence Shang)

Note: SQL Plus will not show your keystrokes as you enter your password.


         
 Once
Image Added


Once you are successfully connected, type the word “password” at the SQL> prompt.

Enter your temporary Oracle password as the “old” password.

Then enter the password you would like to use as your “new” password.

Image Added

If your Oracle temporary password has expired, please call the Duke DHTS Service desk at 919-684-2243 and tell them you “need to have your password reset for the phsdbp01 Oracle database.” Using this exact wording will help them assign the ticket to the correct database team.


6) DBVisualizer (Skip if you will not be using data in our ORACLE server.)

         If you don’t find the icon on the desktop, locate and expand the DBVisualizer program folder in the Windows Start > Programs list.

         Image Added

         You’ll need to establish the database connection for Oracle server PHSDBP01 where the Medicare data are stored.

         Open DBVisualizer and go to “Database”

à

-> “Create New Database Connection”

à

-> Choose “No” for the Connection Wizard prompt.

        Image Added

      Image Added

         Enter the following information:


Oracle

Oracle Thin

Service

vlp-phsdb01.dhe.duke.edu

1532

phsdbp01.dhe.duke.edu

        Image Added

Under Authentication, enter your Duke NetID and your ORACLE password that you set up in step 5 above. This is different from your main Duke NetID password.

Image Added