Connecting an Oracle Database

Connecting an Oracle Database

  1. Navigate to the Oracle Developer folder (should be in C:\app\Oracle Developer)
    Locate the sqldeveloper Application
    Double click on it to open it
  2. Oracle SQL Developer will open and load

  3. Click NO
  4. Uncheck
    Click OK
  5. Open a Command Window
    Go to start and type 
    Click Open

  6. Type in the following command replacing the <PASSWORDXE> section with your own Oracle XE password.
    (In the example, my Oracle XE password is ATC09098PW)
    SQLPLUS system/<PASSWORDXE>@127.0.0.1:1521/XEPDB1 AS SYSDBA
  7. Type in the following commands in order:
    For the first one, we will assign a user password (In the example I assigned Atc10275)
    Note: Remember the user password you assign, you will need it in step 10 of this article.
    CREATE USER F139P_LV IDENTIFIED BY <USERPASSWORD>;
    Press Enter
    GRANT ALL PRIVILEGES TO F139P_LV;
    Press Enter
    EXIT
    Press Enter
    DO NOT CLOSE     the Command window yet.
  8. On the Command window type in the following command:
    Example: imp system/ATC09098PW@127.0.0.1:1521/XEPDB1 FILE="C:\DBs_BAK\LEGACY_Affinity_TestDb1_Oracle.dmp" LOG=C:\Dbs_BAK\LEGACY_Affinity_TestDb1_Oracle_ReImport.log FULL=Y IGNORE=Y
    imp system/<PASSWORDXE>@127.0.0.1:1521/XEPDB1 FILE="<path_to_dump_file>" LOG=<path_to_log_file> FULL=Y IGNORE=Y
    Press Enter
    (It will take a few minutes to create the database)

  9. Once the database gets created
    Go to Oracle SQL Developer
    Click on the Green Plus button
  10. Fill in the following information:
    Give your connection a Name
    Username: F139P_LV
    Role: Default
    Password: <UserPassword> (The password you assigned to the user in Step 7)
    Check Save Password
    Hostname: localhost
    Port: 1521
    SID: XEPDB1
    Service Name: XEPDB1
    Click Connect


    • Related Articles

    • Installing Oracle Database XE

      The following instructions describe how to install Oracle Database XE Visit https://www.oracle.com/database/technologies/appdev/xe.html and download Oracle Database XE Click on the link to download Oracle Database 21c Express Edition for Windows x64 ...

    • Installing Oracle Developer

      This article will walk you through how to install and configure Oracle Developer. Open your web browser and go to https://www.oracle.com/database/sqldeveloper/technologies/download/ Download Windows 64-bit with JDK 17 included Once it finishes ...

    • Repair a corrupt MSSQL database

      For law firms with premises based systems like Time Matters you may run into situations where the database has not been maintained and has become inconsistent. This can prevent your ability to create a backup from which you can migrate the customer ...

    • Convert a Postgres database to MSSQL

      Full Convert by Spectral Core is a robust tool for converting databases from one format to another. The following instructions will walk you through using Full Convert to convert a Postgres database to MSSQL. Launch Full Convert Click New database ...

    • Universal Backup Database Enhancements: 2024-09-18

      On 2024-09-18, the Universal Backup Database was Enhanced as Follows: Renamed *_Role column on __M_Matters_Participating_Entities to *_Participant_Role Recent databases can be upgraded to the latest version by running the following script: exec ...