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