Re: Oracle Import and Export - UNIX

"vc" <enzo67_at_yahoo.com> wrote in
news:0eLN8.514981$%u2.39455_at_atlpnn01.usenetserver.com:

> 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
>
>
>
 

Assuming the paths to the datafiles and the oracle install tree are all the same on the boxes, you should only have to check a few things.

Look for the /etc/oratab file. Copy it from the old box.

Look for /etc/oraInst.loc and/or /var/opt/oracle/oraInst.loc.

If the new box has a new name and IP address, instead of re-using the old one, you'll have to change your tnsnames.ora and listener.ora files in $ORACLE_HOME/network/admin.

Compare /etc/system on the 2 boxes. Most likely your init.ora is calling for more shared memory than the kernel is configured for.

Fix and reboot the box if the /etc/system file had to change.

-- 
Jason Baugher 
Virtual Adept Professional Consulting Services
1406 Adams St.
Quincy, IL 62301
(217) 221-5406
http://baugher.pike.il.us/virtualadept
jason_at_baugher.pike.il.us