Home » RDBMS Server » Server Administration » Database move
Database move [message #168240] Wed, 19 April 2006 07:26 Go to next message
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
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Is the database already started ..do a ps -ef |grep pmon to see if the instance is already up and running ..

-Sai Jeedigunta
Previous Topic: how to configure more than one database
Next Topic: database connection problem
Goto Forum:
  


Current Time: Tue Feb 18 18:51:30 CST 2025