Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Copying zipped files to 10g
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Copying zipped files to 10g

Maria Anderson EXPERT RESPONSE FROM: Maria Anderson

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 24 July 2006
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle database installation, upgrades and patches
How to use the Oracle Database Upgrade Assistant (DBUA)
Oracle delivers database fixes in Critical Patch Update
How to get the most out of Toad for Oracle 10
Coca-Cola Bottling swaps out Oracle for DB2
Oracle renews push into embedded open source software market
Oracle releases new database, says 11g upgrade will cut costs
Comparing servers for Oracle database 11g upgrades
Choosing the right server hardware is all about choosing the right software
The best of the Oracle 11g-ready servers
Can Sun shine running Oracle 11g?

Oracle error messages
Oracle error 6550 may mean incorrect Oracle export version
Why does the archive log in Oracle give me the ORA-16032 error?
Are we getting the ORA-00382 error because we're at maximum block size?
How do I solve the ORA-00257 error in Oracle?
Solving common Oracle errors guide
Solving common Oracle errors guide
Error during RMAN backup
ORA-12560 error with Oracle 10g Instant Client
Unable to view Oracle tables in NetBeans
IMP-00017 error message with Oracle import

How to upgrade to Oracle 10g
Steps to migrate from Oracle 8.0.6 to Oracle 10g R2
Easiest way to migrate from Oracle 7i to Oracle 10g
How to migrate Oracle 10g to RAC cluster on Linux
Migrate 6 TB of data from Oracle 8.1.7 to Oracle 10gR2
Impact of Oracle 8i to Oracle 10g migration on scripts
Lessons Learned: Upgrading to Oracle 10g
Database too large for exp/imp migration
How to apply patch to Oracle 10g on Linux?
Migrating 9i database on Windows to 10g on SLES
Impact on memory for upgrade to Oracle 10g

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
10g  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts