Re: Oracle Import and export - UNIX

From: bigt <ctaustin_at_hotmail.com>
Date: 17 Jun 2002 20:53:28 -0700
Message-ID: <cd68b082.0206171953.3ec1b83e_at_posting.google.com>


"vc" <enzo67_at_yahoo.com> wrote in message news:<ndLN8.514964$%u2.4740_at_atlpnn01.usenetserver.com>...
> Hello all and I apologize not being an ORACLE guy or big UNIX guy.
>
> Scenario
>
> 1. Solaris 2.7 machine
> 2. ORACLE 7.3.4
> 3. Solaris has 3 External drives
> 4. The database files are located on the external Drives.
>
> The 2.7 Soalris machine is close to death and have another 2.7 machine where
> I would like to put the database.
>
> I simply attached the External drives to the new Solaris 2.7 machine and got
> the system and typed "sqlplus".
>
> I got a login, and attempted to login in.
>
> The error says:
>
> ORA-01034: ORACLE not Available
> ORA-07429: smsmsg: shmget() Failed to get segment
> SVR Error: 2: No Such File or Directory
>
> MY Assumption
> Since I never literally installed ORACLE on the new machine the config files
> are all wrong.
>
> Question:
> can the config files be manipulated manually or is it better to reinstall
> all of oracle and then grab the Database???
>
>
> Thanks Alot in advance
>
> Vin

Your best bet is to reinstall the software. There are files that are created outside of the Oracle Home path such as /var and so forth. So if you tried to copy/manipulate them by hand you could easily miss something. Received on Tue Jun 18 2002 - 05:53:28 CEST

Original text of this message