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:
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.
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.