Re: Oracle Import and Export - UNIX

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 - 12:47:30 CDT