[{"_1":2,"_183":-5,"_184":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_158":159},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_85":86,"_105":106,"_149":-5,"_150":11,"_151":17,"_152":11,"_153":-5,"_154":11,"_155":-5,"_156":157},"canonicalUrl","https://hub.docker.com/r/synjq/oragent/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","synjq","reponame","oragent","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":69,"_70":71,"_76":11,"_77":78,"_82":29,"_83":84},"categories",[],"content_types",[40],"image","date_registered","2023-02-25T04:21:57.891798Z","description","","is_private","last_updated","2023-02-25T05:26:08.221832Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",86,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","# Oragent\n\nOragent 是九桥同步自主研发的一款 Oracle 数据库日志解析工具，它通过逆向工程 Oracle Redo 的二进制内容，解析出 Oracle 数据库所执行的相应 SQL 语句，并以数据流的形式，提供给下游数据消费者。\n\n## 开始使用\n\n### 前置条件\n\n- 在运行 Oracle 数据库的宿主机上，需安装完整的 Docker 引擎 (>= 20)\n- 在源端 Oracle 以 `sys` 用户执行以下 `.sql` 脚本：\n\n ```sql\n create or replace view XKCCLE as select * from sys.x$kccle;\n create or replace view XKCCCP as select * from sys.x$kcccp;\n create or replace view ORAGENT_XKSPPI as select * from X$KSPPI;\n create or replace view ORAGENT_XKSPPSV as select * from X$KSPPSV;\n alter database force logging;\n alter database add supplemental log data;\n create user oragent1 identified by oragent1;\n create role oragent_role identified by oragent_role;\n grant connect,lock any table,select any table,select any dictionary,alter system,execute any type to oragent_role,oragent1;\n grant oragent_role to oragent1;\n grant dba to oragent1;\n grant execute on dbms_flashback to oragent_role,oragent1;\n alter user oragent1 quota 2m on users;\n create table oragent1.oragenttemp (f1 int);\n ```\n\n### 第一步：拉取 Docker 镜像\n\n```bash\ndocker pull synjq/oragent:latest\n```\n\n### 第二步：启动 Oragent 容器\n\n```bash\ndocker run -d \\\n --name oragent \\\n -e ORACLE_VERSION= \\\n -e ORACLE_HOME= \\\n -e WEB_LOGIN=sys/@:/ \\\n -e SRC_LOGIN=oragent1/oragent1@:/ \\\n -p 8303:8303 \\\n -v :/u01 \\\n synjq/oragent:latest\n```\n\n### 运行参数\n\nOragent 支持的运行时参数如下：\n\n- `--name`：容器的名字\n- `-p`：映射的端口，暴露的端口为 `8303`\n- `-e ORACLE_VERSION`：Oracle 数据版本 `10g|11g|12c`（`12c` 以上版本统一使用 `12c` 传入）\n- `-e ORACLE_HOME`：Oracle 宿主机的环境变量路径\n- `-e WEB_LOGIN`：用于界面安装步骤中的数据库连接\n- `-e SRC_LOGIN`：用于 Oragent 抓取过程中的数据库连接\n- `-v /u01`：Oracle 数据库安装路径\n\n## 消费数据\n\n消费 Oragent 的增量数据，可以使用以下客户端：\n\n- [Oragent Client for Java](https://github.com/tb-soft/oragent-client/)\n\n## 获取授权\n\nOragent 以商业授权的方式，对外提供 Oracle 数据库增量抓取的能力。\n\n### 授权步骤\n\nOragent 的授权分为两步。\n\n#### 第一步：联系九桥售前，获取授权文件\n\n- [发送邮件](mailto:contact@tb-soft.net?subject=Oragent%20%E6%8E%88%E6%9D%83%E8%AF%B7%E6%B1%82&body=%E6%84%9F%E8%B0%A2%E6%82%A8%E5%AF%B9%20Oragent%20%E7%9A%84%E5%85%B3%E6%B3%A8%EF%BC%81%E8%AF%B7%E5%A1%AB%E5%86%99%E4%BB%A5%E4%B8%8B%E4%BF%A1%E6%81%AF%EF%BC%8C%E4%BB%A5%E4%BE%BF%E4%B9%9D%E6%A1%A5%E5%90%8C%E6%AD%A5%E5%B7%A5%E4%BD%9C%E4%BA%BA%E5%91%98%E5%AE%A1%E6%A0%B8%EF%BC%9A%0A%0A%E5%A7%93%E5%90%8D%EF%BC%88%E5%85%AC%E5%8F%B8%EF%BC%89%EF%BC%9A%0A%E8%81%94%E7%B3%BB%E6%96%B9%E5%BC%8F%EF%BC%88%E6%89%8B%E6%9C%BA%2F%E9%82%AE%E7%AE%B1%EF%BC%89%EF%BC%9A%0AOragent%20%E7%9A%84%E4%BD%BF%E7%94%A8%E5%9C%BA%E6%99%AF%EF%BC%9A)\n- 企业微信\n\n ![售前企业微信](https://image-1302181629.cos.ap-beijing.myqcloud.com/oragent_contact.png)\n\n#### 第二步：将授权文件 `sn.txt` 拷贝进 Oragent 的容器\n\n```bash\ndocker cp sn.txt :/oragent\n```\n\n## 加入社群\n\n使用 Oragent 过程中遇到任何问题，进群解惑：\n\n![群二维码](https://image-1302181629.cos.ap-beijing.myqcloud.com/oragent_group.png)","has_starred","hub_user","hbk671104","immutable_tags_settings",{"_72":11,"_73":74},"enabled","rules",[75],".*","is_automated","permissions",{"_79":17,"_80":11,"_81":11},"read","write","admin","user","storage_size",719713462,"orgData",{"_87":88,"_89":90,"_91":92,"_93":29,"_94":29,"_95":96,"_97":44,"_98":44,"_99":100,"_101":44,"_102":44,"_103":44,"_104":17},"id","000d4f363da64aac89b7aac29e2375b0","uuid","000d4f36-3da6-4aac-89b7-aac29e2375b0","type","organization","orgname","full_name","location","Beijing, China","company","profile_url","date_joined","2023-02-25T03:52:29.360291Z","gravatar_url","gravatar_email","badge","is_active","recentTags",[107,143],{"_108":40,"_109":110,"_111":112,"_113":114,"_87":115,"_116":117,"_46":132,"_133":110,"_134":69,"_135":52,"_53":136,"_137":138,"_139":123,"_140":132,"_141":62,"_142":17},"content_type","creator",8646623,"digest","sha256:bb5990682308b6b436f7f3db7c585e78880b086e7bf60531af17380dfa7f35a8","full_size",719708978,393988112,"images",[118],{"_119":120,"_111":112,"_121":44,"_122":123,"_124":125,"_126":127,"_128":44,"_129":-5,"_130":114,"_59":62,"_131":-5},"architecture","amd64","features","last_pulled","2026-09-25T05:30:42.031485753Z","last_pushed","2023-02-25T05:26:07Z","os","linux","os_features","os_version","size","variant","2023-02-25T05:26:08.214298Z","last_updater","last_updater_username","media_type","latest","repository",19339074,"tag_last_pulled","tag_last_pushed","tag_status","v2",{"_108":40,"_109":110,"_111":112,"_113":114,"_87":144,"_116":145,"_46":147,"_133":110,"_134":69,"_135":52,"_53":148,"_137":138,"_139":123,"_140":147,"_141":62,"_142":17},393988107,[146],{"_119":120,"_111":112,"_121":44,"_122":123,"_124":125,"_126":127,"_128":44,"_129":-5,"_130":114,"_59":62,"_131":-5},"2023-02-25T05:26:06.854788Z","3.6.1","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":160,"_167":168,"_156":181,"_182":11},{"_36":161,"_38":162,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":163,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":69,"_70":164,"_76":11,"_77":166,"_82":29,"_83":84},[],[40],[52],{"_72":11,"_73":165},[75],{"_79":17,"_80":11,"_81":11},"tags",{"_169":170,"_171":-5,"_172":-5,"_173":174},"count",2,"next","previous","results",[175,178],{"_108":40,"_109":110,"_111":112,"_113":114,"_87":115,"_116":176,"_46":132,"_133":110,"_134":69,"_135":52,"_53":136,"_137":138,"_139":123,"_140":132,"_141":62,"_142":17},[177],{"_119":120,"_111":112,"_121":44,"_122":123,"_124":125,"_126":127,"_128":44,"_129":-5,"_130":114,"_59":62,"_131":-5},{"_108":40,"_109":110,"_111":112,"_113":114,"_87":144,"_116":179,"_46":147,"_133":110,"_134":69,"_135":52,"_53":148,"_137":138,"_139":123,"_140":147,"_141":62,"_142":17},[180],{"_119":120,"_111":112,"_121":44,"_122":123,"_124":125,"_126":127,"_128":44,"_129":-5,"_130":114,"_59":62,"_131":-5},[],"canDeleteTags","actionData","errors"]

synjq/oragent

Tags for synjq/oragent