Installing Oracle 12c Client

We have already seen how to install PeopleSoft on your laptop in a previous post.

It’s very important to have your SQL client to take full advantage of your local PeopleSoft installation. In this step-by-step tutorial, I will show you how to get your SQL Developer up and running in minutes.

Let’s get started.

  1. Navigate to \\192.168.56.101 (This is the same IP that you used to access the PIA in the previous post. It may be different for you.)
  2. Oracle 12c 64bit Client

  3. Within the folder oracle-12c-client-64bit, you would see two files as shown below. Copy these files to a local directory.
  4. Copy Client Files

  5. Now unzip the winx64_12c_client.ZIP file. Once extracted, you would see a setup.exe file within the client folder as shown.
  6. Extracting Client Application

  7. Right-click on the file and click Run as Administrator. The installation wizard starts.
  8. Run Setup as Administrator

  9. Select Administrator and click Next to continue.
  10. Choose Installation Option

  11. Select Skip and Next.
  12. Skip Updates

  13. Select the languages you want and then Next.
  14. Selecting Languages

  15. Select Use Windows Built-in Account and Next
  16. Select Install Account

  17. Specify the Oracle base folder and home directory. (The Oracle software location becomes your Oracle Home)
  18. Specify Oracle Home location

  19. The page shows a summary of all your selections. Hit Install.
  20. Install Summary

  21. The installer progresses for a while and then completes successfully.
  22. Install Progress

    Install Complete

  23. Now go to the folder where you’d placed the two files in step 2.
    Move the tnsnames.ora file to the following path: %ORACLE_HOME%\Network\Admin as shown.
  24. Taking tnsnames

    Placing tnsnames in Admin folder

  25. Now navigate to %ORACLE_HOME%\sqldeveloper.
    Launch SQL Developer by double clicking on the sqldeveloper.exe file.
  26. Launch SQL Developer

  27. You are prompted to specify the java path.
    Browse to %ORACLE_HOME%\jdk\bin and select java.exe.
  28. Java path prompt

    Browse Java path

  29. SQL Developer opens.
    You can do the file type associations on this dialog.
  30. File type association

  31. Now click the New Connections button (Green + sign) on the left side of the window.
    The new database connection window opens.
  32. Enter a connection name (any name you want for this connection)
    Enter the username and password as SYSADM
    Choose TNS from the connection type.
    Select Network Alias and select the database name from the drop-down and click save.
  33. New Connection Details

  34. Write a sample query to select some data.
  35. Run sample query

Tags: ,
Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Read previous post:
PeopleSoft Journal Uploader
PeopleSoft Journal Import Error – User-defined type not defined

Close