How to Log Into an Oracle Database for the First Time

By Dave Wilson

After an Oracle database is created, you will usually need to log in to the database directly to perform custom configurations. While there are many Oracle database implementations, most can be accessed through a command line utility with the exception of Oracle Express Edition. Use the SQLPlus utility to log in to an Oracle database for the first time unless using the Express Edition database.

Things You'll Need

  • Credentials of an account that has access to the Oracle database obtained from the database administrator
  • Windows computer with Oracle database software installed
  • Name of the Oracle database obtained from the database administrator

Log In to an Oracle Database Express Edition Database

Step 1

Click the “Start” button on the Windows computer desktop and click “All Programs,” then click “Oracle Database XX Express Edition” where “XX” is the version of Oracle database installed on the computer.

Step 2

Click “Go To Database Home Page” in the menu that appears. The “Database Home Page” login window will appear.

Step 3

Enter “system” into the “Username” field. Type the password configured for the “System” account during the Oracle database software installation.

Step 4

Click the “Login” button to access the database software home page.

Log In to an Oracle Database Using the SQLPlus Application

Step 1

Press the “Windows” key and the “R” key on the keyboard at the same time and type “cmd” into the “Run” box that appears. Press the “Enter” key.

Step 2

Type “sqlplus system@databasename” on the command line except replace “databasename” with the name of the computer hosting the Oracle database. Press the “Enter” key.

Step 3

Enter the database password when prompted and press the “Enter” key.