Oracle 11g XE Trial record

Remove the configuration (if any) of the oracle_home in the system environment variable before installation.

If the Web management interface cannot be accessed or the database cannot be connected after installation, it may be normal to uninstall a few more installs.
When the status is not healthy, you can use C:\oraclexe\app\oracle\product\11.2.0\server\bin\lsnrctl.exe status to view the service status.

After the installation starts, after the various choices, the setup finishes, before formally starts installs, has a summary interface, the interface content to save, resembles the following content:

Destination folder: C:\oraclexe\
Oracle Home directory: C:\oraclexe\app\oracle\product\11.2.0\server\
Oracle Base directory: C:\oraclexe\
Port for ' Oracle Database Listener ': 1521
' Oracle Services for Microsoft Transaction Server ' Port: 2030
Port for ' Oracle HTTP listener ': 8080

In this interface do not click "Start Installation", to the Directory of%userprofile%\appdata\local\temp\{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx} found a named " Oraclemtsrecoveryservice.reg "file, copy and rename to" Key_xe.reg ", if not, in the installation process will error, said" Setup cannot instantiate ... " Key_xe.reg ... The file does not appear to exist. ”

Users added with application Express in the Getting Started Web management interface can also connect Oraclexe normally, but not many permissions, and automatically add a bunch of tables to create users or create them using the relevant GUI management tools, or manually write similar if SQL:

CREATE USER ' Rangeon ' identified by ' Cpush ' account UNLOCK DEFAULT tablespace ' USERS ' temporary tablespace ' TEMP ' profile "DEFAULT"; GRANT "DBA" to "Rangeon"; ALTER USER "Rangeon" DEFAULT ROLE "DBA"; ALTER USER "Rangeon" QUOTA UNLIMITED on "USERS";

　　

The above code directly to the user to give DBA authority, in the native test environment can be set up in the actual production environment for the general user, only give connect, RESOURCE, CREATE any view or table the permissions can be.

Be careful: User names must be capitalized, regardless of whether you create a user with GUI tools or SQL! Otherwise, you will not be able to log in, prompting the user/password incorrectly. Use uppercase to create the user, but use the case can log in, wonderful!

If the Web management interface is inaccessible or the database cannot be connected, you may consider modifying the Listener.ora and D:\OracleXE\app\oracle\product\11.2.0\server\network\ADMIN in the Tnsnames.ora, change the computer name to localhost.

"Cannot find file ' http:/127.0.0.1:%httpport%/apex/f?p=4950 ', make sure the file name is correct ..." This error can modify the corresponding Get_started.url file attribute in C:\oraclexe\app\oracle\product\11.2.0\server, change the address port number in the URL column to 8081, apply, And then change back to 8080, the application, you can open the normal. (Others say restarting the brain is OK, not tested)

Oracle 11g XE Trial record