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

ORA-01034 with migration

I'm about to migrate an instance from 8.1.7 to version 9.2.0.6. Both of these version are in the same machine. When I migrate using DBUA from $ORACLE9_HOME/bin, I get the error message "ORA-01034: ORACLE not available." I am sure I have started up the database, I have checked the listener and I can connect to the database using another machine.

I'm about to migrate an instance from 8.1.7 to version 9.2.0.6 in Solaris Unix. Both of these version are in the same machine. When I migrate using dbua from $ORACLE9_HOME/bin, I get the error message "ORA-01034: ORACLE not available." I am sure I have started up the database, I have checked the listener and I can connect to the database using another machine. I have shut down and restarted the instance but still cannot proceed. Any help is much needed.
Ensure that the ORACLE_SID and ORACLE_HOME environment variables are set properly, and check to see that the oratab file has the correct ORACLE_HOME for the database you are attempting to upgrade. If all of this checks out and the DBUA still reports this error, you should be able to upgrade the database manually via scripts rather than through the DBUA. For more information, refer to the Oracle9i Release 2 Database Migration Guide found here.

Dig Deeper on Oracle database export, import and migration

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