How to Log Into an Oracle Database for the First Time

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.

...
Program a new enterprise database prior to deployment to meet business data handling requirements.

Log In to an Oracle Database Express Edition Database

Step

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

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

Step

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

Step

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

Log In to an Oracle Database Using the SQLPlus Application

Step

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

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

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