OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » oracle 9i question (9.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle 9i question [message #516041]

Thu, 14 July 2011 13:43

patdev
Messages: 73
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

Report message to a moderator

Re: oracle 9i question [message #516042 is a reply to message #516041]

Thu, 14 July 2011 13:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: oracle 9i question [message #516044 is a reply to message #516042]

Thu, 14 July 2011 14:10

patdev
Messages: 73
Registered: August 2008

Member

there are same os packages and structure of file and system all the database are same as server A

Report message to a moderator

Re: oracle 9i question [message #516046 is a reply to message #516044]

Thu, 14 July 2011 14:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: oracle 9i question [message #516049 is a reply to message #516046]

Thu, 14 July 2011 14:42

patdev
Messages: 73
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

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: oracle 9i question [message #516051 is a reply to message #516050]

Thu, 14 July 2011 14:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: oracle 9i question [message #516053 is a reply to message #516049]

Thu, 14 July 2011 15:39

John Watson
Messages: 8931
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.

Report message to a moderator

Re: oracle 9i question [message #516101 is a reply to message #516053]

Fri, 15 July 2011 01:59

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.

Report message to a moderator

Previous Topic:	NLS_COMP and NLS_SORT (merged)
Next Topic:	DUAL, FAST DUAL et. al.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 12:53:54 CDT 2024