Database move [message #168240] |
Wed, 19 April 2006 07:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sxramas
Messages: 16 Registered: January 2006 Location: Chennai
|
Junior Member |
|
|
Hello ,
I moved a database ORADEV from dev01 unix machine to dev02 unix machine. I copied the all the files in oracle_home and all the data files,relog files and control files. When I try to go the server manger mode I get the following error.
unixdev02cequge:oracle$svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
ORA-03113: end-of-file on communication channel
SVRMGR> connect internal@oradev
Password:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
SVRMGR>
I have another instance (TEMP) running on Dev02 . When i go to the server manager mode of that I get the following error
unixdev02cequge:oracle$svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.1.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup pfile=/opt/oracle/app/oracle/product/8.1.6/dbs/initORADEV.ora
ORA-01081: cannot start already-running ORACLE - shut it down first
SVRMGR>
Can you please how should i start the ORADEV instance ? Your quick response is appreciated
Thanks,
Siva
|
|
|
Re: Database move [message #168297 is a reply to message #168240] |
Wed, 19 April 2006 11:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
vjeedigunta
Messages: 201 Registered: March 2005 Location: Hyderabad
|
Senior Member |
![vasu_jeedigunta](/forum/theme/orafaq/images/yahoo.png)
|
|
Is the database already started ..do a ps -ef |grep pmon to see if the instance is already up and running ..
-Sai Jeedigunta
|
|
|