Monday, September 6, 2010

Oracle 10g XE - 3

Hi All,

This post explains the last part of configuring Oracle 10g XE edition.

Once the rpm or the .deb file is installed, you need to issue this command as root.

1. /etc/init.d/oracle-xe configure

Here after giving this above command, there are some steps to be done:

1. Mention the port number in the first command. This would be the port that you will be using to access the homepage of the server.
2. Leave the default port of 1521 for the net listener.
3. Enter the password for sys. This is the same password for system user as well.
4. Finally hit your browser to http://127.0.0.1:portNo/apex

Here enter sys / system as the user and the password you gave in step 3 above.

Once you are logged in as sys user, create a new user and issue a password to it and as well grant other permissions like creating a table, trigger, schema etc to that user.

Hope this is simple and easy to understand.

Cheers :)
Ananth S Gouri

No comments:

Post a Comment