Go Detailed procedures for installing Oracle 10g under WIN7 and resolution of issues

(1) Download Oracle 10g software on Oracle official website at: http://download.oracle.com/otn/nt/oracle10g/10203/10203_vista_w2k8_x86_ Production_db.zip, can directly copy in the Thunder and other download software directly to download.

(2) then modify the following files, the first one is the Refhost.xml file under disk1\stage\prereq\db\ Add the following content:

<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<version value= "6.1"/>
</OPERATING_SYSTEM>

The second is \disk1\stage\prereq\db_prereqs\db under the Refhost.xml file add the following:

<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<version value= "6.1"/>
</OPERATING_SYSTEM>

Then in the Oraparam.ini file under Disk1\install, add the following:

[Windows-6.1-required]
#Minimum display colours for OUI to run
min_display_colors=256
#Minimum CPU speed required for OUI
#CPU =300
[Windows-6.1-optional]

(3) WIN7 the installation of Microsoft LoopBack adapter, because Oracle 10g installs this in order to install it successfully, the following is the installation process:

1. Click Start Target, enter "Hdwwiz" in the smart search, and run the software in the search results as an administrator.

2. According to the Operating System wizard, select Install I manually select hardware from list (advanced).

3. Select "Network adapter" in the hardware list.

4. Select the Microsoft vendor, and on the right, select Microsoft LoopBack Adapter, and then press next to complete the installation as prompted.

5. In the network and Sharing Center in the Control Panel, select Change adapter configuration, one more local connection 2

Then right-click Status-Properties->internet protocol version ipv4-> using the specified IP address such as: 10.71.16.88, subnet mask: 255.255.0.0, default gateway is: 10.71.16.254. This completes the entire operation of the process.

The above 3 issues are frequently encountered during the installation process, after modification click Steup.exe to install, and then complete the installation.

You may also experience the following issues after installation:

(1) When you enter the Sql*plus will choose the user name and password when the time will be generated, connection as SYS should be as SYSDBA or sysoper the result.

The solution is: the user name is; The System password (password) is the one you set for that password.

The following is an explanation of the Oracle user name:

When you install Oracle, the default password is as follows if you do not reset the password for the following users:

User name/password
Login status
Description

The following format is arranged in the format above:

Sys/change_on_install
SYSDBA or Sysoper
Cannot log on as normal and can be used as the default system administrator

System/manager
Sysdba or Normal
Cannot log on as Sysoper and can be used as the default system administrator

Sysman/oem_temp
Sysman User name for OMS

Scott/tiger
NORMAL
Normal User

Aqadm/aqadm
Sysdba or Normal
Advanced Queue Administrators

Dbsnmp/dbsnmp
Sysdba or Normal
Replication Administrator

(2) Oracle:the account is a workaround for locked.

First Kind

Ora-28000:the account is locked
The first step: using PL/SQL, the login name is system, the database name is not changed, select the type of time to change the normal to SYSDBA;
The second step: select Myjob, view users;
Step three: Select System, right click on "edit";
Fourth step: Change the password, the "account is locked" tick off;
Fifth step: Click "Apply" and click "Close";
The sixth step: re-login can be verified by;

The second Kind

ALTER USER username account UNLOCK;

Third Kind

In Plsql Developer If you are logged in with Scott/tiger, ora-28000 the account is locked.

Workaround:

After the newly installed oracle10g, with the Scott/tiger test, the following error message will appear:
oracle10g the account is locked
oracle10g the password has expired
Cause: The default oracle10g Scott cannot log in.
Solve:
(1) Conn Sys/sys as SYSDBA; Log in as a DBA
(2) Alter user Scott account unlock;//then unlock
(3) Conn Scott/tiger//Popup A Password Change dialog box, modify the password can be

In the run input cmd in the DOS mode input sqlplus, the system user name login, password is just loaded Oracle self-filled password orcl, log in after.

Sql> Conn Sys/sys as SYSDBA; (semicolons are required but I am logged in as system this should not be written Conn Sys/sys as SYSDBA should write Conn SYSTEM/ORCL as SYSDBA;)
Connected.
sql> alter user Scott account unlock;
User altered.
Sql> commit;
Commit complete.
Sql> Conn scott/tiger//Please enter a new password and confirm the OK
Password changed
Connected.

At this time again to plsql developer inside to Scott/tiger login on it can be .....

User name/password for Oracle 10g default installation
Username
Password
Description
See Also

Ctxsys
Ctxsys
The Oracle Text account
Oracle Text Reference

Dbsnmp
Dbsnmp
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enterprise Manager Grid Control installation and Basic Configuration

Lbacsys
Lbacsys
The Oracle Label Security Administrator account
Oracle Label Security Administrator ' s Guide

Mddata
Mddata
The schema used by Oracle Spatial for storing Geocoder and router data
Oracle Spatial User ' s Guide and Reference

Mdsys
Mdsys
The Oracle Spatial and Oracle Intermedia Locator Administrator account
Oracle Spatial User ' s Guide and Reference

Dmsys
Dmsys
The Oracle Data Mining account.
Oracle Data Mining Administrator ' s Guide

Oracle Data Mining Concepts

Olapsys
MANAGER
The account used to create OLAP metadata structures. It owns the OLAP Catalog (cwmlite).
Oracle OLAP Application Developer ' s Guide

Ordplugins
Ordplugins
The Oracle intermedia user. Plug-ins supplied by the Oracle and third party format Plug-ins is installed in the this schema.
Oracle intermedia User ' s Guide

Ordsys
Ordsys
The Oracle Intermedia Administrator account
Oracle intermedia User ' s Guide

Outln
Outln
The account that supports plan stability. Plan stability enables you-maintain the same execution plans for the same SQL statements. OUTLN acts as a role to centrally manage metadata associated with stored outlines.
Oracle Database Performance Tuning Guide

Si_informtn_schema
Si_informtn_schema
The account, stores the information views for the SQL/MM still Image standard
Oracle intermedia User ' s Guide

SYS
Change_on_install
The account used to perform database administration tasks
Oracle Database Administrator ' s Guide

Sysman
Change_on_install
The account used to perform Oracle Enterprise Manager database administration tasks. Note that SYS and SYSTEM can also perform these tasks.
Oracle Enterprise Manager Grid Control installation and Basic Configuration

SYSTEM
MANAGER
Another account used to perform database administration tasks

(3) WIN7 processing generates sp2-0110 in the SQL command line with the edit directive: the problem of saving the file "Afiedt.buf" cannot be created.

The workaround is to set Sql*plus to run with administrator privileges because its permissions are insufficient to turn on Notepad.

Go Detailed procedures for installing Oracle 10g under WIN7 and resolution of issues