Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.usReceived on Sun Jun 23 2002 - 11:17:41 CDT