This content has been marked as final. Show 5 replies
Pl post exact OS details, along with a link to the document you followed for the upgrade. Looks like your database files have the value "10.2.0" hardcoded in the file paths, which is always a bad idea :-)
One option is to rename the 10.2.0 datafile directories to something generic, then use the ALTER DATABASE DATAFILE RENAME clause to correct the location in the control file.
How to Rename or Move Datafiles and Logfiles [ID 115424.1]
For the control files, shutdown the database, rename the 10.2.0 hardcoded path to something generic, modify the init.ora file to reflect the new locations of the control file, then startup the database.
Pl ensure that you have a good cold backup before attempting this.
Thanks Srini..I will go through this and update you.
OS - RHEL 5.5 32 bit
After upgrding database , am getting below value for timeszone.
SQL> select * from v$timezone_file;
Please tell me what is the required version for 18.104.22.168 and how I can achieve the same.
Were your earlier path issues solved ?
Pl see this MOS Doc
Updating the RDBMS DST version in 11gR2 (22.214.171.124 and up) using DBMS_DST [ID 977512.1]
Thanks Srini...Issue resolved.