Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Import and Export - UNIX

Re: Oracle Import and Export - UNIX

From: vc <enzo67_at_yahoo.com>
Date: Wed, 12 Jun 2002 16:21:45 -0400
Message-ID: <Z1ON8.521557$%u2.348510@atlpnn01.usenetserver.com>


Your right It started up after using the startup command etc.

Thanks
Vin

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:3d078870.607437809_at_news.globix.com...
> If binaries and datafiles and config files are located on the
> external drives, and you mount everything exactly like it was on the
> other machine, you should be able to start up the database (key is, to
> start up the database,
> #sqlplus internal
> SQL> startup).
>
> U can also install the binaries and copy the config files, if only
> datafiles are on the disk drives.. from your output it looks like
> binaries are on the disks you're moving
>
> You might also have to tweak /etc/systems file, check oracle's install
> manual.
>
> On Wed, 12 Jun 2002 13:09:42 -0400, "vc" <enzo67_at_yahoo.com> wrote:
>
> >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
> >
> >
> >
>
> .......
> We use Oracle 8.1.7.3 on Solaris 2.7 boxes
> remove NSPAM to email
Received on Wed Jun 12 2002 - 15:21:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US