A Guide to Connecting and Initial Configuration of Oracle 11g XE Database

Basics of Connecting to Oracle 11g XE Database

After successfully installing Oracle Database 11g Express Edition (XE), the system automatically creates a default database named "XE". Users do not need to manually create an initial database but can directly access it using pre-configured connection parameters. Key connection information includes: server address (user-defined), port number 1521, database identifier XE, username system, and the password set during installation.

Connecting to the Database Using Oracle SQL Developer

Oracle SQL Developer is a powerful graphical database management tool. When starting it for the first time, follow these steps to configure the connection:

1. Start SQL Developer; on first run, specify the full path to java.exe (e.g., C:\jdk1.5.0\bin\java.exe).
2. In the navigation pane, click "Connections" to enter the connection management interface.
3. Click the "New Connection" icon to open the new connection configuration window.
4. Fill in the connection name, username (e.g., system), and password. For security, it is recommended not to check "Save Password".
5. Switch to the "Oracle" tab, keep the connection type as Basic and the role as default.
6. Enter the hostname and port (default 1521), select the SID option, and enter "xe".
7. Click the "Test" button to verify the connection; after the status shows "Success", click "Connect" to complete the connection.

Once connected, you can perform SQL queries, create tables, and other operations in the SQL Developer environment.

Creating New Users and Schemas via SQL*Plus

Although the default XE database exists, users may need to create independent schemas to isolate data. This can be achieved using the SQL*Plus command-line tool:

SQL> CONNECT sys AS sysdba
After entering the password, execute:
SQL> CREATE USER myschema IDENTIFIED BY password123;
SQL> ALTER USER myschema QUOTA unlimited ON SYSTEM;
SQL> GRANT CREATE SESSION, CONNECT, RESOURCE, DBA TO myschema;
SQL> GRANT ALL PRIVILEGES TO myschema;

The above code creates a new user myschema and grants full database privileges. You can then use this user to connect and create tables in SQL Developer.

Common Issues and Resource References

Beginners often encounter issues such as connection failures or insufficient privileges during configuration. It is advisable to refer to official documentation like "Connecting to Oracle Database Express Edition and Exploring It" and community resources such as "Creating the Sample Database in Oracle 11g Release 2" and "Newbie Guide to Oracle 11g Database Common Problems". These resources provide detailed troubleshooting steps and sample database creation methods, aiding in a deeper understanding of Oracle database management.

Conclusion

Oracle 11g XE lowers the entry barrier through pre-configured databases and standardized tools. Mastering connection configuration, user creation, and privilege management is fundamental for subsequent development. By combining the graphical interface of SQL Developer with the command-line functionality of SQL*Plus, users can efficiently build and manage database objects, laying a solid foundation for complex applications.