Q
Problem solve Get help with specific problems with your technologies, process and projects.

Copying zipped files to 10g

Our project people are sending files (.ctl, .log, .dbf, init.ora) through mail in a zip format. These files were under Oracle 9.2.0.1.0, but I installed 10g and I copied those files in 10g. I'm getting an error. Is the problem with the 10g upgrade?

I have a problem. Our project people are sending files (.ctl, .log, .dbf, init.ora) through mail in a zip format. These files were under Oracle 9.2.0.1.0, but I installed 10g and I copied those files in 10g. After that I started with a command:
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.
If I understand your situation correctly, you regularly receive a physical copy of an entire Oracle 9.2.0.1 database, which you are then attempting to start on your server using Oracle 10g software. If this is the case, you cannot use Oracle 10g software to simply start this database. The database must be started with the same release software it was using at the time it was copied and sent to you.

The most efficient solution would be to install the proper software (release 9.2.0.1) and use it to start this database. If the database was release 9.2.0.4, 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 9.2.0.1, Oracle does not support an upgrade in place to 10g release 2.

My recommendation would be to install Oracle 9.2.0.1 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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close