Re: Copying database instance from one server to another

Comments embedded.
dima_at_inotech.ru wrote:
> Hello All!
>
> I want to copy database instance from one server to another.
> Servers configuration:
> 1) Server from
> Red Hat Linux 7.3 and Oracle 8.1.7
> 2) Server to
> Red Hat Linux 9 and Oracle 8.1.7 (without database instance)
>
> I have copyed $ORACLE_BASE/admin and $ORACLE_BASE/oradata from one
> server to another.

This does not appear to be a problem.

> After this, I have set same oracle environment variables on new server.
>

I'm thinking you may have missed one or set them incorrectly as the LCC-00161 error attests.

> The following errors occured when I trying to startup instance
> /////////////////////////////////////////////////////////////////////////////
> -bash-2.05b$ dbstart
> Oracle Server Manager Release 3.1.7.0.0 - Production
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> ORA-03113: end-of-file on communication channel
> SVRMGR> Password:
> Password:
> ORA-03113: end-of-file on communication channel
> SVRMGR> LCC-00161: Message 161 not found; product=SVRMGR; facility=MGR
>

Possibly ORACLE_HOME is set incorrectly, and thus your path is pointing to the wrong location.

> ORA-03113: end-of-file on communication channel
> SVRMGR>
> Server Manager complete.
>
> Database "MYDB1" warm started.
> ////////////////////////////////////////////////////////////////////////////////
> Can anybody help please?

Another possibility is incorrectly set kernel parameters, however the error you've reported indicates you have improperly set the ORACLE_HOME variable or forgot to add $ORACLE_HOME/bin to your PATH; my guess is ORACLE_HOME isn't set correctly.

I would check your environment for improper/incorrect settings.

David FItzjarrell Received on Tue Jan 24 2006 - 12:37:25 CST