Installing Oracle on Unix [message #146169] |
Wed, 09 November 2005 00:18 |
puneetsachar
Messages: 97 Registered: March 2005 Location: New Delhi, India
|
Member |
|
|
Hi Everyone
I have one cold back of datafiles and oracle home and I want to install the Oracle to new server.
Do I need to install Oracle (8.1.7.4) on new server or can I just coppy accross the files and bring the database up.
Is there any documentation avaliable how can I go about it.
Please help me how to go about it, if I copy across the files and oracle home what all I have to do to bring up the database.
I'm in the process of cloning one apps instance. and unfortunately we are not following standard Oracle guidlines, so cannot ask help from metalink.
Puneet
|
|
|
|
Re: Installing Oracle on Unix [message #146233 is a reply to message #146215] |
Wed, 09 November 2005 08:59 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
I would say
1. Install the Oracle binaries in the new server (keep it at the same level, including the patch (8.1.7.4.0)
2. make same file structure as in the original db
3. copy the cold backup in the corresponding folder.
3. make sure you get the init.ora, listener.ora and tnsnames.ora also
4. fire up the database
Note: The only reason I would do a clean install of the binaries is bocoz during the install, there can be soft links in the server you are not aware of.
I would say, if done carefully, you have a 98% chance your new db will fire up.
IF you want to change the file structure, then you will have to create the control files.
I am in the process of moving to a new server (all 21 databases) and this is exactly what I am doing. In fact I am creating the control files on the new server as I did make changes in the file structure.
And as said above, do a search in this group for other threads.
Good luck.
--
Sanjay
[Updated on: Wed, 09 November 2005 09:01] Report message to a moderator
|
|
|
|
|
Re: Installing Oracle on Unix [message #222821 is a reply to message #146169] |
Tue, 06 March 2007 09:26 |
--Ex--
Messages: 1 Registered: March 2007
|
Junior Member |
|
|
Hello, I have the same problem and I resolved it.
<ORACLE>$ export ORACLE_SID= <INSTANCE>
<ORACLE>$ sqlplus /nolog
SQL> connect /as sysdba
SQL> shutdown abort
SQL> exit
2 processes are not stoped and I kill them.
For me, these processes are: "ora_dbw0_xxx" and "ora_pmon_xxx"
and after-, I can start my database without problem:
<ORACLE>$ sqlplus /nolog
SQL> connect /as sysdba
SQL> startup
|
|
|
|
|