my database is not big enough, it is 3 gb.
before reading your post, i already has taken the following steps.
1.startup nomount the new 11g 64bit server.
2.copy the OLD server control files to the NEW 11g server control files locations.
3.alter database mount;
4. copy OLD datafiles and redolog files to the NEW location.
5.use alter database rename file to 'OLD FILE' to 'NEW FILE'; for all redo and datafiles.
6.alter database open;
it give the following error
ora-01092: ORACLE instance terminated.Disconnection forced
ora-00704:bootstrap process failure
ora-39700: database must be opened with upgrade option
then i search in google and do the following.
database is opened.
now the problem is this my all schemas exists here, but when i want to connect to any of the schema using command CONN HR/HR it give the following error:
ORA-only connect as sysdba is allowed when open in UPGRADE mode.
when i try to issue the command with @ sign, like CONN HR/HR@ORCL it give the follwoing error
ORA-12526: TNS: Listner all appropriate instances are in restricted mode.
i try the import export, there is a problem with it. it do not export ROLES.
i export HR schema, but when i try to import it, it says AD_ROLE does not exist.
AD_ROLES is one of the role i created.
the same error for all the roles.
how to completely export a schema with roles with everything?
i have a small database, and i could afford it.
You cannot copy over the database files to the target server and startup the database in upgrade mode and run the upgrade scripts unless your source database version has been patched to version 10.1.0.5
create the structure/skliton (create all what you have in 10g database)...of db on 11g home and then import data...... hope it will resolve the issue...
Database Migration With OS Upgrade On Windows Platform [ID 752986.1]
How to Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows based Intel Platforms Using the Database Upgrade Assistant (DBUA) [ID 757245.1]