OraFAQ Forum: Server Utilities » Import Database (Merged)

Home » RDBMS Server » Server Utilities » Import Database (Merged)

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

Import Database (Merged) [message #239225]

Mon, 21 May 2007 15:59

JBurch
Messages: 15
Registered: May 2007

Junior Member

I need some help, I am trying to import a dmp file. First I need to patch up Oracle to 9.2.0.6.0 Right now I only have the patches 9.2.0.4.0 and 9.2.0.6.0. I do not have the patches in between. Can anyone help me find them, and also do you think I need them? I have looked everywhere. Please help!!!

[Updated on: Tue, 22 May 2007 00:39] by Moderator

Report message to a moderator

Re: Oracle Patches [message #239226 is a reply to message #239225]

Mon, 21 May 2007 16:01

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

just download them from

https://metalink.oracle.com/metalink/plsql/f?p=200:10:5266541089046176685

Report message to a moderator

Re: Oracle Patches [message #239229 is a reply to message #239225]

Mon, 21 May 2007 16:10

JBurch
Messages: 15
Registered: May 2007

Junior Member

It doesn't let me register

Report message to a moderator

Re: Oracle Patches [message #239231 is a reply to message #239229]

Mon, 21 May 2007 16:15

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

you dont have access to METALINK.
Then ask your senior about that.Because they charge for service.

Report message to a moderator

Import Database [message #239233 is a reply to message #239225]

Mon, 21 May 2007 16:47

JBurch
Messages: 15
Registered: May 2007

Junior Member

Hello, I have a few questions about importing a database.
1. can I import from oracle 9.2.0.6.0 to a oracle 9.2.0.1.0? Or do I need to patch it up.
2. What are the steps to import a database. I have a log file and the dmp file. I am not sure how to do this. Any help would greatly be appriciated. I really don't know oracle databases that much.
Thank you

Report message to a moderator

Re: Import Database [message #239309 is a reply to message #239233]

Tue, 22 May 2007 00:36

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

1.AFAIK, yes you can do without apply any patch.
2.On command prompt ( c:\> / $)

$imp help=y

or search on board for example.

Regards
Taj

Report message to a moderator

Re: Import Database (Merged) [message #239467 is a reply to message #239225]

Tue, 22 May 2007 08:20

JBurch
Messages: 15
Registered: May 2007

Junior Member

As for patching up oracle to 9.2.0.6.0... from 9.2.0.1.0 the only patch i have is 9.2.0.4.0 and 9.2.0.6.0.... can I just use the 9.2.0.6.0 patch? or do i need the ones that come before that?

Report message to a moderator

Re: Import Database (Merged) [message #239470 is a reply to message #239467]

Tue, 22 May 2007 08:22

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Yes, you can use '9.2.0.6.0' Patch. no need to apply '9.2.0.4.0' when you apply higher patch.

Always apply higher patch set for database.
Regards
Taj

Report message to a moderator

Re: Import Database (Merged) [message #239513 is a reply to message #239225]

Tue, 22 May 2007 09:53

JBurch
Messages: 15
Registered: May 2007

Junior Member

How do I apply this patch? I go to install.exe of the patch. then it wants to install to a new path Home1.. instead of ora92. Can someone please help me install this patch

Report message to a moderator

Re: Import Database (Merged) [message #239514 is a reply to message #239513]

Tue, 22 May 2007 09:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Are you read "README.TXT" file...
follow readme.txt file instruction and apply patch set.

Regards
Taj

Report message to a moderator

Re: Import Database (Merged) [message #239524 is a reply to message #239225]

Tue, 22 May 2007 10:23

JBurch
Messages: 15
Registered: May 2007

Junior Member

when i do the install there is an error saying that some of the products are being reinstalled are using the program. please shut down the program and try again... the only thing that is running is the installer... anyone ever get this error?

Report message to a moderator

Re: Import Database (Merged) [message #239605 is a reply to message #239225]

Tue, 22 May 2007 13:50

JBurch
Messages: 15
Registered: May 2007

Junior Member

I finally got it. I shut down all the oracle services but I guess siebel was still trying to use oracle for some reason. So I shutdown those services and it worked... thanks for all the help. Razz