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 editedrefhost.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 thec:\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 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.