안녕하세요 .
현재 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로 접속하면 안되는건지요,,,???