cancel
Showing results for 
Search instead for 
Did you mean: 

MTK-14003 missing users couldn't be found in source Oracle database

Highlighted
Adventurer

MTK-14003 missing users couldn't be found in source Oracle database

Having some diffculties getting MTK to migrate a database from Oracle12c.  I have about scratched my head bald on this one.  If anyone has any ideas or experiance dealing with this error please share.

 

Thanks

[root@master bin]#

[root@master bin]# pwd

/home/enterprisedb/mtk/bin

[root@master bin]# ls

edb-migrationtoolkit.jar  nohup.out  runMTK.sh

[root@master bin]# ./runMTK.sh schema

Running EnterpriseDB Migration Toolkit (Build 50.0.1) ...

Source database connectivity info...

conn =jdbcSmiley Surprisedracle:thin:@10.209.8.74:1521Smiley FrustratedID

user =sys as sysdba

password=******

Target database connectivity info...

conn =jdbc:edb://localhost:5444/sid

user =enterprisedb

password=******

Connecting with source Oracle database server...

Connected to Oracle, version 'Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production'

Connecting with target EDB Postgres database server...

Connected to EnterpriseDB, version '9.6.2.7'

Importing redwood schema schema...

 

Schema ndexrtp imported successfully.

 

MTK-14003: One or more users couldn't be found in the source Oracle database.

With -users mode, the user name should be in uppercase unless it is case-sensitive.

 

One or more schema objects could not be imported during the migration process. Please review the migration output for more details.

 

Migration logs have been saved to /root/.enterprisedb/migration-toolkit/logs

 

******************** Migration Summary ********************

 

Total objects: 0

Successful count: 0

Failed count: 0

Invalid count: 0

 

2 REPLIES
EDB Team Member

Re: MTK-14003 missing users couldn't be found in source Oracle database

@montereyray, the way you are calling the script - I am not clear on how you are doing it.

 

./runMTK.sh  ndexrtp  should be the right way.  Instead, I see ./runMTK.sh schema.  Am I reading it incorectly ?

 

It looks like it is complaining that it cannot find a schema called 'schema'.

Can you also check the contents of the mtk logfile and post it ?

Adventurer

Re: MTK-14003 missing users couldn't be found in source Oracle database

Hi,

Thanks for the response, below are additional details.  I'm curious what MTK-14003 means.  It seems maybe the oracle account we attempting to perform the migration from does not have the rights to read the users definitions.  Additional details are listed below.

 

Getting Profile Resource Definitions...

Getting Roles Definitions...

Getting Users Definitions...

MTK-14003: One or more users couldn't be found in the source Oracle database.

With -users mode, the user name should be in uppercase unless it is case-sensitive.

Stack Trace:

com.edb.MTKException: MTK-14003: One or more users couldn't be found in the source Oracle database.

With -users mode, the user name should be in uppercase unless it is case-sensitive.

        at com.edb.MigrationToolkit.migrateUsers(MigrationToolkit.java:3745)

        at com.edb.MigrationToolkit.main(MigrationToolkit.java:2068)

 

One or more schema objects could not be imported during the migration process. Please review the migration output for more details.

 

Migration logs have been saved to /root/.enterprisedb/migration-toolkit/logs