startup pfile =d: some path; Error : processing parameters Startup upgrade pfile=d:It's working and the database opened but the problem is when I try to connect as a user it's giving an error and we are not able to create a user also. I typed
select file_name , tablespace_name from dba_data_files;Then it hangs. Before I created SYSAUX TS also. Is the problem with the 10g upgrade? Please help.
The most efficient solution would be to install the proper software (release 188.8.131.52) and use it to start this database. If the database was release 184.108.40.206, you would be able to start it using the 10g software but only after upgrading the database itself to 10g (I am assuming that you are referring to Oracle 10g release 2). Because the database is 220.127.116.11, Oracle does not support an upgrade in place to 10g release 2.
My recommendation would be to install Oracle 18.104.22.168 so that you can at least open the database with the proper Oracle software. If, at that point, you wish to upgrade it to Oracle 10g, this can be done by following the upgrade instructions in the Oracle Database 10g Release 2 Upgrade Guide.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.