May 21, 2009 at 11:13 am
Hi all,
I've been handed a backup of an Oracle DB.
We need to get that data into a SQL Server DB.
I haven't the faintest idea how. I've installed Oracle 9i personal on a spare server.
I don't know the Oracle lingo for creating a DB, restoring a backup, etc.
It keeps asking me for a Service Name?
Can anyone point me in the right direction?
Thanks,
Paul
May 21, 2009 at 11:35 am
1)You can get the service name from your .ORA file (Where ever ur Oracle installation folder is) or if click on ur if u click on databases on ur enterprisemanager console, on right side of your grey console window it will give u serice name under TNS Descriptor or Service Name:
2)Assuming u have ur Oracle backup file(.dmp), u will have to restore it using "imp" utility. U can look up that in google.
From ur DOS Prompt,
A)C:\SET ORACLE_SID=
B)C:\SET ORACLE_HOME=c:\Oracle\Ora92
C)imp File=E:\UrBackupFilename.dmp Indexes=y Log=E:\Logfilename.log userid=UserName Pwd=UrPwd FROMUSER=UrSchemaName TouserUrcurrentSchemaName ignore=y rows=n Statistics=Recalculate
Before U run Step (C), U have to create ur TableSpace and user in Oracle
3)After Step 2 is successfully done, where ever ur Sql is installed, u have to Install Oracle client tools and then use DTS import export utility to import tables and their rows into Sql server.
I just have summed up whole process, it will be lot more complicated when u actually do it. But u can use it to research more about each n every step in detail(to get proper syntax etc etc)
May 21, 2009 at 1:05 pm
Thanks for the response.
These services are running under local system accounts.
OracleOraHome92Agent
OracleOraHome92TNSListener
That's a start, I guess.
I can't find the strings "service name", or "service name" in any .ORA file on the box on which I've installed Oracle.
I'm afraid I just don't know what the wizards are asking for.
I'll keep plugging away...
May 21, 2009 at 1:16 pm
Do a search on ur computer by filename tnsnames.ora, u will find "SERVICE_NAME" in there
July 13, 2009 at 7:04 am
If those are the only oracle services you have then it sounds like you haven't actually got a database set up. There should be a tool installed that will guide you through creating a database (DataBase Configuration Assistant?). Once you have done this you can use the database name you created as the oracle_sid and do the import.
August 5, 2009 at 11:03 am
Alright, getting somewhere now.
I have the Oracle Management Server up and running, can connect using Oracle EM.
However, when I try to click on my database, I get a login screen. I have used the NT Administration Assistant to grant my NT account, which has Local Admin on the NT Server upon which Oracle is installed, OS DB Admin and OS DB Operator membership, at the server and Oracle DB level. Also made myself External OS user, and granted myself Local Roles in my DB.
So, what do I enter in the DB login screen in Oracle EM?
TIA,
P
August 6, 2009 at 10:07 am
Do you actually have a database set up on your system? If not, use the Database Configuration Assistant to create a blank database then use the import command to import the .dmp file into the database. The database configuration assistant will ask you for a password during setup. Then you will be able to log in through EM.
August 6, 2009 at 12:16 pm
Thanks for that.
Now, I have access to a DB I created, Test.
I have placed it in Mounted mode, which should enable recovery.
I right-click on the Test database, Backup Management, Recovery. The wizard launches, informs me that I can only recover the entire DB (good). The next screen (Configuration) asks for a predefined configuration, and the only possible option is Test, which of course does not point at the file/folder I'm trying to restore.
P
August 6, 2009 at 12:33 pm
Assuming your database backup is a *.dmp file, I would use the import utility at a command prompt instead of going through EM to restore the database. You can find out more on this utility at the following site: http://www.orafaq.com/wiki/Import/_Export_FAQ
August 6, 2009 at 12:40 pm
Nice!!! The people who did the backup cleverly named the file h26b_full.Mar04 -- no doubt so we could tell it was done on March 4 -- which we already knew from the date on the file...
It's 20 GB. I don't wanna make it unusable. Do you think there's any harm in trying to rename it to h26b_full.dmp? Or should I make a copy of the file before I try that sort of thing? I have a hard copy, but the decompression took most of a day.
August 6, 2009 at 12:46 pm
Are you sure the backup was taken using Oracle Export utility?
August 6, 2009 at 1:17 pm
I've initiated an inquiry.
I'll respond when I get an answer.
I hope they're not on holidays...
Thanks for the help so far.
August 11, 2009 at 10:06 am
It turns out it was done with the Oracle export utility.
August 11, 2009 at 10:49 am
Try the import and let us know how it goes. Good luck.
August 11, 2009 at 12:19 pm
Failed:
VNI-2015 : The Node preferred credentials for the target node are either invalid or do not have sufficient privileges to complete the operation.
On Windows platforms, the Node credentials specified for the Windows target
should have the "Logon as a batch job" privilege.
I am running on Win2K3. Where do I find Preferred Credentials and set that privilege?
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply