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:
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)
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"
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
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 loggon using password file - no success.