Home » RDBMS Server » Server Administration » oracle 9i question (9.2.0.4)
oracle 9i question [message #516041] Thu, 14 July 2011 13:43 Go to next message
patdev
Messages: 55
Registered: August 2008
Member
Hi,

It is just thought or trial,

I have one server A with oracle 9i (9.2.0.4) i know it is not supported but department still using is for old application.

I have give new server B. If i copy everything just like on the server A to Server B will i be able to start instance?

Please guide
Re: oracle 9i question [message #516042 is a reply to message #516041] Thu, 14 July 2011 13:47 Go to previous messageGo to next message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

answer depends on exactly what is same & what is different between the 2 servers
Re: oracle 9i question [message #516044 is a reply to message #516042] Thu, 14 July 2011 14:10 Go to previous messageGo to next message
patdev
Messages: 55
Registered: August 2008
Member
there are same os packages and structure of file and system all the database are same as server A

Re: oracle 9i question [message #516046 is a reply to message #516044] Thu, 14 July 2011 14:20 Go to previous messageGo to next message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
>I have give new server B. If i copy everything just like on the server A to Server B will i be able to start instance?
do clean SHUTDOWN on Server A, copy all necessary files to same directories on Server B & STARTUP both databases
Re: oracle 9i question [message #516049 is a reply to message #516046] Thu, 14 July 2011 14:42 Go to previous messageGo to next message
patdev
Messages: 55
Registered: August 2008
Member
i have done that now but when i go to sqlplus and log in as sys as sysdba it says insufficient previlege. So i cannot pass through the sqlpplus to start the database!! guide

[Updated on: Thu, 14 July 2011 14:43]

Report message to a moderator

Re: oracle 9i question [message #516050 is a reply to message #516049] Thu, 14 July 2011 14:47 Go to previous messageGo to next message
ThomasG
Messages: 3103
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
According to the data you gave us:

Everything is not the same. Make everything the same (including OS users and file permissions), then try again.

Re: oracle 9i question [message #516051 is a reply to message #516050] Thu, 14 July 2011 14:49 Go to previous messageGo to next message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: oracle 9i question [message #516053 is a reply to message #516049] Thu, 14 July 2011 15:39 Go to previous messageGo to next message
John Watson
Messages: 4709
Registered: January 2010
Location: Global Village
Senior Member
This problem could be because even though your username and groups are the same on both machines, your UID and GIDs are not.
Re: oracle 9i question [message #516101 is a reply to message #516053] Fri, 15 July 2011 01:59 Go to previous message
raj9999
Messages: 49
Registered: June 2011
Member
Problem might be with the UID's & GID's as referred by John. Check them & revert. Also, crosscheck all the required files on the server B like password file etc.
Previous Topic: NLS_COMP and NLS_SORT (merged)
Next Topic: DUAL, FAST DUAL et. al.
Goto Forum:
  


Current Time: Fri Oct 31 05:02:41 CDT 2014

Total time taken to generate the page: 0.10699 seconds