Home » RDBMS Server » Server Utilities » Import Database (Merged)
Import Database (Merged) [message #239225] Mon, 21 May 2007 15:59 Go to next message
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 Go to previous messageGo to next message
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
icon8.gif  Re: Oracle Patches [message #239229 is a reply to message #239225] Mon, 21 May 2007 16:10 Go to previous messageGo to next message
JBurch
Messages: 15
Registered: May 2007
Junior Member
It doesn't let me register
Re: Oracle Patches [message #239231 is a reply to message #239229] Mon, 21 May 2007 16:15 Go to previous messageGo to next message
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.
Import Database [message #239233 is a reply to message #239225] Mon, 21 May 2007 16:47 Go to previous messageGo to next message
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
Re: Import Database [message #239309 is a reply to message #239233] Tue, 22 May 2007 00:36 Go to previous messageGo to next message
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

Re: Import Database (Merged) [message #239467 is a reply to message #239225] Tue, 22 May 2007 08:20 Go to previous messageGo to next message
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?
Re: Import Database (Merged) [message #239470 is a reply to message #239467] Tue, 22 May 2007 08:22 Go to previous messageGo to next message
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
Re: Import Database (Merged) [message #239513 is a reply to message #239225] Tue, 22 May 2007 09:53 Go to previous messageGo to next message
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
Re: Import Database (Merged) [message #239514 is a reply to message #239513] Tue, 22 May 2007 09:55 Go to previous messageGo to next message
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
Re: Import Database (Merged) [message #239524 is a reply to message #239225] Tue, 22 May 2007 10:23 Go to previous messageGo to next message
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?
icon7.gif  Re: Import Database (Merged) [message #239605 is a reply to message #239225] Tue, 22 May 2007 13:50 Go to previous messageGo to next message
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
Re: Import Database (Merged) [message #239614 is a reply to message #239225] Tue, 22 May 2007 14:30 Go to previous messageGo to next message
JBurch
Messages: 15
Registered: May 2007
Junior Member
New question... When importing a DB to a new DB... does the names of the importing DB have to be the same as the exporting DB?
Re: Import Database (Merged) [message #239619 is a reply to message #239614] Tue, 22 May 2007 14:41 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
not necessary.
Previous Topic: impdp Import of table having object types of other schema
Next Topic: Oracle Redo log Multiplexing
Goto Forum:
  


Current Time: Fri Dec 09 23:05:09 CST 2016

Total time taken to generate the page: 0.11588 seconds