[SSMA] ORACLE -> MSSQL Migration중입니다. 0 5 1,377

by 초짜 [2018.06.20 09:22:27]


안녕하세요 .

 

현재 ORDACLE -> MSSQL로 마이그레이션 진행중입니다만,  오라클 접속시(SOURCE) 하단의 에러가 발생하고 있습니다.

 

[Mandatory: Generic] [1188/1] [2018-06-20 08:34:11]: Starting assembly: SSMAforOracle, Version=7.8.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
Created: 2018-04-06 오후 7:32:36
Last Modified: 2018-04-06 오후 7:32:36
OS Version: Microsoft Windows NT 6.2.9200.0
OS architecture: x64
Processor architecture: AMD64
Current culture: ko-KR
UI culture: ko-KR
[Mandatory: Collector] [1188/3] [2018-06-20 09:24:35]: Oracle connection provider: oracleclient.
[Mandatory: Collector] [1188/3] [2018-06-20 09:24:35]: Oracle connection mode: Standard.
[Mandatory: Collector] [1188/3] [2018-06-20 09:24:36]: Oracle server version: '12.1.0.2.0'.
[Error: Generic] [1188/3] [2018-06-20 09:24:36]: Failed to collect metabase data.
[Error: Generic] [1188/3] [2018-06-20 09:24:36]: Exception: Error occurred while collecting data.
 site: Microsoft.SSMA.Framework.Generic.Collectors.XMetabase CreateMetabaseAndCollectData(System.Data.IDbConnection, System.String, Microsoft.SSMA.Framework.Generic.XTree.XNode, Microsoft.SSMA.Framework.Generic.UserInterface.IUIProgressBarProvider, Microsoft.SSMA.Framework.Generic.UserInterface.IUIStopOperationProvider, Microsoft.SSMA.Framework.Generic.Collectors.ICollectionContext)
 source: Microsoft.SSMA.Framework.Oracle.Generic
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CollectData(String xmlConnectionParameters, SecureString password, ICollectionContext context, IDbConnection implicitConnection, XNode xFilter)
   위치: Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
   위치: Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
[Error: Generic] [1188/3] [2018-06-20 09:24:36]: Inner Exception #1: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

 site: Void CheckError(System.Data.OracleClient.OciErrorHandle, Int32)
 source: System.Data.OracleClient
 error code: -2146232008
   위치: System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   위치: System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
   위치: System.Data.OracleClient.OracleCommand.ExecuteScalar()
   위치: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.Execute[T](ExecutionDelegate`1 executionMethod)
   위치: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.ExecuteScalar()
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.IsServerContainered(IDbConnection connection)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.UpdateMetabaseServerVersion(XMetabase xMetabase, IDbConnection connection, String serverVersionText, Int64 serverVersion, Boolean isLoadingFirst)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.LoadServerVersion(XMetabase xMetabase, IDbConnection connection, Boolean isLoadingFirst, IUIProgressBarProvider progressBarProvider)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
[Error: Gui] [1188/3] [2018-06-20 09:24:37]: LowLevelAdapter.ReadSource : Read Source error: Microsoft.SSMA.Framework.Generic.Collectors.CollectorException: Error occurred while collecting data. ---> System.Data.OracleClient.OracleException: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

   위치: System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   위치: System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
   위치: System.Data.OracleClient.OracleCommand.ExecuteScalar()
   위치: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.Execute[T](ExecutionDelegate`1 executionMethod)
   위치: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.ExecuteScalar()
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.IsServerContainered(IDbConnection connection)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.UpdateMetabaseServerVersion(XMetabase xMetabase, IDbConnection connection, String serverVersionText, Int64 serverVersion, Boolean isLoadingFirst)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.LoadServerVersion(XMetabase xMetabase, IDbConnection connection, Boolean isLoadingFirst, IUIProgressBarProvider progressBarProvider)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
   --- 내부 예외 스택 추적의 끝 ---
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CollectData(String xmlConnectionParameters, SecureString password, ICollectionContext context, IDbConnection implicitConnection, XNode xFilter)
   위치: Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
   위치: Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
   위치: Microsoft.SSMA.GUI.Product.OracleToMsSql.LowLevel.AppConnectToSourceOracle.ConnectToSourceStart(Object guiContext)
[Error: Gui] [1188/3] [2018-06-20 09:24:37]: Exception: Error occurred while collecting data.
 site: Microsoft.SSMA.Framework.Generic.Collectors.XMetabase CreateMetabaseAndCollectData(System.Data.IDbConnection, System.String, Microsoft.SSMA.Framework.Generic.XTree.XNode, Microsoft.SSMA.Framework.Generic.UserInterface.IUIProgressBarProvider, Microsoft.SSMA.Framework.Generic.UserInterface.IUIStopOperationProvider, Microsoft.SSMA.Framework.Generic.Collectors.ICollectionContext)
 source: Microsoft.SSMA.Framework.Oracle.Generic
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CollectData(String xmlConnectionParameters, SecureString password, ICollectionContext context, IDbConnection implicitConnection, XNode xFilter)
   위치: Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
   위치: Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
   위치: Microsoft.SSMA.GUI.Product.OracleToMsSql.LowLevel.AppConnectToSourceOracle.ConnectToSourceStart(Object guiContext)
[Error: Gui] [1188/3] [2018-06-20 09:24:37]: Inner Exception #1: ORA-00942: 테이블 또는 뷰가 존재하지 않습니다

 site: Void CheckError(System.Data.OracleClient.OciErrorHandle, Int32)
 source: System.Data.OracleClient
 error code: -2146232008
   위치: System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   위치: System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean needCLStype, Boolean needRowid, OciRowidDescriptor& rowidDescriptor)
   위치: System.Data.OracleClient.OracleCommand.ExecuteScalar()
   위치: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.Execute[T](ExecutionDelegate`1 executionMethod)
   위치: Microsoft.SSMA.Framework.Generic.DbUtilities.SsmaDbCommand.ExecuteScalar()
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.IsServerContainered(IDbConnection connection)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.UpdateMetabaseServerVersion(XMetabase xMetabase, IDbConnection connection, String serverVersionText, Int64 serverVersion, Boolean isLoadingFirst)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.LoadServerVersion(XMetabase xMetabase, IDbConnection connection, Boolean isLoadingFirst, IUIProgressBarProvider progressBarProvider)
   위치: Microsoft.SSMA.Framework.Oracle.Collector.OracleObjectCollector.CreateMetabaseAndCollectData(IDbConnection connection, String xmlConnectionParameters, XNode xFilter, IUIProgressBarProvider progressBarProvider, IUIStopOperationProvider stopOperationProvider, ICollectionContext context)

 

USER는 운영팀에서 지원한 특정 계정으로 접속하고 있습니다. (SYS, SYSDBA)계정이 아님

이거 특정 USER로 접속하면 안되는건지요,,,???

 

by 우리집아찌 [2018.06.20 10:11:37]

SSMA는 안써봐서요.

linked server 로 해보세요..

 


by 초짜 [2018.06.20 10:40:05]

LINKED SERVER가 마이그레이션 툴이 아닌걸로 알고있는데요. .

어떤식으로 진행 하셨는지요..?

 


by 우리집아찌 [2018.06.20 12:03:16]

SP 이용해서 이관했습니다.

OPEN QUERY 를 사용하였습니다.

저같은 경우는 차대세 이관이라 데이타가 좀 많이 바뀌었는데 1:1 이관이면 그냥 SCRIPT 짜서 쓰셔도 될겁니다.


by 우리집아찌 [2018.06.20 13:11:13]

LINKED SERVER 설명하자면 

오라클의 DB LINK라고 생각하시면 됩니다.


by 타락천사 [2018.06.21 11:37:07]

이행 대상 확인을 위해서, Oracle 메타에 접근이 필요할것으로 생각되네요

system 이나 dba 권한 계정으로 접속 해보세요 

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입