on 08-11-2005 2:02 PM
Hi,
I've installed the MDM 5.5 today in my system landscape. Server and Tools are all installed, no problem.
After importing data from MSAccess-databases, XML-sheets and excel-sheets, i tried to import data from a oracle-database. But the ImportManager couldn't establish a connection to the dbms.
Probably i got the wrong configuration values in the "connect to source" dialog.
DBMS Server: 192.168. *. * //Server ip where Oracle is installed
Database: addressesdb
User: * //has all rights
Password: * //verified it
Maybe somebody can help and tell me whats wrong. Do I have to add a port or complete Database URL?
I didn't find an example in the Import Manager Reference Guide.
Thx a lot.
In import Manager while trying to put source as Oracle,I'm getting error
ORA-06401: NETCMN : Invalid Driver Designator
Entries I'm doing on the screen are:
Database Server : HOSTNAME:PORT
Database: ORACLE_SID
Username: VALID USER
Password: VALID PASSWORD.
I've tried giving only HOSTNAME i.e. NO PORT in database server but then I get an error ORA: 12637: Packet Receive failed.
Otherwise the same connection is working fine at SQL Prompt.
thanks for the help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andreas,
You have to configure the oracle service and provide that service name in DBMS Server instead of IP/Machine Name. Here I assume that you already know that how to create the oracle service.
Hopefully this will work.
Regards
Shahid Nadeem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try to right click on the server name in the console, and select DBMS settings. Give the database name, login and password, and try connecting. Does that work?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm having the same problem as Andreas. I can connect to a specific Oracle database using several different client applications, but get the same errors Andreas did when attempting to connect via MDM Import Manager.
I also tried using the ODBC connector, but that has been just as fruitless. I have a dsn file that I use to connect to the above Oracle database from other client apps, but MDM IM gives the following error message when I ty to connect:
Login Error:[Microsoft][ODBC Driver Message]Data source not found and no default driver specified.
I do not get this error in any other client apps. I tried both with and without the .dsn extentsion. I also tried giving the full path to the dsn file, but then I get a "source name too long" message.
Has anyone else successfully imported from Oracle -- either directly or through an ODBC connection?
Thanks,
Vince Moore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I can connect to the ressource with DBVisualizer and view the database. I can add new tables, i have full access to the database, everything looks fine, except the connection via the Import Manager.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what happens with you connect to Oracle? Do you get any error message or it just hangs? If it only hangs then it might be you're using too powerful user and the ImportManger in the very beginning tries to list all available tables. If so it can take LOTS of time.
Please explain your error message. In general what you do is absolutely ok and should work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.