Windows – Install Oracle 10.2.0.4 on Windows Server 2012 R2

installationoracleoracle-10gsqlpluswindows-server

I have problem with installing Oracle 10.2.0.4 on Windows Server 2012 R2.

We are running old 10.2.0.4 instance on Windows Server 2008 R2. Now I have to migrate it to the Windows Server 2012 R2. Because the application using the db is old and without support, it is very risky to migrate the db to 11g or 12c. I know that 10.2.0.4 is no longer supported and 2012 R2 is not certified for 10.2.0.4.

I have tried the following steps:

  1. To run the installer I have edited the [Certified Versions] in oraparam.ini:
    Windows=5.0,5.1,5.2,6.0,6.1,6.2 (I have also edited refhost.xml the same way)

  2. Then I have run the installer with "run as administrator" (I am logged as domain admin on the server) and I have installed "software only"

  3. Then I have generated the create scripts using dbca and created the instance:

    a) mkdir adump, dpdump etc.

    b) c:\oracle10\product\10.2.0\db_1\bin\oradim.exe -new -sid test10 -startmode manual

    c) c:\oracle10\product\10.2.0\db_1\bin\oradim.exe -edit -sid test10 -startmode auto -srvcstart system

    d) c:\oracle10\product\10.2.0\db_1\bin\orapwd.exe file=c:\oracle10\product\10.2.0\db_1\database\PWDtest10.ora password=test10 force=y

    e)I have copied the pfile to the c:\oracle10\product\10.2.0\db_1\database

  4. now I want to connect to the idle instance to run startup nomount:

Edit:

I am trying to connect this way under windows command prompt:

set oracle_home

set oracle_sid

sqlplus / as sysdba

But I get following error:

ORA-12546: TNS:permission denied

Then I have edited sqlnet.ora and changed sqlnet.authentication_services = (nts) to (none) and tried to logon using password file – no success.

The ORACLE_SID variable is set correctly.

Best Answer

With no success with installing Oracle 10.2.0.4, we've tried 10.2.0.5. The installation worked without any problem.