Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    SOLVED oracle数据源异常

    CloudCanal
    oracle数据源异常
    5
    13
    683
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w
      wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w last edited by

      1. 在创建ORACLE数据源时,提示“ 测试连接成功”;
      2. 在创建ORACLE2SR任务时:
        源实例ora-6j2pqh94b66w97g (ORACLE2SR) 连接成功!提示成功.

      但随后弹出报错:
      操作失败
      远程获取数据表的元信息失败。错误信息为:invoke rcontroller method failed.Request id:a3358b28-9481-11ec-aa0c-5dcdd3db00d6msg:OracleDatabaseException: ORA-00942: table or view does not exist . Target sidecar is 172.31.238.4, route name is oracle_rdbGetSchemas"

      1 Reply Last reply Reply Quote 0
      • zycgit
        zycgit @Consumables last edited by zycgit

        @consumables 该问题已解决,请留意一下这个问题的相关历史回复。

        权限问题:https://www.askcug.com/topic/263

        1 Reply Last reply Reply Quote 0
        • Consumables
          Consumables last edited by

          我也是这个报错

          zycgit 1 Reply Last reply Reply Quote 0
          • wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w
            wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w @黎永汉 last edited by

            @黎永汉 grant dba to user_name,此处用户为数据源中配置的用户,或者把数据源中配置的用户换为system OR sys

            1 Reply Last reply Reply Quote 0
            • CloudCanal-万少
              CloudCanal-万少 @黎永汉 last edited by

              @黎永汉 这个报错是权限问题。参考下使用文档,确认下使用的用户是否有权限:https://www.askcug.com/topic/263

              1 Reply Last reply Reply Quote 0
              • 黎永汉
                黎永汉 last edited by

                我也有类似的问题,能测试连接通,但是配置任务的时候也是报ORA-00942的错误,暂时还不知道怎么才能配置好。

                CloudCanal-万少 wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w 2 Replies Last reply Reply Quote 0
                • CloudCanal-万少
                  CloudCanal-万少 @CloudCanal-万少 last edited by CloudCanal-万少

                  3d7e066c-5107-4035-8886-7c9bb0cf9188-image.png

                  1 Reply Last reply Reply Quote 0
                  • CloudCanal-万少
                    CloudCanal-万少 @wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w last edited by

                    @wx-ou3ig6at7j8nwuoqst1e8jgxhu0w 你截图没显示全,我看不出来。异常监控sidecar的堆栈发全一些

                    CloudCanal-万少 1 Reply Last reply Reply Quote 0
                    • wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w
                      wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w last edited by

                      另外我给测试用户scott授予了dba权限,所有的表都可以查询,报错仍是一样的,数据源测试成功,然后报错,CC逻辑是查哪个表不存在?

                      CloudCanal-万少 1 Reply Last reply Reply Quote 0
                      • wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w
                        wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w last edited by

                        哪个表不存在?我用客户端连接oracle,都能正常连接,查询。使用普通用户查的,必须用sys用户吗?

                        1 Reply Last reply Reply Quote 0
                        • CloudCanal-万少
                          CloudCanal-万少 last edited by

                          截图不完整,其实堆栈已经说了,table or view does xxx ,建议核查下

                          1 Reply Last reply Reply Quote 0
                          • wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w
                            wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w @CloudCanal-万少 last edited by

                            @cloudcanal-万少 duiz.png

                            1 Reply Last reply Reply Quote 0
                            • CloudCanal-万少
                              CloudCanal-万少 last edited by

                              翻下控制台异常监控sidecar的堆栈

                              wx-ou3Ig6at7j8nWuOqsT1e8jgXhU0w 1 Reply Last reply Reply Quote 0
                              • 1 / 1
                              • First post
                                Last post
                              Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2