10g installation step on Windows XP


Using the Oracle Universal Installer, you install the Oracle Database 10g software and create a database.


Installing Oracle 10g database software :

1. Insert Oracle CD , the auto-run window opens automatically. If you are installing from network or hard disk, click setup.exe in the installation folder.

my setup location:-c:\TEMP\database
2. The Oracle Universal Installer (OUI) will run and display the Select Installation MethodWindow.




3. Choose Basic Installation:
Select this option to quickly install Oracle Database 10g. This method requires minimal user input. It installs the software and optionally creates a general-purpose database based on the information you provide. 
For basic installation, you specify the following:
Oracle Home Location — Enter the directory in which to install the Oracle Database 10g software. You must specify a new Oracle home directory for each new installation of Oracle Database 10g. Use the default value, which is :
  1. c:\oracle\product\10.2.0\db_1

    Installation Type — Select Enterprise Edition :
    If you have limited space, select standard editionPersonal edition installs the same software as the Enterprise Edition, but supports only a single-user development and deployment environment.
    Create Starter Database — Check this box to create a database during installation. Oracle recommends that you create a starter database for first Create Starter Database — time installations. Choose a Global Database Name, like cs157b, or just use the default value.
    Type a password. Don’t lose this password, since you will need it to connect to the database server. Click next  







4. The Product-Specific Prerequisite Checks window appears: Click next 



5. A summary screen appears showing information such as your global settings, space requirements and the new products to be installed. Click Install to start the installation..

6. The Install window appears showing installation progress.

7. At the end of the installation phase, the Configuration Assistants window appears. This window lists the configuration assistants that are started automatically. 
If you are creating a database, then the Database Configuration Assistant starts automatically in a separate window.






At the end of database creation, you are prompted to unlock user accounts to make the accounts accessible. The SYS and SYSTEM accounts are already unlocked. Click OK to bypass password management.
Note: Oracle 10g still keeps HR /HR username and password (UID=HR, PWD=HR) from the old version of oracle. In the old version of oracle, HR/HR user ID is available by default, but not in oracle 10g. If you want to use  HR  / HR  account, you must unlock it by clicking “Password Management” at the last window. Password Management window will appear like the one shown below. Find the user name “HR” and uncheck the “Lock Account?” column for the user name.Here unlock two more account OE or SH..



8. Your installation and database creation is now complete. The End of Installation window displays several important URLs, one of which is for Enterprise Manager.


9. You can navigate to this URL in your browser and log in as the SYS user with the associated password, and connect as SYSDBA. You use Enterprise Manager to perform common database administration tasks 
Note : you can access Oracle Enterprise Manager using browser by typing the URL shown above in your browser. Instead of typing the IP address, you can also access the Enterprise Manager by typing http://localhost:1158/em or “http://[yourComputerName]:1158/em” or by clicking “Start >> All Programs >> Oracle – [YourOracleHome_home1] >> Database Control – [yourOracleID]” in Windows menu.
By default, use user ID “SYSTEM”, with the password that you have chosen at the beginning of installation, to connect to database, SQLPlus, etc. If you want to use other user ID, you may create a new user .



To test that your installation completed successfully, perform the following:
1.
When you click exit from the previous section, a browser opens and the Database Control URL is already launched. If this does not happen, open a browser and enter the following URL:
http://<hostname>:1158/em
Enter system as the User Name and oracle as the Password and click Login.






2.
The Licensing window appears. Scroll to the bottom and click I agree.



3.
The Database Control Home Page appears. Your Installation was successful. 







**********************END*********************************************





No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...