I was the first time to install the orgal11g Data Warehouse, in the installation process, there are many problems. The installation process and the problem-solving solution are documented. If there is any shortage, please criticize the advice.
1. Ensure that the orcal11g is installed in the system. Because of the limitations, I install both the server and the client on the local machine. The local environment is as follows.
Use the SYSDBA link to log into the ORCL database. Success.
The Start menu for installing Orcale 11G is as follows.
1. Select Repository Assistant Start installation
2. The default selection is to manage the warehouse Builder (warehouse builder) workspace.
3. Enter local machine name, default port number, enter service name
4. Select Default New workspace.
5. Create a new user
6. Error entering username password randomly. You should enter the database administrator user name.
When the input database administrator user still complains. You should test for server-side links in the net manager for problems.
Link test failed.
Landing test with Pl/sql failed.
A local service host name error was found and the local machine host name was modified.
Save the test and find that the service is OK but the user is locked.
Solution: Use SYSDBA link to login ORCL database. Success.
Unlock users with commands in Pl/sql. Alter user SYSTEM account unlock;
A password error was found. Alter user system identified by system, using commands to modify passwords.