Oracle 11g R2 – How to Create a Database in Oracle XE 11.2

installationoracleoracle-11g-r2

I'm new to Oracle, so please bear with me.

I recently installed Oracle XE Release 11.2 on a Windows 2008 Server that we have. The installation was successful. During installation, I was asked to set a password for sys, and I did that. Also, the HTTP port used was 8085.

So now I'm trying to create a new database. I have Toad Data Point, but I'm not sure how to connect to the server or how to create the database.

In a browser, I went to http://OurServer:8085/ but it asks for password. I tried logging in with sys, but it doesn't let me. I also tried logging in using my company userid (the one I use to log on to my Windows PC), but it didn't work either.

What else can I do?

Best Answer

Oracle 11 does not use containers so you already have a database and the default users such as sys and system and all the other oracle built in users.

Go to Computer Management/Local Users and Groups and verify that the group ora_dba exists. Assuming this is a development project add your regular windows username to the ora_dba group. Now you can log on as sysdba using these steps:

  • open a command window
  • enter SET ORACLE_SID=XE
  • enter sqlplus / as sysdba

This should get you logged on as sys which you should not do normally. For this one time create a user and grant them a role.

CREATE USER < your new user name > IDENTIFIED BY < your new password >;
GRANT DBA to < your new user name>;

Then enter exit to close the session. Log on as your new user using Toad and you should be good to go.

I note that the operating system and database are out of support and you would be better off using the new 18xe on linux.

Related Question